실습
테이블 (4)
교육생 (student)
- Student Id (student_id) — CHAR(7) — 기본 키 — NOT NULL
- Class id (class_id2) — INT — 외래 키 → 반.Class id — NOT NULL
- Consultant Id (consultant_id) — CHAR(7) — 외래 키 → 반.Consultant Id — NOT NULL
- Name (name) — VARCHAR(15)
- Cardinal Num (cardinal_num) — TINYINT
- Class Id (class_id) — INT
- Leave (leave) — BOOL
- Major (major) — BOOL
반 (class)
- Class id (class_id) — INT — 기본 키 — NOT NULL
- Consultant Id (consultant_id) — CHAR(7) — 외래 키 → 컨설턴트.Consultant Id — NOT NULL
- Region (region) — CHAR(9)
- Class Num (class_num) — TINYINT
- Coach Id (coach_id) — CHAR(7) — 외래 키 → 코치.Coach Id — NOT NULL
- Track (track) — CHAR(6)
컨설턴트 (consultant)
- Consultant Id (consultant_id) — CHAR(7) — 기본 키 — NOT NULL
- Name (name) — VARCHAR(15)
- Work (work) — VARCHAR(60)
코치 (coach)
- Coach Id (coach_id) — CHAR(7) — 기본 키 — NOT NULL
- Name (name) — VARCHAR(15)
- Work (work) — VARCHAR(15)