DB설계 및 ERD 작성 실습

테이블 (6)

Class (class)

  • Class (class) — VARCHAR(5) — 기본 키 — NOT NULL
  • Major (major) — VARCHAR(4)
  • Track (track) — VARCHAR(2)
  • 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)

Consultant (consultant)

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

Major (major)

  • Major (major) — VARCHAR(4) — 기본 키
  • Yes (yes) — BOOLEAN

Student (student)

  • Student Id (student_id) — INT(6) — 기본 키
  • Grade (grade) — INT(2) — NOT NULL
  • Exit (exit) — BOOLEAN — NOT NULL
  • Name (name) — VARCHAR(20) — NOT NULL
  • Age (age) — INT(2) — NOT NULL
  • Track (track) — VARCHAR(2)
  • Class (class) — VARCHAR(5) — 외래 키 → Class.Class — NOT NULL
  • Track (track2) — VARCHAR(2) — 외래 키 → Track.Track
  • Major (major) — VARCHAR(4) — 외래 키 → Major.Major

Track (track)

  • Track (track) — VARCHAR(2) — 기본 키