Show determinant names and maybe other non-id columns in QA and QA_rejected views
When doing quality assessment or updating data, only seeing the determinant_id like "CAS_XXX-XX-X" is often not sufficient to understand about which determinant this data is about.
It would be very helpful to also see a common name, which means the column name of table determinants. This would require to include a join statement in the View definition. As views based on joined tables can not be used to update tables directly any more, INSERT INSTEAD triggers must be introduced, leading the updates to the right target tables.
This would be a major improvement in usability but is also significant effort to be implemented. I propose to start with the QA views as a first step as there are only two writable columns, and e.g. with a prototype for the eqs table. Later also the qa_rejected views could be improved this way, but there the function must contain many more column ...
Resources: https://www.datacamp.com/doc/postgresql/instead-of-triggers