kb_entry_words table - SuperOffice

kb_entry_words Table (354)

This table contains all the words and how many times the are refered to in the FAQ entires

Fields

Name	Description	Type	Nullable
id	Primary key	PK	No
word	A word found in a kb_entry	String(63)	No
score	Indicates how many occurences of this word we have	Int	Yes
origin	Indicates if it is an entry word (0) or a category word (1).	Short	No

Indexes

Fields	Types	Description
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.

Related topics

kb_entry table kb_group_entry table kb_entry_keyword table kb_entry_log table kb_entry_comment table kb_solution_finder_entry table

⌘I