soft delete

Marking a row as deleted, for example by setting a deleted_at date, instead of removing it.

In more detail

The history stays recoverable and foreign keys stay valid, but every query must remember to exclude deleted rows. Use it for records with lasting business value.

Related terms

Taught in

References