과제
테이블 (4)
Class (class)
- ClassNumber (class_id) — INTEGER — 기본 키 — NOT NULL
- ConsultantNumber (consultant_id) — INTEGER — 외래 키 → Consultant.ConsultantNumber — NOT NULL
- Region (region) — VARCHAR(100)
- SmallClassNumber (small_class_number) — INTEGER
Coach (coach)
- CoachNumber (coach_id) — INTEGER — 기본 키 — NOT NULL
- LastName (last_name) — VARCHAR(100)
- FirstName (first_name) — VARCHAR(100)
- ClassNumber (class_id) — INTEGER — 외래 키 → Class.ClassNumber — NOT NULL
- ConsultantNumber (consultant_id) — INTEGER — 외래 키 → Class.ConsultantNumber — NOT NULL
Consultant (consultant)
- ConsultantNumber (consultant_id) — INTEGER — 기본 키 — NOT NULL
- LastName (last_name) — VARCHAR(100)
- FirstName (first_name) — VARCHAR(100)
Student (student)
- StudentNumber (student_id) — INTEGER — 기본 키 — NOT NULL
- ClassNumber (class_id) — INTEGER — 외래 키 → Class.ClassNumber — NOT NULL
- ConsultantNumber (consultant_id) — INTEGER — 외래 키 → Class.ConsultantNumber — NOT NULL
- LastName (last_name) — VARCHAR(100)
- FirstName (first_name) — VARCHAR(100)
- Generation (generation) — INTEGER
- Curriculum (curriculum) — VARCHAR(100)
- IsMajor (is_major) — BOOLEAN
- IsDischarge (is_discharge) — BOOLEAN