set up on delete cascades for DB actions that do not come through the API. https://sqlmodel.tiangolo.com/tutorial/relationship-attributes/cascade-delete-relationships/#delete-in-the-database-with-ondelete