SSAFY 과제
테이블 (6)
Classes (classes)
- Class Id (class_id) — INT — 기본 키 — NOT NULL
- Class (class) — INT
Coach (coach)
- Coach Id (coach_id) — INT — 기본 키 — NOT NULL
- Work (work) — VARCHAR(50)
- Class Id (class_id) — INT — 외래 키 → Classes.Class Id — NOT NULL
- Region Id (region_id) — INT — 외래 키 → Regions.Region Id — NOT NULL
Consultant (consultant)
- Consultant Id (consultant_id) — INT — 기본 키 — NOT NULL
- Work (work) — VARCHAR(50)
- Class Id (class_id) — INT — 외래 키 → Classes.Class Id — NOT NULL
- Region Id (region_id) — INT — 외래 키 → Regions.Region Id — NOT NULL
Curriculum (curriculum)
- Curriculum Id (curriculum _id) — INT — 기본 키 — NOT NULL
- Part (part) — CHAR(2)
Regions (regions)
- Region Id (region_id) — INT — 기본 키 — NOT NULL
- Region (region) — VARCHAR(3)
Students (students)
- Student Id (student_id) — INT — 기본 키 — NOT NULL
- Name (name) — VARCHAR(10)
- Term (term) — INT
- Major (major) — BOOLEAN
- Left (left) — BOOLEAN
- Curriculum Id (curriculum _id) — INT — 외래 키 → Curriculum.Curriculum Id — NOT NULL