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 ;。