dbo.product_categories - Products

Box Inc - Enterprise Data Catalog

Documentation	Products
Schema	dbo
Name	product_categories
Module	Products

Products are grouped into a hierarchy of categories. This hierarchy is represented in product_categories table.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		product_category_id	int		Identity		Category unique ID
Category unique ID Identity
	2		category_name	nvarchar(150)				Product category name
Product category name
	3		parent_category_id	int			dbo.product_categories	Parent category ID or null if category is at the top level
Parent category ID or null if category is at the top level References: dbo.product_categories

Relations

Foreign table		Primary table	Join	Title / Name / Description
dbo.product_categories		dbo.product_categories	dbo.product_categories.parent_category_id = dbo.product_categories.product_category_id	Parent User-defined relation
dbo.product_categories.parent_category_id = dbo.product_categories.product_category_id Title: Parent Name: User-defined relation
dbo.product_categories		dbo.product_categories	dbo.product_categories.parent_category_id = dbo.product_categories.product_category_id	Parent User-defined relation
dbo.product_categories.parent_category_id = dbo.product_categories.product_category_id Title: Parent Name: User-defined relation
dbo.products		dbo.product_categories	dbo.products.product_category_id = dbo.product_categories.product_category_id	FK_products_product_categories
dbo.products.product_category_id = dbo.product_categories.product_category_id Name: FK_products_product_categories

Unique keys

	Key name	Columns	Description
	PK_product_categories	product_category_id

Uses

Name
dbo.product_categories
dbo.product_categories (Parent)

Used by

Name
dbo.product_categories
dbo.product_categories_v
dbo.product_categories (Parent)
dbo.products

Exported: 2019-02-04 23:17, Last imported: 2018-04-10 17:07