CREATE TABLE t_student (
id INT (20) NOT NULL auto_increment COMMENT '编号',
cname VARCHAR (60) NOT NULL COMMENT '学生姓名',
sex TINYINT NOT NULL COMMENT '性别',
selfcard_no INT NOT NULL COMMENT '学生证号',
note VARCHAR (1024) COMMENT '备注',
PRIMARY KEY (id)
);
CREATE TABLE t_student_selfcard (
id INT (20) NOT NULL auto_increment COMMENT '编号',
student_id INT (20) NOT NULL COMMENT '学生编号',
native VARCHAR (60) NOT NULL COMMENT '籍贯',
issue_date date NOT NULL COMMENT '发证日期',
end_date date NOT NULL COMMENT '结束日期',
note VARCHAR (1024) COMMENT '备注',
PRIMARY KEY (id)
);
CREATE TABLE t_lecture (
id INT (20) NOT NULL auto_increment COMMENT '编号',
lecture_name VARCHAR (60) NOT NULL COMMENT '课程名称',
note VARCHAR (1024) COMMENT '备注',
PRIMARY KEY (id)
);
CREATE TABLE t_student ( id INT (20) NOT NULL auto_increment COMMENT '编号', cname VARCHAR (60) NOT NULL COMMENT '学生姓名', sex TINYINT NOT NULL COMMENT '性别', selfcard_no INT NOT NULL COMMENT '学生证号', ...