AdventureWorks
| Table Name: | Sales.CountryRegionCurrency |
| Description: | Cross-reference table mapping ISO currency codes to a country or region. |
| Primary Keys: | CountryRegionCode CurrencyCode |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| CountryRegionCode | nvarchar (3) | None | No | ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode. |
| CurrencyCode | nchar (3) | None | No | ISO standard currency code. Foreign key to Currency.CurrencyCode. |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode | Yes | Yes | CountryRegionCode CurrencyCode |
| IX_CountryRegionCurrency_CurrencyCode | No | No | CurrencyCode |
| Internal Foreign Key Constraint | Affected Field | Source Table |
|---|---|---|
| FK_CountryRegionCurrency_CountryRegion_CountryRegionCode | CountryRegionCode | Person.CountryRegion |
| FK_CountryRegionCurrency_Currency_CurrencyCode | CurrencyCode | Sales.Currency |