22. ERD 작성 실습

테이블 (5)

Classes (class)

  • class_id (PK) — Long — 기본 키 — NOT NULL
  • coach_id (FK) — Long — 외래 키 → Consultants.consultant_id
  • consultant_id (FK2) — Long — 외래 키 → Coaches.coach_id — NOT NULL
  • class_name (Field) — varchar(10) — NOT NULL
  • class_number (Field2) — number — NOT NULL

Coaches (coach)

  • coach_id (PK) — Long — 기본 키 — NOT NULL
  • coach_work (Field) — varchar(10) — NOT NULL

Consultants (consultant)

  • consultant_id (PK) — Long — 기본 키 — NOT NULL
  • consultant_class (Field2) — number — NOT NULL

Curriculums (curriculum)

  • curriculum_id (Key) — Long — 기본 키 — NOT NULL
  • curriculum_name (Field) — varchar(4) — NOT NULL

Students (student)

  • student_id (Key) — Long — 기본 키 — NOT NULL
  • student_generation (Field) — number — NOT NULL
  • student_isMajor (Field2) — bool — NOT NULL
  • student_isDischarge (Field3) — bool — NOT NULL