Currently records cannot be deleted if other records reference them. We have a setup where a main Client record has multiple other records referencing that client that store more specific information. However, if we attempt to delete a Client record we cannot delete it unless we manually delete all the records referencing it first.
Would it be possible to add the ability to cascade record deletions, so that deleting a record also deletes all records referencing it?
Additionally, the option to set other common on-delete actions (per relation field) like SET NULL would be useful.
For an example, see the Postgres docs for ON DELETE actions.
Thanks!