DB설계, ERD 작성 실습

테이블 (6)

Class (class)

  • Class Id (class_id) — VARCHAR(5) — 기본 키 — NOT NULL
  • Region (region) — VARCHAR(3) — NOT NULL
  • Room (room) — INT(2) — NOT NULL
  • Coach Id (coach_id) — INT(6) — 외래 키 → Coach.Coach Id
  • Consultant Id (consultant_id) — INT(6) — 외래 키 → Consultant.Consultant Id — NOT NULL

Coach (coach)

  • Coach Id (coach_id) — INT(6) — 기본 키
  • Work (work) — VARCHAR(255)
  • Class Id (class_id) — VARCHAR(5)

Consultant (consultant)

  • Consultant Id (consultant_id) — INT(6) — 기본 키 — NOT NULL
  • Work (work) — VARCHAR(255)
  • Class Id (class_id) — VARCHAR(5)

Major (major)

  • Major Name (major_name) — VARCHAR(10) — 기본 키
  • Yes Or No (yes_or_no) — BOOLEAN

Student (student)

  • Student Id (student_id) — INT(6) — 기본 키 — NOT NULL
  • Grade (grade) — INT(3) — NOT NULL
  • Exit (exit) — BOOLEAN
  • Name (name) — VARCHAR(10)
  • Age (age) — INT(3)
  • Track Name (track_name) — VARCHAR(10) — 외래 키 → Track.Track Name
  • Class Id (class_id) — VARCHAR(5) — 외래 키 → Class.Class Id — NOT NULL
  • Major Name (major_name) — VARCHAR(10) — 외래 키 → Major.Major Name

Track (track)

  • Track Name (track_name) — VARCHAR(10) — 기본 키