I think it amounts to "use views to decouple access to the table with a fixed interface" and "use triggers for migrating data between tables"