> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Role table

> User roles for role-based security, names and tooltips are in LocaleText. For more information regarding role based security, see http;//techdoc.superoffice.com

## Role Table (191)

User roles for role-based security, names and tooltips are in LocaleText. For more information regarding role based security, see http;//techdoc.superoffice.com

## Fields

| Name                      | Description                                            | Type                                  | Nullable |
| ------------------------- | ------------------------------------------------------ | ------------------------------------- | :------: |
| Role\_id                  | Primary key                                            | PK                                    |    No    |
| name                      | Visible role name                                      | String(239)                           |    Yes   |
| rank                      | Sorting rank of this role in lists                     | UShort                                |    No    |
| tooltip                   | Visible tooltip                                        | String(254)                           |    Yes   |
| deleted                   | 1 if role has been deleted (we do not actually delete) | UShort                                |    No    |
| roleType                  | 0 = employee, 1 = external user, 2 = anonymous         | Enum [RoleType](./enums/roletype.mdx) |    No    |
| encryptedCheck            | Encrypted data, to detect unwanted changes             | String(254)                           |    No    |
| registered                | Registered when                                        | UtcDateTime                           |    No    |
| registered\_associate\_id | Registered by whom                                     | FK [associate](./associate.mdx)       |    No    |
| updated                   | Last updated when                                      | UtcDateTime                           |    No    |
| updated\_associate\_id    | Last updated by whom                                   | FK [associate](./associate.mdx)       |    No    |
| updatedCount              | Number of updates made to this record                  | UShort                                |    No    |
| use\_categories           | Override user categories with role categories          | Bool                                  |    Yes   |

<img src="https://mintcdn.com/superofficeas/3ZhivzBeXAvFeVZx/media/loc/en/database/tables/Role.png?fit=max&auto=format&n=3ZhivzBeXAvFeVZx&q=85&s=cac2a5f2456d389a1599c31a4a88a0ac" alt="Role table relationship diagram" width="812" height="745" data-path="media/loc/en/database/tables/Role.png" />

## Indexes

| Fields | Types | Description |
| ------ | ----- | ----------- |

## Relationships

| Table                                            | Description                                                        |
| ------------------------------------------------ | ------------------------------------------------------------------ |
| [associate](./associate)                         | Employees, resources and other users - except for External persons |
| [DataRight](./dataright)                         | Data right definition                                              |
| [FunctionRightRoleLink](./functionrightrolelink) | Functional right definition                                        |
| [role\_category](./role-category)                | Category membership associated with a role                         |
| [role\_element](./role-element)                  | Profiles associated with a role                                    |
| [role\_workflow](./role-workflow)                | Knowledge base workflow access rights associated with a role       |
| [text](./text)                                   | Long text fields from all over the system                          |
| [UserRoleLink](./userrolelink)                   | Link between user role and user                                    |

## Replication Flags

* Replicate changes DOWN from central to satellites and travellers.
* Replicate changes UP from satellites and travellers back to central.
* Copy to satellite and travel prototypes.

## Security Flags

* No access control via user's Role.


## Related topics

- [ej_role table](/en/database/tables/ej-role.md)
- [StakeholderRole table](/en/database/tables/stakeholderrole.md)
- [role_category table](/en/database/tables/role-category.md)
- [role_element table](/en/database/tables/role-element.md)
- [role_member table](/en/database/tables/role-member.md)
- [role_workflow table](/en/database/tables/role-workflow.md)