Clear changes table when entities not present

Relationship should be added between the two tables to clear the changes when the entity no longer exists.

First test that this is not going to harm performance. If it does, there are other possibilities, such as a job to clear out old changes.

Assigned to Tony.

When higher priority work has been completed, please have a look at this issue.

Using an environment with a large amount of data, try adding the relationship between the Entity and Changes tables such that old changes are removed and test performance.

Thanks.

Care will have to be taken, as the changes in this table could represent deletes to be performed. Should be reassessed once the new mechanism has been decided on IDB-299.

AvV: Please confirm that the adapter being removed deletes the partition.

Confirmed that this partition is cleared.

Confirmed in several regression tests. Closed.