Write SQL to create lookup tables in the new data model - Githubissues

cityofaustin / atd-vz-data

The technology that powers the City of Austin's Vision Zero program

https://visionzero.austin.gov/viewer/

11 stars 3 forks source link

Write SQL to create lookup tables in the new data model #1426

Closed roseeichelmann closed 4 months ago

roseeichelmann commented 5 months ago

Associated issues

Closes https://github.com/cityofaustin/atd-data-tech/issues/16635

Testing

URL to test: You could test on ur local db.

Steps to test:

Start up your local db, could be johns data model db even. Run the up and down migrations.
If you are using another db that already has lookup tables, you could probs first run the down sql to remove the tables to then test the up migrations sql.

Ship list

[ ] Check migrations for any conflicts with latest migrations in master branch
[ ] Confirm Hasura role permissions for necessary access
[ ] Code reviewed
[ ] Product manager approved

roseeichelmann commented 4 months ago

@johnclary sounds good, just removed them!