Feature: Add Entity type and domain to roles

[arvindh123]

Is your feature request related to a problem? Please describe.

In present database model, there is no way to filter roles by entity type or domain in repo, It is required for deletion process.

Describe the feature you are requesting, as well as the possible use case(s) for it.

If we have column entity_type and domain in roles, them can be roles filtered by entity type or domain .

Indicate the importance of this feature to you.

Must-have

Anything else?

No response