Add external accounts table and associated database logic. - Githubissues

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

Regularly migrates production database and schema to development database

1 stars 0 forks source link

Add external accounts table and associated database logic. #20

Closed maxachis closed 1 month ago

maxachis commented 1 month ago

Fixes

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

Description

Created new enum type 'account_type' with value 'github'
Added table 'external_accounts' to store linked external accounts for users.
Also created a view 'user_external_accounts' to display user's external accounts. Addresses database component of #296.

Testing

Steps to test this PR, if there are any required.

Performance

Marginal; additional componetns added to database.

Docs

Not applicable.