missing "deleted_date" for table civicrm_contact
Every now and then happens that contacts are deleted on a certain date, but is not noticed until a few days later. Is there currently a solution how I find out on which day which contact was deleted?
When I look at the database table civicrm_contact, I find "is_deleted" and "modified_date". "modified_date" does not change automatically when deleting a contact. So it seems to me that this information is not stored.
The workaround to compare backup database files seems to me very complex.
Therefore I see 2 options here:
- "modified_date" will be modified when contact is deleted
- adding an additional column for "deleted_date"
Any thoughts on that?