dbo.DimGeography - AdventureWorksDW

Sample Data Warehouse Documentation

- AdventureWorksDW
  - Modules
  - Tables

Documentation	AdventureWorksDW
Schema	dbo
Name	DimGeography
Module	Dimensions

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		GeographyKey	int		Identity
Identity
	2		City	nvarchar(30)
	3		StateProvinceCode	nvarchar(3)
	4		StateProvinceName	nvarchar(50)
	5		CountryRegionCode	nvarchar(3)
	6		EnglishCountryRegionName	nvarchar(50)
	7		SpanishCountryRegionName	nvarchar(50)
	8		FrenchCountryRegionName	nvarchar(50)
	9		PostalCode	nvarchar(15)
	10		SalesTerritoryKey	int			dbo.DimSalesTerritory
References: dbo.DimSalesTerritory
	11		IpAddressLocator	nvarchar(15)

Relations

Foreign table		Primary table	Join	Title / Name / Description
dbo.DimGeography		dbo.DimSalesTerritory	dbo.DimGeography.SalesTerritoryKey = dbo.DimSalesTerritory.SalesTerritoryKey	FK_DimGeography_DimSalesTerritory
dbo.DimGeography.SalesTerritoryKey = dbo.DimSalesTerritory.SalesTerritoryKey Name: FK_DimGeography_DimSalesTerritory
dbo.DimCustomer		dbo.DimGeography	dbo.DimCustomer.GeographyKey = dbo.DimGeography.GeographyKey	FK_DimCustomer_DimGeography
dbo.DimCustomer.GeographyKey = dbo.DimGeography.GeographyKey Name: FK_DimCustomer_DimGeography
dbo.DimReseller		dbo.DimGeography	dbo.DimReseller.GeographyKey = dbo.DimGeography.GeographyKey	FK_DimReseller_DimGeography
dbo.DimReseller.GeographyKey = dbo.DimGeography.GeographyKey Name: FK_DimReseller_DimGeography

Unique keys

	Key name	Columns	Description
	PK_DimGeography_GeographyKey	GeographyKey

Uses

Name
dbo.DimGeography
dbo.DimSalesTerritory

Used by

Name
dbo.DimGeography
dbo.vDMPrep
dbo.vAssocSeqLineItems
dbo.vAssocSeqOrders
dbo.vTargetMail
dbo.vTimeSeries
dbo.DimCustomer
dbo.DimReseller

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