교육기관DB
테이블 (4)
교육생 (student)
- Student id (student_id) — CHAR(7) — 기본 키 — NOT NULL
- Class id (class_id2) — INT — 외래 키 → 반.Class id — NOT NULL
- Consultant Id (consultant_id2) — CHAR(7) — 외래 키 → 반.Consultant Id — NOT NULL
- Name (name) — VARCHAR(15)
- Cardinal Num (cardinal_num) — TINYINT
- Class id (class_id) — INT
- Leave (leave) — BOOL
- Majorm (major) — BOOL
반 (class)
- Class id (class_id) — INT — 기본 키 — NOT NULL
- Consultant Id (consultant_id) — CHAR(7) — 외래 키 → 컨설턴트.Consultant Id — NOT NULL
- Class Num (class_num) — TINYINT
- Region (region) — CHAR(7)
- Track (track) — CHAR(7)
- Coach id (coach_id2) — CHAR(7) — 외래 키 → 코치.Coach id — NOT NULL
컨설턴트 (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)