ex

Tables (3)

department_members

  • member_id — varchar(255) — Foreign key → members.member_id — NOT NULL
  • department_id — varchar(255) — Foreign key → departments.department_id — NOT NULL

departments

  • department_id — varchar(255) — Primary key — NOT NULL
  • department_name — varchar(255)

members

  • member_id — varchar(255) — Primary key — NOT NULL
  • member_name — varchar(255)