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

# 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-bugfix-ty-screen-designer-paradox/A8Y_bcgEblTh4XOv/media/loc/en/database/tables/dictionary.png?fit=max&auto=format&n=A8Y_bcgEblTh4XOv&q=85&s=ef6b9772853e1e3997395bb6fbda58ce" 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.