Sales.CurrencyRate Table

Information

Name	CurrencyRate
Schema	Sales
Row Count	0
Data Size
Index Size
Reserved Size
Unused Size
Created	29.3.2010. 21:58:18
Modified	29.3.2010. 21:58:55

Extended Properties

Name	Type	Property Name	Value
CurrencyRate	TABLE	MS_Description	Currency exchange rates.

Columns

Name	Data Type	Collation	References	Default
CurrencyRateID	int
CurrencyRateDate	datetime
FromCurrencyCode	nchar(3)	SQL_Latin1_General_CP1_CI_AS	Sales.Currency.CurrencyCode
ToCurrencyCode	nchar(3)	SQL_Latin1_General_CP1_CI_AS	Sales.Currency.CurrencyCode
AverageRate	money
EndOfDayRate	money
ModifiedDate	datetime			(getdate())

Indexes

Name	Type	Primary	Unique	Columns
PK_CurrencyRate_CurrencyRateID	Clustered			CurrencyRateID
AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode	NonClustered			CurrencyRateDate, FromCurrencyCode, ToCurrencyCode

Foreign Key Constraints

Name	Type	Referenced Table
FK_CurrencyRate_Currency_FromCurrencyCode	Foreign key	Sales.Currency
FK_CurrencyRate_Currency_ToCurrencyCode	Foreign key	Sales.Currency

SQL Script

CREATE TABLE [Sales].[CurrencyRate] (
    [CurrencyRateID] int NOT NULL IDENTITY,
    [CurrencyRateDate] datetime NOT NULL,
    [FromCurrencyCode] nchar(3) NOT NULL,
    [ToCurrencyCode] nchar(3) NOT NULL,
    [AverageRate] money NOT NULL,
    [EndOfDayRate] money NOT NULL,
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);
CREATE UNIQUE INDEX [AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode] on [Sales].[CurrencyRate]([CurrencyRateDate], [FromCurrencyCode], [ToCurrencyCode]);