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