daily_1_엔티티추출
테이블 (5)
Class (class)
- Region (region) — VARCHAR(3) — 기본 키 — NOT NULL
- Class Num (class_num) — INT(2) — 기본 키 — NOT NULL
- Coach Id (coach_id) — INT(11) — 외래 키 → Coachs.Coach Id — NOT NULL
- Consultants Id (consultants_id) — INT(11) — 외래 키 → Consultants.Consultants Id — NOT NULL
Coachs (coachs)
- Coach Id (coach_id) — INT(11) — 기본 키 — NOT NULL
- Coach Name (coach_name) — VARCHAR(225)
Consultants (consultants)
- Consultants Id (consultants_id) — INT(11) — 기본 키 — NOT NULL
- Consultants Name (consultants_name) — VARCHAR(225)
Curriculums (curriculums)
- Curriculum Id (curriculum_id) — INT(11) — 기본 키 — NOT NULL
- Curriculum Name (curriculum_name) — VARCHAR(2)
Students (students)
- Student Id (student_id) — INT(11) — 기본 키 — NOT NULL
- Student Name (student_name) — VARCHAR(225)
- Year (yaer) — INT(2)
- Is Major (is_major) — CHAR(1)
- Is Discharge (is_discharge) — CHAR(1)
- Region (region) — VARCHAR(3) — 외래 키 → Class.Region — NOT NULL
- Class Num (class_num) — INT(2) — 외래 키 → Class.Class Num — NOT NULL
- Curriculum Id (curriculum_id) — INT(11) — 외래 키 → Curriculums.Curriculum Id — NOT NULL