Object type: Table

Currency exchange rates.

Columns 

Name	Data type	Nullable	Description
CurrencyRateID	int	No	Column has identity seed value of 1 with a step value of 1. Primary key for CurrencyRate records.
CurrencyRateDate	datetime	No	Date and time the exchange rate was obtained.
FromCurrencyCode	nchar(3)	No	Exchange rate was converted from this currency code.
ToCurrencyCode	nchar(3)	No	Exchange rate was converted to this currency code.
AverageRate	money	No	Average exchange rate for the day.
EndOfDayRate	money	No	Final exchange rate for the day.
ModifiedDate	datetime	No	Default value: GETDATE() Date and time the record was last updated.

Constraints 

Name	Type	Columns	Description
DF_CurrencyRate_ModifiedDate	DEFAULT	ModifiedDate	Value: GETDATE() Default constraint value of GETDATE()
PK_CurrencyRate_CurrencyRateID	PRIMARY KEY	CurrencyRateID	Clustered index created by a primary key constraint.
FK_CurrencyRate_Currency_FromCurrencyCode	FOREIGN KEY	FromCurrencyCode	Reference table: Sales.Currency Foreign key constraint referencing Currency.FromCurrencyCode.
FK_CurrencyRate_Currency_ToCurrencyCode	FOREIGN KEY	ToCurrencyCode	Reference table: Sales.Currency Foreign key constraint referencing Currency.ToCurrencyCode.

Indices 

Name	Description
AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode	Unique nonclustered index.

Triggers 

Name	Description
Sales.uCurrencyRate	AFTER UPDATE trigger setting the ModifiedDate column in the CurrencyRate table to the current date.

Linked tables 

Name	Description
Sales.SalesOrderHeader	General sales order information.

Modified by 

Name	Description
Sales.uCurrencyRate	AFTER UPDATE trigger setting the ModifiedDate column in the CurrencyRate 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