> ## 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_element table

> Profiles associated with a role

## role\_element Table (326)

Profiles associated with a role

## Fields

| Name             | Description                        | Type                                         | Nullable |
| ---------------- | ---------------------------------- | -------------------------------------------- | :------: |
| id               | The primary key (auto-incremented) | PK                                           |    No    |
| role             | The id of the group. Deprecated.   | FK [ej\_role](./ej-role.mdx)                 |    No    |
| element\_profile | The id of the element\_profile.    | FK [element\_profile](./element-profile.mdx) |    No    |
| crm\_role        | Link to Role                       | FK [Role](./role.mdx)                        |    Yes   |

<img src="https://mintcdn.com/superofficeas/6OcOTPa_ISkjXJg4/media/loc/en/database/tables/role_element.png?fit=max&auto=format&n=6OcOTPa_ISkjXJg4&q=85&s=0cff887cf0f1821391dddd5c733ae461" alt="role_element table relationship diagram" width="639" height="645" data-path="media/loc/en/database/tables/role_element.png" />

## Indexes

| Fields           | Types | Description |
| ---------------- | ----- | ----------- |
| role             | FK    | Index       |
| element\_profile | FK    | Index       |
| crm\_role        | FK    | Index       |

## Relationships

| Table                                 | Description                                                                                                                                                                                        |
| ------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [ej\_role](./ej-role)                 | Define access rights, memberships and other properties for role user members                                                                                                                       |
| [element\_profile](./element-profile) | The new (4.0) profile table. Contains profile for a single Html-element. Connected through element\_profile\_link                                                                                  |
| [Role](./role)                        | User roles for role-based security, names and tooltips are in LocaleText. For more information regarding role based security, see [http://techdoc.superoffice.com](http://techdoc.superoffice.com) |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [element_profile table](/en/database/tables/element-profile.md)
- [Role table](/en/database/tables/role.md)
- [ej_role table](/en/database/tables/ej-role.md)
- [s_list_element table](/en/database/tables/s-list-element.md)
- [screen_definition_element table](/en/database/tables/screen-definition-element.md)
- [role_category table](/en/database/tables/role-category.md)