会话

session_id INT (10)

session_name VARCHAR (25)

session_start日期

session_end日期

center_id INT (10)

索引

schoolholidays

schoolholiday_id INT (10)

schoolhoiday_name VARCHAR (50)

schoolholiday_datestrt日期

schoolholiday_dateend日期

session_id INT (10)

索引

用户

user_id INT (10)

guardian_id INT (10)

staff_id INT (10)

student_id INT (10)

用户_ VARCHAR (15)

user_password CHAR (40)

user_salt CHAR (32)

索引

工作人员

staff_id INT (10)

staff_firstname VARCHAR (25)

staff_lastname VARCHAR (25)

staff_nric VARCHAR (10)

staff_phonehome VARCHAR (10)

staff_phoneoffice VARCHAR (10)

staff_phonemobile VARCHAR (50)

staff_email VARCHAR (50)

staff_status组(. .)

department_id INT (10)

center_id INT (10)

索引

部门

depart_id INT (10)

department_name VARCHAR (200)

索引

监护人

guardian_id INT (10)

guardian_name VARCHAR (100)

guardian_nric VARCHAR (14)

guardian_phonehome VARCHAR (10)

guardian_phoneoffice VARCHAR (10)

guardian_phonemobile VARCHAR (10)

guardian_email VARCHAR (50)

索引

guardians_students

gs_id INT (10)

guardian_id INT (10)

student_id INT (10)

索引

类

class_id INT (10)

class_name VARCHAR (100)

schoolsession_id INT (10)

索引

classes_students

cs_id INT (10)

class_id INT (10)

student_id INT (10)

索引

schoolsessions

schoolsession_id INT (10)

schoolsession_name VARCHAR (50)

schoolsession_timestart时间

schoolsession_timeend时间

session_id INT (10)

索引

学生

student_id INT (10)

student_firstname VARCHAR (100)

student_lastname VARCHAR (100)

student_gender ENUM(“M”,F)

student_dob日期

student_nric VARCHAR (14)

student_bc VARCHAR (10)

student_remarks VARCHAR (1000)

center_id INT (10)

索引