과제
테이블 (4)
Class (class)
- Class ID (class_id) — INT(11) — 기본 키 — NOT NULL
- Region (region) — VARCHAR(45)
- Class Number (class_number) — INT(11)
- Course (course) — VARCHAR(45)
- Consultant ID (consultant_id2) — INT(11) — 외래 키 → Consultant.Consultant ID — NOT NULL
- Class ID (class_id2) — INT(11) — 외래 키 → Consultant.Class ID — NOT NULL
- Coach ID (coach_id) — INT(11) — 외래 키 → Coach.Coach ID — NOT NULL
- Class ID (class_id3) — INT(11) — 외래 키 → Coach.Class ID — NOT NULL
Coach (coach)
- Coach ID (coach_id) — INT(11) — 기본 키 — NOT NULL
- Class ID (class_id) — INT(11) — 기본 키 — NOT NULL
- Responsibility (responsibility) — VARCHAR(45)
Consultant (consultant)
- Consultant ID (consultant_id) — INT(11) — 기본 키 — NOT NULL
- Class ID (class_id) — INT(11) — 기본 키 — NOT NULL
- Responsibility (responsibility) — VARCHAR(45)
Student (student)
- Student ID (student_id) — INT(11) — 기본 키 — NOT NULL
- Class ID (Key) — INT(11) — 기본 키 — NOT NULL
- NTH (nth) — INT(11)
- Is Major (is_major) — TINYINT
- Is Discharge (is_discharge) — TINYINT
- Studentcol (studentcol) — VARCHAR(45)
- Class ID (class_id2) — INT(11) — 외래 키 → Class.Class ID — NOT NULL