To add: If you want to do CRUD but without the headaches of U and D you can do this: https://en.wikipedia.org/wiki/Bitemporal_modeling https://en.wikipedia.or

To add: If you want to do CRUD but without the headaches of U and D you can do this: https://en.wikipedia.org/wiki/Bitemporal_modeling https://en.wikipedia.org/wiki/Bitemporal_modeling It may seem scary at first and requires more thought, but the benefits are very real, even if the history is not exposed to users in any way.