MySQL分库分表后聚合查询_MySQL订单分库分表多维度查询

create table TS_ORDER

(

ORDER_ID NUMBER(8) not null,

SN VARCHAR2(50),

MEMBER_ID NUMBER(8),

STATUS NUMBER(2),

PAY_STATUS NUMBER(2),

SHIP_STATUS NUMBER(2),

SHIPPING_ID NUMBER(8),

SHIPPING_TYPE VARCHAR2(255),

SHIPPING_AREA VARCHAR2(255),

PAYMENT_ID NUMBER(8),

PAYMENT_NAME VARCHAR2(50),

PAYMENT_TYPE VARCHAR2(50),

PAYMONEY NUMBER(20,2),

CREATE_TIME NUMBER(20) not null,

SHIP_NAME VARCHAR2(255),

SHIP_ADDR VARCHAR2(255),

SHIP_ZIP VARCHAR2(20),

SHIP_EMAIL VARCHAR2(50),

SHIP_MOBILE VARCHAR2(50),

SHIP_TEL VARCHAR2(50),

SHIP_DAY VARCHAR2(255),

SHIP_TIME VARCHAR2(255),

IS_PROTECT VARCHAR2(1),

PROTECT_PRICE NUMBER(20,2),

GOODS_AMOUNT NUMBER(20,2),

SHIPPING_AMOUNT NUMBER(20,2),

ORDER_AMOUNT NUMBER(20,2),

WEIGHT NUMBER(20,2),

GOODS_NUM NUMBER(8),

GAINEDPOINT NUMBER(11) default 0,

CONSUMEPOINT NUMBER(11) default 0,

DISABLED VARCHAR2(1),

DISCOUNT NUMBER(20,2),

IMPORTED NUMBER(2) default 0,

PIMPORTED NUMBER(2) default 0,

COMPLETE_TIME NUMBER(11) default 0,

CANCEL_REASON VARCHAR2(255),

SIGNING_TIME NUMBER(11),

THE_SIGN VARCHAR2(255),

ALLOCATION_TIME NUMBER(11),

SHIP_PROVINCEID NUMBER(11),

SHIP_CITYID NUMBER(11),

SHIP_REGIONID NUMBER(11),

SALE_CMPL NUMBER(2),

SALE_CMPL_TIME NUMBER(11),

DEPOTID NUMBER(11),

ADMIN_REMARK VARCHAR2(1000),

COMPANY_CODE VARCHAR2(32),

PARENT_SN VARCHAR2(50),

REMARK VARCHAR2(100),

GOODS CLOB,

ORIGINAL_AMOUNT NUMBER(20,2),

IS_ONLINE CHAR(1),

IS_COMMENTED CHAR(1) default 0,

ORDER_FLAG CHAR(1) default 1

)