The table `itgen_user_roles` holds: roles granted to a user. Example: Mr. John is part of the Accounting role. It keeps history. Its natural key code is `ure`. ## Columns The table has these columns, besides the [[Invantive Studio/Repository/Concepts/Standard Columns|standard columns]]: - `documentation` (`varchar2(4000)`): Documentation. Documentation on the user role. - `rle_id` (`number`, required): Role ID. Reference to a role registered in ITGEN_ROLES. - `usr_id` (`number`, required): User Role. Reference to a user registered in ITGEN_USERS. - `column1` to `column10` and `column_type`: free text columns to extend the data model with fields only available at one site. ## Referential Constraints The table is related to other tables as follows: - `rle_id` refers to Roles (`id`). - `usr_id` refers to Users (`id`). ## Indexes The table has these indexes: - `itgen_ure_nk` (unique) on `usr_id`, `rle_id`. - `itgen_ure_pk` (unique) on `id`. - `itgen_ure_rle_fk` on `rle_id`. - `itgen_ure_uk_orig` (unique) on `orig_system_reference`. - `itgen_ure_usr_fk` on `usr_id`. See also [[Invantive Studio/Repository/Reference/Tables of the Repository|Tables of the Repository]].