Table ezp54_community.ezsearch_object_word_link Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
contentclass_attribute_id int 10 0
contentclass_id int 10 0
ezcontentclass.id ezsearch_object_word_link_ibfk_2 R
contentobject_id int 10 0
ezcontentobject.id ezsearch_object_word_link_ibfk_1 R
frequency float 12 0
id int 10  √ 
identifier varchar 255
integer_value int 10 0
next_word_id int 10 0
placement int 10 0
prev_word_id int 10 0
published int 10 0
section_id int 10 0
ezsection.id ezsearch_object_word_link_ibfk_3 R
word_id int 10 0

Analyzed at ? 7 07 11:43 CEST 2015

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
contentclass_id Performance Asc contentclass_id
frequency Performance Asc ezsearch_object_word_link_frequency
identifier Performance Asc ezsearch_object_word_link_identifier
integer_value Performance Asc ezsearch_object_word_link_integer_value
contentobject_id Performance Asc ezsearch_object_word_link_object
word_id Performance Asc ezsearch_object_word_link_word
section_id Performance Asc section_id

Close relationships  within of separation: