...
So here are some things I think will go away/need to be changed:
| table.column | notes |
|---|---|
execution_blocks.product_code | obsolete |
execution_blocks.filegroup_id | obsolete |
images.file_id | obsolete |
calibrations.project_code | obsolete |
calibrations.filegroup_id | obsolete |
subscans.file_id | VLASS thought it was needed, never been used? |
scans.filegroup_id | obsolete |
scans.filename | never been used? |
image_products | turn into ancillary products, move metadata to the relevant image(s) |
| images.thumbnail | turn into ancillary products and teach the files table about thumbnail paths |
This isn't an exhaustive list, feel free to add to it.
...