dbo.DimProductSubcategory - AdventureWorksDW

Sample Data Warehouse Documentation

- AdventureWorksDW
  - Modules
  - Tables

Documentation	AdventureWorksDW
Schema	dbo
Name	DimProductSubcategory
Module	Dimensions

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		ProductSubcategoryKey	int		Identity
Identity
	2		ProductSubcategoryAlternateKey	int
	3		EnglishProductSubcategoryName	nvarchar(50)
	4		SpanishProductSubcategoryName	nvarchar(50)
	5		FrenchProductSubcategoryName	nvarchar(50)
	6		ProductCategoryKey	int			dbo.DimProductCategory
References: dbo.DimProductCategory

Relations

Foreign table		Primary table	Join	Title / Name / Description
dbo.DimProductSubcategory		dbo.DimProductCategory	dbo.DimProductSubcategory.ProductCategoryKey = dbo.DimProductCategory.ProductCategoryKey	FK_DimProductSubcategory_DimProductCategory
dbo.DimProductSubcategory.ProductCategoryKey = dbo.DimProductCategory.ProductCategoryKey Name: FK_DimProductSubcategory_DimProductCategory
dbo.DimProduct		dbo.DimProductSubcategory	dbo.DimProduct.ProductSubcategoryKey = dbo.DimProductSubcategory.ProductSubcategoryKey	FK_DimProduct_DimProductSubcategory
dbo.DimProduct.ProductSubcategoryKey = dbo.DimProductSubcategory.ProductSubcategoryKey Name: FK_DimProduct_DimProductSubcategory

Unique keys

	Key name	Columns	Description
	PK_DimProductSubcategory_ProductSubcategoryKey	ProductSubcategoryKey
	AK_DimProductSubcategory_ProductSubcategoryAlternateKey	ProductSubcategoryAlternateKey

Uses

Name
dbo.DimProductSubcategory
dbo.DimProductCategory

Used by

Name
dbo.DimProductSubcategory
dbo.vDMPrep
dbo.vAssocSeqLineItems
dbo.vAssocSeqOrders
dbo.vTargetMail
dbo.vTimeSeries
dbo.DimProduct

Exported: 2019-02-04 22:31, Last imported: 2019-02-04 21:58