Summary

Currently deleting a provider requires locking the public provider table to delete underlying foreign keyed data. We should switch the tenant specific foreign key relationships to a tenant specific table for more reasonable provider deletes that don't require access to the public table.