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