22. ERD 작성 실습
테이블 (5)
Classes (class)
- class_id (PK) — Long — 기본 키 — NOT NULL
- coach_id (FK) — Long — 외래 키 → Consultants.consultant_id
- consultant_id (FK2) — Long — 외래 키 → Coaches.coach_id — NOT NULL
- class_name (Field) — varchar(10) — NOT NULL
- class_number (Field2) — number — NOT NULL
Coaches (coach)
- coach_id (PK) — Long — 기본 키 — NOT NULL
- coach_work (Field) — varchar(10) — NOT NULL
Consultants (consultant)
- consultant_id (PK) — Long — 기본 키 — NOT NULL
- consultant_class (Field2) — number — NOT NULL
Curriculums (curriculum)
- curriculum_id (Key) — Long — 기본 키 — NOT NULL
- curriculum_name (Field) — varchar(4) — NOT NULL
Students (student)
- student_id (Key) — Long — 기본 키 — NOT NULL
- student_generation (Field) — number — NOT NULL
- student_isMajor (Field2) — bool — NOT NULL
- student_isDischarge (Field3) — bool — NOT NULL