SSAFY- DB 설계, ERD 작성 실습
테이블 (4)
Classes (class)
- Class Id (class_id) — INT — 기본 키 — NOT NULL
- Area (area) — Enum
- Class (class) — Enum
- Curriculum (curriculum) — Enum
Coaches (coaches)
- Coach Id (coach_id) — INT — 기본 키 — NOT NULL
- Class Id (class_id2) — INT — 외래 키 → Classes.Class Id — NOT NULL
- Class Id (class_id) — INT
- Work (work) — Work
Consultants (consultants)
- Consultants Id (consultants_id) — INT — 기본 키 — NOT NULL
- Class Id (class_id2) — INT — 외래 키 → Classes.Class Id — NOT NULL
- Class Id (class_id) — INT
- Work (work) — Work
Student (students)
- Student Id (student_id) — INT(7) — 기본 키 — NOT NULL
- Class Id (class_id2) — INT — 외래 키 → Classes.Class Id — NOT NULL
- Cardinal Number (cardinal_number) — INT
- Major (major) — boolean
- Retire (retire) — boolean
- Class Id (class_id) — INT