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

# word_relations table

> This table shows which word are used in which FAQ entry, and how many times            they are used in each

## word\_relations Table (355)

This table shows which word are used in which FAQ entry, and how many times            they are used in each

## Fields

| Name            | Description                                                  | Type                                        | Nullable |
| --------------- | ------------------------------------------------------------ | ------------------------------------------- | :------: |
| id              | Primary key                                                  | PK                                          |    No    |
| entry\_word\_id | A reference to the id of the word                            | FK [kb\_entry\_words](./kb-entry-words.mdx) |    No    |
| entry\_id       | A reference to the id of the entry                           | FK [kb\_entry](./kb-entry.mdx)              |    No    |
| used            | Indicates how many times this word is used in the FAQ entry  | Int                                         |    No    |
| origin          | Indicates if it is an entry word (0) or a category word (1). | Short                                       |    No    |

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

## Indexes

| Fields          | Types | Description |
| --------------- | ----- | ----------- |
| entry\_word\_id | FK    | Index       |
| entry\_id       | FK    | Index       |

## Relationships

| Table                                | Description                                                                                                 |
| ------------------------------------ | ----------------------------------------------------------------------------------------------------------- |
| [kb\_entry](./kb-entry)              | This table contains FAQ entries.                                                                            |
| [kb\_entry\_words](./kb-entry-words) | This table contains all the words and how many times the are refered                  to in the FAQ entires |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [kb_entry_words table](/en/database/tables/kb-entry-words.md)
- [temporary_words table](/en/database/tables/temporary-words.md)
- [relations table](/en/database/tables/relations.md)
- [ticket_relation table](/en/database/tables/ticket-relation.md)
- [ticket_relation_def table](/en/database/tables/ticket-relation-def.md)
- [ImportRelation table](/en/database/tables/importrelation.md)