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