Add missing foreign key constraints to RBAC tables
Open
- Dominant language
- Python
- Stars
- 670
- Forks
- 183
- Avg merge
- 17h 7m
- Merged PRs (30d)
- 358
Description
Several RBAC tables are missing foreign key constraints, allowing orphan rows when referenced entities are deleted.
Add FK constraints via Alembic migration:
- permissions.role_id → roles.id (CASCADE DELETE)
- user_roles.user_id → users.uuid (CASCADE DELETE)
- user_roles.role_id → roles.id (CASCADE DELETE)
JIRA Issue: BA-4736
Contributor guide
Assessment
This issue has not been assessed yet.