school_exam

Tables (6)

attend

  • at_num (Key) — int — Primary key — NOT NULL
  • at_st_num (Field) — int
  • at_co_num (Field2) — int
  • at_mid (Field3) — int
  • at_final (Field4) — int
  • at_attend (Field5) — int
  • at_hw (Field6) — int
  • at_score (Field7) — varchar(45)
  • at_pass (Field8) — varchar(1)
  • at_repetition (Field9) — varchar(1)
  • st_num (Key2) — int — Foreign key → student.st_num — NOT NULL
  • co_num (Key3) — int — Foreign key → course.co_num — NOT NULL

course

  • co_num (Key) — int — Primary key — NOT NULL
  • co_pr_num (Field) — int
  • co_su_num (Field2) — int
  • co_term (Field3) — varchar(10)
  • co_year (Field4) — int
  • co_timetable (Field5) — varchar(100)
  • co_degree (Field6) — int
  • su_num (Key2) — int — Foreign key → subject.su_num — NOT NULL
  • pr_num (Key3) — int — Foreign key → professor.pr_num — NOT NULL

guide

  • gu_num (Key) — int — Primary key — NOT NULL
  • gu_pr_num (Field) — int
  • gu_st_num (Field2) — int
  • gu_year (Field3) — varchar(45)
  • st_num (Key2) — int — Foreign key → student.st_num — NOT NULL
  • pr_num (Key3) — int — Foreign key → professor.pr_num — NOT NULL

professor

  • pr_num (Key) — int — Primary key — NOT NULL
  • pr_name (Field) — varchar(20)
  • pr_age (Field2) — int
  • pr_room (Field3) — varchar(45)
  • pr_state (Field4) — varchar(45)
  • pr_position (Field5) — varchar(45)

student

  • st_num (Key) — int — Primary key — NOT NULL
  • st_name (Field) — varchar(20)
  • st_term (Field2) — int
  • st_credit (Field3) — int

subject

  • su_num (Key) — int — Primary key — NOT NULL
  • su_code (Field) — varchar(20)
  • su_title (Field2) — varchar(45)
  • su_point (Field3) — int
  • su_time (Field4) — int