Table item_navigation_node
Stores a node reference in an item with navigation

Legend:
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 int8 19
item_navigation_node.parent_id fka57d421f11e6b39 R
item_navigation_tab.node_id fkadc0d996f3bfa6e1 R
icon varchar 100  √  null
identifier varchar 200  √  null
index int4 10  √  null
name text 2147483647  √  null
uuid varchar 40  √  null
item_id int8 19
item.id fka57d4216f7f1a9c R
parent_id int8 19  √  null
item_navigation_node.id fka57d421f11e6b39 R
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc item_navigation_node_pkey
item_id Performance Asc itemnavnodeitem
parent_id Performance Asc itemnavnodeparent

Close relationships  within of separation: