数据采集系统数据库.
- 1、下载文档前请自行甄别文档内容的完整性,平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益,请联系客服反馈,我们会尽快为您处理(人工客服工作时间:9:00-18:30)。
create table treaty_table ( TID INT identity(1,1, Tname varchar(20, F-route varchar(50, period int, filename varchar(50, Type_ID INT, constraint
PK_TREATY_TABLE primary key (TID create table type_table ( Type_ID INT identity(1,1, typename varchar(20, bourse varchar(40, constraint PK_TYPE_TABLE primary key (Type_ID ; create table CY_table ( CY_ID INT identity(1,1, MF varchar(20, pt datetime, Type_ID INT, constraint PK_CY_TABLE primary key (CY_ID ; create table Time_table ( Time_ID INT identity(1,1, DATE DATETIME, constraint
PK_TIME_TABLE primary key (Time_ID ; create table K_table ( Root_ID INT identity(1,1, Type_ID INT, period INT, date datetime, rootnum INT, constraint
PK_K_TABLE primary key (Root_ID ; create table Min1_table ( Min1_ID INT identity(1,1, treaty_name varchar(20, date datetime, open money, Close money, Heigh money, low money, Vol money, OPI money, S money, constraint PK_MIN1_TABLE primary key (Min1_ID ; create table Min5_table ( Min5_ID INT identity(1,1,
treaty_name varchar(20, date datetime, open money, Close money, Heigh money, low money, Vol money, OPI money, S money, constraint PK_MIN1_TABLE primary key (Min5_ID ; create table Min15_table ( Min15_ID INT identity(1,1, treaty_name varchar(20, date datetime, open money, Close money, Heigh money, low money, Vol money, OPI money, S money, constraint PK_MIN1_TABLE primary key (Min15_ID ; create table Min30_table ( Min30_ID INT identity(1,1, treaty_name varchar(20, date datetime, open money, Close money, Heigh money, low money, Vol money, OPI money, S money, constraint PK_MIN1_TABLE primary key (Min30_ID ; create table
Hour1_table ( H
our1_ID INT identity(1,1, treaty_name varchar(20, date datetime, open money, Close money, Heigh money, low money, Vol money, OPI money, S money, constraint PK_MIN1_TABLE primary key (Hour1_ID ; create table Hour4_table ( Hour4_ID INT identity(1,1, treaty_name varchar(20, date datetime, open money, Close money, Heigh money, low money, Vol money, OPI money, S money, constraint PK_MIN1_TABLE primary key (Hour4_ID ; create table Day_table ( Day_ID INT identity(1,1, treaty_name
varchar(20, date datetime, open money, close money, heigh money, low money, OPI money, S money, constraint PK_DAY_TABLE primary key (Day_ID ; create table Week_table ( Week_ID INT identity(1,1, treaty_name varchar(20, date datetime, open money, close money, heigh money, low money, OPI money, S money, constraint
PK_DAY_TABLE primary key (Week_ID ; create table Year_table ( Year_ID INT identity(1,1, treaty_name varchar(20, date datetime, open money, close money, heigh money, low money, OPI money, S money, constraint PK_DAY_TABLE primary key (Year_ID ; create table Tick_table ( Tick_ID INT identity(1,1, treaty_name varchar(20, date datetime, VOM money, SH money, SOPI money, constraint PK_TICK_TABLE primary key (Tick_ID ; create table SEC10_table ( SEC_ID INT identity(1,1,
treaty_name varchar(20, date datetime, VOM money, SH money, SOPI money, constraint PK_TICK_TABLE primary key (SEC_ID ;