SCHOOL EXAM
Tables (6)
COURSE (Untitled)
- Key (CO_NUM) — INT — Primary key — NOT NULL
- Field (CO_PR_NUM) — INT
- Field (CO_SU_NUM) — INT
- Field (CO_TERM) — VARCHAR(10)
- Field (CO_YEAR) — INT
- Field (CO_TIMETABLE) — VARCHAR(100)
- Field (CO_DEGREE) — INT
- Key (AT_NUM) — INT — Foreign key → Untitled3.Key — NOT NULL
PROFESSOR (Untitled2)
- Key (PR_NUM) — INT — Primary key — NOT NULL
- Field (PR_NAME) — VARCHAR(20)
- Field (PR_AGE) — INT
- Field (PR_ROOM) — VARCHAR(45)
- Field (PR_STATE) — VARCHAR(45)
- Field (PR_POSITION) — VARCHAR(45)
- Key (CO_NUM) — INT — Foreign key → COURSE.Key — NOT NULL
- Key (CO_NUM2) — INT — Foreign key → COURSE.Key — NOT NULL
- Key (GU_NUM) — INT — Foreign key → Untitled2.Key — NOT NULL
Untitled2 (GUIDE)
- Key (GU_NUM) — INT — Primary key — NOT NULL
- Field (GU_PR_NUM) — INT
- Field (GU_ST_NUM) — INT
- Field (GU_TERM) — VARCHAR(45)
Untitled3 (STUDENT)
- Key (ST_NUM) — INT — Primary key — NOT NULL
- Field (ST_NAME) — VARCHAR(20)
- Field (ST_TERM) — INT
- Field (ST_POINT)
- Key (GU_NUM) — INT — Foreign key → Untitled2.Key — NOT NULL
Untitled3 (SUBJECT)
- Key (SU_NUM) — INT — Primary key — NOT NULL
- Field (SU_CODE) — VARCHAR(20)
- Field (SU_TITLE) — VARCHAR(45)
- Field (SU_POINT) — INT
- Field (SU_TIME) — INT
- Key (CO_NUM) — INT — Foreign key → COURSE.Key — NOT NULL
Untitled3 (ATTEND)
- Key (AT_NUM) — INT — Primary key — NOT NULL
- Field (AT_ST_NUM) — INT
- Field (AT_CO_NUM) — INT
- Field (AT_MID) — INT
- Field (AT_FINAL) — INT
- Field (AT_ATTEND) — INT
- Field (AT_HW) — INT
- Field (AT_SCORE) — CHAR(1)
- Field (AT_PASS) — VARCHAR(10)
- Field (AT_REPETITION) — VARCHAR(10)
- Key (ST_NUM2) — INT — Foreign key → Untitled3.Key — NOT NULL