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

# profile table

> Deprecated. This table contains entries for the user profiles.

## profile Table (329)

Deprecated. This table contains entries for the user profiles.

## Fields

| Name                     | Description                                                    | Type                      | Nullable |
| ------------------------ | -------------------------------------------------------------- | ------------------------- | :------: |
| id                       | The primary key (auto-incremented)                             | PK                        |    No    |
| name                     | This is the name of the profile                                | String(255)               |    Yes   |
| user\_id                 | The id of the user.                                            | FK [ejuser](./ejuser.mdx) |    No    |
| list\_ticket\_header     | The fields for listing one ticket. Encoded as CSV string.      | Clob                      |    Yes   |
| list\_tickets\_header    | Depricated                                                     | String(255)               |    Yes   |
| list\_customers\_header  | Depricated                                                     | String(255)               |    Yes   |
| list\_companies\_header  | Depricated                                                     | String(255)               |    Yes   |
| list\_tickets\_header2   | The fields for listing several tickets. Encoded as CSV string. | Clob                      |    Yes   |
| list\_customers\_header2 | The fields for listing customers. Encoded as CSV string.       | Clob                      |    Yes   |
| list\_companies\_header2 | The fields for listing companies. Encoded as CSV string.       | Clob                      |    Yes   |

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

## Indexes

| Fields   | Types | Description |
| -------- | ----- | ----------- |
| user\_id | FK    | Index       |

## Relationships

| Table              | Description                                              |
| ------------------ | -------------------------------------------------------- |
| [ejuser](./ejuser) | This table contains entries for the users of the system. |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [element_profile table](/en/database/tables/element-profile.md)
- [screen_definition_element table](/en/database/tables/screen-definition-element.md)
- [role_element table](/en/database/tables/role-element.md)
- [ejuser table](/en/database/tables/ejuser.md)
- [Profile](/en/automation/crmscript/reference/CRMScript.Native.Profile.md)