Table ezp54_community.eznode_assignment 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
contentobject_id int 10  √  null
contentobject_version int 10  √  null
from_node_id int 10  √  0
id int 10  √ 
is_main int 10 0
op_code int 10 0
parent_node int 10  √  null
ezcontentobject_tree.node_id eznode_assignment_ibfk_1 R
parent_remote_id varchar 100
remote_id varchar 100 0
sort_field int 10  √  1
sort_order int 10  √  1
priority int 10 0
is_hidden int 10 0

Analyzed at ? 7 07 11:43 CEST 2015

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
contentobject_version Performance Asc eznode_assignment_co_version
contentobject_id + contentobject_version Performance Asc/Asc eznode_assignment_coid_cov
is_main Performance Asc eznode_assignment_is_main
parent_node Performance Asc eznode_assignment_parent_node

Close relationships  within of separation: