member

Tables (3)

departmentmembers

  • id (pk) — long — Primary key — NOT NULL
  • memberId (fk) — String — Foreign key → members.memberNumber — NOT NULL
  • departmentId (fk2) — String — Foreign key → departments.code — NOT NULL

departments

  • code (pk) — String — Primary key — NOT NULL
  • departmentName (Field) — String

members

  • memberNumber (pk) — String — Primary key — NOT NULL
  • name (Field) — String