基于一卡通的學(xué)生考勤系統(tǒng)畢業(yè)論文-在線瀏覽
2025-08-09 01:50本頁(yè)面
【正文】 0)空專業(yè)學(xué)生編號(hào)depart_idint非空15表SpecialStatisics（專業(yè)考勤統(tǒng)計(jì)表）表名列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其他說明special_statistics_idint非空種子，自增1special_idint非空外鍵special_to_class_ratedecimal(18, 0)空到課率special_late_timesint空遲到次數(shù)special_truant_timesint空曠課次數(shù)special_statistics_timedatetime空統(tǒng)計(jì)時(shí)間16表Student（學(xué)生表）表名列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其他說明student_idint非空種子，自增1student_codedecimal(18, 0)非空學(xué)生編號(hào)student_namenvarchar(50)非空學(xué)生姓名student_ageint空年齡student_nationalitynvarchar(50)空民族student_birthdaydatetime空出身日期student_sexvarchar(10)空性別student_birthday_placenvarchar(50)空籍貫class_idint空外鍵班級(jí)編號(hào)student_identitynvarchar(50)空身份證17表StudentStatisics（學(xué)生考勤統(tǒng)計(jì)表）表名列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其他說明student_statistics_idint非空種子，自增1student_idint空外鍵student_to_class_ratedecimal(18, 0)空到課率student_late_timesint空遲到次數(shù)student_truant_timesint空曠課次數(shù)student_statistics_timedatetime空統(tǒng)計(jì)時(shí)間18表StudentTime（學(xué)生時(shí)間表）表名列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其他說明student_time_idint空主鍵student_idint空外鍵學(xué)生編號(hào)time_idint空外鍵時(shí)間編號(hào)stateint空狀態(tài)（標(biāo)識(shí)考勤狀態(tài)）19表StudentTrainplan（學(xué)生培養(yǎng)計(jì)劃表）表名列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其他說明student_plan_idint非空種子，自增1student_idint空外鍵學(xué)生編號(hào)statusnvarchar(50)空培養(yǎng)狀態(tài)（在修，已修）resultnvarchar(50)空train_plan_course_idint外鍵培養(yǎng)計(jì)劃課程表20表SystemRight（系統(tǒng)權(quán)限表）表名列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其他說明system_right_idint非空種子，自增1system_right_namenvarchar(50)空system_right_descriptionnvarchar(MAX)空21表SystemRole（系統(tǒng)角色表）表名列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其他說明system_role_idint非空種子，自增1system_role_namenvarchar(50)空system_role_ descriptionnvarchar(MAX)空22表SystemUser（系統(tǒng)用戶）表名列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其他說明system_user_idint非空種子，自增1system_user_accountnvarchar(50)非空賬號(hào)system_user_passwordnvarchar(50)空密碼23表TeachClass表名列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其他說明teach_class_idint非空種子，自增1train_plan_course_idint空外鍵24表TeachClassStudent（教學(xué)班學(xué)生表）表名列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其他說明teach_class_student_idint非空種子，自增1student_plan_idint非空外鍵teach_class_idint非空外鍵25表Teacher表名列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其他說明teacher_idint非空種子，自增1teacher_namenvarchar(50)非空姓名teacher_sexvarchar(10)非空性別teacher_nationalitynvarchar(50)空民族teacher_title_idint空外鍵職稱teacher_birthday_placenvarchar(50)空籍貫teacher_birthdaydatetime空出身日期teacher_ageint空年齡26表TeacherStatistics表名列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其他說明teacher_statistics_idint非空種子，自增1teacher_to_class_ratedecimal(18, 0)空到課率teacher_late_timesint空遲到次數(shù)teacher_truant_timesint空曠課次數(shù)teacher_statistics_timedatetime空統(tǒng)計(jì)時(shí)間teacher_idint非空外鍵27表TeacherTeachClass（教師教學(xué)班表）表名列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其他說明IDint非空種子，自增1teacher_idint空外鍵教師表IDteach_class_idint空外鍵教學(xué)班表ID28表TeacherTime表名列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其他說明teacher_time_idint非空種子，自增1teacher_idint非空外鍵time_idint非空外鍵stateint空29表TeacherTitle表名列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其他說明teacher_title_idint非空種子，自增1teacher_title_namenvarchar(50)非空30表TeachPrinciple（教學(xué)計(jì)劃）表名列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其他說明outline_idint非空種子，自增1course_idint非空外鍵課程IDcourse_hourint空課時(shí)book_isbnnvarchar(50)空outline_versionint空course_pointint空31表Test（測(cè)試表）表名列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其他說明test_idint非空種子，自增1outline_idint空外鍵test_timedatetime空測(cè)試時(shí)間test_addressnvarchar(50)空地點(diǎn)test_main_teachernvarchar(50)空主考官32表TestScore表名列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其他說明score_idint非空種子，自增1test_idint空外鍵student_idint空學(xué)生編號(hào)score_typenvarchar(50)空考試類型score_valueint空test_sortnvarchar(50)空33表TestTeacherclass表名列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其他說明test_teach_class_idint非空種子，自增1teach_class_idint空外鍵教學(xué)班IDtest_idint空外鍵測(cè)試ID34表Time表名列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其他說明time_idint非空種子，自增1part_numberint非空節(jié)次day_numberint非空日次week_numberint非空周次35表TrainPlan（培養(yǎng)計(jì)劃）表名列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其他說明train_plan_idint非空種子，自增1train_plan_codenvarchar(50)空培養(yǎng)計(jì)劃編碼train_plan_vernvarchar(50)空培養(yǎng)計(jì)劃版本train_plan_authornvarchar(50
研究報(bào)告相關(guān)推薦
鄂ICP備17016276號(hào)-1