How to set up last access (timestamptz) in table 1( basic info table) when working with many other tables having foreign key from table 1?
I have two solutions:


Create a lastAccess column on all 5 of the tables. Create database triggers on each table to update it's corresponding lastAccess column. This will allow you to track when each table is updated.
Create lastAccess on Table 1. Then create triggers on tables 2,3,4,5 that will update the lastAccess column on Table 1.