When a domain is deleted, we currently mark it deleted = 0, the recordset/record data remains.
We currently don't have a deleted column on these tables, as keeping the data for a period of time after deletion has not been necessary. With the new zone-manager service coming in through the zone-exists-spec, we should add a new periodic task to issue a SQL DELETE for domains deleted over 24hr (config option ofc), which will cascade through to the recordsets/records etc.
When a domain is deleted, we currently mark it deleted = 0, the recordset/record data remains.
We currently don't have a deleted column on these tables, as keeping the data for a period of time after deletion has not been necessary. With the new zone-manager service coming in through the zone-exists-spec, we should add a new periodic task to issue a SQL DELETE for domains deleted over 24hr (config option ofc), which will cascade through to the recordsets/records etc.