대학생
테이블 (10)
COURSE
- CO_NUM — INT — 기본 키 — NOT NULL
- CO_ATT — INT — NOT NULL
- CO_HOME — INT — NOT NULL
- CO_MID — INT — NOT NULL
- CO_FINAL — INT — NOT NULL
- CO_TOTAL — VARCHAR(4)
- CO_ST_NUM — CHAR(10) — 외래 키 → STUDENT.ST_NUM — NOT NULL
- CO_LE_NUM — INT — 외래 키 → LECTURE.LE_NUM — NOT NULL
DEPARTMENT
- DE_NUM — CHAR(3) — 기본 키 — NOT NULL
- DE_NAME — VARCHAR(50) — NOT NULL
- DE_OFFICE — VARCHAR(255)
- DE_PR_NUM — CHAR(11) — 외래 키 → PROFESSOR.PR_NUM — NOT NULL
FINAL_PASS
- FP_NUM — INT — 기본 키 — NOT NULL
- FP_NAME — VARCHAR(50) — NOT NULL
- FP_PHONE — VARCHAR(13) — NOT NULL
- FP_YEAR — INT — NOT NULL
- FP_RES_NUM — CHAR(14) — NOT NULL
- FP_DE_NUM — CHAR(3) — 외래 키 → DEPARTMENT.DE_NUM — NOT NULL
LECTURE
- LE_NUM — INT — 기본 키 — NOT NULL
- LE_YEAR — INT — NOT NULL
- LE_SEMESTER — ENUM("1","2","여름","겨울") — NOT NULL
- LE_CLASS_ROOM — VARCHAR(255)
- LE_CLASS — INT — NOT NULL
- LE_MAX — INT — NOT NULL
- LE_PLAN — LONGTEXT
- LE_SJ_NUM — INT — 외래 키 → SUBJECT.SJ_NUM — NOT NULL
- LE_PR_NUM — CHAR(11) — 외래 키 → PROFESSOR.PR_NUM — NOT NULL
LECTURE_SCHEDULE
- LC_NUM — INT — 기본 키 — NOT NULL
- LC_DAY — CHAR(1) — NOT NULL
- LC_TIME — VARCHAR(2) — NOT NULL
- LC_MINUTE — CHAR(1) — NOT NULL
- LC_LE_NUM — INT — 외래 키 → LECTURE.LE_NUM — NOT NULL
LECTURE_STANDARD
- LS_NUM — INT — 기본 키 — NOT NULL
- LS_MID — INT — NOT NULL
- LS_FINAL — INT — NOT NULL
- LS_HOME — INT — NOT NULL
- LS_ATT — INT — NOT NULL
- LS_LE_NUM — INT — 외래 키 → LECTURE.LE_NUM — NOT NULL
PROFESSOR
- PR_NUM — CHAR(11) — 기본 키 — NOT NULL
- PR_NAME — VARCHAR(50) — NOT NULL
- PR_PHONE — VARCHAR(13) — NOT NULL
- PR_RES_NUM — CHAR(14) — NOT NULL
- PR_YEAR — INT — NOT NULL
- PR_DE_NUM — CHAR(3) — 외래 키 → DEPARTMENT.DE_NUM — NOT NULL
STUDENT
- ST_NUM — CHAR(10) — 기본 키 — NOT NULL
- ST_NAME — VARCHAR(50) — NOT NULL
- ST_RES_NUM — CHAR(14) — NOT NULL
- ST_PHONE — VARCHAR(13) — NOT NULL
- ST_YEAR — INT — NOT NULL
- ST_DE_NUM — CHAR(3) — 외래 키 → DEPARTMENT.DE_NUM — NOT NULL
- ST_PR_NUM — CHAR(11) — 외래 키 → PROFESSOR.PR_NUM — NOT NULL
SUBJECT
- SJ_NUM — INT — 기본 키 — NOT NULL
- SJ_TITLE — VARCHAR(50) — NOT NULL
- SJ_POINT — INT — NOT NULL
- SJ_TIME — INT — NOT NULL
- SJ_CODE — CHAR(6) — NOT NULL
- SJ_SC_CODE — CHAR(3) — 외래 키 → SUBJECT_CATEGORY.SC_CODE — NOT NULL
SUBJECT_CATEGORY
- SC_CODE — CHAR(3) — 기본 키 — NOT NULL
- Field — VARCHAR(255)