Refactoring Databases - Evolutionary Database Design

Introduce Soft Delete

Introduce a flag to an existing table which indicates that a row has been deleted (this is called a soft/logical delete) instead of actually deleting the row (a hard delete).



Example

Introduce Soft Delete Example

For more information see page 222 of Database Refactoring