daily_1_엔티티추출
테이블 (6)
Batches
- id — INT
- name — VARCHAR(50) — NOT NULL
Classes
- id — INT
- region — ENUM('서울', '대전', '구미', '광주', '부울경') — NOT NULL
- name — VARCHAR(50) — NOT NULL
- consultant_id — INT — NOT NULL
- coach_id — INT
Coaches
- id — INT
- name — VARCHAR(50) — NOT NULL
- responsibility — VARCHAR(100) — NOT NULL
Consultants
- id — INT
- name — VARCHAR(50) — NOT NULL
- responsibility — VARCHAR(100) — NOT NULL
Courses
- id — INT
- name — VARCHAR(50) — NOT NULL
- type — ENUM('공통', '특화', '자율') — NOT NULL
- Field
Students
- id — INT
- name — VARCHAR(50) — NOT NULL
- batch_id — INT — NOT NULL
- major — BOOLEAN — NOT NULL
- is_graduated — BOOLEAN — NOT NULL