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)