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

# user_candidate table

> This table will hold user candidate secrets

## user\_candidate Table (389)

This table will hold user candidate secrets

## Fields

| Name          | Description                                                    | Type                      | Nullable |
| ------------- | -------------------------------------------------------------- | ------------------------- | :------: |
| id            | Primary key                                                    | PK                        |    No    |
| person\_id    | Foreign key. Id of a person representing Customer Center User. | FK [person](./person.mdx) |    No    |
| secret\_key   | Username of a Customer Centre User.                            | String(255)               |    Yes   |
| secret\_value | Password of a Customer Centre User.                            | String(255)               |    Yes   |

<img src="https://mintcdn.com/superofficeas/8-OIGQQJR0VGDXy_/media/loc/en/database/tables/user_candidate.png?fit=max&auto=format&n=8-OIGQQJR0VGDXy_&q=85&s=2141f8108f238818c6cc5ecd4e310858" alt="user_candidate table relationship diagram" width="417" height="59" data-path="media/loc/en/database/tables/user_candidate.png" />

## Indexes

| Fields      | Types       | Description |
| ----------- | ----------- | ----------- |
| person\_id  | FK          | Index       |
| secret\_key | String(255) | Index       |

## Relationships

| Table              | Description |
| ------------------ | ----------- |
| [person](./person) | Persons     |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [SuperOffice.WebApi.Data.UserCandidate](/en/api/reference/webapi/SuperOffice.WebApi.Data.UserCandidate.md)
- [Create Or Update User Candidate](/en/api/reference/restful/agent/person_agent/create-or-update-user-candidate.md)
- [SuperOffice.WebApi.Agents.PersonAgent](/en/api/reference/webapi/SuperOffice.WebApi.Agents.PersonAgent.md)
- [SuperOffice.WebApi.Agents.IPersonAgent](/en/api/reference/webapi/SuperOffice.WebApi.Agents.IPersonAgent.md)
- [Get User Candidate By Person](/en/api/reference/restful/agent/person_agent/get-user-candidate-by-person.md)
- [SuperOffice.WebApi.Data.Person GetUserCandidateByPersonRequest](/en/api/reference/webapi/SuperOffice.WebApi.Data.Person_GetUserCandidateByPersonRequest.md)