Production.ProductCategory - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Production
Name	ProductCategory
Module	Products

High-level product categorization.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		ProductCategoryID	int		Identity		Primary key for ProductCategory records.
Primary key for ProductCategory records. Identity
	2		Name	nvarchar(50)			Production.ProductModelIllustration	Category description.
Category description. References: Production.ProductModelIllustration
	3		rowguid	uniqueidentifier		Default: newid()		ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. Default: newid()
	4		ModifiedDate	datetime		Default: getdate()		Date and time the record was last updated.
Date and time the record was last updated. Default: getdate()

Relations

Foreign table		Primary table	Join	Title / Name / Description
Production.ProductCategory		Production.ProductModelIllustration	Production.ProductCategory.Name = Production.ProductModelIllustration.ProductModelID Production.ProductCategory.Name = Production.ProductModelIllustration.IllustrationID	fk_ProductModelIllustration_ProductCategory
Production.ProductCategory.Name = Production.ProductModelIllustration.ProductModelID Production.ProductCategory.Name = Production.ProductModelIllustration.IllustrationID Name: fk_ProductModelIllustration_ProductCategory
Production.ProductSubcategory		Production.ProductCategory	Production.ProductSubcategory.ProductCategoryID = Production.ProductCategory.ProductCategoryID	FK_ProductSubcategory_ProductCategory_ProductCategoryID Foreign key constraint referencing ProductCategory.ProductCategoryID.
Production.ProductSubcategory.ProductCategoryID = Production.ProductCategory.ProductCategoryID Name: FK_ProductSubcategory_ProductCategory_ProductCategoryID Foreign key constraint referencing ProductCategory.ProductCategoryID.

Unique keys

	Key name	Columns	Description
	PK_ProductCategory_ProductCategoryID	ProductCategoryID	Primary key (clustered) constraint
Primary key (clustered) constraint
	AK_ProductCategory_Name	Name	Unique nonclustered index.
Unique nonclustered index.
	AK_ProductCategory_rowguid	rowguid	Unique nonclustered index. Used to support replication samples.
Unique nonclustered index. Used to support replication samples.

Uses

Name
Production.ProductCategory
Production.ProductModelIllustration

Used by

Name
Production.ProductCategory
Production.ProductSubcategory

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56