0923644
과제
테이블 (5)
Class (class)
- Class ID (class id) — INT(11) — 기본 키 — NOT NULL
- Student_ID (student_id2) — INT(11) — 외래 키 → Student.Student_ID — NOT NULL
- Consultant_ID (consultant_id) — INT(11) — 외래 키 → Consultant.Consultant_ID — NOT NULL
- Coach_ID (coach_id) — INT(11) — 외래 키 → Coach.Coach_ID — NOT NULL
- Kind (kind) — VARCHAR(10) — 외래 키 → Curriculum.Kind — NOT NULL
- Kind (kind2) — VARCHAR(10) — 외래 키 → Student.Kind — NOT NULL
- Region (region) — VARCHAR(20)
- Number (number) — INT(11)
Coach (coach)
- Coach_ID (coach_id) — INT(11) — 기본 키 — NOT NULL
- NAME (name) — VARCHAR(255)
Consultant (consultant)
- Consultant_ID (consultant_id) — INT(11) — 기본 키 — NOT NULL
- Name (name) — VARCHAR(255)
Curriculum (curriculum)
- Kind (kind) — VARCHAR(10) — 기본 키 — NOT NULL
Student (student)
- Student_ID (student_id) — INT(11) — 기본 키 — NOT NULL
- Kind (kind) — VARCHAR(10) — 외래 키 → Curriculum.Kind — NOT NULL
- Major (major) — BOOL
- Discharge (discharge) — BOOL
- Last Name (last_name) — VARCHAR(255)
- First NAME (first name) — VARCHAR(255)