1Hour_user

Tables (4)

Class (Untitled4)

  • class_id (Key) — Primary key — NOT NULL
  • teacher_id (Key2) — Foreign key → Teacher.user_id — NOT NULL
  • student_id (Key3) — Foreign key → Student.user_id — NOT NULL

School (Untitled)

  • school_id (Key) — Primary key — NOT NULL

Student (Untitled2)

  • user_id (Key) — Primary key — NOT NULL
  • school_id (Key2) — Foreign key → School.school_id — NOT NULL
  • class_id (Key3) — Foreign key → Class.class_id — NOT NULL

Teacher (Untitled3)

  • user_id (Key) — Primary key — NOT NULL
  • school_id (Key2) — Foreign key → School.school_id — NOT NULL