erd

Tables (5)

Class

  • Key — int — Primary key — NOT NULL
  • Field (location) — String
  • Field2 (class_id) — int
  • Key (course_type) — String — Foreign key → Consultant.Key — NOT NULL
  • Key (consultant_id) — int — Foreign key → Coach.Key — NOT NULL
  • Key (coach_id) — int — Foreign key → Course.Key — NOT NULL

Coach

  • Key — int — Primary key — NOT NULL
  • Field (coach_id) — int
  • Key (class_id) — int — Foreign key → Class.Key — NOT NULL

Consultant

  • Key — int — Primary key — NOT NULL
  • Field (consultant_id) — int

Course

  • Key — int — Primary key — NOT NULL
  • Field (course_type) — String

Student

  • Key — int — Primary key — NOT NULL
  • Field (name) — String
  • Field2 (cohort) — int
  • Field3 (is_major) — Boolean
  • Field4 (is_discharge) — Boolean
  • Key (class_id) — int — Foreign key → Class.Key — NOT NULL