DB설계, ERD작성 실습

테이블 (4)

Coach (coach)

  • Coach Id (coach_id) — INT(11) — 기본 키 — NOT NULL
  • Last Name (last_name) — VARCHAR(255)
  • First Name (first_name) — VARCHAR(255)
  • Room Id (room_id) — INT(30) — 외래 키 → Room.Room Id — NOT NULL

Consultant (consultant)

  • Consultant Id (consultant_id) — INT(11) — 기본 키 — NOT NULL
  • Last Name (last_name) — VARCHAR(255)
  • First Name (first_name) — VARCHAR(255)
  • Room Id (room_id) — INT(30) — 외래 키 → Room.Room Id — NOT NULL

Room (room)

  • Room Id (room_id) — INT(30) — 기본 키 — NOT NULL
  • Region (region) — VARCHAR(255)
  • Number (number) — INT(11)
  • Course (course) — VARCHAR(255)

Student (student)

  • Student Id (student_id) — INT(11) — 기본 키 — NOT NULL
  • Last Name (last_name) — VARCHAR(255)
  • First Name (first_name) — VARCHAR(255)
  • Major (major) — BOOLEAN
  • Discharge (discharge) — BOOLEAN
  • Room Id (room_id) — INT(30) — 외래 키 → Room.Room Id — NOT NULL