계절2
테이블 (7)
Batches
- batch_id — INT — 기본 키
- batch_name — VARCHAR(50) — NOT NULL
ClassCoaches
- coach_id (coach_id2) — INT — 외래 키 → Coaches.coach_id
- class_id (class_id2) — INT — 외래 키 → Classes.class_id
Classes
- class_id — INT — 기본 키
- class_number — INT — NOT NULL
- consultant_id — INT
- region — ENUM('서울', '대전', '구미', '광주', '부울경') — NOT NULL
Coaches
- coach_id — INT — 기본 키
- name — VARCHAR(100) — NOT NULL
- task — VARCHAR(255) — NOT NULL
Consultants
- consultant_id — INT — 기본 키
- name — VARCHAR(100) — NOT NULL
- task — VARCHAR(255) — NOT NULL
- class_id — INT — 외래 키 → Classes.class_id
Courses
- course_id — INT — 기본 키
- course_name — ENUM('공통', '특화', '자율') — NOT NULL
Students
- student_id — INT — 기본 키
- name — VARCHAR(100) — NOT NULL
- major — ENUM('전공자', '비전공자') — NOT NULL
- status — ENUM('재학중', '퇴소') — NOT NULL
- class_id — INT — 외래 키 → Classes.class_id
- batch_id (batch_id2) — INT — 외래 키 → Batches.batch_id
- course_id — INT — 외래 키 → Courses.course_id