AdventureWorks
| Table Name: | Sales.CurrencyRate |
| Description: | Currency exchange rates. |
| Primary Keys: | CurrencyRateID |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| CurrencyRateID | int - Identity | None | No | Primary key for CurrencyRate records. |
| CurrencyRateDate | datetime | None | No | Date and time the exchange rate was obtained. |
| FromCurrencyCode | nchar (3) | None | No | Exchange rate was converted from this currency code. |
| ToCurrencyCode | nchar (3) | None | No | Exchange rate was converted to this currency code. |
| AverageRate | money | None | No | Average exchange rate for the day. |
| EndOfDayRate | money | None | No | Final exchange rate for the day. |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_CurrencyRate_CurrencyRateID | Yes | Yes | CurrencyRateID |
| AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode | No | Yes | CurrencyRateDate FromCurrencyCode ToCurrencyCode |
| Internal Foreign Key Constraint | Affected Field | Source Table |
|---|---|---|
| FK_CurrencyRate_Currency_FromCurrencyCode | FromCurrencyCode | Sales.Currency |
| FK_CurrencyRate_Currency_ToCurrencyCode | ToCurrencyCode | Sales.Currency |
| Primary Key as Foreign Key Constraint | Affected Table | Affected Field |
|---|---|---|
| FK_SalesOrderHeader_CurrencyRate_CurrencyRateID | Sales.SalesOrderHeader | CurrencyRateID |