submission_search_object_keywords


Description

Relationships between search objects and keywords in the search index

Columns

Column Type Size Nulls Auto Default Children Parents Comments
submission_search_object_keyword_id BIGINT UNSIGNED 20 √ null
object_id BIGINT 19 null
submission_search_objects.object_id submission_search_object_keywords_object_id_foreignC
keyword_id BIGINT 19 null
submission_search_keyword_list.keyword_id submission_search_object_keywords_keyword_idC
pos INT 10 null

Word position of the keyword in the object.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc submission_search_object_keyword_id
submission_search_object_keywords_keyword_id Performance Asc keyword_id
submission_search_object_keywords_object_id Performance Asc object_id
submission_search_object_keywords_unique Must be unique Asc/Asc object_id + pos

Relationships

Close relationships within degrees of separation