6--course数据库完整结构

Course数据库最终完整结构表3-1department字段名数据类型长度是否空值是否主键外键默认值备注department_id char3NO主键学院编号department_name varchar10NO学院名称表3-2teacher字段名数据类型长度是否空值主键或外键默认值备注teacher_id char5NO主键教师编号teacher_name varchar4NO教师姓名department_id char3NO外键学院编号gender char1NO男性别introduction varchar100介绍表3-3course字段名数据类型长度是否空值主键或外键默认值备注course_id char4NO主键课程号course_name varchar10NO课程名学时period tinyint3NOcredit tinyint1NO学分人数上限capacity tinyint4NO60外键教师编号teacher_id char5NO上课时间attend_time varchar20NOattend_address varchar10NO上课教室开课学期term char8NO开始选课时间begin_choose_time datetime结束选课时间end_choose_time datetimedescription varchar50描述表3-4classes字段名数据类型长度是否空值主键或外键默认值备注主键班级编号class_id char4NOclass_name varchar8NO班级名年度year int4NOdepartment_id char3NO外键学院编号表3-5student字段名数据类型长度是否空值主键或外键默认值备注student_id char12NO主键学号student_name varchar4NO姓名password char32NO密码gender char1NO男性别class_id char4NO外键班级编号birthday dateNO生日phone varchar18电话homr_address varchar32家庭住址introduction varchar100介绍department_id char3NO学院编号表3-6choose字段名数据类型长度是否空值主键或外键默认值备注choose_id int11NO主键AUTOJNCREMENTstudent_id char12NO外键学号course_id char4NO外键课程号choose_time datetimeNO选课时间score float0成绩department tinywvt•department_id:ch«n department1u»xtw Jd:char⑸attend timenam»;vacchar10varhacO attendAdd，6$:vatchar10\JstudevHc term.char8•stuient_id:chart1Ze beqanchoose tHTiedatet^ne Tendstufent_rkrw;v«M€har4〈hoose twTM**glZtmepasssord:charp]gendet:1•desoiplMi:v«»*hat1024chaf1department」d:chatl・class id:c2rM_cU4S_id:char

4.class,name:varchar8■bvrfHdaydatr________________■year:kit11depactment id:ctwir

3.phone:var^har

18.hom»_«Kkifc:v«rchjir12tntioiuc9ionv^ftw«10O5•.choose•9d:int11■-student_kf:clwr12cour wjd:ch^r

4.T choosetime:datetime・Kore.float5teacher1■d:char5teacher.name:varchar44password二vafchaf32d4»p«Bftment_«d:d,3«•Q^nder:ch4Wf m4ijot:v«ircttar8•pole%MoruM:v«*cchar8intrcMluction-v«HcharlOOJ Ocourse•coufw id:II«M4i■coursen*me:v«trharIO•period:tin0nt3■cfecfittinymtXI■capacity。