daily_1 엔티티추출
테이블 (5)
Student (교육생)
- StudentId (student_id) — int — 기본 키 — NOT NULL
- FirstName (first_name) — Varchar(10)
- LastName (last_name) — Varchar(10)
- Course (course) — Char(2)
- IsMajor (is_major) — Boolean
- IsLeave (is_leave) — Boolean
class (반)
- StudentId (student_id) — int — 외래 키 → Student.StudentId — NOT NULL
- ConsultantId (consultant_id) — int — 외래 키 → consultant.ConsultantId — NOT NULL
- CoachId (coach_id) — int — 외래 키 → coach.CoachId — NOT NULL
- Area (area) — Varchar(255)
- ClassNumber (class_number) — int
coach (코치)
- CoachId (coach_id) — int — 기본 키 — NOT NULL
- FirstName (first_name) — Varchar(10)
- LastName (last_name) — Varchar(10)
- Role (role) — Varchar(255)
consultant (컨설턴트)
- ConsultantId (consultant_id) — int — 기본 키 — NOT NULL
- FirstName (first_name) — Varchar(10)
- LastName (last_name) — Varchar(10)
- Role (role) — Varchar(255)