I have a few tables that are subservient to multiple other tables (notes, addresses, attached documents etc).
These tables carry the 'owning' table name and its record's PK.
I can manually keep these tables tidy and avoid orphans, but is there a way within postgresql to reference these tables on a FK constraint to automatically delete the subservient recs when the parent is deleted?
OR have I got the structure all wrong anyway and is there a cleaner way of holding, say notes, for records on a whole range of tables?
Thanks all.
