类图

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