This repository supports code used to create tables in the GAP_PRODUCTS Oracle schema. These tables include the master production tables, tables shared with AKFIN, and tables publicly shared on FOSS.
Here are all of the back burner issues that will need to be added to the gap products effort in upcoming lull periods. Please consider this a living document.
🔧 Optimizing gapindex/production workflow
[x] Have gapindex only update parts of the table so the whole table doesn't have to be dropped, just the things that changed.
[x] Establish audit tables, which can act as track changes to tables and schemata.
[x] Incorporate gap_products.taxonomic_classifications and gap_products.taxonomic_groups changes and minimum ID integration and move away from the old racebase.species table
Tasklist
Here are all of the back burner issues that will need to be added to the gap products effort in upcoming lull periods. Please consider this a living document.
🔧 Optimizing
gapindex/production workflowgapindexonly update parts of the table so the whole table doesn't have to be dropped, just the things that changed.gap_products.taxonomic_classificationsandgap_products.taxonomic_groupschanges and minimum ID integration and move away from the oldracebase.speciestable🆕 Add new products
🧹 Clean up
✍️ Documentation