[tiwazz]

Try 6NF[0], not only do you get separate logging for when the row was/will be marked deleted, but you have a record of when the DB believed that the record was/will be deleted. Also true history and rewind capability.

[0] https://en.wikipedia.org/wiki/Sixth_normal_form

[bmh100]

Right, thank you for reminding me about the term. I like to see databases that generally follow this strategy, while providing higher-speed access to current data through materialized views [1].

[1]: https://en.wikipedia.org/wiki/Materialized_view