multi-tenant
Tables (14)
Branch_Roles
- branch_id — UUID — Primary key — NOT NULL
- role_id — UUID — Primary key — NOT NULL
Branches
- branch_id — UUID
- tenant_id — UUID — NOT NULL
- name — VARCHAR(255) — NOT NULL
Dashboard_Widgets
- dashboard_id — UUID — Primary key — NOT NULL
- widget_id — UUID — Primary key — NOT NULL
- layout_json — JSONB
Dashboards
- dashboard_id — UUID
- tenant_id — UUID — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
Department_Roles
- department_id — UUID — Primary key — NOT NULL
- role_id — UUID — Primary key — NOT NULL
Departments
- department_id — UUID
- branch_id — UUID — NOT NULL
- name — VARCHAR(255) — NOT NULL
Pages
- page_id — UUID
- tenant_id — UUID
- page_key — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- metadata_json — JSONB
Position_Roles
- position_id — UUID — Primary key — NOT NULL
- role_id — UUID — Primary key — NOT NULL
Positions
- position_id — UUID
- tenant_id — UUID — NOT NULL
- name — VARCHAR(255) — NOT NULL
Role_Permissions
- permission_id — BIGSERIAL
- role_id — UUID — NOT NULL
- resource_type — VARCHAR(100) — NOT NULL
- resource_key — VARCHAR(255) — NOT NULL
- can_read — BOOLEAN — NOT NULL
- can_edit — BOOLEAN — NOT NULL
- can_create — BOOLEAN — NOT NULL
- can_delete — BOOLEAN — NOT NULL
- UNIQUE(role_id, — resource_type,
Roles
- role_id — UUID
- tenant_id — UUID — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
Tenants
- tenant_id — UUID
- name — VARCHAR(255) — NOT NULL
- status — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP
User_Roles
- user_id — UUID — Primary key — NOT NULL
- role_id — UUID — Primary key — NOT NULL
Users
- user_id — UUID
- tenant_id — UUID — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- branch_id — UUID
- department_id — UUID
- position_id — UUID
- is_active — BOOLEAN
- created_at — TIMESTAMP