Sales.CurrencyRate

Columns

• //

  ${escapify(column.description)}
  CurrencyRateID
  [int] IDENTITY (1,1) NOT NULL
• //

  ${escapify(column.description)}
  CurrencyRateDate
  [datetime] NOT NULL
• //

  ${escapify(column.description)}
  FromCurrencyCode
  [nchar](3) NOT NULL
• //

  ${escapify(column.description)}
  ToCurrencyCode
  [nchar](3) NOT NULL
• //

  ${escapify(column.description)}
  AverageRate
  [money] NOT NULL
• //

  ${escapify(column.description)}
  EndOfDayRate
  [money] NOT NULL
• //

  ${escapify(column.description)}
  ModifiedDate
  [datetime] NOT NULL DEFAULT (getdate())

Indexes

• //

  Clustered index created by a primary key constraint.
  PK_CurrencyRate_CurrencyRateID
  UNIQUE CLUSTERED
  CurrencyRateID
• //

  Unique nonclustered index.
  AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
  UNIQUE NONCLUSTERED
  CurrencyRateDate , FromCurrencyCode , ToCurrencyCode

Foreign Keys

• //

  Foreign key constraint referencing Currency.FromCurrencyCode.
  FK_CurrencyRate_Currency_FromCurrencyCode
  Sales.Currency
  FromCurrencyCode ⥱ CurrencyCode
• //

  Foreign key constraint referencing Currency.ToCurrencyCode.
  FK_CurrencyRate_Currency_ToCurrencyCode
  Sales.Currency
  ToCurrencyCode ⥱ CurrencyCode

Sample Data