Sales.CountryRegionCurrency - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Sales
Name	CountryRegionCurrency
Module	Sales

Cross-reference table mapping ISO currency codes to a country or region.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		CountryRegionCode	nvarchar(3)			Person.CountryRegion	ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode.
ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode. References: Person.CountryRegion
	2		CurrencyCode	nchar(3)			Sales.Currency	ISO standard currency code. Foreign key to Currency.CurrencyCode.
ISO standard currency code. Foreign key to Currency.CurrencyCode. References: Sales.Currency
	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.CountryRegionCurrency		Sales.Currency	Sales.CountryRegionCurrency.CurrencyCode = Sales.Currency.CurrencyCode	FK_CountryRegionCurrency_Currency_CurrencyCode Foreign key constraint referencing Currency.CurrencyCode.
Sales.CountryRegionCurrency.CurrencyCode = Sales.Currency.CurrencyCode Name: FK_CountryRegionCurrency_Currency_CurrencyCode Foreign key constraint referencing Currency.CurrencyCode.

Unique keys

	Key name	Columns	Description
	PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode	CountryRegionCode, CurrencyCode	Primary key (clustered) constraint
Primary key (clustered) constraint

Uses

Name
Sales.CountryRegionCurrency
Person.CountryRegion
Sales.Currency

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