교육기관DB

테이블 (4)

교육생 (student)

  • Student id (student_id) — CHAR(7) — 기본 키 — NOT NULL
  • Class id (class_id2) — INT — 외래 키 → 반.Class id — NOT NULL
  • Consultant Id (consultant_id2) — CHAR(7) — 외래 키 → 반.Consultant Id — NOT NULL
  • Name (name) — VARCHAR(15)
  • Cardinal Num (cardinal_num) — TINYINT
  • Class id (class_id) — INT
  • Leave (leave) — BOOL
  • Majorm (major) — BOOL

반 (class)

  • Class id (class_id) — INT — 기본 키 — NOT NULL
  • Consultant Id (consultant_id) — CHAR(7) — 외래 키 → 컨설턴트.Consultant Id — NOT NULL
  • Class Num (class_num) — TINYINT
  • Region (region) — CHAR(7)
  • Track (track) — CHAR(7)
  • Coach id (coach_id2) — CHAR(7) — 외래 키 → 코치.Coach id — NOT NULL

컨설턴트 (consultant)

  • Consultant Id (consultant_id) — CHAR(7) — 기본 키 — NOT NULL
  • Name (name) — VARCHAR(15)
  • Work (work) — VARCHAR(60)

코치 (coach)

  • Coach id (coach_id) — CHAR(7) — 기본 키 — NOT NULL
  • Name (name) — VARCHAR(15)
  • Work (work) — VARCHAR(15)