hw
Tables (5)
Class
- class_id (Key) — INTEGER — Primary key — NOT NULL
- region (att1) — TEXT
- group (att2) — INTEGER
Coach
- coach_id (Key) — INTEGER — Primary key — NOT NULL
- name (att1) — TEXT — NOT NULL
- work (att2) — TEXT — NOT NULL
- class_id (Key2) — INTEGER — Foreign key → Class.class_id — NOT NULL
Consultant
- consultant_id (Key) — INTEGER — Primary key — NOT NULL
- name (att1) — TEXT — NOT NULL
- work (att2) — TEXT — NOT NULL
- class_id (Key2) — INTEGER — Foreign key → Class.class_id — NOT NULL
Curriculum
- curriculum_id (Key) — INTEGER — Primary key — NOT NULL
- curriculum_name (att1) — TEXT — NOT NULL
Student
- student_id (Key) — INTEGER — Primary key — NOT NULL
- name (att1) — TEXT — NOT NULL
- generation (att2) — INTEGER
- ismajor (att3) — BOOLEAN — NOT NULL
- isOut (att4) — BOOLEAN — NOT NULL
- class_id (Key2) — INTEGER — Foreign key → Class.class_id — NOT NULL