실습

테이블 (4)

교육생 (student)

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

반 (class)

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

컨설턴트 (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)