n
1
Course start class
- courseStart_id《PK》：int- course_id《FK》：int- course_termID《FK》：int- course_tchID《FK》：int- course_majorID《FK》：int- course_time：varchar- course_address：varchar- course_capacity：int- course_allowFlag：int
R_comment
- cid《PK》：int- uid 《FK》：int- rid 《FK》：varchar- cmessage：varchar- cdate：datetime
Scholarship
- sch_id《PK》：int- sch_name：varchar- sch_amount：double- sch_cause：varchar- sch_status：int- stu_id：int- term_id：int
Student
- stu_id《PK》：int- tu_majorID《FK》：int- stu_collegenumber：varchar- stu_name：varchar- stu_ identity：varchar- stu_sex：varchar- stu_birthday：date- stu_telephone：varchar- stu_origin：varchar- stu_nation：varchar- stu_politics：varchar- stu_native：varchar- stu_address：varchar
Teacher Work
- twork_id《PK》：int- tch_id 《FK》：int- twork_time：date- twork_address：varchar- twork_content：varchar- course_id：int- term_id：int
Major
- major_id《PK》：int- major_collegeID《FK》：int- major_code：varchar- major_name：varchar- major_intro：varchar
Administrator
- id《PK》：int- name：varchar- password：varchar- security：varchar- answer：varchar
Teacher
- tch_id《PK》:int- tc_ collegeID《FK》:int- tch_name ：varchar- tch_birthday：varchar- tch_telephone：varchar- tch_sex：varchar- tch_professional：varchar- tch_nation：varchar- tch_address：varchar- tch_politics：varchar- tch_native：varchar- tch_ identity：varchar- tc_jobnumber：varchar
Students' Course
- selectCourse_id《PK》：int- stu_id《FK》：varchar- course_id《FK》：varchar- selectCourse_time：datetime- selectCourse_result：int
Term
- term_id《PK》：int- college_year：varchar- college_term：varchar
College
- college_id《PK》：int- college_name：varchar- college_intro：varchar
Resource
- rid《PK》：int- rtype：varchar- rsize：int- uid：int- rscore：varchar- rstyle- rupdate-
Punishment
- pun_id《PK》：int- pun_content：varchar- pun_cause：varchar- stu_id：int- term_id：int
R_download
- did《PK》：int- uid 《FK》：int- rid 《FK》：int- ddate：datetime
Course Baise
- course_id《PK》：int- course_code：int- course_name：varchar- course_hours：int- course_credit：int- course_type：int- course_description：varchar- course_character：int
