Magento Certified Developer GuideCategory: 7. CatalogHow is the category hierarchy reflected in the database? Does it differ when multiple root categories are present?
Manish Prakash Staff asked 5 years ago

The category hierarchy is stored in table ‘catalog_category_entity’

The main two column used to maintain hierarchy are ‘parent_id’ and ‘path’

Also it doesn’t differ when we have multiple root categories, that concept remains the same.