I pushed some new changes that address the most urgent of Gregory Dubois-Felsmann's comments. I've replaced the first section which described the old schema files with some text on the new Felis-based tools, removed the Enterprise Architect references, updated the stale links for SciSQL, and added a line at the start of the tables which shows the cat SHA1 that was used. I put some text in the README also as a quick guide for how to update the document with a new schema.
With that, the TODO items I propose to defer (and ticket) are:
- Deciding what to do with the diagrams
- Description of ADQL, updates to the UDF discussion, possible mention of qserv_*
- Exposure and Visit tables re: Gen3.
- Checking if the provenance model is still relevant
Does that seem like a reasonably passable state for an RFC, Gregory Dubois-Felsmann?
Attached a diff of the column list in the baseline LDM-153 vs. the column list currently on master of the cat package (sha ddbdf7d): baseline_vs_master_diff.txt
. There are a substantial number of changes which have been made since the document was baselined. I'm willing to accept these as-is and RFC them in bulk; I don't know that there's much value in attempting to re-assess each ticket in the past 5 years.
As a sanity check, the column list I obtain from scraping of the master version of cat SQL is identical to the yaml file. That is only checking the table names; not the various annotations.
(edit: on the attached diff, the left column is baseline and the right column is the latest master)