...
So here are some things I think will go away/need to be changed:
| table.column | notes | Objections |
|---|---|---|
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? | Indexer needs this for VLBA. Only way to link subscans and data descriptions to filegroup_id since execution_block_id is not unique in this case |
scans.filegroup_id | obsolete | |
scans.filename | never been used? | |
image_products | turn into ancillary products, transfer configurations to the relevant image(s) | |
| images.thumbnail | turn into ancillary products and teach the files table about thumbnail paths | |
| intents | empty table, never used? | |
| subscan_intents | empty table, never used? |
This isn't an exhaustive list, feel free to add to it.
...