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