afpowell

Yes, I think I should have something like this... it looks good! I'll make a note and check it out more later this week. Thanks!

Closed by #4271

after discussing a bit, a solution involving triggers for specific tables and jsonb seems reasonable - something like the following? https://elephas.io/audit-logging-using-jsonb-in-postgres/

From Bryan: enable removal of entries for old modifications (e.g. changes made more than X years ago)

For future ref, it looks like the example in the link above includes the timestamps for each record

From my testing, these seem to be the unaltered audit tables: cvterm_dbxref_audit cvtermprop_audit cvtermsynonym_audit dbxrefprop_audit nd_experiment_contact_audit nd_experiment_dbxref_audit nd_experiment_pub_audit nd_experiment_stock_dbxref_audit nd_experiment_stockprop_audit nd_protocol_reagent_audit nd_reagent_audit nd_reagentprop_audit nd_reagent_relationship_audit organism_dbxref_audit organismpath_audit organismprop_audit organism_relationship_audit phenotype_cvterm_audit phenotypeprop_audit...