DB설계_ERD작성실습
DB설계_ERD작성실습
테이블 (4)
Class (class)
- Class_Code (class_code) — VARCHAR(5) — 기본 키 — NOT NULL
- Consultant_Id (consultant_id) — INT(11) — 외래 키 → consultant.Consultant_Id — NOT NULL
- Region (region) — VARCHAR(100)
- Class_Number (class_number) — INT(11)
- Coach_Id (coach_id) — INT(11) — 외래 키 → coach.Coach_Id — NOT NULL
coach
- Coach_Id (coach_id) — INT(11) — 기본 키 — NOT NULL
- Task (task) — VARCHAR(100)
- Class_Code (class_code) — VARCHAR(5)
- Assignment (assignment) — VARCHAR(5)
consultant
- Consultant_Id (consultant_id) — INT(11) — 기본 키 — NOT NULL
- Class_Code (class_code) — VARCHAR(5)
- Task (task) — VARCHAR(100)
student
- Student_Id (student_id) — INT(11) — 기본 키 — NOT NULL
- Class_Code (class_code2) — VARCHAR(5) — 외래 키 → Class.Class_Code — NOT NULL
- Consultant_Id (consultant_id) — INT(11) — 외래 키 → Class.Consultant_Id — NOT NULL
- Coach_Id (coach_id) — INT(11) — 외래 키 → coach.Coach_Id — NOT NULL
- Entry_Point (entry_point) — INT(11)
- Class (class) — VARCHAR(20)
- Discharge (discharge) — VARCHAR(5)
- Curriculum (curriculum) — VARCHAR(5)