Tables SQL 2005 Adventure Works OLTP

Sales.CountryRegionCurrency

Object type: Table

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
CurrencyCode 
Clustered 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
The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation

Document was prepared on: Thursday, April 05, 2007
Help compiled by DBDocumentor, a Pikauba Software product. All rights reserved.