/* Navicat MySQL Data Transfer Source Server : 192.168.0.22 Source Server Version : 50735 Source Host : 192.168.0.22:3306 Source Database : cems_2022 Target Server Type : MYSQL Target Server Version : 50735 File Encoding : 65001 Date: 2022-01-26 10:31:05 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for anal_device_runtime -- ---------------------------- DROP TABLE IF EXISTS `anal_device_runtime`; CREATE TABLE `anal_device_runtime` ( `device_id` int(11) NOT NULL COMMENT '设备id', `upload_date` bigint(20) NOT NULL COMMENT '统计时间yyyyMMdd', `company_id` int(11) NOT NULL COMMENT '所属企业id', `run_time` int(11) NOT NULL DEFAULT '0' COMMENT '运行时间(分钟)', PRIMARY KEY (`device_id`,`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='设备运行时间统计表'; -- ---------------------------- -- Table structure for anal_monitor_date -- ---------------------------- DROP TABLE IF EXISTS `anal_monitor_date`; CREATE TABLE `anal_monitor_date` ( `mn` varchar(30) NOT NULL COMMENT '净化设施mn', `company_id` int(11) NOT NULL COMMENT '企业id', `upload_date` bigint(20) NOT NULL COMMENT '时间yyyyMMdd', `smoke_total` decimal(12,3) DEFAULT NULL COMMENT '烟雾浓度排放总量，单位克', `voc_total` decimal(12,3) DEFAULT NULL COMMENT 'VOC浓度排放总量，单位克', `pm25_total` decimal(12,3) DEFAULT NULL COMMENT 'pm25排放总量，单位克', PRIMARY KEY (`mn`,`company_id`,`upload_date`), KEY `indexes_upload_date` (`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='油烟排放量日表'; -- ---------------------------- -- Table structure for anal_soot_company -- ---------------------------- DROP TABLE IF EXISTS `anal_soot_company`; CREATE TABLE `anal_soot_company` ( `company_id` int(11) NOT NULL COMMENT '机构id', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMdd', `soot` decimal(8,3) NOT NULL COMMENT '油烟排放总量，单位：g', `run_time` decimal(8,3) NOT NULL COMMENT '运行时间', `run_total` int(11) NOT NULL COMMENT '运行总数', PRIMARY KEY (`company_id`,`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='公司油烟排放表'; -- ---------------------------- -- Table structure for anal_soot_org -- ---------------------------- DROP TABLE IF EXISTS `anal_soot_org`; CREATE TABLE `anal_soot_org` ( `org_id` int(11) NOT NULL COMMENT '机构id', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMdd', `soot` decimal(8,3) DEFAULT NULL COMMENT '油烟排放总量单位：g', `run_total` int(11) DEFAULT NULL COMMENT '运行总数', PRIMARY KEY (`org_id`,`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='机构油烟排放表'; -- ---------------------------- -- Table structure for company_credit -- ---------------------------- DROP TABLE IF EXISTS `company_credit`; CREATE TABLE `company_credit` ( `company_id` int(11) NOT NULL COMMENT '企业id', `org_id` int(11) NOT NULL COMMENT '组织机构id', `upload_date` bigint(20) NOT NULL COMMENT '时间yyyyMM', `score` int(11) NOT NULL DEFAULT '0' COMMENT '评分', PRIMARY KEY (`company_id`,`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='企业信用统计月表'; -- ---------------------------- -- Table structure for company_red_black -- ---------------------------- DROP TABLE IF EXISTS `company_red_black`; CREATE TABLE `company_red_black` ( `company_id` int(11) NOT NULL COMMENT '企业id', `org_id` int(11) NOT NULL COMMENT '组织机构id', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMdd', `exceed_total` int(11) NOT NULL DEFAULT '0' COMMENT '超标总数（油烟、voc、pm25）', `smoke_density` decimal(8,3) NOT NULL COMMENT '烟雾浓度总数，单位：ppm', `voc_density` decimal(8,3) NOT NULL COMMENT 'VOC浓度总数，单位：ppm', `pm25` decimal(8,3) NOT NULL COMMENT 'pm25总数', `smoke_sum` int(11) NOT NULL DEFAULT '0' COMMENT '油烟上报总数', PRIMARY KEY (`company_id`,`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='企业红黑榜统计表'; -- ---------------------------- -- Table structure for company_warn_statistics -- ---------------------------- DROP TABLE IF EXISTS `company_warn_statistics`; CREATE TABLE `company_warn_statistics` ( `company_id` int(11) NOT NULL COMMENT '企业id', `org_id` int(11) NOT NULL COMMENT '组织机构id', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMdd', `exceed_total` int(11) NOT NULL DEFAULT '0' COMMENT '超标总数（油烟、voc、pm25）', `exceed_declare_total` int(11) NOT NULL DEFAULT '0' COMMENT '超标已申报总数（油烟、voc、pm25）', `exceed_undeclare_total` int(11) NOT NULL DEFAULT '0' COMMENT '超标未申报总数（油烟、voc、pm25）', `exceed_smoke_num` int(11) NOT NULL DEFAULT '0' COMMENT '油烟超标总数', `exceed_voc_num` int(11) NOT NULL DEFAULT '0' COMMENT 'voc超标总数', `exceed_pm25_num` int(11) NOT NULL DEFAULT '0' COMMENT 'pm25超标总数', `exceed_device_num` int(11) NOT NULL DEFAULT '0' COMMENT '超标设备总数', `exceed_device_ids` varchar(200) DEFAULT NULL COMMENT '超标设备id，以","分隔', `offline_total` int(11) NOT NULL DEFAULT '0' COMMENT '设备异常总数（离线报警）', `offline_declare_total` int(11) NOT NULL DEFAULT '0' COMMENT '设备异常已申报总数（离线报警）', `offline_undeclare_total` int(11) NOT NULL DEFAULT '0' COMMENT '设备异常未申报总数（离线报警）', `overdue_total` int(11) NOT NULL DEFAULT '0' COMMENT '清洗逾期报警总数', `overdue_declare_total` int(11) NOT NULL DEFAULT '0' COMMENT '清洗逾期报警已申报总数', `overdue_undeclare_total` int(11) NOT NULL DEFAULT '0' COMMENT '清洗逾期报警未申报总数', `monitoring_type` int(1) NOT NULL DEFAULT '0' COMMENT '企业监测类型，0：油烟监测；1：配电工况', PRIMARY KEY (`company_id`,`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='企业报警情况统计表'; -- ---------------------------- -- Table structure for online_data_electric_01 -- ---------------------------- DROP TABLE IF EXISTS `online_data_electric_01`; CREATE TABLE `online_data_electric_01` ( `terminal_id` varchar(30) NOT NULL COMMENT '监测仪编号', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMddHHmmss', `ia` decimal(12,3) DEFAULT NULL COMMENT 'A相电流，单位：A安[培]', `ib` decimal(12,3) DEFAULT NULL COMMENT 'B相电流，单位：A安[培]', `ic` decimal(12,3) DEFAULT NULL COMMENT 'C相电流，单位：A安[培]', `ua` decimal(12,3) DEFAULT NULL COMMENT 'A相电压，单位：V伏[特]', `ub` decimal(12,3) DEFAULT NULL COMMENT 'B相电压，单位：V伏[特]', `uc` decimal(12,3) DEFAULT NULL COMMENT 'C相电压，单位：V伏[特]', `pa` decimal(12,4) DEFAULT NULL COMMENT '瞬时A相有功功率，kW千瓦', `pb` decimal(12,4) DEFAULT NULL COMMENT '瞬时B相有功功率，kW千瓦', `pc` decimal(12,4) DEFAULT NULL COMMENT '瞬时C相有功功率，kW千瓦', `p` decimal(12,4) DEFAULT NULL COMMENT '瞬时总有功功率，kW千瓦', `thea` decimal(12,3) DEFAULT NULL COMMENT 'A相功率因数，单位：无量纲', `theb` decimal(12,3) DEFAULT NULL COMMENT 'B相功率因数，单位：无量纲', `thec` decimal(12,3) DEFAULT NULL COMMENT 'C相功率因数，单位：无量纲', `the` decimal(12,3) DEFAULT NULL COMMENT '总功率因数，单位：无量纲', `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间yyyyMMddHHmmss', PRIMARY KEY (`terminal_id`,`upload_date`), KEY `indexes_upload_date` (`upload_date`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='电力实时表' /*!50100 PARTITION BY RANGE (upload_date) (PARTITION part01 VALUES LESS THAN (20220101235959) ENGINE = InnoDB, PARTITION part02 VALUES LESS THAN (20220102235959) ENGINE = InnoDB, PARTITION part03 VALUES LESS THAN (20220103235959) ENGINE = InnoDB, PARTITION part04 VALUES LESS THAN (20220104235959) ENGINE = InnoDB, PARTITION part05 VALUES LESS THAN (20220105235959) ENGINE = InnoDB, PARTITION part06 VALUES LESS THAN (20220106235959) ENGINE = InnoDB, PARTITION part07 VALUES LESS THAN (20220107235959) ENGINE = InnoDB, PARTITION part08 VALUES LESS THAN (20220108235959) ENGINE = InnoDB, PARTITION part09 VALUES LESS THAN (20220109235959) ENGINE = InnoDB, PARTITION part10 VALUES LESS THAN (20220110235959) ENGINE = InnoDB, PARTITION part11 VALUES LESS THAN (20220111235959) ENGINE = InnoDB, PARTITION part12 VALUES LESS THAN (20220112235959) ENGINE = InnoDB, PARTITION part13 VALUES LESS THAN (20220113235959) ENGINE = InnoDB, PARTITION part14 VALUES LESS THAN (20220114235959) ENGINE = InnoDB, PARTITION part15 VALUES LESS THAN (20220115235959) ENGINE = InnoDB, PARTITION part16 VALUES LESS THAN (20220116235959) ENGINE = InnoDB, PARTITION part17 VALUES LESS THAN (20220117235959) ENGINE = InnoDB, PARTITION part18 VALUES LESS THAN (20220118235959) ENGINE = InnoDB, PARTITION part19 VALUES LESS THAN (20220119235959) ENGINE = InnoDB, PARTITION part20 VALUES LESS THAN (20220120235959) ENGINE = InnoDB, PARTITION part21 VALUES LESS THAN (20220121235959) ENGINE = InnoDB, PARTITION part22 VALUES LESS THAN (20220122235959) ENGINE = InnoDB, PARTITION part23 VALUES LESS THAN (20220123235959) ENGINE = InnoDB, PARTITION part24 VALUES LESS THAN (20220124235959) ENGINE = InnoDB, PARTITION part25 VALUES LESS THAN (20220125235959) ENGINE = InnoDB, PARTITION part26 VALUES LESS THAN (20220126235959) ENGINE = InnoDB, PARTITION part27 VALUES LESS THAN (20220127235959) ENGINE = InnoDB, PARTITION part28 VALUES LESS THAN (20220128235959) ENGINE = InnoDB, PARTITION part29 VALUES LESS THAN (20220129235959) ENGINE = InnoDB, PARTITION part30 VALUES LESS THAN (20220130235959) ENGINE = InnoDB, PARTITION part31 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; -- ---------------------------- -- Table structure for online_data_electric_02 -- ---------------------------- DROP TABLE IF EXISTS `online_data_electric_02`; CREATE TABLE `online_data_electric_02` ( `terminal_id` varchar(30) NOT NULL COMMENT '监测仪编号', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMddHHmmss', `ia` decimal(12,3) DEFAULT NULL COMMENT 'A相电流，单位：A安[培]', `ib` decimal(12,3) DEFAULT NULL COMMENT 'B相电流，单位：A安[培]', `ic` decimal(12,3) DEFAULT NULL COMMENT 'C相电流，单位：A安[培]', `ua` decimal(12,3) DEFAULT NULL COMMENT 'A相电压，单位：V伏[特]', `ub` decimal(12,3) DEFAULT NULL COMMENT 'B相电压，单位：V伏[特]', `uc` decimal(12,3) DEFAULT NULL COMMENT 'C相电压，单位：V伏[特]', `pa` decimal(12,4) DEFAULT NULL COMMENT '瞬时A相有功功率，kW千瓦', `pb` decimal(12,4) DEFAULT NULL COMMENT '瞬时B相有功功率，kW千瓦', `pc` decimal(12,4) DEFAULT NULL COMMENT '瞬时C相有功功率，kW千瓦', `p` decimal(12,4) DEFAULT NULL COMMENT '瞬时总有功功率，kW千瓦', `thea` decimal(12,3) DEFAULT NULL COMMENT 'A相功率因数，单位：无量纲', `theb` decimal(12,3) DEFAULT NULL COMMENT 'B相功率因数，单位：无量纲', `thec` decimal(12,3) DEFAULT NULL COMMENT 'C相功率因数，单位：无量纲', `the` decimal(12,3) DEFAULT NULL COMMENT '总功率因数，单位：无量纲', `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间yyyyMMddHHmmss', PRIMARY KEY (`terminal_id`,`upload_date`), KEY `indexes_upload_date` (`upload_date`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='电力实时表' /*!50100 PARTITION BY RANGE (upload_date) (PARTITION part01 VALUES LESS THAN (20220201235959) ENGINE = InnoDB, PARTITION part02 VALUES LESS THAN (20220202235959) ENGINE = InnoDB, PARTITION part03 VALUES LESS THAN (20220203235959) ENGINE = InnoDB, PARTITION part04 VALUES LESS THAN (20220204235959) ENGINE = InnoDB, PARTITION part05 VALUES LESS THAN (20220205235959) ENGINE = InnoDB, PARTITION part06 VALUES LESS THAN (20220206235959) ENGINE = InnoDB, PARTITION part07 VALUES LESS THAN (20220207235959) ENGINE = InnoDB, PARTITION part08 VALUES LESS THAN (20220208235959) ENGINE = InnoDB, PARTITION part09 VALUES LESS THAN (20220209235959) ENGINE = InnoDB, PARTITION part10 VALUES LESS THAN (20220210235959) ENGINE = InnoDB, PARTITION part11 VALUES LESS THAN (20220211235959) ENGINE = InnoDB, PARTITION part12 VALUES LESS THAN (20220212235959) ENGINE = InnoDB, PARTITION part13 VALUES LESS THAN (20220213235959) ENGINE = InnoDB, PARTITION part14 VALUES LESS THAN (20220214235959) ENGINE = InnoDB, PARTITION part15 VALUES LESS THAN (20220215235959) ENGINE = InnoDB, PARTITION part16 VALUES LESS THAN (20220216235959) ENGINE = InnoDB, PARTITION part17 VALUES LESS THAN (20220217235959) ENGINE = InnoDB, PARTITION part18 VALUES LESS THAN (20220218235959) ENGINE = InnoDB, PARTITION part19 VALUES LESS THAN (20220219235959) ENGINE = InnoDB, PARTITION part20 VALUES LESS THAN (20220220235959) ENGINE = InnoDB, PARTITION part21 VALUES LESS THAN (20220221235959) ENGINE = InnoDB, PARTITION part22 VALUES LESS THAN (20220222235959) ENGINE = InnoDB, PARTITION part23 VALUES LESS THAN (20220223235959) ENGINE = InnoDB, PARTITION part24 VALUES LESS THAN (20220224235959) ENGINE = InnoDB, PARTITION part25 VALUES LESS THAN (20220225235959) ENGINE = InnoDB, PARTITION part26 VALUES LESS THAN (20220226235959) ENGINE = InnoDB, PARTITION part27 VALUES LESS THAN (20220227235959) ENGINE = InnoDB, PARTITION part28 VALUES LESS THAN (20220228235959) ENGINE = InnoDB, PARTITION part29 VALUES LESS THAN (20220229235959) ENGINE = InnoDB, PARTITION part30 VALUES LESS THAN (20220230235959) ENGINE = InnoDB, PARTITION part31 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; -- ---------------------------- -- Table structure for online_data_electric_03 -- ---------------------------- DROP TABLE IF EXISTS `online_data_electric_03`; CREATE TABLE `online_data_electric_03` ( `terminal_id` varchar(30) NOT NULL COMMENT '监测仪编号', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMddHHmmss', `ia` decimal(12,3) DEFAULT NULL COMMENT 'A相电流，单位：A安[培]', `ib` decimal(12,3) DEFAULT NULL COMMENT 'B相电流，单位：A安[培]', `ic` decimal(12,3) DEFAULT NULL COMMENT 'C相电流，单位：A安[培]', `ua` decimal(12,3) DEFAULT NULL COMMENT 'A相电压，单位：V伏[特]', `ub` decimal(12,3) DEFAULT NULL COMMENT 'B相电压，单位：V伏[特]', `uc` decimal(12,3) DEFAULT NULL COMMENT 'C相电压，单位：V伏[特]', `pa` decimal(12,4) DEFAULT NULL COMMENT '瞬时A相有功功率，kW千瓦', `pb` decimal(12,4) DEFAULT NULL COMMENT '瞬时B相有功功率，kW千瓦', `pc` decimal(12,4) DEFAULT NULL COMMENT '瞬时C相有功功率，kW千瓦', `p` decimal(12,4) DEFAULT NULL COMMENT '瞬时总有功功率，kW千瓦', `thea` decimal(12,3) DEFAULT NULL COMMENT 'A相功率因数，单位：无量纲', `theb` decimal(12,3) DEFAULT NULL COMMENT 'B相功率因数，单位：无量纲', `thec` decimal(12,3) DEFAULT NULL COMMENT 'C相功率因数，单位：无量纲', `the` decimal(12,3) DEFAULT NULL COMMENT '总功率因数，单位：无量纲', `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间yyyyMMddHHmmss', PRIMARY KEY (`terminal_id`,`upload_date`), KEY `indexes_upload_date` (`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='电力实时表' /*!50100 PARTITION BY RANGE (upload_date) (PARTITION part01 VALUES LESS THAN (20220301235959) ENGINE = InnoDB, PARTITION part02 VALUES LESS THAN (20220302235959) ENGINE = InnoDB, PARTITION part03 VALUES LESS THAN (20220303235959) ENGINE = InnoDB, PARTITION part04 VALUES LESS THAN (20220304235959) ENGINE = InnoDB, PARTITION part05 VALUES LESS THAN (20220305235959) ENGINE = InnoDB, PARTITION part06 VALUES LESS THAN (20220306235959) ENGINE = InnoDB, PARTITION part07 VALUES LESS THAN (20220307235959) ENGINE = InnoDB, PARTITION part08 VALUES LESS THAN (20220308235959) ENGINE = InnoDB, PARTITION part09 VALUES LESS THAN (20220309235959) ENGINE = InnoDB, PARTITION part10 VALUES LESS THAN (20220310235959) ENGINE = InnoDB, PARTITION part11 VALUES LESS THAN (20220311235959) ENGINE = InnoDB, PARTITION part12 VALUES LESS THAN (20220312235959) ENGINE = InnoDB, PARTITION part13 VALUES LESS THAN (20220313235959) ENGINE = InnoDB, PARTITION part14 VALUES LESS THAN (20220314235959) ENGINE = InnoDB, PARTITION part15 VALUES LESS THAN (20220315235959) ENGINE = InnoDB, PARTITION part16 VALUES LESS THAN (20220316235959) ENGINE = InnoDB, PARTITION part17 VALUES LESS THAN (20220317235959) ENGINE = InnoDB, PARTITION part18 VALUES LESS THAN (20220318235959) ENGINE = InnoDB, PARTITION part19 VALUES LESS THAN (20220319235959) ENGINE = InnoDB, PARTITION part20 VALUES LESS THAN (20220320235959) ENGINE = InnoDB, PARTITION part21 VALUES LESS THAN (20220321235959) ENGINE = InnoDB, PARTITION part22 VALUES LESS THAN (20220322235959) ENGINE = InnoDB, PARTITION part23 VALUES LESS THAN (20220323235959) ENGINE = InnoDB, PARTITION part24 VALUES LESS THAN (20220324235959) ENGINE = InnoDB, PARTITION part25 VALUES LESS THAN (20220325235959) ENGINE = InnoDB, PARTITION part26 VALUES LESS THAN (20220326235959) ENGINE = InnoDB, PARTITION part27 VALUES LESS THAN (20220327235959) ENGINE = InnoDB, PARTITION part28 VALUES LESS THAN (20220328235959) ENGINE = InnoDB, PARTITION part29 VALUES LESS THAN (20220329235959) ENGINE = InnoDB, PARTITION part30 VALUES LESS THAN (20220330235959) ENGINE = InnoDB, PARTITION part31 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; -- ---------------------------- -- Table structure for online_data_electric_04 -- ---------------------------- DROP TABLE IF EXISTS `online_data_electric_04`; CREATE TABLE `online_data_electric_04` ( `terminal_id` varchar(30) NOT NULL COMMENT '监测仪编号', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMddHHmmss', `ia` decimal(12,3) DEFAULT NULL COMMENT 'A相电流，单位：A安[培]', `ib` decimal(12,3) DEFAULT NULL COMMENT 'B相电流，单位：A安[培]', `ic` decimal(12,3) DEFAULT NULL COMMENT 'C相电流，单位：A安[培]', `ua` decimal(12,3) DEFAULT NULL COMMENT 'A相电压，单位：V伏[特]', `ub` decimal(12,3) DEFAULT NULL COMMENT 'B相电压，单位：V伏[特]', `uc` decimal(12,3) DEFAULT NULL COMMENT 'C相电压，单位：V伏[特]', `pa` decimal(12,4) DEFAULT NULL COMMENT '瞬时A相有功功率，kW千瓦', `pb` decimal(12,4) DEFAULT NULL COMMENT '瞬时B相有功功率，kW千瓦', `pc` decimal(12,4) DEFAULT NULL COMMENT '瞬时C相有功功率，kW千瓦', `p` decimal(12,4) DEFAULT NULL COMMENT '瞬时总有功功率，kW千瓦', `thea` decimal(12,3) DEFAULT NULL COMMENT 'A相功率因数，单位：无量纲', `theb` decimal(12,3) DEFAULT NULL COMMENT 'B相功率因数，单位：无量纲', `thec` decimal(12,3) DEFAULT NULL COMMENT 'C相功率因数，单位：无量纲', `the` decimal(12,3) DEFAULT NULL COMMENT '总功率因数，单位：无量纲', `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间yyyyMMddHHmmss', PRIMARY KEY (`terminal_id`,`upload_date`), KEY `indexes_upload_date` (`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='电力实时表' /*!50100 PARTITION BY RANGE (upload_date) (PARTITION part01 VALUES LESS THAN (20220401235959) ENGINE = InnoDB, PARTITION part02 VALUES LESS THAN (20220402235959) ENGINE = InnoDB, PARTITION part03 VALUES LESS THAN (20220403235959) ENGINE = InnoDB, PARTITION part04 VALUES LESS THAN (20220404235959) ENGINE = InnoDB, PARTITION part05 VALUES LESS THAN (20220405235959) ENGINE = InnoDB, PARTITION part06 VALUES LESS THAN (20220406235959) ENGINE = InnoDB, PARTITION part07 VALUES LESS THAN (20220407235959) ENGINE = InnoDB, PARTITION part08 VALUES LESS THAN (20220408235959) ENGINE = InnoDB, PARTITION part09 VALUES LESS THAN (20220409235959) ENGINE = InnoDB, PARTITION part10 VALUES LESS THAN (20220410235959) ENGINE = InnoDB, PARTITION part11 VALUES LESS THAN (20220411235959) ENGINE = InnoDB, PARTITION part12 VALUES LESS THAN (20220412235959) ENGINE = InnoDB, PARTITION part13 VALUES LESS THAN (20220413235959) ENGINE = InnoDB, PARTITION part14 VALUES LESS THAN (20220414235959) ENGINE = InnoDB, PARTITION part15 VALUES LESS THAN (20220415235959) ENGINE = InnoDB, PARTITION part16 VALUES LESS THAN (20220416235959) ENGINE = InnoDB, PARTITION part17 VALUES LESS THAN (20220417235959) ENGINE = InnoDB, PARTITION part18 VALUES LESS THAN (20220418235959) ENGINE = InnoDB, PARTITION part19 VALUES LESS THAN (20220419235959) ENGINE = InnoDB, PARTITION part20 VALUES LESS THAN (20220420235959) ENGINE = InnoDB, PARTITION part21 VALUES LESS THAN (20220421235959) ENGINE = InnoDB, PARTITION part22 VALUES LESS THAN (20220422235959) ENGINE = InnoDB, PARTITION part23 VALUES LESS THAN (20220423235959) ENGINE = InnoDB, PARTITION part24 VALUES LESS THAN (20220424235959) ENGINE = InnoDB, PARTITION part25 VALUES LESS THAN (20220425235959) ENGINE = InnoDB, PARTITION part26 VALUES LESS THAN (20220426235959) ENGINE = InnoDB, PARTITION part27 VALUES LESS THAN (20220427235959) ENGINE = InnoDB, PARTITION part28 VALUES LESS THAN (20220428235959) ENGINE = InnoDB, PARTITION part29 VALUES LESS THAN (20220429235959) ENGINE = InnoDB, PARTITION part30 VALUES LESS THAN (20220430235959) ENGINE = InnoDB, PARTITION part31 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; -- ---------------------------- -- Table structure for online_data_electric_05 -- ---------------------------- DROP TABLE IF EXISTS `online_data_electric_05`; CREATE TABLE `online_data_electric_05` ( `terminal_id` varchar(30) NOT NULL COMMENT '监测仪编号', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMddHHmmss', `ia` decimal(12,3) DEFAULT NULL COMMENT 'A相电流，单位：A安[培]', `ib` decimal(12,3) DEFAULT NULL COMMENT 'B相电流，单位：A安[培]', `ic` decimal(12,3) DEFAULT NULL COMMENT 'C相电流，单位：A安[培]', `ua` decimal(12,3) DEFAULT NULL COMMENT 'A相电压，单位：V伏[特]', `ub` decimal(12,3) DEFAULT NULL COMMENT 'B相电压，单位：V伏[特]', `uc` decimal(12,3) DEFAULT NULL COMMENT 'C相电压，单位：V伏[特]', `pa` decimal(12,4) DEFAULT NULL COMMENT '瞬时A相有功功率，kW千瓦', `pb` decimal(12,4) DEFAULT NULL COMMENT '瞬时B相有功功率，kW千瓦', `pc` decimal(12,4) DEFAULT NULL COMMENT '瞬时C相有功功率，kW千瓦', `p` decimal(12,4) DEFAULT NULL COMMENT '瞬时总有功功率，kW千瓦', `thea` decimal(12,3) DEFAULT NULL COMMENT 'A相功率因数，单位：无量纲', `theb` decimal(12,3) DEFAULT NULL COMMENT 'B相功率因数，单位：无量纲', `thec` decimal(12,3) DEFAULT NULL COMMENT 'C相功率因数，单位：无量纲', `the` decimal(12,3) DEFAULT NULL COMMENT '总功率因数，单位：无量纲', `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间yyyyMMddHHmmss', PRIMARY KEY (`terminal_id`,`upload_date`), KEY `indexes_upload_date` (`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='电力实时表' /*!50100 PARTITION BY RANGE (upload_date) (PARTITION part01 VALUES LESS THAN (20220501235959) ENGINE = InnoDB, PARTITION part02 VALUES LESS THAN (20220502235959) ENGINE = InnoDB, PARTITION part03 VALUES LESS THAN (20220503235959) ENGINE = InnoDB, PARTITION part04 VALUES LESS THAN (20220504235959) ENGINE = InnoDB, PARTITION part05 VALUES LESS THAN (20220505235959) ENGINE = InnoDB, PARTITION part06 VALUES LESS THAN (20220506235959) ENGINE = InnoDB, PARTITION part07 VALUES LESS THAN (20220507235959) ENGINE = InnoDB, PARTITION part08 VALUES LESS THAN (20220508235959) ENGINE = InnoDB, PARTITION part09 VALUES LESS THAN (20220509235959) ENGINE = InnoDB, PARTITION part10 VALUES LESS THAN (20220510235959) ENGINE = InnoDB, PARTITION part11 VALUES LESS THAN (20220511235959) ENGINE = InnoDB, PARTITION part12 VALUES LESS THAN (20220512235959) ENGINE = InnoDB, PARTITION part13 VALUES LESS THAN (20220513235959) ENGINE = InnoDB, PARTITION part14 VALUES LESS THAN (20220514235959) ENGINE = InnoDB, PARTITION part15 VALUES LESS THAN (20220515235959) ENGINE = InnoDB, PARTITION part16 VALUES LESS THAN (20220516235959) ENGINE = InnoDB, PARTITION part17 VALUES LESS THAN (20220517235959) ENGINE = InnoDB, PARTITION part18 VALUES LESS THAN (20220518235959) ENGINE = InnoDB, PARTITION part19 VALUES LESS THAN (20220519235959) ENGINE = InnoDB, PARTITION part20 VALUES LESS THAN (20220520235959) ENGINE = InnoDB, PARTITION part21 VALUES LESS THAN (20220521235959) ENGINE = InnoDB, PARTITION part22 VALUES LESS THAN (20220522235959) ENGINE = InnoDB, PARTITION part23 VALUES LESS THAN (20220523235959) ENGINE = InnoDB, PARTITION part24 VALUES LESS THAN (20220524235959) ENGINE = InnoDB, PARTITION part25 VALUES LESS THAN (20220525235959) ENGINE = InnoDB, PARTITION part26 VALUES LESS THAN (20220526235959) ENGINE = InnoDB, PARTITION part27 VALUES LESS THAN (20220527235959) ENGINE = InnoDB, PARTITION part28 VALUES LESS THAN (20220528235959) ENGINE = InnoDB, PARTITION part29 VALUES LESS THAN (20220529235959) ENGINE = InnoDB, PARTITION part30 VALUES LESS THAN (20220530235959) ENGINE = InnoDB, PARTITION part31 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; -- ---------------------------- -- Table structure for online_data_electric_06 -- ---------------------------- DROP TABLE IF EXISTS `online_data_electric_06`; CREATE TABLE `online_data_electric_06` ( `terminal_id` varchar(30) NOT NULL COMMENT '监测仪编号', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMddHHmmss', `ia` decimal(12,3) DEFAULT NULL COMMENT 'A相电流，单位：A安[培]', `ib` decimal(12,3) DEFAULT NULL COMMENT 'B相电流，单位：A安[培]', `ic` decimal(12,3) DEFAULT NULL COMMENT 'C相电流，单位：A安[培]', `ua` decimal(12,3) DEFAULT NULL COMMENT 'A相电压，单位：V伏[特]', `ub` decimal(12,3) DEFAULT NULL COMMENT 'B相电压，单位：V伏[特]', `uc` decimal(12,3) DEFAULT NULL COMMENT 'C相电压，单位：V伏[特]', `pa` decimal(12,4) DEFAULT NULL COMMENT '瞬时A相有功功率，kW千瓦', `pb` decimal(12,4) DEFAULT NULL COMMENT '瞬时B相有功功率，kW千瓦', `pc` decimal(12,4) DEFAULT NULL COMMENT '瞬时C相有功功率，kW千瓦', `p` decimal(12,4) DEFAULT NULL COMMENT '瞬时总有功功率，kW千瓦', `thea` decimal(12,3) DEFAULT NULL COMMENT 'A相功率因数，单位：无量纲', `theb` decimal(12,3) DEFAULT NULL COMMENT 'B相功率因数，单位：无量纲', `thec` decimal(12,3) DEFAULT NULL COMMENT 'C相功率因数，单位：无量纲', `the` decimal(12,3) DEFAULT NULL COMMENT '总功率因数，单位：无量纲', `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间yyyyMMddHHmmss', PRIMARY KEY (`terminal_id`,`upload_date`), KEY `indexes_upload_date` (`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='电力实时表' /*!50100 PARTITION BY RANGE (upload_date) (PARTITION part01 VALUES LESS THAN (20220601235959) ENGINE = InnoDB, PARTITION part02 VALUES LESS THAN (20220602235959) ENGINE = InnoDB, PARTITION part03 VALUES LESS THAN (20220603235959) ENGINE = InnoDB, PARTITION part04 VALUES LESS THAN (20220604235959) ENGINE = InnoDB, PARTITION part05 VALUES LESS THAN (20220605235959) ENGINE = InnoDB, PARTITION part06 VALUES LESS THAN (20220606235959) ENGINE = InnoDB, PARTITION part07 VALUES LESS THAN (20220607235959) ENGINE = InnoDB, PARTITION part08 VALUES LESS THAN (20220608235959) ENGINE = InnoDB, PARTITION part09 VALUES LESS THAN (20220609235959) ENGINE = InnoDB, PARTITION part10 VALUES LESS THAN (20220610235959) ENGINE = InnoDB, PARTITION part11 VALUES LESS THAN (20220611235959) ENGINE = InnoDB, PARTITION part12 VALUES LESS THAN (20220612235959) ENGINE = InnoDB, PARTITION part13 VALUES LESS THAN (20220613235959) ENGINE = InnoDB, PARTITION part14 VALUES LESS THAN (20220614235959) ENGINE = InnoDB, PARTITION part15 VALUES LESS THAN (20220615235959) ENGINE = InnoDB, PARTITION part16 VALUES LESS THAN (20220616235959) ENGINE = InnoDB, PARTITION part17 VALUES LESS THAN (20220617235959) ENGINE = InnoDB, PARTITION part18 VALUES LESS THAN (20220618235959) ENGINE = InnoDB, PARTITION part19 VALUES LESS THAN (20220619235959) ENGINE = InnoDB, PARTITION part20 VALUES LESS THAN (20220620235959) ENGINE = InnoDB, PARTITION part21 VALUES LESS THAN (20220621235959) ENGINE = InnoDB, PARTITION part22 VALUES LESS THAN (20220622235959) ENGINE = InnoDB, PARTITION part23 VALUES LESS THAN (20220623235959) ENGINE = InnoDB, PARTITION part24 VALUES LESS THAN (20220624235959) ENGINE = InnoDB, PARTITION part25 VALUES LESS THAN (20220625235959) ENGINE = InnoDB, PARTITION part26 VALUES LESS THAN (20220626235959) ENGINE = InnoDB, PARTITION part27 VALUES LESS THAN (20220627235959) ENGINE = InnoDB, PARTITION part28 VALUES LESS THAN (20220628235959) ENGINE = InnoDB, PARTITION part29 VALUES LESS THAN (20220629235959) ENGINE = InnoDB, PARTITION part30 VALUES LESS THAN (20220630235959) ENGINE = InnoDB, PARTITION part31 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; -- ---------------------------- -- Table structure for online_data_electric_07 -- ---------------------------- DROP TABLE IF EXISTS `online_data_electric_07`; CREATE TABLE `online_data_electric_07` ( `terminal_id` varchar(30) NOT NULL COMMENT '监测仪编号', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMddHHmmss', `ia` decimal(12,3) DEFAULT NULL COMMENT 'A相电流，单位：A安[培]', `ib` decimal(12,3) DEFAULT NULL COMMENT 'B相电流，单位：A安[培]', `ic` decimal(12,3) DEFAULT NULL COMMENT 'C相电流，单位：A安[培]', `ua` decimal(12,3) DEFAULT NULL COMMENT 'A相电压，单位：V伏[特]', `ub` decimal(12,3) DEFAULT NULL COMMENT 'B相电压，单位：V伏[特]', `uc` decimal(12,3) DEFAULT NULL COMMENT 'C相电压，单位：V伏[特]', `pa` decimal(12,4) DEFAULT NULL COMMENT '瞬时A相有功功率，kW千瓦', `pb` decimal(12,4) DEFAULT NULL COMMENT '瞬时B相有功功率，kW千瓦', `pc` decimal(12,4) DEFAULT NULL COMMENT '瞬时C相有功功率，kW千瓦', `p` decimal(12,4) DEFAULT NULL COMMENT '瞬时总有功功率，kW千瓦', `thea` decimal(12,3) DEFAULT NULL COMMENT 'A相功率因数，单位：无量纲', `theb` decimal(12,3) DEFAULT NULL COMMENT 'B相功率因数，单位：无量纲', `thec` decimal(12,3) DEFAULT NULL COMMENT 'C相功率因数，单位：无量纲', `the` decimal(12,3) DEFAULT NULL COMMENT '总功率因数，单位：无量纲', `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间yyyyMMddHHmmss', PRIMARY KEY (`terminal_id`,`upload_date`), KEY `indexes_upload_date` (`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='电力实时表' /*!50100 PARTITION BY RANGE (upload_date) (PARTITION part01 VALUES LESS THAN (20220701235959) ENGINE = InnoDB, PARTITION part02 VALUES LESS THAN (20220702235959) ENGINE = InnoDB, PARTITION part03 VALUES LESS THAN (20220703235959) ENGINE = InnoDB, PARTITION part04 VALUES LESS THAN (20220704235959) ENGINE = InnoDB, PARTITION part05 VALUES LESS THAN (20220705235959) ENGINE = InnoDB, PARTITION part06 VALUES LESS THAN (20220706235959) ENGINE = InnoDB, PARTITION part07 VALUES LESS THAN (20220707235959) ENGINE = InnoDB, PARTITION part08 VALUES LESS THAN (20220708235959) ENGINE = InnoDB, PARTITION part09 VALUES LESS THAN (20220709235959) ENGINE = InnoDB, PARTITION part10 VALUES LESS THAN (20220710235959) ENGINE = InnoDB, PARTITION part11 VALUES LESS THAN (20220711235959) ENGINE = InnoDB, PARTITION part12 VALUES LESS THAN (20220712235959) ENGINE = InnoDB, PARTITION part13 VALUES LESS THAN (20220713235959) ENGINE = InnoDB, PARTITION part14 VALUES LESS THAN (20220714235959) ENGINE = InnoDB, PARTITION part15 VALUES LESS THAN (20220715235959) ENGINE = InnoDB, PARTITION part16 VALUES LESS THAN (20220716235959) ENGINE = InnoDB, PARTITION part17 VALUES LESS THAN (20220717235959) ENGINE = InnoDB, PARTITION part18 VALUES LESS THAN (20220718235959) ENGINE = InnoDB, PARTITION part19 VALUES LESS THAN (20220719235959) ENGINE = InnoDB, PARTITION part20 VALUES LESS THAN (20220720235959) ENGINE = InnoDB, PARTITION part21 VALUES LESS THAN (20220721235959) ENGINE = InnoDB, PARTITION part22 VALUES LESS THAN (20220722235959) ENGINE = InnoDB, PARTITION part23 VALUES LESS THAN (20220723235959) ENGINE = InnoDB, PARTITION part24 VALUES LESS THAN (20220724235959) ENGINE = InnoDB, PARTITION part25 VALUES LESS THAN (20220725235959) ENGINE = InnoDB, PARTITION part26 VALUES LESS THAN (20220726235959) ENGINE = InnoDB, PARTITION part27 VALUES LESS THAN (20220727235959) ENGINE = InnoDB, PARTITION part28 VALUES LESS THAN (20220728235959) ENGINE = InnoDB, PARTITION part29 VALUES LESS THAN (20220729235959) ENGINE = InnoDB, PARTITION part30 VALUES LESS THAN (20220730235959) ENGINE = InnoDB, PARTITION part31 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; -- ---------------------------- -- Table structure for online_data_electric_08 -- ---------------------------- DROP TABLE IF EXISTS `online_data_electric_08`; CREATE TABLE `online_data_electric_08` ( `terminal_id` varchar(30) NOT NULL COMMENT '监测仪编号', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMddHHmmss', `ia` decimal(12,3) DEFAULT NULL COMMENT 'A相电流，单位：A安[培]', `ib` decimal(12,3) DEFAULT NULL COMMENT 'B相电流，单位：A安[培]', `ic` decimal(12,3) DEFAULT NULL COMMENT 'C相电流，单位：A安[培]', `ua` decimal(12,3) DEFAULT NULL COMMENT 'A相电压，单位：V伏[特]', `ub` decimal(12,3) DEFAULT NULL COMMENT 'B相电压，单位：V伏[特]', `uc` decimal(12,3) DEFAULT NULL COMMENT 'C相电压，单位：V伏[特]', `pa` decimal(12,4) DEFAULT NULL COMMENT '瞬时A相有功功率，kW千瓦', `pb` decimal(12,4) DEFAULT NULL COMMENT '瞬时B相有功功率，kW千瓦', `pc` decimal(12,4) DEFAULT NULL COMMENT '瞬时C相有功功率，kW千瓦', `p` decimal(12,4) DEFAULT NULL COMMENT '瞬时总有功功率，kW千瓦', `thea` decimal(12,3) DEFAULT NULL COMMENT 'A相功率因数，单位：无量纲', `theb` decimal(12,3) DEFAULT NULL COMMENT 'B相功率因数，单位：无量纲', `thec` decimal(12,3) DEFAULT NULL COMMENT 'C相功率因数，单位：无量纲', `the` decimal(12,3) DEFAULT NULL COMMENT '总功率因数，单位：无量纲', `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间yyyyMMddHHmmss', PRIMARY KEY (`terminal_id`,`upload_date`), KEY `indexes_upload_date` (`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='电力实时表' /*!50100 PARTITION BY RANGE (upload_date) (PARTITION part01 VALUES LESS THAN (20220801235959) ENGINE = InnoDB, PARTITION part02 VALUES LESS THAN (20220802235959) ENGINE = InnoDB, PARTITION part03 VALUES LESS THAN (20220803235959) ENGINE = InnoDB, PARTITION part04 VALUES LESS THAN (20220804235959) ENGINE = InnoDB, PARTITION part05 VALUES LESS THAN (20220805235959) ENGINE = InnoDB, PARTITION part06 VALUES LESS THAN (20220806235959) ENGINE = InnoDB, PARTITION part07 VALUES LESS THAN (20220807235959) ENGINE = InnoDB, PARTITION part08 VALUES LESS THAN (20220808235959) ENGINE = InnoDB, PARTITION part09 VALUES LESS THAN (20220809235959) ENGINE = InnoDB, PARTITION part10 VALUES LESS THAN (20220810235959) ENGINE = InnoDB, PARTITION part11 VALUES LESS THAN (20220811235959) ENGINE = InnoDB, PARTITION part12 VALUES LESS THAN (20220812235959) ENGINE = InnoDB, PARTITION part13 VALUES LESS THAN (20220813235959) ENGINE = InnoDB, PARTITION part14 VALUES LESS THAN (20220814235959) ENGINE = InnoDB, PARTITION part15 VALUES LESS THAN (20220815235959) ENGINE = InnoDB, PARTITION part16 VALUES LESS THAN (20220816235959) ENGINE = InnoDB, PARTITION part17 VALUES LESS THAN (20220817235959) ENGINE = InnoDB, PARTITION part18 VALUES LESS THAN (20220818235959) ENGINE = InnoDB, PARTITION part19 VALUES LESS THAN (20220819235959) ENGINE = InnoDB, PARTITION part20 VALUES LESS THAN (20220820235959) ENGINE = InnoDB, PARTITION part21 VALUES LESS THAN (20220821235959) ENGINE = InnoDB, PARTITION part22 VALUES LESS THAN (20220822235959) ENGINE = InnoDB, PARTITION part23 VALUES LESS THAN (20220823235959) ENGINE = InnoDB, PARTITION part24 VALUES LESS THAN (20220824235959) ENGINE = InnoDB, PARTITION part25 VALUES LESS THAN (20220825235959) ENGINE = InnoDB, PARTITION part26 VALUES LESS THAN (20220826235959) ENGINE = InnoDB, PARTITION part27 VALUES LESS THAN (20220827235959) ENGINE = InnoDB, PARTITION part28 VALUES LESS THAN (20220828235959) ENGINE = InnoDB, PARTITION part29 VALUES LESS THAN (20220829235959) ENGINE = InnoDB, PARTITION part30 VALUES LESS THAN (20220830235959) ENGINE = InnoDB, PARTITION part31 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; -- ---------------------------- -- Table structure for online_data_electric_09 -- ---------------------------- DROP TABLE IF EXISTS `online_data_electric_09`; CREATE TABLE `online_data_electric_09` ( `terminal_id` varchar(30) NOT NULL COMMENT '监测仪编号', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMddHHmmss', `ia` decimal(12,3) DEFAULT NULL COMMENT 'A相电流，单位：A安[培]', `ib` decimal(12,3) DEFAULT NULL COMMENT 'B相电流，单位：A安[培]', `ic` decimal(12,3) DEFAULT NULL COMMENT 'C相电流，单位：A安[培]', `ua` decimal(12,3) DEFAULT NULL COMMENT 'A相电压，单位：V伏[特]', `ub` decimal(12,3) DEFAULT NULL COMMENT 'B相电压，单位：V伏[特]', `uc` decimal(12,3) DEFAULT NULL COMMENT 'C相电压，单位：V伏[特]', `pa` decimal(12,4) DEFAULT NULL COMMENT '瞬时A相有功功率，kW千瓦', `pb` decimal(12,4) DEFAULT NULL COMMENT '瞬时B相有功功率，kW千瓦', `pc` decimal(12,4) DEFAULT NULL COMMENT '瞬时C相有功功率，kW千瓦', `p` decimal(12,4) DEFAULT NULL COMMENT '瞬时总有功功率，kW千瓦', `thea` decimal(12,3) DEFAULT NULL COMMENT 'A相功率因数，单位：无量纲', `theb` decimal(12,3) DEFAULT NULL COMMENT 'B相功率因数，单位：无量纲', `thec` decimal(12,3) DEFAULT NULL COMMENT 'C相功率因数，单位：无量纲', `the` decimal(12,3) DEFAULT NULL COMMENT '总功率因数，单位：无量纲', `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间yyyyMMddHHmmss', PRIMARY KEY (`terminal_id`,`upload_date`), KEY `indexes_upload_date` (`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='电力实时表' /*!50100 PARTITION BY RANGE (upload_date) (PARTITION part01 VALUES LESS THAN (20220901235959) ENGINE = InnoDB, PARTITION part02 VALUES LESS THAN (20220902235959) ENGINE = InnoDB, PARTITION part03 VALUES LESS THAN (20220903235959) ENGINE = InnoDB, PARTITION part04 VALUES LESS THAN (20220904235959) ENGINE = InnoDB, PARTITION part05 VALUES LESS THAN (20220905235959) ENGINE = InnoDB, PARTITION part06 VALUES LESS THAN (20220906235959) ENGINE = InnoDB, PARTITION part07 VALUES LESS THAN (20220907235959) ENGINE = InnoDB, PARTITION part08 VALUES LESS THAN (20220908235959) ENGINE = InnoDB, PARTITION part09 VALUES LESS THAN (20220909235959) ENGINE = InnoDB, PARTITION part10 VALUES LESS THAN (20220910235959) ENGINE = InnoDB, PARTITION part11 VALUES LESS THAN (20220911235959) ENGINE = InnoDB, PARTITION part12 VALUES LESS THAN (20220912235959) ENGINE = InnoDB, PARTITION part13 VALUES LESS THAN (20220913235959) ENGINE = InnoDB, PARTITION part14 VALUES LESS THAN (20220914235959) ENGINE = InnoDB, PARTITION part15 VALUES LESS THAN (20220915235959) ENGINE = InnoDB, PARTITION part16 VALUES LESS THAN (20220916235959) ENGINE = InnoDB, PARTITION part17 VALUES LESS THAN (20220917235959) ENGINE = InnoDB, PARTITION part18 VALUES LESS THAN (20220918235959) ENGINE = InnoDB, PARTITION part19 VALUES LESS THAN (20220919235959) ENGINE = InnoDB, PARTITION part20 VALUES LESS THAN (20220920235959) ENGINE = InnoDB, PARTITION part21 VALUES LESS THAN (20220921235959) ENGINE = InnoDB, PARTITION part22 VALUES LESS THAN (20220922235959) ENGINE = InnoDB, PARTITION part23 VALUES LESS THAN (20220923235959) ENGINE = InnoDB, PARTITION part24 VALUES LESS THAN (20220924235959) ENGINE = InnoDB, PARTITION part25 VALUES LESS THAN (20220925235959) ENGINE = InnoDB, PARTITION part26 VALUES LESS THAN (20220926235959) ENGINE = InnoDB, PARTITION part27 VALUES LESS THAN (20220927235959) ENGINE = InnoDB, PARTITION part28 VALUES LESS THAN (20220928235959) ENGINE = InnoDB, PARTITION part29 VALUES LESS THAN (20220929235959) ENGINE = InnoDB, PARTITION part30 VALUES LESS THAN (20220930235959) ENGINE = InnoDB, PARTITION part31 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; -- ---------------------------- -- Table structure for online_data_electric_10 -- ---------------------------- DROP TABLE IF EXISTS `online_data_electric_10`; CREATE TABLE `online_data_electric_10` ( `terminal_id` varchar(30) NOT NULL COMMENT '监测仪编号', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMddHHmmss', `ia` decimal(12,3) DEFAULT NULL COMMENT 'A相电流，单位：A安[培]', `ib` decimal(12,3) DEFAULT NULL COMMENT 'B相电流，单位：A安[培]', `ic` decimal(12,3) DEFAULT NULL COMMENT 'C相电流，单位：A安[培]', `ua` decimal(12,3) DEFAULT NULL COMMENT 'A相电压，单位：V伏[特]', `ub` decimal(12,3) DEFAULT NULL COMMENT 'B相电压，单位：V伏[特]', `uc` decimal(12,3) DEFAULT NULL COMMENT 'C相电压，单位：V伏[特]', `pa` decimal(12,4) DEFAULT NULL COMMENT '瞬时A相有功功率，kW千瓦', `pb` decimal(12,4) DEFAULT NULL COMMENT '瞬时B相有功功率，kW千瓦', `pc` decimal(12,4) DEFAULT NULL COMMENT '瞬时C相有功功率，kW千瓦', `p` decimal(12,4) DEFAULT NULL COMMENT '瞬时总有功功率，kW千瓦', `thea` decimal(12,3) DEFAULT NULL COMMENT 'A相功率因数，单位：无量纲', `theb` decimal(12,3) DEFAULT NULL COMMENT 'B相功率因数，单位：无量纲', `thec` decimal(12,3) DEFAULT NULL COMMENT 'C相功率因数，单位：无量纲', `the` decimal(12,3) DEFAULT NULL COMMENT '总功率因数，单位：无量纲', `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间yyyyMMddHHmmss', PRIMARY KEY (`terminal_id`,`upload_date`), KEY `indexes_upload_date` (`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='电力实时表' /*!50100 PARTITION BY RANGE (upload_date) (PARTITION part01 VALUES LESS THAN (20221001235959) ENGINE = InnoDB, PARTITION part02 VALUES LESS THAN (20221002235959) ENGINE = InnoDB, PARTITION part03 VALUES LESS THAN (20221003235959) ENGINE = InnoDB, PARTITION part04 VALUES LESS THAN (20221004235959) ENGINE = InnoDB, PARTITION part05 VALUES LESS THAN (20221005235959) ENGINE = InnoDB, PARTITION part06 VALUES LESS THAN (20221006235959) ENGINE = InnoDB, PARTITION part07 VALUES LESS THAN (20221007235959) ENGINE = InnoDB, PARTITION part08 VALUES LESS THAN (20221008235959) ENGINE = InnoDB, PARTITION part09 VALUES LESS THAN (20221009235959) ENGINE = InnoDB, PARTITION part10 VALUES LESS THAN (20221010235959) ENGINE = InnoDB, PARTITION part11 VALUES LESS THAN (20221011235959) ENGINE = InnoDB, PARTITION part12 VALUES LESS THAN (20221012235959) ENGINE = InnoDB, PARTITION part13 VALUES LESS THAN (20221013235959) ENGINE = InnoDB, PARTITION part14 VALUES LESS THAN (20221014235959) ENGINE = InnoDB, PARTITION part15 VALUES LESS THAN (20221015235959) ENGINE = InnoDB, PARTITION part16 VALUES LESS THAN (20221016235959) ENGINE = InnoDB, PARTITION part17 VALUES LESS THAN (20221017235959) ENGINE = InnoDB, PARTITION part18 VALUES LESS THAN (20221018235959) ENGINE = InnoDB, PARTITION part19 VALUES LESS THAN (20221019235959) ENGINE = InnoDB, PARTITION part20 VALUES LESS THAN (20221020235959) ENGINE = InnoDB, PARTITION part21 VALUES LESS THAN (20221021235959) ENGINE = InnoDB, PARTITION part22 VALUES LESS THAN (20221022235959) ENGINE = InnoDB, PARTITION part23 VALUES LESS THAN (20221023235959) ENGINE = InnoDB, PARTITION part24 VALUES LESS THAN (20221024235959) ENGINE = InnoDB, PARTITION part25 VALUES LESS THAN (20221025235959) ENGINE = InnoDB, PARTITION part26 VALUES LESS THAN (20221026235959) ENGINE = InnoDB, PARTITION part27 VALUES LESS THAN (20221027235959) ENGINE = InnoDB, PARTITION part28 VALUES LESS THAN (20221028235959) ENGINE = InnoDB, PARTITION part29 VALUES LESS THAN (20221029235959) ENGINE = InnoDB, PARTITION part30 VALUES LESS THAN (20221030235959) ENGINE = InnoDB, PARTITION part31 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; -- ---------------------------- -- Table structure for online_data_electric_11 -- ---------------------------- DROP TABLE IF EXISTS `online_data_electric_11`; CREATE TABLE `online_data_electric_11` ( `terminal_id` varchar(30) NOT NULL COMMENT '监测仪编号', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMddHHmmss', `ia` decimal(12,3) DEFAULT NULL COMMENT 'A相电流，单位：A安[培]', `ib` decimal(12,3) DEFAULT NULL COMMENT 'B相电流，单位：A安[培]', `ic` decimal(12,3) DEFAULT NULL COMMENT 'C相电流，单位：A安[培]', `ua` decimal(12,3) DEFAULT NULL COMMENT 'A相电压，单位：V伏[特]', `ub` decimal(12,3) DEFAULT NULL COMMENT 'B相电压，单位：V伏[特]', `uc` decimal(12,3) DEFAULT NULL COMMENT 'C相电压，单位：V伏[特]', `pa` decimal(12,4) DEFAULT NULL COMMENT '瞬时A相有功功率，kW千瓦', `pb` decimal(12,4) DEFAULT NULL COMMENT '瞬时B相有功功率，kW千瓦', `pc` decimal(12,4) DEFAULT NULL COMMENT '瞬时C相有功功率，kW千瓦', `p` decimal(12,4) DEFAULT NULL COMMENT '瞬时总有功功率，kW千瓦', `thea` decimal(12,3) DEFAULT NULL COMMENT 'A相功率因数，单位：无量纲', `theb` decimal(12,3) DEFAULT NULL COMMENT 'B相功率因数，单位：无量纲', `thec` decimal(12,3) DEFAULT NULL COMMENT 'C相功率因数，单位：无量纲', `the` decimal(12,3) DEFAULT NULL COMMENT '总功率因数，单位：无量纲', `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间yyyyMMddHHmmss', PRIMARY KEY (`terminal_id`,`upload_date`), KEY `indexes_upload_date` (`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='电力实时表' /*!50100 PARTITION BY RANGE (upload_date) (PARTITION part01 VALUES LESS THAN (20221101235959) ENGINE = InnoDB, PARTITION part02 VALUES LESS THAN (20221102235959) ENGINE = InnoDB, PARTITION part03 VALUES LESS THAN (20221103235959) ENGINE = InnoDB, PARTITION part04 VALUES LESS THAN (20221104235959) ENGINE = InnoDB, PARTITION part05 VALUES LESS THAN (20221105235959) ENGINE = InnoDB, PARTITION part06 VALUES LESS THAN (20221106235959) ENGINE = InnoDB, PARTITION part07 VALUES LESS THAN (20221107235959) ENGINE = InnoDB, PARTITION part08 VALUES LESS THAN (20221108235959) ENGINE = InnoDB, PARTITION part09 VALUES LESS THAN (20221109235959) ENGINE = InnoDB, PARTITION part10 VALUES LESS THAN (20221110235959) ENGINE = InnoDB, PARTITION part11 VALUES LESS THAN (20221111235959) ENGINE = InnoDB, PARTITION part12 VALUES LESS THAN (20221112235959) ENGINE = InnoDB, PARTITION part13 VALUES LESS THAN (20221113235959) ENGINE = InnoDB, PARTITION part14 VALUES LESS THAN (20221114235959) ENGINE = InnoDB, PARTITION part15 VALUES LESS THAN (20221115235959) ENGINE = InnoDB, PARTITION part16 VALUES LESS THAN (20221116235959) ENGINE = InnoDB, PARTITION part17 VALUES LESS THAN (20221117235959) ENGINE = InnoDB, PARTITION part18 VALUES LESS THAN (20221118235959) ENGINE = InnoDB, PARTITION part19 VALUES LESS THAN (20221119235959) ENGINE = InnoDB, PARTITION part20 VALUES LESS THAN (20221120235959) ENGINE = InnoDB, PARTITION part21 VALUES LESS THAN (20221121235959) ENGINE = InnoDB, PARTITION part22 VALUES LESS THAN (20221122235959) ENGINE = InnoDB, PARTITION part23 VALUES LESS THAN (20221123235959) ENGINE = InnoDB, PARTITION part24 VALUES LESS THAN (20221124235959) ENGINE = InnoDB, PARTITION part25 VALUES LESS THAN (20221125235959) ENGINE = InnoDB, PARTITION part26 VALUES LESS THAN (20221126235959) ENGINE = InnoDB, PARTITION part27 VALUES LESS THAN (20221127235959) ENGINE = InnoDB, PARTITION part28 VALUES LESS THAN (20221128235959) ENGINE = InnoDB, PARTITION part29 VALUES LESS THAN (20221129235959) ENGINE = InnoDB, PARTITION part30 VALUES LESS THAN (20221130235959) ENGINE = InnoDB, PARTITION part31 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; -- ---------------------------- -- Table structure for online_data_electric_12 -- ---------------------------- DROP TABLE IF EXISTS `online_data_electric_12`; CREATE TABLE `online_data_electric_12` ( `terminal_id` varchar(30) NOT NULL COMMENT '监测仪编号', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMddHHmmss', `ia` decimal(12,3) DEFAULT NULL COMMENT 'A相电流，单位：A安[培]', `ib` decimal(12,3) DEFAULT NULL COMMENT 'B相电流，单位：A安[培]', `ic` decimal(12,3) DEFAULT NULL COMMENT 'C相电流，单位：A安[培]', `ua` decimal(12,3) DEFAULT NULL COMMENT 'A相电压，单位：V伏[特]', `ub` decimal(12,3) DEFAULT NULL COMMENT 'B相电压，单位：V伏[特]', `uc` decimal(12,3) DEFAULT NULL COMMENT 'C相电压，单位：V伏[特]', `pa` decimal(12,4) DEFAULT NULL COMMENT '瞬时A相有功功率，kW千瓦', `pb` decimal(12,4) DEFAULT NULL COMMENT '瞬时B相有功功率，kW千瓦', `pc` decimal(12,4) DEFAULT NULL COMMENT '瞬时C相有功功率，kW千瓦', `p` decimal(12,4) DEFAULT NULL COMMENT '瞬时总有功功率，kW千瓦', `thea` decimal(12,3) DEFAULT NULL COMMENT 'A相功率因数，单位：无量纲', `theb` decimal(12,3) DEFAULT NULL COMMENT 'B相功率因数，单位：无量纲', `thec` decimal(12,3) DEFAULT NULL COMMENT 'C相功率因数，单位：无量纲', `the` decimal(12,3) DEFAULT NULL COMMENT '总功率因数，单位：无量纲', `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间yyyyMMddHHmmss', PRIMARY KEY (`terminal_id`,`upload_date`), KEY `indexes_upload_date` (`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='电力实时表' /*!50100 PARTITION BY RANGE (upload_date) (PARTITION part01 VALUES LESS THAN (20221201235959) ENGINE = InnoDB, PARTITION part02 VALUES LESS THAN (20221202235959) ENGINE = InnoDB, PARTITION part03 VALUES LESS THAN (20221203235959) ENGINE = InnoDB, PARTITION part04 VALUES LESS THAN (20221204235959) ENGINE = InnoDB, PARTITION part05 VALUES LESS THAN (20221205235959) ENGINE = InnoDB, PARTITION part06 VALUES LESS THAN (20221206235959) ENGINE = InnoDB, PARTITION part07 VALUES LESS THAN (20221207235959) ENGINE = InnoDB, PARTITION part08 VALUES LESS THAN (20221208235959) ENGINE = InnoDB, PARTITION part09 VALUES LESS THAN (20221209235959) ENGINE = InnoDB, PARTITION part10 VALUES LESS THAN (20221210235959) ENGINE = InnoDB, PARTITION part11 VALUES LESS THAN (20221211235959) ENGINE = InnoDB, PARTITION part12 VALUES LESS THAN (20221212235959) ENGINE = InnoDB, PARTITION part13 VALUES LESS THAN (20221213235959) ENGINE = InnoDB, PARTITION part14 VALUES LESS THAN (20221214235959) ENGINE = InnoDB, PARTITION part15 VALUES LESS THAN (20221215235959) ENGINE = InnoDB, PARTITION part16 VALUES LESS THAN (20221216235959) ENGINE = InnoDB, PARTITION part17 VALUES LESS THAN (20221217235959) ENGINE = InnoDB, PARTITION part18 VALUES LESS THAN (20221218235959) ENGINE = InnoDB, PARTITION part19 VALUES LESS THAN (20221219235959) ENGINE = InnoDB, PARTITION part20 VALUES LESS THAN (20221220235959) ENGINE = InnoDB, PARTITION part21 VALUES LESS THAN (20221221235959) ENGINE = InnoDB, PARTITION part22 VALUES LESS THAN (20221222235959) ENGINE = InnoDB, PARTITION part23 VALUES LESS THAN (20221223235959) ENGINE = InnoDB, PARTITION part24 VALUES LESS THAN (20221224235959) ENGINE = InnoDB, PARTITION part25 VALUES LESS THAN (20221225235959) ENGINE = InnoDB, PARTITION part26 VALUES LESS THAN (20221226235959) ENGINE = InnoDB, PARTITION part27 VALUES LESS THAN (20221227235959) ENGINE = InnoDB, PARTITION part28 VALUES LESS THAN (20221228235959) ENGINE = InnoDB, PARTITION part29 VALUES LESS THAN (20221229235959) ENGINE = InnoDB, PARTITION part30 VALUES LESS THAN (20221230235959) ENGINE = InnoDB, PARTITION part31 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; -- ---------------------------- -- Table structure for online_data_electric_company -- ---------------------------- DROP TABLE IF EXISTS `online_data_electric_company`; CREATE TABLE `online_data_electric_company` ( `company_id` int(11) NOT NULL COMMENT '企业id', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMddHHmmss', `ia` decimal(12,3) DEFAULT NULL COMMENT 'A相电流，单位：A安[培]', `ib` decimal(12,3) DEFAULT NULL COMMENT 'B相电流，单位：A安[培]', `ic` decimal(12,3) DEFAULT NULL COMMENT 'C相电流，单位：A安[培]', `ua` decimal(12,3) DEFAULT NULL COMMENT 'A相电压，单位：V伏[特]', `ub` decimal(12,3) DEFAULT NULL COMMENT 'B相电压，单位：V伏[特]', `uc` decimal(12,3) DEFAULT NULL COMMENT 'C相电压，单位：V伏[特]', `pa` decimal(12,4) DEFAULT NULL COMMENT '瞬时A相有功功率，kW千瓦', `pb` decimal(12,4) DEFAULT NULL COMMENT '瞬时B相有功功率，kW千瓦', `pc` decimal(12,4) DEFAULT NULL COMMENT '瞬时C相有功功率，kW千瓦', `p` decimal(12,4) DEFAULT NULL COMMENT '瞬时总有功功率，kW千瓦', `thea` decimal(12,3) DEFAULT NULL COMMENT 'A相功率因数，单位：无量纲', `theb` decimal(12,3) DEFAULT NULL COMMENT 'B相功率因数，单位：无量纲', `thec` decimal(12,3) DEFAULT NULL COMMENT 'C相功率因数，单位：无量纲', `the` decimal(12,3) DEFAULT NULL COMMENT '总功率因数，单位：无量纲', `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间yyyyMMddHHmmss', PRIMARY KEY (`company_id`,`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='电力实时表' /*!50100 PARTITION BY RANGE (upload_date) (PARTITION part01 VALUES LESS THAN (20220131235959) ENGINE = InnoDB, PARTITION part02 VALUES LESS THAN (20220231235959) ENGINE = InnoDB, PARTITION part03 VALUES LESS THAN (20220331235959) ENGINE = InnoDB, PARTITION part04 VALUES LESS THAN (20220431235959) ENGINE = InnoDB, PARTITION part05 VALUES LESS THAN (20220531235959) ENGINE = InnoDB, PARTITION part06 VALUES LESS THAN (20220631235959) ENGINE = InnoDB, PARTITION part07 VALUES LESS THAN (20220731235959) ENGINE = InnoDB, PARTITION part08 VALUES LESS THAN (20220831235959) ENGINE = InnoDB, PARTITION part09 VALUES LESS THAN (20220931235959) ENGINE = InnoDB, PARTITION part10 VALUES LESS THAN (20221031235959) ENGINE = InnoDB, PARTITION part11 VALUES LESS THAN (20221131235959) ENGINE = InnoDB, PARTITION part12 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; -- ---------------------------- -- Table structure for online_data_electric_org -- ---------------------------- DROP TABLE IF EXISTS `online_data_electric_org`; CREATE TABLE `online_data_electric_org` ( `org_id` int(11) NOT NULL COMMENT '机构id', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMddHHmmss', `ia` decimal(12,3) DEFAULT NULL COMMENT 'A相电流，单位：A安[培]', `ib` decimal(12,3) DEFAULT NULL COMMENT 'B相电流，单位：A安[培]', `ic` decimal(12,3) DEFAULT NULL COMMENT 'C相电流，单位：A安[培]', `ua` decimal(12,3) DEFAULT NULL COMMENT 'A相电压，单位：V伏[特]', `ub` decimal(12,3) DEFAULT NULL COMMENT 'B相电压，单位：V伏[特]', `uc` decimal(12,3) DEFAULT NULL COMMENT 'C相电压，单位：V伏[特]', `pa` decimal(12,4) DEFAULT NULL COMMENT '瞬时A相有功功率，kW千瓦', `pb` decimal(12,4) DEFAULT NULL COMMENT '瞬时B相有功功率，kW千瓦', `pc` decimal(12,4) DEFAULT NULL COMMENT '瞬时C相有功功率，kW千瓦', `p` decimal(12,4) DEFAULT NULL COMMENT '瞬时总有功功率，kW千瓦', `thea` decimal(12,3) DEFAULT NULL COMMENT 'A相功率因数，单位：无量纲', `theb` decimal(12,3) DEFAULT NULL COMMENT 'B相功率因数，单位：无量纲', `thec` decimal(12,3) DEFAULT NULL COMMENT 'C相功率因数，单位：无量纲', `the` decimal(12,3) DEFAULT NULL COMMENT '总功率因数，单位：无量纲', `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间yyyyMMddHHmmss', PRIMARY KEY (`org_id`,`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='电力实时表' /*!50100 PARTITION BY RANGE (upload_date) (PARTITION part01 VALUES LESS THAN (20220131235959) ENGINE = InnoDB, PARTITION part02 VALUES LESS THAN (20220231235959) ENGINE = InnoDB, PARTITION part03 VALUES LESS THAN (20220331235959) ENGINE = InnoDB, PARTITION part04 VALUES LESS THAN (20220431235959) ENGINE = InnoDB, PARTITION part05 VALUES LESS THAN (20220531235959) ENGINE = InnoDB, PARTITION part06 VALUES LESS THAN (20220631235959) ENGINE = InnoDB, PARTITION part07 VALUES LESS THAN (20220731235959) ENGINE = InnoDB, PARTITION part08 VALUES LESS THAN (20220831235959) ENGINE = InnoDB, PARTITION part09 VALUES LESS THAN (20220931235959) ENGINE = InnoDB, PARTITION part10 VALUES LESS THAN (20221031235959) ENGINE = InnoDB, PARTITION part11 VALUES LESS THAN (20221131235959) ENGINE = InnoDB, PARTITION part12 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; -- ---------------------------- -- Table structure for online_data_lampblack_01 -- ---------------------------- DROP TABLE IF EXISTS `online_data_lampblack_01`; CREATE TABLE `online_data_lampblack_01` ( `terminal_id` varchar(30) NOT NULL COMMENT '监测仪编号', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMddHHmmss', `flue_temp` decimal(8,3) DEFAULT NULL COMMENT '烟道温度(通道0)，单位：℃', `flue_humidity` decimal(8,3) DEFAULT NULL COMMENT '烟道湿度(通道0)，单位：RH', `smoke_density` decimal(8,3) DEFAULT NULL COMMENT '烟雾浓度(通道0)，单位：ppm', `voc_density` decimal(8,3) DEFAULT NULL COMMENT 'VOC浓度(通道0)，单位：ppm', `pm25` decimal(8,3) DEFAULT NULL COMMENT 'pm25', `latitude` varchar(20) DEFAULT NULL COMMENT '纬度，单位度', `longitude` varchar(20) DEFAULT NULL COMMENT '经度，单位度', `smoke_total` decimal(8,3) DEFAULT NULL COMMENT '烟雾浓度排放总量，单位克', `voc_total` decimal(8,3) DEFAULT NULL COMMENT 'VOC浓度排放总量，单位克', `pm25_total` decimal(8,3) DEFAULT NULL COMMENT 'pm25排放总量，单位克', `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间yyyyMMddHHmmss', PRIMARY KEY (`terminal_id`,`upload_date`), KEY `indexes_upload_date` (`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='油烟实时表' /*!50100 PARTITION BY RANGE (upload_date) (PARTITION part01 VALUES LESS THAN (20220101235959) ENGINE = InnoDB, PARTITION part02 VALUES LESS THAN (20220102235959) ENGINE = InnoDB, PARTITION part03 VALUES LESS THAN (20220103235959) ENGINE = InnoDB, PARTITION part04 VALUES LESS THAN (20220104235959) ENGINE = InnoDB, PARTITION part05 VALUES LESS THAN (20220105235959) ENGINE = InnoDB, PARTITION part06 VALUES LESS THAN (20220106235959) ENGINE = InnoDB, PARTITION part07 VALUES LESS THAN (20220107235959) ENGINE = InnoDB, PARTITION part08 VALUES LESS THAN (20220108235959) ENGINE = InnoDB, PARTITION part09 VALUES LESS THAN (20220109235959) ENGINE = InnoDB, PARTITION part10 VALUES LESS THAN (20220110235959) ENGINE = InnoDB, PARTITION part11 VALUES LESS THAN (20220111235959) ENGINE = InnoDB, PARTITION part12 VALUES LESS THAN (20220112235959) ENGINE = InnoDB, PARTITION part13 VALUES LESS THAN (20220113235959) ENGINE = InnoDB, PARTITION part14 VALUES LESS THAN (20220114235959) ENGINE = InnoDB, PARTITION part15 VALUES LESS THAN (20220115235959) ENGINE = InnoDB, PARTITION part16 VALUES LESS THAN (20220116235959) ENGINE = InnoDB, PARTITION part17 VALUES LESS THAN (20220117235959) ENGINE = InnoDB, PARTITION part18 VALUES LESS THAN (20220118235959) ENGINE = InnoDB, PARTITION part19 VALUES LESS THAN (20220119235959) ENGINE = InnoDB, PARTITION part20 VALUES LESS THAN (20220120235959) ENGINE = InnoDB, PARTITION part21 VALUES LESS THAN (20220121235959) ENGINE = InnoDB, PARTITION part22 VALUES LESS THAN (20220122235959) ENGINE = InnoDB, PARTITION part23 VALUES LESS THAN (20220123235959) ENGINE = InnoDB, PARTITION part24 VALUES LESS THAN (20220124235959) ENGINE = InnoDB, PARTITION part25 VALUES LESS THAN (20220125235959) ENGINE = InnoDB, PARTITION part26 VALUES LESS THAN (20220126235959) ENGINE = InnoDB, PARTITION part27 VALUES LESS THAN (20220127235959) ENGINE = InnoDB, PARTITION part28 VALUES LESS THAN (20220128235959) ENGINE = InnoDB, PARTITION part29 VALUES LESS THAN (20220129235959) ENGINE = InnoDB, PARTITION part30 VALUES LESS THAN (20220130235959) ENGINE = InnoDB, PARTITION part31 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; -- ---------------------------- -- Table structure for online_data_lampblack_02 -- ---------------------------- DROP TABLE IF EXISTS `online_data_lampblack_02`; CREATE TABLE `online_data_lampblack_02` ( `terminal_id` varchar(30) NOT NULL COMMENT '监测仪编号', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMddHHmmss', `flue_temp` decimal(8,3) DEFAULT NULL COMMENT '烟道温度(通道0)，单位：℃', `flue_humidity` decimal(8,3) DEFAULT NULL COMMENT '烟道湿度(通道0)，单位：RH', `smoke_density` decimal(8,3) DEFAULT NULL COMMENT '烟雾浓度(通道0)，单位：ppm', `voc_density` decimal(8,3) DEFAULT NULL COMMENT 'VOC浓度(通道0)，单位：ppm', `pm25` decimal(8,3) DEFAULT NULL COMMENT 'pm25', `latitude` varchar(20) DEFAULT NULL COMMENT '纬度，单位度', `longitude` varchar(20) DEFAULT NULL COMMENT '经度，单位度', `smoke_total` decimal(8,3) DEFAULT NULL COMMENT '烟雾浓度排放总量，单位克', `voc_total` decimal(8,3) DEFAULT NULL COMMENT 'VOC浓度排放总量，单位克', `pm25_total` decimal(8,3) DEFAULT NULL COMMENT 'pm25排放总量，单位克', `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间yyyyMMddHHmmss', PRIMARY KEY (`terminal_id`,`upload_date`), KEY `indexes_upload_date` (`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='油烟实时表' /*!50100 PARTITION BY RANGE (upload_date) (PARTITION part01 VALUES LESS THAN (20220201235959) ENGINE = InnoDB, PARTITION part02 VALUES LESS THAN (20220202235959) ENGINE = InnoDB, PARTITION part03 VALUES LESS THAN (20220203235959) ENGINE = InnoDB, PARTITION part04 VALUES LESS THAN (20220204235959) ENGINE = InnoDB, PARTITION part05 VALUES LESS THAN (20220205235959) ENGINE = InnoDB, PARTITION part06 VALUES LESS THAN (20220206235959) ENGINE = InnoDB, PARTITION part07 VALUES LESS THAN (20220207235959) ENGINE = InnoDB, PARTITION part08 VALUES LESS THAN (20220208235959) ENGINE = InnoDB, PARTITION part09 VALUES LESS THAN (20220209235959) ENGINE = InnoDB, PARTITION part10 VALUES LESS THAN (20220210235959) ENGINE = InnoDB, PARTITION part11 VALUES LESS THAN (20220211235959) ENGINE = InnoDB, PARTITION part12 VALUES LESS THAN (20220212235959) ENGINE = InnoDB, PARTITION part13 VALUES LESS THAN (20220213235959) ENGINE = InnoDB, PARTITION part14 VALUES LESS THAN (20220214235959) ENGINE = InnoDB, PARTITION part15 VALUES LESS THAN (20220215235959) ENGINE = InnoDB, PARTITION part16 VALUES LESS THAN (20220216235959) ENGINE = InnoDB, PARTITION part17 VALUES LESS THAN (20220217235959) ENGINE = InnoDB, PARTITION part18 VALUES LESS THAN (20220218235959) ENGINE = InnoDB, PARTITION part19 VALUES LESS THAN (20220219235959) ENGINE = InnoDB, PARTITION part20 VALUES LESS THAN (20220220235959) ENGINE = InnoDB, PARTITION part21 VALUES LESS THAN (20220221235959) ENGINE = InnoDB, PARTITION part22 VALUES LESS THAN (20220222235959) ENGINE = InnoDB, PARTITION part23 VALUES LESS THAN (20220223235959) ENGINE = InnoDB, PARTITION part24 VALUES LESS THAN (20220224235959) ENGINE = InnoDB, PARTITION part25 VALUES LESS THAN (20220225235959) ENGINE = InnoDB, PARTITION part26 VALUES LESS THAN (20220226235959) ENGINE = InnoDB, PARTITION part27 VALUES LESS THAN (20220227235959) ENGINE = InnoDB, PARTITION part28 VALUES LESS THAN (20220228235959) ENGINE = InnoDB, PARTITION part29 VALUES LESS THAN (20220229235959) ENGINE = InnoDB, PARTITION part30 VALUES LESS THAN (20220230235959) ENGINE = InnoDB, PARTITION part31 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; -- ---------------------------- -- Table structure for online_data_lampblack_03 -- ---------------------------- DROP TABLE IF EXISTS `online_data_lampblack_03`; CREATE TABLE `online_data_lampblack_03` ( `terminal_id` varchar(30) NOT NULL COMMENT '监测仪编号', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMddHHmmss', `flue_temp` decimal(8,3) DEFAULT NULL COMMENT '烟道温度(通道0)，单位：℃', `flue_humidity` decimal(8,3) DEFAULT NULL COMMENT '烟道湿度(通道0)，单位：RH', `smoke_density` decimal(8,3) DEFAULT NULL COMMENT '烟雾浓度(通道0)，单位：ppm', `voc_density` decimal(8,3) DEFAULT NULL COMMENT 'VOC浓度(通道0)，单位：ppm', `pm25` decimal(8,3) DEFAULT NULL COMMENT 'pm25', `latitude` varchar(20) DEFAULT NULL COMMENT '纬度，单位度', `longitude` varchar(20) DEFAULT NULL COMMENT '经度，单位度', `smoke_total` decimal(8,3) DEFAULT NULL COMMENT '烟雾浓度排放总量，单位克', `voc_total` decimal(8,3) DEFAULT NULL COMMENT 'VOC浓度排放总量，单位克', `pm25_total` decimal(8,3) DEFAULT NULL COMMENT 'pm25排放总量，单位克', `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间yyyyMMddHHmmss', PRIMARY KEY (`terminal_id`,`upload_date`), KEY `indexes_upload_date` (`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='油烟实时表' /*!50100 PARTITION BY RANGE (upload_date) (PARTITION part01 VALUES LESS THAN (20220301235959) ENGINE = InnoDB, PARTITION part02 VALUES LESS THAN (20220302235959) ENGINE = InnoDB, PARTITION part03 VALUES LESS THAN (20220303235959) ENGINE = InnoDB, PARTITION part04 VALUES LESS THAN (20220304235959) ENGINE = InnoDB, PARTITION part05 VALUES LESS THAN (20220305235959) ENGINE = InnoDB, PARTITION part06 VALUES LESS THAN (20220306235959) ENGINE = InnoDB, PARTITION part07 VALUES LESS THAN (20220307235959) ENGINE = InnoDB, PARTITION part08 VALUES LESS THAN (20220308235959) ENGINE = InnoDB, PARTITION part09 VALUES LESS THAN (20220309235959) ENGINE = InnoDB, PARTITION part10 VALUES LESS THAN (20220310235959) ENGINE = InnoDB, PARTITION part11 VALUES LESS THAN (20220311235959) ENGINE = InnoDB, PARTITION part12 VALUES LESS THAN (20220312235959) ENGINE = InnoDB, PARTITION part13 VALUES LESS THAN (20220313235959) ENGINE = InnoDB, PARTITION part14 VALUES LESS THAN (20220314235959) ENGINE = InnoDB, PARTITION part15 VALUES LESS THAN (20220315235959) ENGINE = InnoDB, PARTITION part16 VALUES LESS THAN (20220316235959) ENGINE = InnoDB, PARTITION part17 VALUES LESS THAN (20220317235959) ENGINE = InnoDB, PARTITION part18 VALUES LESS THAN (20220318235959) ENGINE = InnoDB, PARTITION part19 VALUES LESS THAN (20220319235959) ENGINE = InnoDB, PARTITION part20 VALUES LESS THAN (20220320235959) ENGINE = InnoDB, PARTITION part21 VALUES LESS THAN (20220321235959) ENGINE = InnoDB, PARTITION part22 VALUES LESS THAN (20220322235959) ENGINE = InnoDB, PARTITION part23 VALUES LESS THAN (20220323235959) ENGINE = InnoDB, PARTITION part24 VALUES LESS THAN (20220324235959) ENGINE = InnoDB, PARTITION part25 VALUES LESS THAN (20220325235959) ENGINE = InnoDB, PARTITION part26 VALUES LESS THAN (20220326235959) ENGINE = InnoDB, PARTITION part27 VALUES LESS THAN (20220327235959) ENGINE = InnoDB, PARTITION part28 VALUES LESS THAN (20220328235959) ENGINE = InnoDB, PARTITION part29 VALUES LESS THAN (20220329235959) ENGINE = InnoDB, PARTITION part30 VALUES LESS THAN (20220330235959) ENGINE = InnoDB, PARTITION part31 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; -- ---------------------------- -- Table structure for online_data_lampblack_04 -- ---------------------------- DROP TABLE IF EXISTS `online_data_lampblack_04`; CREATE TABLE `online_data_lampblack_04` ( `terminal_id` varchar(30) NOT NULL COMMENT '监测仪编号', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMddHHmmss', `flue_temp` decimal(8,3) DEFAULT NULL COMMENT '烟道温度(通道0)，单位：℃', `flue_humidity` decimal(8,3) DEFAULT NULL COMMENT '烟道湿度(通道0)，单位：RH', `smoke_density` decimal(8,3) DEFAULT NULL COMMENT '烟雾浓度(通道0)，单位：ppm', `voc_density` decimal(8,3) DEFAULT NULL COMMENT 'VOC浓度(通道0)，单位：ppm', `pm25` decimal(8,3) DEFAULT NULL COMMENT 'pm25', `latitude` varchar(20) DEFAULT NULL COMMENT '纬度，单位度', `longitude` varchar(20) DEFAULT NULL COMMENT '经度，单位度', `smoke_total` decimal(8,3) DEFAULT NULL COMMENT '烟雾浓度排放总量，单位克', `voc_total` decimal(8,3) DEFAULT NULL COMMENT 'VOC浓度排放总量，单位克', `pm25_total` decimal(8,3) DEFAULT NULL COMMENT 'pm25排放总量，单位克', `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间yyyyMMddHHmmss', PRIMARY KEY (`terminal_id`,`upload_date`), KEY `indexes_upload_date` (`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='油烟实时表' /*!50100 PARTITION BY RANGE (upload_date) (PARTITION part01 VALUES LESS THAN (20220401235959) ENGINE = InnoDB, PARTITION part02 VALUES LESS THAN (20220402235959) ENGINE = InnoDB, PARTITION part03 VALUES LESS THAN (20220403235959) ENGINE = InnoDB, PARTITION part04 VALUES LESS THAN (20220404235959) ENGINE = InnoDB, PARTITION part05 VALUES LESS THAN (20220405235959) ENGINE = InnoDB, PARTITION part06 VALUES LESS THAN (20220406235959) ENGINE = InnoDB, PARTITION part07 VALUES LESS THAN (20220407235959) ENGINE = InnoDB, PARTITION part08 VALUES LESS THAN (20220408235959) ENGINE = InnoDB, PARTITION part09 VALUES LESS THAN (20220409235959) ENGINE = InnoDB, PARTITION part10 VALUES LESS THAN (20220410235959) ENGINE = InnoDB, PARTITION part11 VALUES LESS THAN (20220411235959) ENGINE = InnoDB, PARTITION part12 VALUES LESS THAN (20220412235959) ENGINE = InnoDB, PARTITION part13 VALUES LESS THAN (20220413235959) ENGINE = InnoDB, PARTITION part14 VALUES LESS THAN (20220414235959) ENGINE = InnoDB, PARTITION part15 VALUES LESS THAN (20220415235959) ENGINE = InnoDB, PARTITION part16 VALUES LESS THAN (20220416235959) ENGINE = InnoDB, PARTITION part17 VALUES LESS THAN (20220417235959) ENGINE = InnoDB, PARTITION part18 VALUES LESS THAN (20220418235959) ENGINE = InnoDB, PARTITION part19 VALUES LESS THAN (20220419235959) ENGINE = InnoDB, PARTITION part20 VALUES LESS THAN (20220420235959) ENGINE = InnoDB, PARTITION part21 VALUES LESS THAN (20220421235959) ENGINE = InnoDB, PARTITION part22 VALUES LESS THAN (20220422235959) ENGINE = InnoDB, PARTITION part23 VALUES LESS THAN (20220423235959) ENGINE = InnoDB, PARTITION part24 VALUES LESS THAN (20220424235959) ENGINE = InnoDB, PARTITION part25 VALUES LESS THAN (20220425235959) ENGINE = InnoDB, PARTITION part26 VALUES LESS THAN (20220426235959) ENGINE = InnoDB, PARTITION part27 VALUES LESS THAN (20220427235959) ENGINE = InnoDB, PARTITION part28 VALUES LESS THAN (20220428235959) ENGINE = InnoDB, PARTITION part29 VALUES LESS THAN (20220429235959) ENGINE = InnoDB, PARTITION part30 VALUES LESS THAN (20220430235959) ENGINE = InnoDB, PARTITION part31 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; -- ---------------------------- -- Table structure for online_data_lampblack_05 -- ---------------------------- DROP TABLE IF EXISTS `online_data_lampblack_05`; CREATE TABLE `online_data_lampblack_05` ( `terminal_id` varchar(30) NOT NULL COMMENT '监测仪编号', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMddHHmmss', `flue_temp` decimal(8,3) DEFAULT NULL COMMENT '烟道温度(通道0)，单位：℃', `flue_humidity` decimal(8,3) DEFAULT NULL COMMENT '烟道湿度(通道0)，单位：RH', `smoke_density` decimal(8,3) DEFAULT NULL COMMENT '烟雾浓度(通道0)，单位：ppm', `voc_density` decimal(8,3) DEFAULT NULL COMMENT 'VOC浓度(通道0)，单位：ppm', `pm25` decimal(8,3) DEFAULT NULL COMMENT 'pm25', `latitude` varchar(20) DEFAULT NULL COMMENT '纬度，单位度', `longitude` varchar(20) DEFAULT NULL COMMENT '经度，单位度', `smoke_total` decimal(8,3) DEFAULT NULL COMMENT '烟雾浓度排放总量，单位克', `voc_total` decimal(8,3) DEFAULT NULL COMMENT 'VOC浓度排放总量，单位克', `pm25_total` decimal(8,3) DEFAULT NULL COMMENT 'pm25排放总量，单位克', `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间yyyyMMddHHmmss', PRIMARY KEY (`terminal_id`,`upload_date`), KEY `indexes_upload_date` (`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='油烟实时表' /*!50100 PARTITION BY RANGE (upload_date) (PARTITION part01 VALUES LESS THAN (20220501235959) ENGINE = InnoDB, PARTITION part02 VALUES LESS THAN (20220502235959) ENGINE = InnoDB, PARTITION part03 VALUES LESS THAN (20220503235959) ENGINE = InnoDB, PARTITION part04 VALUES LESS THAN (20220504235959) ENGINE = InnoDB, PARTITION part05 VALUES LESS THAN (20220505235959) ENGINE = InnoDB, PARTITION part06 VALUES LESS THAN (20220506235959) ENGINE = InnoDB, PARTITION part07 VALUES LESS THAN (20220507235959) ENGINE = InnoDB, PARTITION part08 VALUES LESS THAN (20220508235959) ENGINE = InnoDB, PARTITION part09 VALUES LESS THAN (20220509235959) ENGINE = InnoDB, PARTITION part10 VALUES LESS THAN (20220510235959) ENGINE = InnoDB, PARTITION part11 VALUES LESS THAN (20220511235959) ENGINE = InnoDB, PARTITION part12 VALUES LESS THAN (20220512235959) ENGINE = InnoDB, PARTITION part13 VALUES LESS THAN (20220513235959) ENGINE = InnoDB, PARTITION part14 VALUES LESS THAN (20220514235959) ENGINE = InnoDB, PARTITION part15 VALUES LESS THAN (20220515235959) ENGINE = InnoDB, PARTITION part16 VALUES LESS THAN (20220516235959) ENGINE = InnoDB, PARTITION part17 VALUES LESS THAN (20220517235959) ENGINE = InnoDB, PARTITION part18 VALUES LESS THAN (20220518235959) ENGINE = InnoDB, PARTITION part19 VALUES LESS THAN (20220519235959) ENGINE = InnoDB, PARTITION part20 VALUES LESS THAN (20220520235959) ENGINE = InnoDB, PARTITION part21 VALUES LESS THAN (20220521235959) ENGINE = InnoDB, PARTITION part22 VALUES LESS THAN (20220522235959) ENGINE = InnoDB, PARTITION part23 VALUES LESS THAN (20220523235959) ENGINE = InnoDB, PARTITION part24 VALUES LESS THAN (20220524235959) ENGINE = InnoDB, PARTITION part25 VALUES LESS THAN (20220525235959) ENGINE = InnoDB, PARTITION part26 VALUES LESS THAN (20220526235959) ENGINE = InnoDB, PARTITION part27 VALUES LESS THAN (20220527235959) ENGINE = InnoDB, PARTITION part28 VALUES LESS THAN (20220528235959) ENGINE = InnoDB, PARTITION part29 VALUES LESS THAN (20220529235959) ENGINE = InnoDB, PARTITION part30 VALUES LESS THAN (20220530235959) ENGINE = InnoDB, PARTITION part31 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; -- ---------------------------- -- Table structure for online_data_lampblack_06 -- ---------------------------- DROP TABLE IF EXISTS `online_data_lampblack_06`; CREATE TABLE `online_data_lampblack_06` ( `terminal_id` varchar(30) NOT NULL COMMENT '监测仪编号', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMddHHmmss', `flue_temp` decimal(8,3) DEFAULT NULL COMMENT '烟道温度(通道0)，单位：℃', `flue_humidity` decimal(8,3) DEFAULT NULL COMMENT '烟道湿度(通道0)，单位：RH', `smoke_density` decimal(8,3) DEFAULT NULL COMMENT '烟雾浓度(通道0)，单位：ppm', `voc_density` decimal(8,3) DEFAULT NULL COMMENT 'VOC浓度(通道0)，单位：ppm', `pm25` decimal(8,3) DEFAULT NULL COMMENT 'pm25', `latitude` varchar(20) DEFAULT NULL COMMENT '纬度，单位度', `longitude` varchar(20) DEFAULT NULL COMMENT '经度，单位度', `smoke_total` decimal(8,3) DEFAULT NULL COMMENT '烟雾浓度排放总量，单位克', `voc_total` decimal(8,3) DEFAULT NULL COMMENT 'VOC浓度排放总量，单位克', `pm25_total` decimal(8,3) DEFAULT NULL COMMENT 'pm25排放总量，单位克', `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间yyyyMMddHHmmss', PRIMARY KEY (`terminal_id`,`upload_date`), KEY `indexes_upload_date` (`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='油烟实时表' /*!50100 PARTITION BY RANGE (upload_date) (PARTITION part01 VALUES LESS THAN (20220601235959) ENGINE = InnoDB, PARTITION part02 VALUES LESS THAN (20220602235959) ENGINE = InnoDB, PARTITION part03 VALUES LESS THAN (20220603235959) ENGINE = InnoDB, PARTITION part04 VALUES LESS THAN (20220604235959) ENGINE = InnoDB, PARTITION part05 VALUES LESS THAN (20220605235959) ENGINE = InnoDB, PARTITION part06 VALUES LESS THAN (20220606235959) ENGINE = InnoDB, PARTITION part07 VALUES LESS THAN (20220607235959) ENGINE = InnoDB, PARTITION part08 VALUES LESS THAN (20220608235959) ENGINE = InnoDB, PARTITION part09 VALUES LESS THAN (20220609235959) ENGINE = InnoDB, PARTITION part10 VALUES LESS THAN (20220610235959) ENGINE = InnoDB, PARTITION part11 VALUES LESS THAN (20220611235959) ENGINE = InnoDB, PARTITION part12 VALUES LESS THAN (20220612235959) ENGINE = InnoDB, PARTITION part13 VALUES LESS THAN (20220613235959) ENGINE = InnoDB, PARTITION part14 VALUES LESS THAN (20220614235959) ENGINE = InnoDB, PARTITION part15 VALUES LESS THAN (20220615235959) ENGINE = InnoDB, PARTITION part16 VALUES LESS THAN (20220616235959) ENGINE = InnoDB, PARTITION part17 VALUES LESS THAN (20220617235959) ENGINE = InnoDB, PARTITION part18 VALUES LESS THAN (20220618235959) ENGINE = InnoDB, PARTITION part19 VALUES LESS THAN (20220619235959) ENGINE = InnoDB, PARTITION part20 VALUES LESS THAN (20220620235959) ENGINE = InnoDB, PARTITION part21 VALUES LESS THAN (20220621235959) ENGINE = InnoDB, PARTITION part22 VALUES LESS THAN (20220622235959) ENGINE = InnoDB, PARTITION part23 VALUES LESS THAN (20220623235959) ENGINE = InnoDB, PARTITION part24 VALUES LESS THAN (20220624235959) ENGINE = InnoDB, PARTITION part25 VALUES LESS THAN (20220625235959) ENGINE = InnoDB, PARTITION part26 VALUES LESS THAN (20220626235959) ENGINE = InnoDB, PARTITION part27 VALUES LESS THAN (20220627235959) ENGINE = InnoDB, PARTITION part28 VALUES LESS THAN (20220628235959) ENGINE = InnoDB, PARTITION part29 VALUES LESS THAN (20220629235959) ENGINE = InnoDB, PARTITION part30 VALUES LESS THAN (20220630235959) ENGINE = InnoDB, PARTITION part31 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; -- ---------------------------- -- Table structure for online_data_lampblack_07 -- ---------------------------- DROP TABLE IF EXISTS `online_data_lampblack_07`; CREATE TABLE `online_data_lampblack_07` ( `terminal_id` varchar(30) NOT NULL COMMENT '监测仪编号', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMddHHmmss', `flue_temp` decimal(8,3) DEFAULT NULL COMMENT '烟道温度(通道0)，单位：℃', `flue_humidity` decimal(8,3) DEFAULT NULL COMMENT '烟道湿度(通道0)，单位：RH', `smoke_density` decimal(8,3) DEFAULT NULL COMMENT '烟雾浓度(通道0)，单位：ppm', `voc_density` decimal(8,3) DEFAULT NULL COMMENT 'VOC浓度(通道0)，单位：ppm', `pm25` decimal(8,3) DEFAULT NULL COMMENT 'pm25', `latitude` varchar(20) DEFAULT NULL COMMENT '纬度，单位度', `longitude` varchar(20) DEFAULT NULL COMMENT '经度，单位度', `smoke_total` decimal(8,3) DEFAULT NULL COMMENT '烟雾浓度排放总量，单位克', `voc_total` decimal(8,3) DEFAULT NULL COMMENT 'VOC浓度排放总量，单位克', `pm25_total` decimal(8,3) DEFAULT NULL COMMENT 'pm25排放总量，单位克', `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间yyyyMMddHHmmss', PRIMARY KEY (`terminal_id`,`upload_date`), KEY `indexes_upload_date` (`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='油烟实时表' /*!50100 PARTITION BY RANGE (upload_date) (PARTITION part01 VALUES LESS THAN (20220701235959) ENGINE = InnoDB, PARTITION part02 VALUES LESS THAN (20220702235959) ENGINE = InnoDB, PARTITION part03 VALUES LESS THAN (20220703235959) ENGINE = InnoDB, PARTITION part04 VALUES LESS THAN (20220704235959) ENGINE = InnoDB, PARTITION part05 VALUES LESS THAN (20220705235959) ENGINE = InnoDB, PARTITION part06 VALUES LESS THAN (20220706235959) ENGINE = InnoDB, PARTITION part07 VALUES LESS THAN (20220707235959) ENGINE = InnoDB, PARTITION part08 VALUES LESS THAN (20220708235959) ENGINE = InnoDB, PARTITION part09 VALUES LESS THAN (20220709235959) ENGINE = InnoDB, PARTITION part10 VALUES LESS THAN (20220710235959) ENGINE = InnoDB, PARTITION part11 VALUES LESS THAN (20220711235959) ENGINE = InnoDB, PARTITION part12 VALUES LESS THAN (20220712235959) ENGINE = InnoDB, PARTITION part13 VALUES LESS THAN (20220713235959) ENGINE = InnoDB, PARTITION part14 VALUES LESS THAN (20220714235959) ENGINE = InnoDB, PARTITION part15 VALUES LESS THAN (20220715235959) ENGINE = InnoDB, PARTITION part16 VALUES LESS THAN (20220716235959) ENGINE = InnoDB, PARTITION part17 VALUES LESS THAN (20220717235959) ENGINE = InnoDB, PARTITION part18 VALUES LESS THAN (20220718235959) ENGINE = InnoDB, PARTITION part19 VALUES LESS THAN (20220719235959) ENGINE = InnoDB, PARTITION part20 VALUES LESS THAN (20220720235959) ENGINE = InnoDB, PARTITION part21 VALUES LESS THAN (20220721235959) ENGINE = InnoDB, PARTITION part22 VALUES LESS THAN (20220722235959) ENGINE = InnoDB, PARTITION part23 VALUES LESS THAN (20220723235959) ENGINE = InnoDB, PARTITION part24 VALUES LESS THAN (20220724235959) ENGINE = InnoDB, PARTITION part25 VALUES LESS THAN (20220725235959) ENGINE = InnoDB, PARTITION part26 VALUES LESS THAN (20220726235959) ENGINE = InnoDB, PARTITION part27 VALUES LESS THAN (20220727235959) ENGINE = InnoDB, PARTITION part28 VALUES LESS THAN (20220728235959) ENGINE = InnoDB, PARTITION part29 VALUES LESS THAN (20220729235959) ENGINE = InnoDB, PARTITION part30 VALUES LESS THAN (20220730235959) ENGINE = InnoDB, PARTITION part31 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; -- ---------------------------- -- Table structure for online_data_lampblack_08 -- ---------------------------- DROP TABLE IF EXISTS `online_data_lampblack_08`; CREATE TABLE `online_data_lampblack_08` ( `terminal_id` varchar(30) NOT NULL COMMENT '监测仪编号', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMddHHmmss', `flue_temp` decimal(8,3) DEFAULT NULL COMMENT '烟道温度(通道0)，单位：℃', `flue_humidity` decimal(8,3) DEFAULT NULL COMMENT '烟道湿度(通道0)，单位：RH', `smoke_density` decimal(8,3) DEFAULT NULL COMMENT '烟雾浓度(通道0)，单位：ppm', `voc_density` decimal(8,3) DEFAULT NULL COMMENT 'VOC浓度(通道0)，单位：ppm', `pm25` decimal(8,3) DEFAULT NULL COMMENT 'pm25', `latitude` varchar(20) DEFAULT NULL COMMENT '纬度，单位度', `longitude` varchar(20) DEFAULT NULL COMMENT '经度，单位度', `smoke_total` decimal(8,3) DEFAULT NULL COMMENT '烟雾浓度排放总量，单位克', `voc_total` decimal(8,3) DEFAULT NULL COMMENT 'VOC浓度排放总量，单位克', `pm25_total` decimal(8,3) DEFAULT NULL COMMENT 'pm25排放总量，单位克', `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间yyyyMMddHHmmss', PRIMARY KEY (`terminal_id`,`upload_date`), KEY `indexes_upload_date` (`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='油烟实时表' /*!50100 PARTITION BY RANGE (upload_date) (PARTITION part01 VALUES LESS THAN (20220801235959) ENGINE = InnoDB, PARTITION part02 VALUES LESS THAN (20220802235959) ENGINE = InnoDB, PARTITION part03 VALUES LESS THAN (20220803235959) ENGINE = InnoDB, PARTITION part04 VALUES LESS THAN (20220804235959) ENGINE = InnoDB, PARTITION part05 VALUES LESS THAN (20220805235959) ENGINE = InnoDB, PARTITION part06 VALUES LESS THAN (20220806235959) ENGINE = InnoDB, PARTITION part07 VALUES LESS THAN (20220807235959) ENGINE = InnoDB, PARTITION part08 VALUES LESS THAN (20220808235959) ENGINE = InnoDB, PARTITION part09 VALUES LESS THAN (20220809235959) ENGINE = InnoDB, PARTITION part10 VALUES LESS THAN (20220810235959) ENGINE = InnoDB, PARTITION part11 VALUES LESS THAN (20220811235959) ENGINE = InnoDB, PARTITION part12 VALUES LESS THAN (20220812235959) ENGINE = InnoDB, PARTITION part13 VALUES LESS THAN (20220813235959) ENGINE = InnoDB, PARTITION part14 VALUES LESS THAN (20220814235959) ENGINE = InnoDB, PARTITION part15 VALUES LESS THAN (20220815235959) ENGINE = InnoDB, PARTITION part16 VALUES LESS THAN (20220816235959) ENGINE = InnoDB, PARTITION part17 VALUES LESS THAN (20220817235959) ENGINE = InnoDB, PARTITION part18 VALUES LESS THAN (20220818235959) ENGINE = InnoDB, PARTITION part19 VALUES LESS THAN (20220819235959) ENGINE = InnoDB, PARTITION part20 VALUES LESS THAN (20220820235959) ENGINE = InnoDB, PARTITION part21 VALUES LESS THAN (20220821235959) ENGINE = InnoDB, PARTITION part22 VALUES LESS THAN (20220822235959) ENGINE = InnoDB, PARTITION part23 VALUES LESS THAN (20220823235959) ENGINE = InnoDB, PARTITION part24 VALUES LESS THAN (20220824235959) ENGINE = InnoDB, PARTITION part25 VALUES LESS THAN (20220825235959) ENGINE = InnoDB, PARTITION part26 VALUES LESS THAN (20220826235959) ENGINE = InnoDB, PARTITION part27 VALUES LESS THAN (20220827235959) ENGINE = InnoDB, PARTITION part28 VALUES LESS THAN (20220828235959) ENGINE = InnoDB, PARTITION part29 VALUES LESS THAN (20220829235959) ENGINE = InnoDB, PARTITION part30 VALUES LESS THAN (20220830235959) ENGINE = InnoDB, PARTITION part31 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; -- ---------------------------- -- Table structure for online_data_lampblack_09 -- ---------------------------- DROP TABLE IF EXISTS `online_data_lampblack_09`; CREATE TABLE `online_data_lampblack_09` ( `terminal_id` varchar(30) NOT NULL COMMENT '监测仪编号', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMddHHmmss', `flue_temp` decimal(8,3) DEFAULT NULL COMMENT '烟道温度(通道0)，单位：℃', `flue_humidity` decimal(8,3) DEFAULT NULL COMMENT '烟道湿度(通道0)，单位：RH', `smoke_density` decimal(8,3) DEFAULT NULL COMMENT '烟雾浓度(通道0)，单位：ppm', `voc_density` decimal(8,3) DEFAULT NULL COMMENT 'VOC浓度(通道0)，单位：ppm', `pm25` decimal(8,3) DEFAULT NULL COMMENT 'pm25', `latitude` varchar(20) DEFAULT NULL COMMENT '纬度，单位度', `longitude` varchar(20) DEFAULT NULL COMMENT '经度，单位度', `smoke_total` decimal(8,3) DEFAULT NULL COMMENT '烟雾浓度排放总量，单位克', `voc_total` decimal(8,3) DEFAULT NULL COMMENT 'VOC浓度排放总量，单位克', `pm25_total` decimal(8,3) DEFAULT NULL COMMENT 'pm25排放总量，单位克', `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间yyyyMMddHHmmss', PRIMARY KEY (`terminal_id`,`upload_date`), KEY `indexes_upload_date` (`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='油烟实时表' /*!50100 PARTITION BY RANGE (upload_date) (PARTITION part01 VALUES LESS THAN (20220901235959) ENGINE = InnoDB, PARTITION part02 VALUES LESS THAN (20220902235959) ENGINE = InnoDB, PARTITION part03 VALUES LESS THAN (20220903235959) ENGINE = InnoDB, PARTITION part04 VALUES LESS THAN (20220904235959) ENGINE = InnoDB, PARTITION part05 VALUES LESS THAN (20220905235959) ENGINE = InnoDB, PARTITION part06 VALUES LESS THAN (20220906235959) ENGINE = InnoDB, PARTITION part07 VALUES LESS THAN (20220907235959) ENGINE = InnoDB, PARTITION part08 VALUES LESS THAN (20220908235959) ENGINE = InnoDB, PARTITION part09 VALUES LESS THAN (20220909235959) ENGINE = InnoDB, PARTITION part10 VALUES LESS THAN (20220910235959) ENGINE = InnoDB, PARTITION part11 VALUES LESS THAN (20220911235959) ENGINE = InnoDB, PARTITION part12 VALUES LESS THAN (20220912235959) ENGINE = InnoDB, PARTITION part13 VALUES LESS THAN (20220913235959) ENGINE = InnoDB, PARTITION part14 VALUES LESS THAN (20220914235959) ENGINE = InnoDB, PARTITION part15 VALUES LESS THAN (20220915235959) ENGINE = InnoDB, PARTITION part16 VALUES LESS THAN (20220916235959) ENGINE = InnoDB, PARTITION part17 VALUES LESS THAN (20220917235959) ENGINE = InnoDB, PARTITION part18 VALUES LESS THAN (20220918235959) ENGINE = InnoDB, PARTITION part19 VALUES LESS THAN (20220919235959) ENGINE = InnoDB, PARTITION part20 VALUES LESS THAN (20220920235959) ENGINE = InnoDB, PARTITION part21 VALUES LESS THAN (20220921235959) ENGINE = InnoDB, PARTITION part22 VALUES LESS THAN (20220922235959) ENGINE = InnoDB, PARTITION part23 VALUES LESS THAN (20220923235959) ENGINE = InnoDB, PARTITION part24 VALUES LESS THAN (20220924235959) ENGINE = InnoDB, PARTITION part25 VALUES LESS THAN (20220925235959) ENGINE = InnoDB, PARTITION part26 VALUES LESS THAN (20220926235959) ENGINE = InnoDB, PARTITION part27 VALUES LESS THAN (20220927235959) ENGINE = InnoDB, PARTITION part28 VALUES LESS THAN (20220928235959) ENGINE = InnoDB, PARTITION part29 VALUES LESS THAN (20220929235959) ENGINE = InnoDB, PARTITION part30 VALUES LESS THAN (20220930235959) ENGINE = InnoDB, PARTITION part31 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; -- ---------------------------- -- Table structure for online_data_lampblack_10 -- ---------------------------- DROP TABLE IF EXISTS `online_data_lampblack_10`; CREATE TABLE `online_data_lampblack_10` ( `terminal_id` varchar(30) NOT NULL COMMENT '监测仪编号', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMddHHmmss', `flue_temp` decimal(8,3) DEFAULT NULL COMMENT '烟道温度(通道0)，单位：℃', `flue_humidity` decimal(8,3) DEFAULT NULL COMMENT '烟道湿度(通道0)，单位：RH', `smoke_density` decimal(8,3) DEFAULT NULL COMMENT '烟雾浓度(通道0)，单位：ppm', `voc_density` decimal(8,3) DEFAULT NULL COMMENT 'VOC浓度(通道0)，单位：ppm', `pm25` decimal(8,3) DEFAULT NULL COMMENT 'pm25', `latitude` varchar(20) DEFAULT NULL COMMENT '纬度，单位度', `longitude` varchar(20) DEFAULT NULL COMMENT '经度，单位度', `smoke_total` decimal(8,3) DEFAULT NULL COMMENT '烟雾浓度排放总量，单位克', `voc_total` decimal(8,3) DEFAULT NULL COMMENT 'VOC浓度排放总量，单位克', `pm25_total` decimal(8,3) DEFAULT NULL COMMENT 'pm25排放总量，单位克', `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间yyyyMMddHHmmss', PRIMARY KEY (`terminal_id`,`upload_date`), KEY `indexes_upload_date` (`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='油烟实时表' /*!50100 PARTITION BY RANGE (upload_date) (PARTITION part01 VALUES LESS THAN (20221001235959) ENGINE = InnoDB, PARTITION part02 VALUES LESS THAN (20221002235959) ENGINE = InnoDB, PARTITION part03 VALUES LESS THAN (20221003235959) ENGINE = InnoDB, PARTITION part04 VALUES LESS THAN (20221004235959) ENGINE = InnoDB, PARTITION part05 VALUES LESS THAN (20221005235959) ENGINE = InnoDB, PARTITION part06 VALUES LESS THAN (20221006235959) ENGINE = InnoDB, PARTITION part07 VALUES LESS THAN (20221007235959) ENGINE = InnoDB, PARTITION part08 VALUES LESS THAN (20221008235959) ENGINE = InnoDB, PARTITION part09 VALUES LESS THAN (20221009235959) ENGINE = InnoDB, PARTITION part10 VALUES LESS THAN (20221010235959) ENGINE = InnoDB, PARTITION part11 VALUES LESS THAN (20221011235959) ENGINE = InnoDB, PARTITION part12 VALUES LESS THAN (20221012235959) ENGINE = InnoDB, PARTITION part13 VALUES LESS THAN (20221013235959) ENGINE = InnoDB, PARTITION part14 VALUES LESS THAN (20221014235959) ENGINE = InnoDB, PARTITION part15 VALUES LESS THAN (20221015235959) ENGINE = InnoDB, PARTITION part16 VALUES LESS THAN (20221016235959) ENGINE = InnoDB, PARTITION part17 VALUES LESS THAN (20221017235959) ENGINE = InnoDB, PARTITION part18 VALUES LESS THAN (20221018235959) ENGINE = InnoDB, PARTITION part19 VALUES LESS THAN (20221019235959) ENGINE = InnoDB, PARTITION part20 VALUES LESS THAN (20221020235959) ENGINE = InnoDB, PARTITION part21 VALUES LESS THAN (20221021235959) ENGINE = InnoDB, PARTITION part22 VALUES LESS THAN (20221022235959) ENGINE = InnoDB, PARTITION part23 VALUES LESS THAN (20221023235959) ENGINE = InnoDB, PARTITION part24 VALUES LESS THAN (20221024235959) ENGINE = InnoDB, PARTITION part25 VALUES LESS THAN (20221025235959) ENGINE = InnoDB, PARTITION part26 VALUES LESS THAN (20221026235959) ENGINE = InnoDB, PARTITION part27 VALUES LESS THAN (20221027235959) ENGINE = InnoDB, PARTITION part28 VALUES LESS THAN (20221028235959) ENGINE = InnoDB, PARTITION part29 VALUES LESS THAN (20221029235959) ENGINE = InnoDB, PARTITION part30 VALUES LESS THAN (20221030235959) ENGINE = InnoDB, PARTITION part31 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; -- ---------------------------- -- Table structure for online_data_lampblack_11 -- ---------------------------- DROP TABLE IF EXISTS `online_data_lampblack_11`; CREATE TABLE `online_data_lampblack_11` ( `terminal_id` varchar(30) NOT NULL COMMENT '监测仪编号', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMddHHmmss', `flue_temp` decimal(8,3) DEFAULT NULL COMMENT '烟道温度(通道0)，单位：℃', `flue_humidity` decimal(8,3) DEFAULT NULL COMMENT '烟道湿度(通道0)，单位：RH', `smoke_density` decimal(8,3) DEFAULT NULL COMMENT '烟雾浓度(通道0)，单位：ppm', `voc_density` decimal(8,3) DEFAULT NULL COMMENT 'VOC浓度(通道0)，单位：ppm', `pm25` decimal(8,3) DEFAULT NULL COMMENT 'pm25', `latitude` varchar(20) DEFAULT NULL COMMENT '纬度，单位度', `longitude` varchar(20) DEFAULT NULL COMMENT '经度，单位度', `smoke_total` decimal(8,3) DEFAULT NULL COMMENT '烟雾浓度排放总量，单位克', `voc_total` decimal(8,3) DEFAULT NULL COMMENT 'VOC浓度排放总量，单位克', `pm25_total` decimal(8,3) DEFAULT NULL COMMENT 'pm25排放总量，单位克', `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间yyyyMMddHHmmss', PRIMARY KEY (`terminal_id`,`upload_date`), KEY `indexes_upload_date` (`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='油烟实时表' /*!50100 PARTITION BY RANGE (upload_date) (PARTITION part01 VALUES LESS THAN (20221101235959) ENGINE = InnoDB, PARTITION part02 VALUES LESS THAN (20221102235959) ENGINE = InnoDB, PARTITION part03 VALUES LESS THAN (20221103235959) ENGINE = InnoDB, PARTITION part04 VALUES LESS THAN (20221104235959) ENGINE = InnoDB, PARTITION part05 VALUES LESS THAN (20221105235959) ENGINE = InnoDB, PARTITION part06 VALUES LESS THAN (20221106235959) ENGINE = InnoDB, PARTITION part07 VALUES LESS THAN (20221107235959) ENGINE = InnoDB, PARTITION part08 VALUES LESS THAN (20221108235959) ENGINE = InnoDB, PARTITION part09 VALUES LESS THAN (20221109235959) ENGINE = InnoDB, PARTITION part10 VALUES LESS THAN (20221110235959) ENGINE = InnoDB, PARTITION part11 VALUES LESS THAN (20221111235959) ENGINE = InnoDB, PARTITION part12 VALUES LESS THAN (20221112235959) ENGINE = InnoDB, PARTITION part13 VALUES LESS THAN (20221113235959) ENGINE = InnoDB, PARTITION part14 VALUES LESS THAN (20221114235959) ENGINE = InnoDB, PARTITION part15 VALUES LESS THAN (20221115235959) ENGINE = InnoDB, PARTITION part16 VALUES LESS THAN (20221116235959) ENGINE = InnoDB, PARTITION part17 VALUES LESS THAN (20221117235959) ENGINE = InnoDB, PARTITION part18 VALUES LESS THAN (20221118235959) ENGINE = InnoDB, PARTITION part19 VALUES LESS THAN (20221119235959) ENGINE = InnoDB, PARTITION part20 VALUES LESS THAN (20221120235959) ENGINE = InnoDB, PARTITION part21 VALUES LESS THAN (20221121235959) ENGINE = InnoDB, PARTITION part22 VALUES LESS THAN (20221122235959) ENGINE = InnoDB, PARTITION part23 VALUES LESS THAN (20221123235959) ENGINE = InnoDB, PARTITION part24 VALUES LESS THAN (20221124235959) ENGINE = InnoDB, PARTITION part25 VALUES LESS THAN (20221125235959) ENGINE = InnoDB, PARTITION part26 VALUES LESS THAN (20221126235959) ENGINE = InnoDB, PARTITION part27 VALUES LESS THAN (20221127235959) ENGINE = InnoDB, PARTITION part28 VALUES LESS THAN (20221128235959) ENGINE = InnoDB, PARTITION part29 VALUES LESS THAN (20221129235959) ENGINE = InnoDB, PARTITION part30 VALUES LESS THAN (20221130235959) ENGINE = InnoDB, PARTITION part31 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; -- ---------------------------- -- Table structure for online_data_lampblack_12 -- ---------------------------- DROP TABLE IF EXISTS `online_data_lampblack_12`; CREATE TABLE `online_data_lampblack_12` ( `terminal_id` varchar(30) NOT NULL COMMENT '监测仪编号', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMddHHmmss', `flue_temp` decimal(8,3) DEFAULT NULL COMMENT '烟道温度(通道0)，单位：℃', `flue_humidity` decimal(8,3) DEFAULT NULL COMMENT '烟道湿度(通道0)，单位：RH', `smoke_density` decimal(8,3) DEFAULT NULL COMMENT '烟雾浓度(通道0)，单位：ppm', `voc_density` decimal(8,3) DEFAULT NULL COMMENT 'VOC浓度(通道0)，单位：ppm', `pm25` decimal(8,3) DEFAULT NULL COMMENT 'pm25', `latitude` varchar(20) DEFAULT NULL COMMENT '纬度，单位度', `longitude` varchar(20) DEFAULT NULL COMMENT '经度，单位度', `smoke_total` decimal(8,3) DEFAULT NULL COMMENT '烟雾浓度排放总量，单位克', `voc_total` decimal(8,3) DEFAULT NULL COMMENT 'VOC浓度排放总量，单位克', `pm25_total` decimal(8,3) DEFAULT NULL COMMENT 'pm25排放总量，单位克', `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间yyyyMMddHHmmss', PRIMARY KEY (`terminal_id`,`upload_date`), KEY `indexes_upload_date` (`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='油烟实时表' /*!50100 PARTITION BY RANGE (upload_date) (PARTITION part01 VALUES LESS THAN (20221201235959) ENGINE = InnoDB, PARTITION part02 VALUES LESS THAN (20221202235959) ENGINE = InnoDB, PARTITION part03 VALUES LESS THAN (20221203235959) ENGINE = InnoDB, PARTITION part04 VALUES LESS THAN (20221204235959) ENGINE = InnoDB, PARTITION part05 VALUES LESS THAN (20221205235959) ENGINE = InnoDB, PARTITION part06 VALUES LESS THAN (20221206235959) ENGINE = InnoDB, PARTITION part07 VALUES LESS THAN (20221207235959) ENGINE = InnoDB, PARTITION part08 VALUES LESS THAN (20221208235959) ENGINE = InnoDB, PARTITION part09 VALUES LESS THAN (20221209235959) ENGINE = InnoDB, PARTITION part10 VALUES LESS THAN (20221210235959) ENGINE = InnoDB, PARTITION part11 VALUES LESS THAN (20221211235959) ENGINE = InnoDB, PARTITION part12 VALUES LESS THAN (20221212235959) ENGINE = InnoDB, PARTITION part13 VALUES LESS THAN (20221213235959) ENGINE = InnoDB, PARTITION part14 VALUES LESS THAN (20221214235959) ENGINE = InnoDB, PARTITION part15 VALUES LESS THAN (20221215235959) ENGINE = InnoDB, PARTITION part16 VALUES LESS THAN (20221216235959) ENGINE = InnoDB, PARTITION part17 VALUES LESS THAN (20221217235959) ENGINE = InnoDB, PARTITION part18 VALUES LESS THAN (20221218235959) ENGINE = InnoDB, PARTITION part19 VALUES LESS THAN (20221219235959) ENGINE = InnoDB, PARTITION part20 VALUES LESS THAN (20221220235959) ENGINE = InnoDB, PARTITION part21 VALUES LESS THAN (20221221235959) ENGINE = InnoDB, PARTITION part22 VALUES LESS THAN (20221222235959) ENGINE = InnoDB, PARTITION part23 VALUES LESS THAN (20221223235959) ENGINE = InnoDB, PARTITION part24 VALUES LESS THAN (20221224235959) ENGINE = InnoDB, PARTITION part25 VALUES LESS THAN (20221225235959) ENGINE = InnoDB, PARTITION part26 VALUES LESS THAN (20221226235959) ENGINE = InnoDB, PARTITION part27 VALUES LESS THAN (20221227235959) ENGINE = InnoDB, PARTITION part28 VALUES LESS THAN (20221228235959) ENGINE = InnoDB, PARTITION part29 VALUES LESS THAN (20221229235959) ENGINE = InnoDB, PARTITION part30 VALUES LESS THAN (20221230235959) ENGINE = InnoDB, PARTITION part31 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; -- ---------------------------- -- Table structure for online_data_lampblack_company -- ---------------------------- DROP TABLE IF EXISTS `online_data_lampblack_company`; CREATE TABLE `online_data_lampblack_company` ( `company_id` int(11) NOT NULL COMMENT '企业id', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMddHHmmss', `flue_temp` decimal(8,3) DEFAULT NULL COMMENT '烟道温度(通道0)，单位：℃', `flue_humidity` decimal(8,3) DEFAULT NULL COMMENT '烟道湿度(通道0)，单位：RH', `smoke_density` decimal(8,3) DEFAULT NULL COMMENT '烟雾浓度(通道0)，单位：ppm', `voc_density` decimal(8,3) DEFAULT NULL COMMENT 'VOC浓度(通道0)，单位：ppm', `pm25` decimal(8,3) DEFAULT NULL COMMENT 'pm25', `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间yyyyMMddHHmmss', PRIMARY KEY (`company_id`,`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='油烟实时表' /*!50100 PARTITION BY RANGE (upload_date) (PARTITION part01 VALUES LESS THAN (20220131235959) ENGINE = InnoDB, PARTITION part02 VALUES LESS THAN (20220231235959) ENGINE = InnoDB, PARTITION part03 VALUES LESS THAN (20220331235959) ENGINE = InnoDB, PARTITION part04 VALUES LESS THAN (20220431235959) ENGINE = InnoDB, PARTITION part05 VALUES LESS THAN (20220531235959) ENGINE = InnoDB, PARTITION part06 VALUES LESS THAN (20220631235959) ENGINE = InnoDB, PARTITION part07 VALUES LESS THAN (20220731235959) ENGINE = InnoDB, PARTITION part08 VALUES LESS THAN (20220831235959) ENGINE = InnoDB, PARTITION part09 VALUES LESS THAN (20220931235959) ENGINE = InnoDB, PARTITION part10 VALUES LESS THAN (20221031235959) ENGINE = InnoDB, PARTITION part11 VALUES LESS THAN (20221131235959) ENGINE = InnoDB, PARTITION part12 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; -- ---------------------------- -- Table structure for online_data_lampblack_org -- ---------------------------- DROP TABLE IF EXISTS `online_data_lampblack_org`; CREATE TABLE `online_data_lampblack_org` ( `org_id` int(11) NOT NULL COMMENT '机构id', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMddHHmmss', `flue_temp` decimal(8,3) DEFAULT NULL COMMENT '烟道温度(通道0)，单位：℃', `flue_humidity` decimal(8,3) DEFAULT NULL COMMENT '烟道湿度(通道0)，单位：RH', `smoke_density` decimal(8,3) DEFAULT NULL COMMENT '烟雾浓度(通道0)，单位：ppm', `voc_density` decimal(8,3) DEFAULT NULL COMMENT 'VOC浓度(通道0)，单位：ppm', `pm25` decimal(8,3) DEFAULT NULL COMMENT 'pm25', `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间yyyyMMddHHmmss', PRIMARY KEY (`org_id`,`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='油烟实时表' /*!50100 PARTITION BY RANGE (upload_date) (PARTITION part01 VALUES LESS THAN (20220131235959) ENGINE = InnoDB, PARTITION part02 VALUES LESS THAN (20220231235959) ENGINE = InnoDB, PARTITION part03 VALUES LESS THAN (20220331235959) ENGINE = InnoDB, PARTITION part04 VALUES LESS THAN (20220431235959) ENGINE = InnoDB, PARTITION part05 VALUES LESS THAN (20220531235959) ENGINE = InnoDB, PARTITION part06 VALUES LESS THAN (20220631235959) ENGINE = InnoDB, PARTITION part07 VALUES LESS THAN (20220731235959) ENGINE = InnoDB, PARTITION part08 VALUES LESS THAN (20220831235959) ENGINE = InnoDB, PARTITION part09 VALUES LESS THAN (20220931235959) ENGINE = InnoDB, PARTITION part10 VALUES LESS THAN (20221031235959) ENGINE = InnoDB, PARTITION part11 VALUES LESS THAN (20221131235959) ENGINE = InnoDB, PARTITION part12 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; -- ---------------------------- -- Table structure for online_monitor_event -- ---------------------------- DROP TABLE IF EXISTS `online_monitor_event`; CREATE TABLE `online_monitor_event` ( `mn` varchar(30) NOT NULL COMMENT '监测仪mn', `upload_date` bigint(20) NOT NULL COMMENT '上传时间yyyyMMddHHmmss', `power_off` int(1) DEFAULT '0' COMMENT '1停电，0上电', `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间yyyyMMddHHmmss', PRIMARY KEY (`mn`,`upload_date`), KEY `indexes_upload_date` (`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='油烟设备停上电事件'; -- ---------------------------- -- Table structure for warn -- ---------------------------- DROP TABLE IF EXISTS `warn`; CREATE TABLE `warn` ( `id` bigint(20) NOT NULL, `org_id` int(11) NOT NULL COMMENT '机构id', `company_id` int(11) NOT NULL COMMENT '企业id', `catering_style` varchar(20) NOT NULL COMMENT '餐饮风格，菜系，000010001', `warn_type` varchar(20) NOT NULL COMMENT '报警类型，000100001', `warn_state` tinyint(1) NOT NULL DEFAULT '0' COMMENT '告警状态：0未恢复：1已恢复', `facilities_id` int(11) DEFAULT NULL COMMENT '净化设施id', `device_id` int(11) NOT NULL COMMENT '设备id，净化器/风机', `warn_starttime` bigint(20) NOT NULL COMMENT '报警开始时间yyyyMMddHHmmss', `warn_endtime` bigint(20) DEFAULT NULL COMMENT '报警结束时间yyyyMMddHHmmss', `process_info` text COMMENT '报警过程信息', `abnormal_id` int(11) DEFAULT NULL COMMENT '异常申报id', `abnormal_date` bigint(20) DEFAULT NULL COMMENT '申报时间yyyyMMddHHmmss', `abnormal_state` varchar(255) DEFAULT '000170001' COMMENT '处理状态，000170001：未申报；000170002：未审核；000170003；审核通过；000170004：审核未通过', `work_order_id` int(11) DEFAULT NULL COMMENT '工单id', `work_order_time` bigint(20) DEFAULT NULL COMMENT '工单创建时间yyyyMMddHHmmss', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='报警表'; -- ---------------------------- -- Table structure for warn_early -- ---------------------------- DROP TABLE IF EXISTS `warn_early`; CREATE TABLE `warn_early` ( `id` bigint(20) NOT NULL, `org_id` int(11) NOT NULL COMMENT '机构id', `company_id` int(11) NOT NULL COMMENT '企业id', `catering_style` varchar(20) NOT NULL COMMENT '餐饮风格，菜系，000010001', `warn_type` varchar(20) NOT NULL COMMENT '预警类型，000100001', `warn_state` tinyint(1) NOT NULL DEFAULT '0' COMMENT '预警状态：0未恢复：1已恢复', `facilities_id` int(11) DEFAULT NULL COMMENT '净化设施id', `device_id` int(11) NOT NULL COMMENT '设备id，净化器/风机', `warn_starttime` bigint(20) NOT NULL COMMENT '预警开始时间yyyyMMddHHmmss', `warn_endtime` bigint(20) DEFAULT NULL COMMENT '预警结束时间yyyyMMddHHmmss', `process_info` text COMMENT '预警过程信息', `abnormal_id` int(11) DEFAULT NULL COMMENT '异常申报id', `abnormal_date` bigint(20) DEFAULT NULL COMMENT '申报时间yyyyMMddHHmmss', `abnormal_state` varchar(255) DEFAULT '000170001' COMMENT '处理状态，000170001：未申报；000170002：未审核；000170003；审核通过；000170004：审核未通过', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='预警表';