Remove UM_EDIT_RESTRICTION Column from UM_HYBRID_USER_ROLE and UM_ORG_USER_ASSOCIATION Tables

[BimsaraBodaragama]

Description

This task involves the removal of the UM_EDIT_RESTRICTION column from the UM_HYBRID_USER_ROLE and UM_ORG_USER_ASSOCIATION tables, as its functionality is no longer required or will be managed differently.

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

Currently, the UM_EDIT_RESTRICTION column in both tables is unused or redundant. Retaining it unnecessarily complicates the schema and can cause confusion when maintaining the database or extending its functionality.

Describe the solution you would prefer

Update the database schema by:

• Dropping the UM_EDIT_RESTRICTION column from the UM_HYBRID_USER_ROLE table.
• Dropping the UM_EDIT_RESTRICTION column from the UM_ORG_USER_ASSOCIATION table.
• Ensuring related references and constraints are updated or removed appropriately.
• Verifying schema integrity and maintaining compatibility across all supported databases.

Additional context

Removing the UM_EDIT_RESTRICTION column will:

• Simplify the database schema.
• Eliminate unnecessary complexity in schema management.
• Align the database structure with the latest functional requirements.

Version

7.1

[BimsaraBodaragama]

You can track the PR here.