Production.ProductSubcategory - Products - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Production
Name	ProductSubcategory
Module	Products

Product subcategories. See ProductCategory table.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		ProductSubcategoryID	int		Identity		Primary key for ProductSubcategory records.
Primary key for ProductSubcategory records. Identity
	2		ProductCategoryID	int			Production.ProductCategory	Product category identification number. Foreign key to ProductCategory.ProductCategoryID.
Product category identification number. Foreign key to ProductCategory.ProductCategoryID. References: Production.ProductCategory
	3		Name	nvarchar(50)				Subcategory description.
Subcategory description.
	4		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()
	5		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.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.
Production.Product		Production.ProductSubcategory	Production.Product.ProductSubcategoryID = Production.ProductSubcategory.ProductSubcategoryID	FK_Product_ProductSubcategory_ProductSubcategoryID Foreign key constraint referencing ProductSubcategory.ProductSubcategoryID.
Production.Product.ProductSubcategoryID = Production.ProductSubcategory.ProductSubcategoryID Name: FK_Product_ProductSubcategory_ProductSubcategoryID Foreign key constraint referencing ProductSubcategory.ProductSubcategoryID.

Unique keys

	Key name	Columns	Description
	PK_ProductSubcategory_ProductSubcategoryID	ProductSubcategoryID	Primary key (clustered) constraint
Primary key (clustered) constraint
	AK_ProductSubcategory_Name	Name	Unique nonclustered index.
Unique nonclustered index.
	AK_ProductSubcategory_rowguid	rowguid	Unique nonclustered index. Used to support replication samples.
Unique nonclustered index. Used to support replication samples.

Uses

Name
Production.ProductSubcategory
Production.ProductCategory

Used by

Name
Production.ProductSubcategory
Production.Product

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