SpringTest

Tables (3)

Department (Untitled)

  • department_id (Key) — String — Primary key — NOT NULL
  • department_name (Field) — String

Staff (Untitled2)

  • staff_no (Key) — Long — Primary key — NOT NULL
  • staff_name (Field) — String

StaffDepartment (Untitled3)

  • staff_department_id (Key) — Long — Primary key — NOT NULL
  • department_id (Key2) — String — Foreign key → Department.department_id — NOT NULL
  • staff_no (Key3) — Long — Foreign key → Staff.staff_no — NOT NULL