Mysql

create table student(
studentNo int(4) not null comment '学号',
loginPwd varchar(20) null,
studentName varchar(20) null comment '学生姓名',
sex tinyint(1) comment '性别，取值0或1',
gradeId int(11) comment '年纪编号',
phone varchar(20) not null comment '联系电话',
address varchar(255) not null comment '地址',
bornDate datetime comment '出生时间',
email varchar(50) not null comment '邮箱编号',
identityCard varchar(18) comment '身份证号'

);

create table result(
studentNo int(4) not null comment '学号',
subjectNo int(4) not null comment '课程编号',
ExamDate datetime not null comment '考试日期',
studentResult int(4) not null comment '考试成绩'
);