Create Permissions Tables, Add Permissions and Comments - Githubissues

Police-Data-Accessibility-Project / prod-to-dev-migration

Regularly migrates production database and schema to development database

1 stars 0 forks source link

Create Permissions Tables, Add Permissions and Comments #23

Closed maxachis closed 4 weeks ago

maxachis commented 1 month ago

Fixes

Addresses database component of https://github.com/Police-Data-Accessibility-Project/data-sources-app/issues/162

Description

Created Permissions and User_Permissions tables. Added two permissions to Permissions table. Added comments to tables and columns.
Created test user with elevated permissions for testing purposes.

Testing

Not applicable.

Performance

Additional tables added; performance impact marginal.
As currently designed, only a small number of users will have the provided permissions -- storage impact is trivial.

Docs

Not applicable.