> ## 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.

# element_profile table

> The new (4.0) profile table. Contains profile for a single Html-element. Connected through element_profile_link

## element\_profile Table (328)

The new (4.0) profile table. Contains profile for a single Html-element. Connected through element\_profile\_link

## Fields

| Name                        | Description                                                                                                            | Type                                                              | Nullable |
| --------------------------- | ---------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------- | :------: |
| id                          | The primary key (auto-incremented)                                                                                     | PK                                                                |    No    |
| name                        | This is the name used by common profiles                                                                               | String(255)                                                       |    Yes   |
| static\_element             | An enum for which HtmlElement this is. All profileable elements in static screens has a unique enum matching this one. | static\_element                                                   |    Yes   |
| screen\_definition\_element | The id of the screen\_definition\_element.                                                                             | FK [screen\_definition\_element](./screen-definition-element.mdx) |    No    |
| profile\_type               | Enum indicating whether this is the default profile (only one), user profile or a common profile. Defined in Profile.h | profile\_type                                                     |    Yes   |
| element\_type               | What kind of element is this? Static, blogic or extra table?                                                           | element\_type                                                     |    Yes   |
| owned\_by\_user             | The id of the user.                                                                                                    | FK [ejuser](./ejuser.mdx)                                         |    No    |
| config                      | The actual profile data. Each HtmlElement may choose format. Normally XML.                                             | Clob                                                              |    Yes   |
| filter\_field               | Name of field, if any, that is used to filter which profiles should be shown                                           | String(254)                                                       |    Yes   |
| filter\_value               | If filter\_field is set, then this field is the value that is used to filter which profiles should be shown            | String(254)                                                       |    Yes   |

<img src="https://mintcdn.com/superofficeas/i6M2qZmvMNH7UTeu/media/loc/en/database/tables/element_profile.png?fit=max&auto=format&n=i6M2qZmvMNH7UTeu&q=85&s=9be03e8b60fa3b0589485be88a863341" alt="element_profile table relationship diagram" width="864" height="763" data-path="media/loc/en/database/tables/element_profile.png" />

## Indexes

| Fields                      | Types | Description |
| --------------------------- | ----- | ----------- |
| screen\_definition\_element | FK    | Index       |
| owned\_by\_user             | FK    | Index       |

## Relationships

| Table                                                      | Description                                              |
| ---------------------------------------------------------- | -------------------------------------------------------- |
| [ejuser](./ejuser)                                         | This table contains entries for the users of the system. |
| [role\_element](./role-element)                            | Profiles associated with a role                          |
| [screen\_definition\_element](./screen-definition-element) | An element in a configurable screen                      |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [role_element table](/en/database/tables/role-element.md)
- [screen_definition_element table](/en/database/tables/screen-definition-element.md)
- [profile table](/en/database/tables/profile.md)
- [s_list_element table](/en/database/tables/s-list-element.md)
- [Profile](/en/ui/blogic/learn/profiles/index.md)
- [ejuser table](/en/database/tables/ejuser.md)