Rename `state_names` table to `us_states` - Githubissues

Police-Data-Accessibility-Project / data-sources-app

An API and UI for using and maintaining the Data Sources database

MIT License

4 stars 5 forks source link

Rename `state_names` table to `us_states` #443

Closed maxachis closed 1 month ago

maxachis commented 2 months ago

Context

state_names is a small table in the database that provides the names and iso's of every state in the US.
The nomenclature is a little confusing, and the column names redundant, so let's change those and make sure we don't break anything in the app.

Requirements

Change state_names to us_states
Rename the state_name column to name
Rename the state_iso column to iso
Add comments to the table, name, and iso columns

Tests

All existing tests should be unaffected*
There may be cases where a test query inserting data needs modified to account for the changed nomenclature, but this should be the only cases.

Docs

Add comments to the table, name, and iso columns

Open questions

No open questions.