So… I’ve worked out how to do triggers on insert/update when I have all the data I’m concerned with in one big table… but if I break the big table up into smaller normalized tables, how do I write a trigger that writes to a couple columns in one table (date_added & date_updated) when any part of the individual table is updated? Can triggers work with views?
It’s almost seeming like it’d be easier (at least on the surface) to do from the application side of thing…