daily1_엔티티추출
테이블 (5)
Class (class)
- Class Num (class_num) — INT(11) — 기본 키 — NOT NULL
- Region (region) — VARCHAR(22) — 기본 키 — NOT NULL
- Student ID (student_id) — INT(7) — 외래 키 → Student.Student ID — NOT NULL
- Consultant ID (consultant_id) — INT(7) — 외래 키 → Consultant.Consultant ID — NOT NULL
- Coach ID (coach_id) — INT(7) — 외래 키 → Coach.Coach ID — NOT NULL
Coach (coach)
- Coach ID (coach_id) — INT(7) — 기본 키 — NOT NULL
- Field
- Field2
Consultant (consultant)
- Consultant ID (consultant_id) — INT(7) — 기본 키 — NOT NULL
- Field
- Field2
Course (course)
- Course Name (course_name) — VARCHAR(12) — 기본 키 — NOT NULL
- Student ID (student_id) — INT(7) — 외래 키 → Student.Student ID — NOT NULL
Student (students)
- Student ID (student_id) — INT(7) — 기본 키 — NOT NULL
- Major (major) — boolean
- Retirement (retirement) — boolean