Table ezp54_community.ezstarrating_data 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
id int 10  √ 
created_at int 10
user_id int 10
ezuser.contentobject_id ezstarrating_data_ibfk_1 R
session_key varchar 32
rating float 12
contentobject_id int 10
ezcontentobject.id ezstarrating_data_ibfk_2 R
contentobject_attribute_id int 10
ezcontentobject_attribute.id ezstarrating_data_ibfk_3 R

Analyzed at ? 7 07 11:43 CEST 2015

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
contentobject_attribute_id Performance Asc contentobject_attribute_id
contentobject_id + contentobject_attribute_id Performance Asc/Asc contentobject_id_contentobject_attribute_id
user_id + session_key Performance Asc/Asc user_id_session_key

Close relationships  within of separation: