Sales |
04/26/2006 |
PRIMARY |
768 |
400 |
13532 |
Currency exchange rates. |
|
|
CurrencyRateID |
int |
4 |
|
|
|
|
Primary key for CurrencyRate records. |
|
|
CurrencyRateDate |
datetime |
8 |
|
|
|
|
Date and time the exchange rate was obtained. |
|
|
FromCurrencyCode |
nchar |
3 |
|
|
|
|
Exchange rate was converted from this currency code. |
|
|
ToCurrencyCode |
nchar |
3 |
|
|
|
|
Exchange rate was converted to this currency code. |
|
|
AverageRate |
money |
8 |
|
|
|
|
Average exchange rate for the day. |
|
|
EndOfDayRate |
money |
8 |
|
|
|
|
Final exchange rate for the day. |
|
|
ModifiedDate |
datetime |
8 |
|
(getdate()) |
|
|
Date and time the record was last updated. |
Total: 7 column(s)
|
CurrencyRateID |
1 |
1 |
|
Total: 2 index(es)
Total: 1 table(s)
Total: 2 table(s)
Total: 2 object(s)
Total: 6 object(s)
CREATE TABLE [CurrencyRate] (
[CurrencyRateID] [int] IDENTITY (1, 1) NOT NULL ,
[CurrencyRateDate] [datetime] NOT NULL ,
[FromCurrencyCode] [nchar] (3) COLLATE Latin1_General_CS_AS NOT NULL ,
[ToCurrencyCode] [nchar] (3) COLLATE Latin1_General_CS_AS NOT NULL ,
[AverageRate] [money] NOT NULL ,
[EndOfDayRate] [money] NOT NULL ,
[ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_CurrencyRate_ModifiedDate] DEFAULT (getdate()),
CONSTRAINT [PK_CurrencyRate_CurrencyRateID] PRIMARY KEY CLUSTERED
(
[CurrencyRateID]
) ON [PRIMARY] ,
CONSTRAINT [FK_CurrencyRate_Currency_FromCurrencyCode] FOREIGN KEY
(
[FromCurrencyCode]
) REFERENCES [Currency] (
[CurrencyCode]
),
CONSTRAINT [FK_CurrencyRate_Currency_ToCurrencyCode] FOREIGN KEY
(
[ToCurrencyCode]
) REFERENCES [Currency] (
[CurrencyCode]
)
) ON [PRIMARY]
GO
List of tables