Suppose I delete a contact and suppose I have linked emails to this contact....

Now when I delete a contact, that record gets a deleted = 1. Do all the children tables relating to the contacts table also automatically get a deleted = 1 as well (sort of a cascade deleted = 1 function.)?

The issue is I want to manually prune my database, I heard running the pruneDatabase Function will leave orphans.

Is this true?

How does this work, specifically as it relates to emails.