daily work

Tables (6)

Class (class)

  • location — VARCHAR — Primary key — NOT NULL
  • class_id — INT — Primary key — NOT NULL

Coach

  • Coach_ID — INT — Primary key — NOT NULL
  • name — VARCHAR
  • location — VARCHAR — Foreign key → Class.location — NOT NULL
  • class_id — INT — Foreign key → Class.class_id — NOT NULL

Cohort

  • Cohort_ID — INT — Primary key — NOT NULL
  • Cohort_name — INT

Consultant

  • Consultant_ID — INT — Primary key — NOT NULL
  • name — VARCHAR
  • location — VARCHAR — Foreign key → Class.location — NOT NULL
  • class_id — INT — Foreign key → Class.class_id — NOT NULL

Curriculum

  • Curriculum_ID — INT — Primary key — NOT NULL
  • Curriculum Name — VARCHAR

Student (student)

  • Student_ID — INT — Primary key — NOT NULL
  • name — STR
  • major — BOOL
  • graduated — BOOL
  • Cohort_ID — INT — Foreign key → Cohort.Cohort_ID — NOT NULL
  • location — VARCHAR — Foreign key → Class.location — NOT NULL
  • class_id — INT — Foreign key → Class.class_id — NOT NULL
  • Curriculum_ID — INT — Foreign key → Curriculum.Curriculum_ID — NOT NULL