I do something similar, but instead keep a "date_deleted" column null by default, and the "active" column as a boolean. That way, I kill two birds in one stone

I do something similar, but instead keep a "date_deleted" column null by default, and the "active" column as a boolean. That way, I kill two birds in one stone by having a dedicated column for last deletion (instead of updating a record that is supposedly deleted) and the status just as a boolean instead of some enum, or integer or string.