The current DB has several legacy naming conventions. In addition to that, there are some inconsistencies in column names. Due to the size of changes, in particular downstream pages, this will likely be broken out into multiple PR's.
Currently identified:
recon -> mask_recons
metadata -> scans
catalog -> scan_labels
scan -> scan_pvs (scan_params)
For naming as per SQLAlchemy conventions:
All ORM tables: CapitalCase (singular)
SQL Table Names: snake_case (plural)
All Columns: snake_case
Primary Keys: id
Foreign_Keys: foreigntable_id
And any other general cleanup we think we need.
The current DB has several legacy naming conventions. In addition to that, there are some inconsistencies in column names. Due to the size of changes, in particular downstream pages, this will likely be broken out into multiple PR's.
Currently identified:
recon -> mask_recons
metadata -> scans
catalog -> scan_labels
scan -> scan_pvs (scan_params)
For naming as per SQLAlchemy conventions:
All ORM tables: CapitalCase (singular)
SQL Table Names: snake_case (plural)
All Columns: snake_case
Primary Keys: id
Foreign_Keys: foreigntable_id
And any other general cleanup we think we need.