word_relations table - SuperOffice

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	No
entry_id	A reference to the id of the entry	FK kb_entry	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

Indexes

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

Related topics

kb_entry_words table temporary_words table relations table ticket_relation table ticket_relation_def table ImportRelation table

⌘I