Person.CountryRegion - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Person
Name	CountryRegion
Module	People

Lookup table containing the ISO standard codes for countries and regions.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		CountryRegionCode	nvarchar(3)				ISO standard code for countries and regions.
ISO standard code for countries and regions.
	2		Name	nvarchar(50)				Country or region name.
Country or region name.
	3		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
Sales.CountryRegionCurrency		Person.CountryRegion	Sales.CountryRegionCurrency.CountryRegionCode = Person.CountryRegion.CountryRegionCode	FK_CountryRegionCurrency_CountryRegion_CountryRegionCode Foreign key constraint referencing CountryRegion.CountryRegionCode.
Sales.CountryRegionCurrency.CountryRegionCode = Person.CountryRegion.CountryRegionCode Name: FK_CountryRegionCurrency_CountryRegion_CountryRegionCode Foreign key constraint referencing CountryRegion.CountryRegionCode.
Sales.SalesTerritory		Person.CountryRegion	Sales.SalesTerritory.CountryRegionCode = Person.CountryRegion.CountryRegionCode	FK_SalesTerritory_CountryRegion_CountryRegionCode Foreign key constraint referencing CountryRegion.CountryRegionCode.
Sales.SalesTerritory.CountryRegionCode = Person.CountryRegion.CountryRegionCode Name: FK_SalesTerritory_CountryRegion_CountryRegionCode Foreign key constraint referencing CountryRegion.CountryRegionCode.
Person.StateProvince		Person.CountryRegion	Person.StateProvince.CountryRegionCode = Person.CountryRegion.CountryRegionCode	FK_StateProvince_CountryRegion_CountryRegionCode Foreign key constraint referencing CountryRegion.CountryRegionCode.
Person.StateProvince.CountryRegionCode = Person.CountryRegion.CountryRegionCode Name: FK_StateProvince_CountryRegion_CountryRegionCode Foreign key constraint referencing CountryRegion.CountryRegionCode.

Unique keys

	Key name	Columns	Description
	PK_CountryRegion_CountryRegionCode	CountryRegionCode	Primary key (clustered) constraint
Primary key (clustered) constraint
	AK_CountryRegion_Name	Name	Unique nonclustered index.
Unique nonclustered index.

Used by

Name
Person.CountryRegion
HumanResources.vEmployee
Person.vStateProvinceCountryRegion
Purchasing.vVendorWithAddresses
Sales.vIndividualCustomer
Sales.vSalesPerson
Sales.vStoreWithAddresses
Person.StateProvince
Sales.CountryRegionCurrency
Sales.SalesTerritory

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