Table ezp54_community.ezcontentobject_trash 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
ezcontentobject.id ezcontentobject_trash_ibfk_1 R
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
modified_subnode int 10  √  0
node_id int 10 0
parent_node_id int 10 0
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 ? 7 07 11:43 CEST 2015

Indexes:
Column(s) Type Sort Constraint Name
node_id Primary key Asc PRIMARY
contentobject_id Performance Asc ezcobj_trash_co_id
depth Performance Asc ezcobj_trash_depth
modified_subnode Performance Asc ezcobj_trash_modified_subnode
parent_node_id Performance Asc ezcobj_trash_p_node_id
path_string Performance Asc ezcobj_trash_path
path_identification_string Performance Asc ezcobj_trash_path_ident

Close relationships  within of separation: