assignment07-2
Tables (6)
CLASS
- id — INT
- consultant_id — INT — NOT NULL
- coach_id — INT
- region — VARCHAR(20) — NOT NULL
- class_number — INT — NOT NULL
CLASS_CURRICULUM
- class_id — INT
- curriculum_id — INT
COACH
- id — INT
- name — VARCHAR(50) — NOT NULL
- responsibility — VARCHAR(200) — NOT NULL
CONSULTANT
- id — INT
- name — VARCHAR(50) — NOT NULL
- responsibility — VARCHAR(200) — NOT NULL
CURRICULUM
- id — INT
- type — VARCHAR(20) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- CHECK — (type IN ('공통', '특화', '자율'))
STUDENT
- id — INT
- class_id — INT — NOT NULL
- generation — INT — NOT NULL
- is_major — BOOLEAN — NOT NULL
- is_dropped — BOOLEAN — NOT NULL