kb_entry_words Table (354)
•
Environment: onsite, online
Some tooltip text!
• 1 minute to read
• 1 minute to read
This table contains all the words and how many times the are refered to in the FAQ entires
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| id | Primary key | PK | |
| word | A word found in a kb_entry | String(63) | |
| score | Indicates how many occurences of this word we have | Int | ● |
| origin | Indicates if it is an entry word (0) or a category word (1). | Short |
Indexes
| Fields | Types | Description |
|---|---|---|
| id | PK | Clustered, Unique |
| word | String(63) | Index |
Relationships
| Table | Description |
|---|---|
| word_relations | This table shows which word are used in which FAQ entry, and how many times they are used in each |
Replication Flags
- None
Security Flags
- No access control via user's Role.