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