Table schemadoc.ezcontentobject_tree 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
ezuser_role.contentobject_id ezuser_role_ibfk_2 R
contentobject_is_published int 10  √  null
contentobject_version int 10  √  null
depth int 10 0
is_hidden int 10 0
is_invisible int 10 0
main_node_id int 10  √  null
ezcontentobject_tree.node_id ezcontentobject_tree_ibfk_1 R
modified_subnode int 10  √  0
node_id int 10  √ 
ezcontentbrowsebookmark.node_id ezcontentbrowsebookmark_ibfk_1 R
ezcontentbrowserecent.node_id ezcontentbrowserecent_ibfk_1 R
ezcontentobject_tree.main_node_id ezcontentobject_tree_ibfk_1 R
ezcontentobject_tree.parent_node_id ezcontentobject_tree_ibfk_2 R
eznode_assignment.parent_node eznode_assignment_ibfk_1 R
ezpdf_export.source_node_id ezpdf_export_ibfk_1 R
ezrss_import.destination_node_id ezrss_import_ibfk_3 R
ezsubtree_notification_rule.node_id ezsubtree_notification_rule_ibfk_1 R
eztipafriend_counter.node_id eztipafriend_counter_ibfk_1 R
ezview_counter.node_id ezview_counter_ibfk_1 R
parent_node_id int 10 0
ezcontentobject_tree.node_id ezcontentobject_tree_ibfk_2 R
path_identification_string longtext 2147483647  √  null
path_string varchar 255
priority int 10 0
remote_id varchar 100
sort_field int 10  √  1
sort_order int 10  √  1

Analyzed at Fri Apr 01 10:42 CEST 2011

Indexes:
Column(s) Type Sort Constraint Name
node_id Primary key Asc PRIMARY
contentobject_id Performance Asc ezcontentobject_tree_co_id
depth Performance Asc ezcontentobject_tree_depth
parent_node_id Performance Asc ezcontentobject_tree_p_node_id
path_string Performance Asc ezcontentobject_tree_path
path_identification_string Performance Asc ezcontentobject_tree_path_ident
main_node_id Performance Asc main_node_id
modified_subnode Performance Asc modified_subnode

Close relationships  within of separation: