9기_대전2반_이시영_ERD
테이블 (5)
Class (class)
- Class (class) — INT — 기본 키 — NOT NULL
- Region (region) — VARCHAR(50)
- Coach ID (coach_id) — INT — 외래 키 → Coach.Coach ID
- Consultant ID (consultant_id) — INT — 외래 키 → Consultant.Consultant ID — NOT NULL
Coach (coach)
- Coach ID (coach_id) — INT — 기본 키 — NOT NULL
- Name (name) — VARCHAR(50)
- Work (work) — VARCHAR(100)
Consultant (consultant)
- Consultant ID (consultant_id) — INT — 기본 키 — NOT NULL
- Name (name) — VARCHAR(50)
- Work (work) — VARCHAR(100)
Student (student)
- Student ID (student_id) — INT — 기본 키 — NOT NULL
- Class (class) — INT — 외래 키 → Class.Class — NOT NULL
- Curriculum (curriculum) — VARCHAR(50)
- Name (name) — VARCHAR(50)
- Degree (degree) — INT
- Discharge (discharge) — BOOLEAN
- Track (track) — VARCHAR(50( — 외래 키 → Track.Track — NOT NULL
Track (track)
- Track (track) — VARCHAR(50( — 기본 키 — NOT NULL