test
Tables (7)
Batches
- batch_id — INT
- batch_name — VARCHAR(50) — NOT NULL
ClassCoaches
- class_coach_id — INT
- class_id — INT — NOT NULL
- coach_id — INT — NOT NULL
Classes
- batch_id — INT — NOT NULL
- class_id — INT
- region — ENUM('서울', '대전', '구미', '광주', '부울경') — NOT NULL
Coaches
- coach_id — INT
- name — VARCHAR(100) — NOT NULL
- task_description — TEXT
Consultants
- consultant_id — INT
- name — VARCHAR(100) — NOT NULL
- task_description — TEXT
Courses
- course_id — INT
- course_type — ENUM('공통', '특화', '자율') — NOT NULL
Students
- student_id — INT
- name — VARCHAR(100) — NOT NULL
- is_major — BOOLEAN — NOT NULL
- is_graduated — BOOLEAN — NOT NULL
- class_id — INT — NOT NULL