4 ms·
Don't ask the question about database systems. Ask the question about data. Instead of asking "how can rows in my posts table reference a deleted row in the us
by immibis 3y ago
Don't ask the question about database systems. Ask the question about data.
Instead of asking "how can rows in my posts table reference a deleted row in the users table?" ask "how can I show posts by deleted users?"
And that's a business requirement. Either you delete the post, or you delete the post's author link, or you delete the post's author link and content. Find out which one, and design and implement it.
- immibis 3y agoor you retain the author link but scrub all useful information from the author record