I have a database question - say you have an items table and a messages table, and messages can refer to items. If someone needs to delete an item, you can't because of the foreign reference in messages.
I know you could 'soft delete' - set a status column to deleted, but what if you really need to delete, for example because the content is illegal or the user has a legal right to delete it?
