I have created a procedure in Postgres that will create a table with the contents of another three tables (SELECT with JOINS). Then the resulting table will be altered adding two columns that didnt exist before and finally within the same procedure I have created 3 triggers that will be applied on those three tables so anytime a new write happens on any of those, the same entity will be recorded in the new table