daily_1_엔티티추출
테이블 (6)
Class (class)
- Class ID (class_id) — INT — 기본 키 — NOT NULL
- Type (type) — VARCHAR
- Consultant ID (consultant_id) — INT — 외래 키 → Consultant.Consultant ID — NOT NULL
- Coach ID (coach_id) — INT — 외래 키 → Coach.Coach ID — NOT NULL
Coach (coach)
- Coach ID (coach_id) — INT — 기본 키 — NOT NULL
- Last Name (last_name) — VARCHAR
- First Name (first_name) — VARCHAR
- Job ID (job_id) — INT — 외래 키 → Job.Job ID — NOT NULL
Consultant (consultant)
- Consultant ID (consultant_id) — INT — 기본 키 — NOT NULL
- Last Name (last_name) — VARCHAR
- First Name (first_name) — VARCHAR
- Job ID (job_id) — INT — 외래 키 → Job.Job ID — NOT NULL
Course (course)
- Course ID (course_id) — INT — 기본 키 — NOT NULL
- Name (name) — VARCHAR
Job (job)
- Job ID (job_id) — INT — 기본 키 — NOT NULL
- Name (name) — VARCHAR
Student (student)
- Student ID (student_id) — INT — 기본 키 — NOT NULL
- Last Name (last_name) — VARCHAR
- First Name (first_name) — VARCHAR
- Generation (generation) — INT
- Major (major) — BOOLEAN
- Left (left) — BOOLEAN
- Class ID (class_id) — INT — 외래 키 → Class.Class ID — NOT NULL
- Course ID (course_id) — INT — 외래 키 → Course.Course ID — NOT NULL