ERD실습
테이블 (5)
Class (Untitled)
- Class_Id (class_id) — INT — 기본 키
- Area (area) — VARCHAR
- Class_Num (class_num) — INT
- Consultant_Id (consultant_id2) — INT — 외래 키 → Consultant.Consultant_Id — NOT NULL
Coach (Untitled2)
- Coach_Id (coach_id) — INT — 기본 키 — NOT NULL
- Job (job) — VARCHAR(30)
- Class_Id (class_id) — INT — 외래 키 → Class.Class_Id
Consultant
- Consultant_Id (consultant_id) — INT — 기본 키 — NOT NULL
- Job (job) — VARCHAR(30)
EduCourse
- Course_Id (course_id) — INT — 기본 키 — NOT NULL
- Course (course) — VARCHAR(20)
- Student_Id (student_id) — INT — 외래 키 → Student.Student_Id — NOT NULL
Student (Untitled3)
- Student_Id (student_id) — INT — 기본 키 — NOT NULL
- Generation (generation) — INT
- Major (major) — BOOLEAN
- Out (out) — BOOLEAN
- Class_Id (class_id) — INT — 외래 키 → Class.Class_Id