submission_search_object_keywords

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
object_id int8 19 null
submission_search_objects.object_id submission_search_object_keywords_object_id_foreignC
keyword_id int8 19 null
submission_search_keyword_list.keyword_id submission_search_object_keywords_keyword_idC
pos int4 10 null

Word position of the keyword in the object.

Indexes

Constraint Name Type Sort Column(s)
submission_search_object_keywords_keyword_id Performance Asc keyword_id
submission_search_object_keywords_object_id Performance Asc object_id
submission_search_object_keywords_pkey Must be unique Asc/Asc object_id + pos

Relationships