What does hard delete person and company delete?

When a person or company is deleted what related data is then deleted?

First person/company record is softdeleted by setting DeletedDate on person/company. But when person/company is hard deleted - then what related data i deleted?

Can I find info about that somewhere?

I expect this is deleted:

  • address
  • phone
  • email
  • url
  • interets
  • udef
  • (persons on the company)

 

I expect this is not deleted:

  • Appointment
  • Contact
  • Sale

 

But the database 'Relationships' list for ex contact/company is quite long and how is each relation handled?

What if contact/company or person have an extra field (x_) linking to an extratable (y_)?

RE: What does hard delete person and company delete?

I'm assuming your read Marek's blog post about this, is that true? An exerpt:
Directly dependent records such as email or phone are deleted. Other tables have independent reasons to exist: an meeting still happened, even if no longer have a valid person reference, so there we just zero the appointment.person_id. In all, about 65 tables are impacted by such a cleanup. Not by coincidence, the cleanup is the same one that happens during the upgrade to 8.2R05 in preparation for allowing person-without-company to be visible. That code is well tested and will clean up any loose ends.

And so I'm guessing you would like a list of the 65 or so tables mentioned?

Von: Tony Yates 3. Feb 2021

RE: What does hard delete person and company delete?

No I have not read Marek's blog about it, but have just found it here: Soft delete – the Undo revolution

A customer ask what they should delete - when their GDPR rules require them to delete data.

Ie in this specific case I would like to tell them what data is left when a company or person is deleted. Then they can decide if that data also need/must be deleted in their database. 

They delete company, person and other releveant data via a custommade integration using REST. (ie they have another system as master owner of data).

 

Von: Morten Larsen 3. Feb 2021

RE: What does hard delete person and company delete?

Marek wrote: "Other tables have independent reasons to exist: an meeting still happened, even if no longer have a valid person reference, so there we just zero the appointment.person_id."

Is it correct to conclude that all related tables are handled by eiter:
1) Records are deleted in the table
2) Records are updated by setting contact_id/person_id =0

To me tables handled by rule 2 are obvious candidates for customers to consider how to handle in their business.

Is it possible to get at list of these tables for contact and person deep delete?

Von: Morten Larsen 5. Feb 2021

RE: What does hard delete person and company delete?

Hi Morten,

No, there is no documentation available that lists all affected tables when a soft-delete occurs. I've added it to our backlog.

Best regards.

Von: Tony Yates 9. Feb 2021

RE: What does hard delete person and company delete?

ok

Von: Morten Larsen 12. Feb 2021