대학생

테이블 (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)