id char 20
password char 256
name varchar 50
e_mail_location varchar 50
phonenumber varchar 30
targetURL varchar 256

administrator
    id
    password
    name
    e_mail_location
    phonenumber
    

profession_info
    profession_code char 8
    college varchar 256
    department varchar 256
    profession varchar 256

student
    id
    password
    name
    e_mail_location
    phonenumber
    profession_code char 8
    grade char 4

teacher
    id
    password
    name
    e_mail_location
    phonenumber
    profession_code char 8
    job_title varchar 256
    education varchar 256


graduation_design
    id
    student_id
    teacher_id
    chinese_name varchar 256
    english_name varchar 256
    type_of_topic char 3
    source_of_design char 1
    nature_of_design char 1
    description_of_topic text
    

graduation_design_opening_report
    id
    opening_report_date date
    opening_report_location varchar 256
    opening_report_url 
    opening_report_teacher_leader_team_id
    opening_report_secretary_leader_team_id
    estimated_word_count int

graduation_design_opening_report_opinion_record
    id
    mentor_opinion text
    mentor_opinion_date date
    secretary_record text
    secretary_record_date date
    report_teacher_team_opinion text
    report_teacher_team_opinion_date date
    college_opinion text
    college_opinion_date date

opening_report_teacher_team
    leader_teacher_id
    teacher1_id
    teacher2_id

opening_report_secretary_team
    leader_student_id
    student1_id
    student2_id

graduation_design_finished_product
    id
    word_count int
    final_date date
    graduation_design_url
    chinese_abstract text
    chinese_key_words text
    english_abstract text
    english_key_words text


graduation_design_finished_product_mentor_score
    id

graduation_design_finished_product_reviewer_score
    id
    score int
    opinion text
    reviewer_score_date date

graduation_design_reply
    id
    reply_date date
    reply_location varchar 256
    reply_teacher_team_leader_id
    reply_secretary_team_leader_id
    
graduation_design_reply_opinion_record_score
    id
    mentor_opinion text
    mentor_opinion_date date
    secretary_record text
    secretary_record_date date
    reply_teacher_team_opinion text
    reply_teacher_team_score int
    reply_teacher_team_opinion_date date
    college_opinion text
    college_score int
    college_opinion_date date
    school_opinion text
    school_score int
    school_opinion_date date

reply_teacher_team
    leader_teacher_id
    teacher1_id
    teacher2_id

reply_secretary_team
    leader_student_id
    student1_id
    student2_id
