교육기관

테이블 (5)

Class (class)

  • Class Id (class_id) — INT(11) — 기본 키 — NOT NULL
  • Student Id (student_id) — INT(11) — 외래 키 → Student.Student Id — NOT NULL
  • Consultant Id (consultant_id) — INT(11) — 외래 키 → Consultant.Consultant Id — NOT NULL
  • Coach Id (coach_id) — INT(11) — 외래 키 → Coach.Coach Id — NOT NULL
  • Track Id (track_id) — INT(11) — 외래 키 → Track.Track Id — NOT NULL
  • Region (region) — VARCHAR(100)
  • Class (class) — INT(11)

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)

Student (student)

  • Student Id (student_id) — INT(11) — 기본 키 — NOT NULL
  • Cardinal Number (cardinal_number) — INT(11) — NOT NULL
  • Major (major) — Boolean
  • Discharge (discharge) — Boolean

Track (track)

  • Track Id (track_id) — INT(11) — 기본 키 — NOT NULL
  • Name (name) — VARCHAR(101)