DB설계
테이블 (4)
Class (Untitled2)
- class_id (Key) — int — 기본 키 — NOT NULL
- area (Field) — enum
- class (Field2) — enum
- curriculum (Field3) — enum
Coach (Untitled4)
- coach_id (Key) — int — 기본 키 — NOT NULL
- class_id (Key2) — int — 외래 키 → Class.class_id — NOT NULL
- class_id (Field)
Consultant (Untitled3)
- consultant_id (Key) — int — 기본 키 — NOT NULL
- class_id (Key2) — int — 외래 키 → Class.class_id — NOT NULL
- class_id (Field) — int
- work (Field2)
Student (Untitled)
- student_id (Key) — 기본 키 — NOT NULL
- class_id (Key2) — int — 외래 키 → Class.class_id — NOT NULL
- class_id (Field) — int
- number (Field2) — int
- major (Field3) — boolean
- retire (Field4) — boolean