32 lines
911 B
SQL
Executable File
32 lines
911 B
SQL
Executable File
|
|
DROP TABLE IF EXISTS `T_EXCHANGE_APPLY_ORDER`;
|
|
CREATE TABLE `T_EXCHANGE_APPLY_ORDER` (
|
|
`UUID` varchar(32) NOT NULL COMMENT '主键',
|
|
`PARTY_ID` varchar(32) ,
|
|
`SYMBOL` varchar(32) COMMENT '代码',
|
|
`ORDER_NO` varchar(64) ,
|
|
`OFFSET`varchar(32),
|
|
`VOLUME` double ,
|
|
`PRICE` double ,
|
|
`ORDER_PRICE_TYPE`varchar(32),
|
|
`STATE` varchar(32) ,
|
|
`CREATE_TIME` datetime ,
|
|
`FEE` double ,
|
|
PRIMARY KEY (`UUID`),
|
|
KEY `INDEX_EXCHANGE_APPLY_ORDER_STATUS` (`STATE`,`CREATE_TIME`),
|
|
KEY `INDEX_EXCHANGE_APPLY_ORDER_ORDER_NO` (`ORDER_NO`),
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
|
|
|
|
|
|
DROP TABLE IF EXISTS `T_WALLET_EXTEND_COSTUSDT`;
|
|
CREATE TABLE `T_WALLET_EXTEND_COSTUSDT` (
|
|
`UUID` varchar(32) NOT NULL COMMENT '主键',
|
|
`PARTY_ID` varchar(32) ,
|
|
`WALLETTYPE` varchar(32) ,
|
|
`VOLUME` double ,
|
|
`PRICE` double ,
|
|
PRIMARY KEY (`UUID`),
|
|
KEY `INDEX_WALLET_EXTEND_COSTUSDT_PARTY_ID` (`PARTY_ID`,`WALLETTYPE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |