| Column | Data Type | Nullable | Default | Description / PK / Index |
| CurrencyRateID | int | not null | | Primary key for CurrencyRate records.
PK_CurrencyRate_CurrencyRateID |
| CurrencyRateDate | datetime | not null | | Date and time the exchange rate was obtained.
AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode |
| FromCurrencyCode | nchar(3) | not null | | Exchange rate was converted from this currency code.
AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode |
| ToCurrencyCode | nchar(3) | not null | | Exchange rate was converted to this currency code.
AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode |
| AverageRate | money | not null | | Average exchange rate for the day.
|
| EndOfDayRate | money | not null | | Final exchange rate for the day.
|
| ModifiedDate | datetime | not null | (GETDATE()) | Date and time the record was last updated.
|