product_categories

674 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
category_products_count.category_id category_products_count_category_id_fkey R
product_categories.parent_id product_categories_parent_id_fkey N
products.category_id products_category_id_fkey R
name VARCHAR 255 null
parent_id INT 10 √ null
product_categories.id product_categories_parent_id_fkey N
level INT 10 0
path VARCHAR 255 null
created_at DATETIME 19 CURRENT_TIMESTAMP
updated_at DATETIME 19 CURRENT_TIMESTAMP
deleted_at DATETIME 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_product_categories_parent_id Performance Asc parent_id

Relationships

Close relationships within degrees of separation