DB설계

테이블 (4)

Class (Untitled2)

  • class_id (Key) — int — 기본 키 — NOT NULL
  • area (Field) — enum
  • class (Field2) — enum
  • curriculum (Field3) — enum

Coach (Untitled4)

  • coach_id (Key) — int — 기본 키 — NOT NULL
  • class_id (Key2) — int — 외래 키 → Class.class_id — NOT NULL
  • class_id (Field)

Consultant (Untitled3)

  • consultant_id (Key) — int — 기본 키 — NOT NULL
  • class_id (Key2) — int — 외래 키 → Class.class_id — NOT NULL
  • class_id (Field) — int
  • work (Field2)

Student (Untitled)

  • student_id (Key) — 기본 키 — NOT NULL
  • class_id (Key2) — int — 외래 키 → Class.class_id — NOT NULL
  • class_id (Field) — int
  • number (Field2) — int
  • major (Field3) — boolean
  • retire (Field4) — boolean