assignment07

Tables (5)

CLASS

  • class_id — int — Primary key — NOT NULL
  • consultant_id — int
  • coach_id — int
  • region — varchar
  • class_number — int

COACH

  • coach_id — int — Primary key — NOT NULL
  • name — varchar
  • responsibility — varchar
  • class_id — int — Foreign key → CLASS.class_id — NOT NULL

CONSULTANT

  • consultant_id — int — Primary key — NOT NULL
  • name — varchar
  • responsibility — varchar
  • class_id — int — Foreign key → CLASS.class_id — NOT NULL

CURRICULUM

  • curriculum_id — int — Primary key — NOT NULL
  • type — varchar
  • name — varchar
  • start_date — date
  • end_date — date
  • class_id — int — Foreign key → CLASS.class_id — NOT NULL

STUDENT

  • student_id — int — Primary key — NOT NULL
  • class_id (class_id2) — int — Foreign key → CLASS.class_id — NOT NULL
  • class_id — int
  • generation — int
  • is_major — boolean
  • is_dropped — boolean