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