waterthetrees / wtt_db

waterthetrees.com local dev database
Creative Commons Zero v1.0 Universal
0 stars 0 forks source link

feature/53/rename-tree-sources-staging #54

Closed tzinckgraf closed 1 year ago

tzinckgraf commented 1 year ago

Renamed tree_sources_staging to treedata_staging to more easily determine what table this is staging.

Other columns remain the same as it reflects the tree-sources file.

Two files were added. One is the migrations file, the other is the file created by running the fetch-tables script.

This relates to #53

zoobot commented 1 year ago

So the unique tree id should be called "id", the unique source id should be called id_source_name/idSourceName.

The database serialized table names should be named after the table like id_treedata or id_source or id_crosswalk or id_likes.