[Issue]: Database schema: users and roles #14

Branch Name

feature/14-users-roles

Task

Description
Design the tables for users and roles, matching the department-based role model used for permissions. For DB schemas we use https://dbdiagram.io/

Scope

• users table
• roles table
• Relationship between users and roles
• Migration

Acceptance Criteria

• The tables support the roles defined for the app
• The migration applies cleanly on an empty database
• Relationships and constraints are in place

Checklist

• I have checked for duplicate issues.
• I have assigned the issue to the correct project board.
• I have tagged the issue properly.

Code of Conduct

• I agree to follow this project's Code of Conduct