자기주도 필수5

테이블 (5)

교육과정 (Untitled5)

  • Track (track) — VARCHAR(255)

교육생 (student)

  • Cardinal Number (cardinal_number) — INT(11) — 기본 키 — NOT NULL
  • Major (major) — VARCHAR(255)
  • Discharge (discharge) — BOOLEAN

반 (group)

  • Group ID (group_id) — INT(11) — 기본 키 — NOT NULL
  • Location (location) — VARCHAR(255)
  • Group Number (group_number) — INT(11)

컨설턴트 (consultant)

  • Main Work (main_work) — VARCHAR(255)
  • Group ID (group_id) — INT(11) — 외래 키 → 반.Group ID — NOT NULL

코치 (Untitled3)

  • Main Work (main_work) — VARCHAR(255)
  • Group ID (group_id) — INT(11) — 외래 키 → 반.Group ID — NOT NULL