Audit Ingest DB Constriants
Many of the FK constraints in the ingest db do not properly cascade, and should be audited to cascade deletes to their descendants properly. In addition, some of the relationships for the newer entities do not appear to be set up properly, as we can be left with orphaned entities in the database with no clear link as to who they should be attached to.