DB 설계 및 ERD 실습

테이블 (6)

Class (class)

  • Class ID (class_id) — INT(11) — 기본 키 — NOT NULL
  • Class Number (class_number) — INT(50)
  • Consultant ID (consultant_id) — INT(11) — 외래 키 → Consultant.Consultant ID — NOT NULL
  • Coach ID (coach_id) — INT(11) — 외래 키 → Coach.Coach ID — NOT NULL
  • Region ID (region_id) — INT(11) — 외래 키 → Region.Region ID — NOT NULL
  • Course ID (course_id) — INT(11) — 외래 키 → Course.Course ID — NOT NULL

Coach (coach)

  • Coach ID (coach_id) — INT(11) — 기본 키 — NOT NULL
  • Task (task) — VARCHAR(255)

Consultant (consultant)

  • Consultant ID (consultant_id) — INT(11) — 기본 키 — NOT NULL
  • Task (task) — VARCHAR(255)

Course (course)

  • Course ID (course_id) — INT(11) — 기본 키 — NOT NULL
  • Course Name (course_name) — VARCHAR(255)

Region (region)

  • Region ID (region_id) — INT(11) — 기본 키 — NOT NULL
  • Region Name (region_name) — VARCHAR(50)

Student (student)

  • Student ID (student_id) — INT(11) — 기본 키 — NOT NULL
  • Generation (generation) — VARCHAR(50)
  • Major (major) — BOOLEAN
  • Withdrawal (withdrawal) — BOOLEAN
  • Class ID (class_id) — INT(11) — 외래 키 → Class.Class ID — NOT NULL