Sales.CountryRegionCurrency (table)

From dbscript Online Help
Jump to: navigation, search

wikibot[edit]

Table Sales.CountryRegionCurrency
Description Cross-reference table mapping ISO currency codes to a country or region.

Columns[edit]

Column Data Type Nullable Default Description
CountryRegionCode nvarchar(3) not null ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode.
CurrencyCode nchar(3) not null ISO standard currency code. Foreign key to Currency.CurrencyCode.
ModifiedDate datetime not null (getdate()) Date and time the record was last updated.

Primary Key[edit]

Primary Key Columns
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode CountryRegionCode, CurrencyCode

Indexes[edit]

Index Type Columns
IX_CountryRegionCurrency_CurrencyCode CurrencyCode

Foreign Keys[edit]

Relation Column Referenced Column
Person.CountryRegion CountryRegionCode CountryRegionCode
Sales.Currency CurrencyCode CurrencyCode

References[edit]

Dependency Type Object Type Referenced Object
Schema Schema Sales


automatically generated[edit]

Table Sales.CountryRegionCurrency
Description Cross-reference table mapping ISO currency codes to a country or region.


Column Data Type Nullable Default Description / PK / Index
CountryRegionCode nvarchar(3) not null ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode.
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode
CurrencyCode nchar(3) not null ISO standard currency code. Foreign key to Currency.CurrencyCode.
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCodeIX_CountryRegionCurrency_CurrencyCode
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Relation Column Referenced Column
Person.CountryRegion CountryRegionCode CountryRegionCode
Sales.Currency CurrencyCode CurrencyCode


Dependency Type Object Type Referenced Object
Schema Schema Sales