我是咖啡哥
9
CREATE TABLE `XXX` (
`ID` VARCHAR(200) NOT NULL COMMENT 'ID',
`VEHICLE_NO` VARCHAR(50) DEFAULT NULL COMMENT '',
`WAYBILL_NO` VARCHAR(50) NOT NULL COMMENT '运单号',
....
`DEP_NODE_THREE` INT(10) DEFAULT NULL COMMENT '出发节点3',
`DEP_NODE_FOUR` INT(10) DEFAULT NULL COMMENT '出发节点4',
`DEP_NODE_FIVE` INT(10) DEFAULT NULL COMMENT '出发节点5',
`TKHK_TICKS` INT(10) DEFAULT NULL COMMENT '特快xx票数',
`EXP_TICKS` INT(10) DEFAULT NULL COMMENT 'x',
`ACTIVE` CHAR(1) DEFAULT NULL COMMENT '是否有效',
`CREATE_TIME` DATETIME(6) DEFAULT NULL COMMENT '创建时间',
`PARTITION_DATE` DATE NOT NULL COMMENT '分区日期',
`SHARDING_ITEM` INT(10) DEFAULT NULL COMMENT '分片项',
PRIMARY KEY (`ID`) /*T![clustered_index] NONCLUSTERED */,
KEY `IDX_UPII_WAYBILL_NO` (`WAYBILL_NO`),
KEY `IDX_UPII_CREATE_TIME` (`CREATE_TIME`),
KEY `IDX_ITEM_TIME` (`SHARDING_ITEM`,`CREATE_TIME`),
KEY `IDX_UPII_GROUP_BY_COMPOSITE` (`VEHICLE_NO`,`ARRIVE_ORG_CODE`,`CONSUMER_TAG`)
) ENGINE=INNODB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='xxx' SHARD_ROW_ID_BITS = 4,PRE_SPLIT_REGIONS = 4;