word_relations Table (355)
•
Environment: onsite, online
Some tooltip text!
• 1 minute to read
• 1 minute to read
This table shows which word are used in which FAQ entry, and how many times they are used in each
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| id | Primary key | PK | |
| entry_word_id | A reference to the id of the word | FK kb_entry_words | |
| entry_id | A reference to the id of the entry | FK kb_entry | |
| used | Indicates how many times this word is used in the FAQ entry | Int | |
| origin | Indicates if it is an entry word (0) or a category word (1). | Short |
Indexes
| Fields | Types | Description |
|---|---|---|
| id | PK | Clustered, Unique |
| entry_word_id | FK | Index |
| entry_id | FK | Index |
Relationships
| Table | Description |
|---|---|
| kb_entry | This table contains FAQ entries. |
| 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.