Department
Tables (3)
department
- department_id — BIGINT — Primary key — NOT NULL — AUTO INCREMENT
- department_name — VARCHAR(20) — NOT NULL
- department_code — VARCHAR(50) — NOT NULL
member
- member_id — VARCHAR(20) — Primary key — NOT NULL
- member_name — VARCHAR(20) — NOT NULL
member_department
- member_department_id — BIGINT — Primary key — NOT NULL — AUTOINCREMENT
- member_id — VARCHAR(20) — Foreign key → member.member_id — NOT NULL
- department_id — BIGINT — Foreign key → department.department_id — NOT NULL — AUTO INCREMENT