> ## Documentation Index
> Fetch the complete documentation index at: https://superofficeas-bugfix-ty-screen-designer-paradox.mintlify.site/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-bugfix-ty-screen-designer-paradox/G4reeQVP-LmhQATQ/media/loc/en/database/tables/role_element.png?fit=max&auto=format&n=G4reeQVP-LmhQATQ&q=85&s=fbc118f9a9417d92a5e59cd73ad4d06d" 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.