[Task]: Use an FK to tables which refers user_idp_references.uuid

[renuka-fernando]

Please select the area the issue is related to

Platform API

Please select the aspect the issue is related to

Aspect/API (API backends, definitions, contracts, interfaces, OpenAPI)

Description

Instead of deleting data in user_idp_references table, anonymize PII data. So we can use Inner join instead of Left joins

[ashera96]

Putting this as on-hold for the 1.0.0 release