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.