set a status field to 'closed' or 'deleted' rather than physically removing records. This preserves audit trails and simplifies recovery.