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