CNS

Tables (3)

Untitled (TB_CLASS)

  • Field (CLASS_NO) — VARCHAR(10) — Primary key
  • Field (DEPARTMENT_NO) — VARCHAR(20)
  • Field (PREATTENDING_CLASS_NO) — VARCHAR(20)
  • Field (CLASS_NAME) — VARCHAR(60)
  • Field (CALSS_TYPE) — VARCHAR(20)

Untitled (TB_CLASS_PROFESSOR)

  • Field (CLASS_NO) — VARCHAR(10)
  • Field (PROFESSOR_NO) — VARCHAR(10)

Untitled (TB_DEPARTMENT)

  • Field (DEPARTMENT_NO) — VARCHAR(10) — Primary key
  • Field (DEPARTMENT_NAME) — VARCHAR(40)
  • Field (CATEGORY) — VARCHAR(40)
  • Field (OPEN_YN) — CHAR(1)
  • Field (CAPACITY) — NUMBER