NOJO_Project

Tables (3)

Department (Untitled2)

  • DEPT KEY (Key) — Primary key — NOT NULL
  • Department Name (Field)

Member (Untitled)

  • member_id (Key) — Primary key — NOT NULL
  • DEPT KEY (Key2) — Foreign key → Department.DEPT KEY — NOT NULL
  • SchoolId (Key3) — Foreign key → School.SchoolId — NOT NULL
  • Name (Field)
  • ID (Field2)
  • Password (Field3)

School (Untitled3)

  • SchoolId (Key) — Primary key — NOT NULL
  • School Name (Field)
  • Region (Field2)
  • VacationStart (Field3)
  • VacationEnd (Field4)