Tables | SQL 2005 Adventure Works OLTP |
Cross-reference table mapping ISO currency codes to a country or region.
Columns
Name Data type Nullable Description CountryRegionCode nvarchar(3) No ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode. CurrencyCode nchar(3) No ISO standard currency code. Foreign key to Currency.CurrencyCode. ModifiedDate datetime No Default value: GETDATE()
Date and time the record was last updated.
Constraints
Name Type Columns Description DF_CountryRegionCurrency_ModifiedDate DEFAULT ModifiedDate Value: GETDATE()
Default constraint value of GETDATE()PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode PRIMARY KEY CountryRegionCode
CurrencyCodeClustered index created by a primary key constraint. FK_CountryRegionCurrency_CountryRegion_CountryRegionCode FOREIGN KEY CountryRegionCode Reference table: Person.CountryRegion
Foreign key constraint referencing CountryRegion.CountryRegionCode.FK_CountryRegionCurrency_Currency_CurrencyCode FOREIGN KEY CurrencyCode Reference table: Sales.Currency
Foreign key constraint referencing Currency.CurrencyCode.
Indices
Name Description IX_CountryRegionCurrency_CurrencyCode Nonclustered index.
Triggers
Name Description Sales.uCountryRegionCurrency AFTER UPDATE trigger setting the ModifiedDate column in the CountryRegionCurrency table to the current date.
Modified by
Name Description Sales.uCountryRegionCurrency AFTER UPDATE trigger setting the ModifiedDate column in the CountryRegionCurrency table to the current date.
Applies to
Tables | User