daily_1_엔티티추출
테이블 (5)
Class (class)
- Class Id (id) — INT(10) — 기본 키 — NOT NULL
- No (no) — INT(2)
- Region (region) — VARCHAR(2)
- Consultant Id (consultant_id) — INT(10) — 외래 키 → Consultant.Consultant Id — NOT NULL
- Coach Id (coach_id) — INT(10) — 외래 키 → Coach.Coach Id — NOT NULL
Coach (coach)
- Coach Id (id) — INT(10) — 기본 키 — NOT NULL
- Class Id (class_id) — INT(2)
- Task (task) — VARCHAR(225)
Consultant (consultant)
- Consultant Id (id) — INT(10) — 기본 키 — NOT NULL
- Class Id (class_id) — INT(2)
- Task (task) — VARCHAR(225)
Curriculum (curriculum)
- Curriculum Id (id) — INT(10) — 기본 키 — NOT NULL
- Name (name) — VARCHAR(2)
Student (student)
- Student Id (id) — INT(10) — 기본 키 — NOT NULL
- Name (name) — VARCHAR(10)
- No th (no_th) — INT(2)
- Is Major (is_major) — BOOLEAN — 전공 / 비전공
- Is Leave (is_leave) — BOOLEAN
- Class Id (class_id) — INT(10) — 외래 키 → Class.Class Id — NOT NULL