school

Tables (4)

class (Untitled)

  • class_id (key) — Primary key — NOT NULL
  • grade (Field)
  • class_number (Field2)

major (Untitled4)

  • major_id (Key) — Primary key — NOT NULL
  • name (Field)

student (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • class_id (id) — Foreign key → class.class_id — NOT NULL
  • major_id (Key2) — Foreign key → major.major_id — NOT NULL
  • name (Field)
  • number (Field2)

teacher (Untitled3)

  • teacher_id (Key) — Primary key — NOT NULL
  • class_id (key) — Foreign key → class.class_id — NOT NULL
  • name (Field)
  • type (Field2)