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