assignment07-2

Tables (6)

CLASS

  • id — INT
  • consultant_id — INT — NOT NULL
  • coach_id — INT
  • region — VARCHAR(20) — NOT NULL
  • class_number — INT — NOT NULL

CLASS_CURRICULUM

  • class_id — INT
  • curriculum_id — INT

COACH

  • id — INT
  • name — VARCHAR(50) — NOT NULL
  • responsibility — VARCHAR(200) — NOT NULL

CONSULTANT

  • id — INT
  • name — VARCHAR(50) — NOT NULL
  • responsibility — VARCHAR(200) — NOT NULL

CURRICULUM

  • id — INT
  • type — VARCHAR(20) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • CHECK — (type IN ('공통', '특화', '자율'))

STUDENT

  • id — INT
  • class_id — INT — NOT NULL
  • generation — INT — NOT NULL
  • is_major — BOOLEAN — NOT NULL
  • is_dropped — BOOLEAN — NOT NULL