3 ms·
They way I see it relationships to the deleted record must always be nullified/marked deleted, because otherwise you get broken records referencing deletions. A
by graftak 3y ago
They way I see it relationships to the deleted record must always be nullified/marked deleted, because otherwise you get broken records referencing deletions. And relationships from a deleted record might as well persist because the foreign key will (fingers crossed) remain untouched.
Again, not versed in db at all so this is likely total rubbish.
- vaidhy 3y agoYou are correct.. But if you move the deleted record to a different db, you have to follow the chain of relationships and move more records to the "deleted" db. Which means you would have a create a full database to maintain the entity relationships.