18 lines
766 B
Transact-SQL
18 lines
766 B
Transact-SQL
CREATE TABLE [dbo].[TMP_Data_1Week] (
|
|
[CRTD_ID] INT IDENTITY (-95995, -1) NOT NULL,
|
|
[CRTD_Period] DATETIME NOT NULL,
|
|
[CRTD_FirstQuote] DATETIME NOT NULL,
|
|
[CRTD_LastQuote] DATETIME NOT NULL,
|
|
[CRTD_PairSymbol] VARCHAR (50) NOT NULL,
|
|
[CRTD_BidOpeningValue] FLOAT (53) NOT NULL,
|
|
[CRTD_BidClosingValue] FLOAT (53) NOT NULL,
|
|
[CRTD_BidLowValue] FLOAT (53) NOT NULL,
|
|
[CRTD_BidHighValue] FLOAT (53) NOT NULL,
|
|
[CRTD_MidOpeningValue] FLOAT (53) NOT NULL,
|
|
[CRTD_MidClosingValue] FLOAT (53) NOT NULL,
|
|
[CRTD_MidLowValue] FLOAT (53) NOT NULL,
|
|
[CRTD_MidHighValue] FLOAT (53) NOT NULL,
|
|
[CRTD_DateIn] DATETIME NOT NULL
|
|
);
|
|
|