CREATE TABLE `gj` (
  `clearId` varchar(100) NOT NULL,
  `alarmTitle` varchar(115) DEFAULT NULL,
  `equipmentClass` varchar(35) DEFAULT NULL COMMENT '设备类型',
  `maker` varchar(25) DEFAULT NULL,
  `standardCode` varchar(155) DEFAULT '',
  `standardName` varchar(155) DEFAULT '',
  `utranCell` varchar(155) DEFAULT '' COMMENT '小区号名',
  `eventTime` datetime DEFAULT NULL COMMENT '发生时间',
  `clearTime` datetime DEFAULT NULL COMMENT '清除时间',
  `dzOrXq` int(11) DEFAULT NULL COMMENT '1:断站 2:断小区',
  `gridName` varchar(45) DEFAULT '',
  `dzSc` varchar(25) DEFAULT '' COMMENT '断站时差',
  `week` int(3) DEFAULT NULL,
  `year` int(11) DEFAULT NULL,
  `standardZs` varchar(15) DEFAULT '',
  `gsxzq` varchar(15) DEFAULT '' COMMENT '归属行政区',
  `cj` varchar(25) DEFAULT '' COMMENT '场景',
  `dzMinute` bigint(20) DEFAULT NULL COMMENT '断站分钟数',
  `eventDay` int(11) DEFAULT NULL COMMENT '发生日期',
  `eventH` int(11) DEFAULT NULL,
  `eventMonth` int(11) DEFAULT NULL,
  `codeOrName` varchar(85) DEFAULT NULL,
  `fdz` int(11) DEFAULT '0',
  `gjStandardZs` varchar(15) DEFAULT NULL,
  `ssjxOver` int(1) DEFAULT '0' COMMENT '0:实时解析刚从middle中导入数据1:实时解析已处理，防止重复查询站/小区再次导入',
  `impDay` int(11) DEFAULT NULL,
  `staticIn` int(1) DEFAULT NULL,
  `pushDingTalk` int(1) DEFAULT '0',
  KEY `eventTime` (`eventTime`) BLOCK_SIZE 16384 LOCAL,
  KEY `clearTime` (`clearTime`) BLOCK_SIZE 16384 LOCAL,
  KEY `dzOrXq` (`dzOrXq`) BLOCK_SIZE 16384 LOCAL,
  KEY `standardZs` (`standardZs`) BLOCK_SIZE 16384 LOCAL,
  KEY `eventDay` (`eventDay`) BLOCK_SIZE 16384 LOCAL,
  KEY `eventMonth` (`eventMonth`) BLOCK_SIZE 16384 LOCAL,
  KEY `clearId` (`clearId`) BLOCK_SIZE 16384 LOCAL,
  KEY `dzMinute` (`dzMinute`) BLOCK_SIZE 16384 LOCAL,
  KEY `codeOrName` (`codeOrName`) BLOCK_SIZE 16384 LOCAL,
  KEY `gridName` (`gridName`) BLOCK_SIZE 16384 LOCAL,
  KEY `utranCell` (`utranCell`) BLOCK_SIZE 16384 LOCAL,
  KEY `dzOrXq_eventMonth` (`dzOrXq`, `eventMonth`, `staticIn`) BLOCK_SIZE 16384 LOCAL
) DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = 'zstd_1.3.8' REPLICA_NUM = 5 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0



CREATE TABLE `gjfq` (
  `clearId` varchar(100) NOT NULL,
  `alarmTitle` varchar(115) DEFAULT NULL,
  `equipmentClass` varchar(35) DEFAULT NULL COMMENT '设备类型',
  `maker` varchar(25) DEFAULT NULL,
  `standardCode` varchar(155) DEFAULT '',
  `standardName` varchar(155) DEFAULT '',
  `utranCell` varchar(155) DEFAULT '' COMMENT '小区号名',
  `eventTime` datetime DEFAULT NULL COMMENT '发生时间',
  `clearTime` datetime DEFAULT NULL COMMENT '清除时间',
  `dzOrXq` int(11) DEFAULT NULL COMMENT '1:断站 2:断小区',
  `gridName` varchar(45) DEFAULT '',
  `dzSc` varchar(25) DEFAULT '' COMMENT '断站时差',
  `week` int(3) DEFAULT NULL,
  `year` int(11) DEFAULT NULL,
  `standardZs` varchar(15) DEFAULT '',
  `gsxzq` varchar(15) DEFAULT '' COMMENT '归属行政区',
  `cj` varchar(25) DEFAULT '' COMMENT '场景',
  `dzMinute` bigint(20) DEFAULT NULL COMMENT '断站分钟数',
  `eventDay` int(11) DEFAULT NULL COMMENT '发生日期',
  `eventH` int(11) DEFAULT NULL,
  `eventMonth` int(11) DEFAULT NULL,
  `codeOrName` varchar(85) DEFAULT NULL,
  `fdz` int(11) DEFAULT '0',
  `gjStandardZs` varchar(15) DEFAULT NULL,
  `ssjxOver` int(1) DEFAULT '0' COMMENT '0:实时解析刚从middle中导入数据1:实时解析已处理，防止重复查询站/小区再次导入',
  `impDay` int(11) DEFAULT NULL,
  `staticIn` int(1) DEFAULT NULL,
  `pushDingTalk` int(1) DEFAULT '0',
  KEY `IDX_eventTime` (`eventTime`) BLOCK_SIZE 16384 LOCAL,
  KEY `IDX_clearTime` (`clearTime`) BLOCK_SIZE 16384 LOCAL,
  KEY `IDX_dzOrXq` (`dzOrXq`) BLOCK_SIZE 16384 LOCAL,
  KEY `IDX_standardZs` (`standardZs`) BLOCK_SIZE 16384 LOCAL,
  KEY `IDX_eventDay` (`eventDay`) BLOCK_SIZE 16384 LOCAL,
  KEY `IDX_eventMonth` (`eventMonth`) BLOCK_SIZE 16384 LOCAL,
  KEY `IDX_clearId` (`clearId`) BLOCK_SIZE 16384 LOCAL,
  KEY `IDX_dzMinute` (`dzMinute`) BLOCK_SIZE 16384 LOCAL,
  KEY `IDX_codeOrName` (`codeOrName`) BLOCK_SIZE 16384 LOCAL,
  KEY `IDX_gridName` (`gridName`) BLOCK_SIZE 16384 LOCAL,
  KEY `IDX_utranCell` (`utranCell`) BLOCK_SIZE 16384 LOCAL,
  KEY `IDX_dzOrXq_eventMonth` (`dzOrXq`, `eventMonth`, `staticIn`) BLOCK_SIZE 16384 LOCAL
) DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = 'zstd_1.3.8' REPLICA_NUM = 5 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0
 partition by range columns(year) subpartition by hash(eventmonth)
(partition p2022 values less than (2023) (
subpartition p2022sp0,
subpartition p2022sp1,
subpartition p2022sp2,
subpartition p2022sp3,
subpartition p2022sp4,
subpartition p2022sp5,
subpartition p2022sp6,
subpartition p2022sp7,
subpartition p2022sp8,
subpartition p2022sp9,
subpartition p2022sp10,
subpartition p2022sp11),
partition p2023 values less than (2024) (
subpartition p2023sp0,
subpartition p2023sp1,
subpartition p2023sp2,
subpartition p2023sp3,
subpartition p2023sp4,
subpartition p2023sp5,
subpartition p2023sp6,
subpartition p2023sp7,
subpartition p2023sp8,
subpartition p2023sp9,
subpartition p2023sp10,
subpartition p2023sp11))