Knocks/BackEnd/Knoks.PriceDB/Tables/HistData.sql

16 lines
590 B
Transact-SQL

CREATE TABLE [dbo].[HistData] (
[HD_Date] DATETIME NULL,
[HD_Time] VARCHAR (10) NULL,
[HD_Open] FLOAT (53) NULL,
[HD_High] FLOAT (53) NULL,
[HD_Low] FLOAT (53) NULL,
[HD_Close] FLOAT (53) NULL,
[HD_Volume] BIGINT NULL,
[HD_Interval] INT NULL,
[HD_StockName] VARCHAR (50) NULL,
[HD_InstrumentSymbol] VARCHAR (10) NULL,
[HD_FileName] VARCHAR (50) NULL,
[TargetTable] VARCHAR (100) NULL
);