category_tree


Columns

Column Type Size Nulls Auto Default Children Parents Comments
self_id CHAR 36 null
node_id INT 10 null
parent_node_id INT 10 0
type VARCHAR 36 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc node_id
idx_categorytree Performance Asc self_id

Relationships