dbo.DimSalesTerritory - AdventureWorksDW

Sample Data Warehouse Documentation

- AdventureWorksDW
  - Modules
  - Tables

Documentation	AdventureWorksDW
Schema	dbo
Name	DimSalesTerritory
Module	Dimensions

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		SalesTerritoryKey	int		Identity
Identity
	2		SalesTerritoryAlternateKey	int
	3		SalesTerritoryRegion	nvarchar(50)
	4		SalesTerritoryCountry	nvarchar(50)
	5		SalesTerritoryGroup	nvarchar(50)
	6		SalesTerritoryImage	varbinary(MAX)

Relations

Foreign table		Primary table	Join	Title / Name / Description
dbo.DimEmployee		dbo.DimSalesTerritory	dbo.DimEmployee.SalesTerritoryKey = dbo.DimSalesTerritory.SalesTerritoryKey	FK_DimEmployee_DimSalesTerritory
dbo.DimEmployee.SalesTerritoryKey = dbo.DimSalesTerritory.SalesTerritoryKey Name: FK_DimEmployee_DimSalesTerritory
dbo.DimGeography		dbo.DimSalesTerritory	dbo.DimGeography.SalesTerritoryKey = dbo.DimSalesTerritory.SalesTerritoryKey	FK_DimGeography_DimSalesTerritory
dbo.DimGeography.SalesTerritoryKey = dbo.DimSalesTerritory.SalesTerritoryKey Name: FK_DimGeography_DimSalesTerritory
dbo.FactInternetSales		dbo.DimSalesTerritory	dbo.FactInternetSales.SalesTerritoryKey = dbo.DimSalesTerritory.SalesTerritoryKey	FK_FactInternetSales_DimSalesTerritory
dbo.FactInternetSales.SalesTerritoryKey = dbo.DimSalesTerritory.SalesTerritoryKey Name: FK_FactInternetSales_DimSalesTerritory
dbo.FactResellerSales		dbo.DimSalesTerritory	dbo.FactResellerSales.SalesTerritoryKey = dbo.DimSalesTerritory.SalesTerritoryKey	FK_FactResellerSales_DimSalesTerritory
dbo.FactResellerSales.SalesTerritoryKey = dbo.DimSalesTerritory.SalesTerritoryKey Name: FK_FactResellerSales_DimSalesTerritory

Unique keys

	Key name	Columns	Description
	PK_DimSalesTerritory_SalesTerritoryKey	SalesTerritoryKey
	AK_DimSalesTerritory_SalesTerritoryAlternateKey	SalesTerritoryAlternateKey

Used by

Name
dbo.DimSalesTerritory
dbo.vDMPrep
dbo.vAssocSeqLineItems
dbo.vAssocSeqOrders
dbo.vTargetMail
dbo.vTimeSeries
dbo.DimEmployee
dbo.DimGeography
dbo.FactInternetSales
dbo.FactResellerSales

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