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

# dictionary table

> User added dictionary words

## dictionary Table (358)

User added dictionary words

## Fields

| Name     | Description                           | Type                                         | Nullable |
| -------- | ------------------------------------- | -------------------------------------------- | :------: |
| id       | The primary key (auto-incremented)    | PK                                           |    No    |
| base\_id | The reference to the dictionary base. | FK [dictionary\_base](./dictionary-base.mdx) |    No    |
| user\_id | The reference to the user.            | FK [ejuser](./ejuser.mdx)                    |    No    |
| include  | Include/Exclude word.                 | Int                                          |    No    |
| word     | User word                             | String(32)                                   |    No    |

<img src="https://mintcdn.com/superofficeas/i6M2qZmvMNH7UTeu/media/loc/en/database/tables/dictionary.png?fit=max&auto=format&n=i6M2qZmvMNH7UTeu&q=85&s=3fbc02c44abfc19c0be9cea5e68af6f1" alt="dictionary table relationship diagram" width="669" height="59" data-path="media/loc/en/database/tables/dictionary.png" />

## Indexes

| Fields   | Types      | Description |
| -------- | ---------- | ----------- |
| base\_id | FK         | Index       |
| user\_id | FK         | Index       |
| include  | Int        | Index       |
| word     | String(32) | Index       |

## Relationships

| Table                                 | Description                                                                                  |
| ------------------------------------- | -------------------------------------------------------------------------------------------- |
| [dictionary\_base](./dictionary-base) | Language catalog for the ejournal dictionaries (automatic proof reading of message text etc) |
| [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

- [Practical details - how to use Bulk Update API](/en/api/bulk-operations/bulk-update/using-bulk-update.md)
- [Troubleshooting migration errors](/en/online/migrate/troubleshooting.md)
- [DBSetup.exe - Database maintenance](/en/onsite/install/database/dbsetup-exe.md)
- [dictionary_base table](/en/database/tables/dictionary-base.md)
- [SuperOffice.WebApi.Agents.DatabaseTableAgent](/en/api/reference/webapi/SuperOffice.WebApi.Agents.DatabaseTableAgent.md)
- [SuperOffice.WebApi.Agents.IDatabaseTableAgent](/en/api/reference/webapi/SuperOffice.WebApi.Agents.IDatabaseTableAgent.md)