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

For more information see page 222 of Database Refactoring