数据库结构
2021-04-14 19:05:32 4 举报以学生为主体建立涵盖学生信息表、教师信息表、课程成绩表等相关数据表
作者其他创作
大纲/内容
int pkvarchar(40)varchar(20)varchar(20)varchar(6)varchar(20)varchar(20)varchar(40)intvarchar(20)fk
term_id
varchar(20) pkvarchar(20)intvarchar(20)varchar(20)varchar(20)varchar(20)
class_id
int pkvarchar(20)varchar(8)varchar(20)varchar(20)varchar(20)varchar(40)
student_id
stutent_info
student_idstudent_numberstudent_namemajorgenderbirth_datenative_placeidcard_numcontactclass_id
time_info
time_idstart_lessonend_lessonweeksstart_weekend_week
int pkvarchar(50)int fkint fkint fkvarchar(20)int fk
term_info
term_idstart_dateend_dateyearsterm
time_id
class_info
class_idclass_nameclass_p_numteacher_keymonitercico_stulbs_stu
teacher_id
int pkdatedatevarchar(10)int
int fkvarchar(20)floatfloatfloatvarchar(40)varchar(20) fkint fkvarchar(20)
teacher_info
teacher_idteacher_namegendertech_post_titlenative_placebirth_dateid_card_num
int pkintintvarchar(10)varchar(20varchar(20))
student_score
student_idcourse_namecredittotal_scoreGPAcourse_natureclass_idterm_idregular_score
course_info
course_idcourse_nameclass_idterm_idteacher_idclassroomtime_id
0 条评论
下一页
