CREATE TABLE Students(
Student_ID INT(10) PRIMARY KEY COMMENT '学号',
Name VARCHAR(30) NOT NULL COMMENT '姓名',
Password VARCHAR(20) NOT NULL COMMENT '密码',
Class VARCHAR(30) NULL COMMENT '班级',
Gender ENUM('男','女') NULL COMMENT '性别',
ID CHAR(18) NOT NULL COMMENT '身份证号',
Birthdate DATE NOT NULL COMMENT '出生日期',
Telephone VARCHAR(20) NOT NULL COMMENT '联系电话'
);
CREATE TABLE Teachers (
Teacher_ID INT(10) PRIMARY KEY COMMENT '教工号',
Name VARCHAR(30) NOT NULL COMMENT '姓名',
Password VARCHAR(20) NOT NULL COMMENT '密码',
Title VARCHAR(20) NULL COMMENT '职称',
Gender ENUM('男','女') NULL COMMENT '性别',
ID CHAR(18) NOT NULL COMMENT '身份证号',
Birthdate DATE NOT NULL COMMENT '出生日期',
Telephone VARCHAR(20) NOT NULL COMMENT '联系电话'
);
CREATE TABLE Courses (
Course_ID INT(10) PRIMARY KEY COMMENT '课程号',
Course_Name VARCHAR(50) NOT NULL COMMENT '课程名',
Course_Type VARCHAR(20) NULL COMMENT '课程类型',
Hours INT(4) NOT NULL COMMENT '学时',
Credit FLOAT(3,1) NOT NULL COMMENT '学分',
Course_Desc TEXT NULL COMMENT '课程介绍'
);
