9기_서울5반_주창훈_ERD
테이블 (5)
각반
- Class Id (class_id) — int — 기본 키 — NOT NULL
- Consultant Id (consultant_id) — int — 외래 키 → 컨설턴트.Consultant Id — NOT NULL
- Coach Id (coach_id) — int — 외래 키 → 코치.Coach Id — NOT NULL
- Region (region) — varchar
- Class Number (class_number) — int
교육과정
- Course Id (course_id) — int — 기본 키 — NOT NULL
- Course Type (course_type) — varchar
- Field
교육생
- Student Id (student_id) — int — 기본 키 — NOT NULL
- Class Id (class_id) — int — 외래 키 → 각반.Class Id — NOT NULL
- Consultant Id (consultant_id) — int — 외래 키 → 각반.Consultant Id — NOT NULL
- Coach Id (coach_id) — int — 외래 키 → 각반.Coach Id — NOT NULL
- Course Id (course_id) — int — 외래 키 → 교육과정.Course Id — NOT NULL
- Batch (batch) — int
- Major (major) — tinyint
- Withdrawal (withdrawal) — tinyint
컨설턴트
- Consultant Id (consultant_id) — int — 기본 키 — NOT NULL
- Responsibility (responsibility) — varchar
코치
- Coach Id (coach_id) — int — 기본 키 — NOT NULL
- Responsibility (responsibility) — varchar