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