Server/VB_DSM_V2.1/Scripts/Sqls/vbdsm_powergov.sql

-- MySQL dump 10.13  Distrib 5.6.40, for Linux (x86_64)
--
-- Host: 127.0.0.1    Database: vbdsm_powergov
-- ------------------------------------------------------
-- Server version	5.6.40-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Current Database: `vbdsm_powergov`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `vbdsm_powergov` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `vbdsm_powergov`;

--
-- Table structure for table `t_airtemp`
--

DROP TABLE IF EXISTS `t_airtemp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_airtemp` (
  `cityId` int(10) NOT NULL COMMENT '区域编号',
  `getDate` int(8) NOT NULL COMMENT '日期',
  `maxTemp` int(4) DEFAULT NULL COMMENT '最高温度',
  `minTemp` int(4) DEFAULT NULL COMMENT '最低温度',
  PRIMARY KEY (`cityId`,`getDate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='区域气温表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `t_city_date_m`
--

DROP TABLE IF EXISTS `t_city_date_m`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_city_date_m` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `province` int(12) NOT NULL COMMENT '县区编码',
  `city` int(12) NOT NULL COMMENT '县区编码',
  `getDate` int(8) NOT NULL,
  `mmin` decimal(14,2) DEFAULT NULL COMMENT '最小值',
  `minTime` bigint(18) DEFAULT NULL COMMENT '最小值时间',
  `mmax` decimal(14,2) DEFAULT NULL COMMENT '最大值',
  `maxTime` bigint(18) DEFAULT NULL COMMENT '最大值时间',
  `mavg` decimal(14,2) DEFAULT NULL COMMENT '平均值',
  PRIMARY KEY (`id`,`province`,`city`,`getDate`),
  UNIQUE KEY `city_date_index` (`city`,`getDate`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3965834 DEFAULT CHARSET=utf8 COMMENT='市日最值';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `t_city_month_m`
--

DROP TABLE IF EXISTS `t_city_month_m`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_city_month_m` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `province` int(12) NOT NULL COMMENT '县区编码',
  `city` int(12) NOT NULL COMMENT '县区编码',
  `year` int(4) NOT NULL,
  `month` int(2) NOT NULL,
  `mmin` decimal(14,2) DEFAULT NULL COMMENT '最小值',
  `minTime` bigint(18) DEFAULT NULL COMMENT '最小值时间',
  `mmax` decimal(14,2) DEFAULT NULL COMMENT '最大值',
  `maxTime` bigint(18) DEFAULT NULL COMMENT '最大值时间',
  `mavg` decimal(14,2) DEFAULT NULL COMMENT '平均值',
  PRIMARY KEY (`id`),
  UNIQUE KEY `city_month` (`city`,`year`,`month`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=135523 DEFAULT CHARSET=utf8 COMMENT='市月最值';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `t_city_online`
--

DROP TABLE IF EXISTS `t_city_online`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_city_online` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增编号',
  `province` int(10) NOT NULL COMMENT '省份编码',
  `city` int(10) NOT NULL COMMENT '城市编码',
  `getTime` bigint(18) NOT NULL COMMENT '得到数据时间',
  `p` decimal(14,2) DEFAULT NULL COMMENT '数据值',
  PRIMARY KEY (`id`),
  UNIQUE KEY `city_online_index` (`city`,`getTime`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=144123998 DEFAULT CHARSET=utf8 COMMENT='市实时负荷';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `t_company_date_m`
--

DROP TABLE IF EXISTS `t_company_date_m`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_company_date_m` (
  `companyId` bigint(20) NOT NULL COMMENT '企业编号',
  `getDate` int(8) NOT NULL COMMENT 'yyyyMMdd',
  `mmin` decimal(14,2) DEFAULT NULL COMMENT '最小值',
  `minTime` bigint(18) DEFAULT NULL COMMENT '最小值时间yyyyMMddHHmmss',
  `mmax` decimal(14,2) DEFAULT NULL COMMENT '最大值',
  `maxTime` bigint(18) DEFAULT NULL COMMENT '最大值时间yyyyMMddHHmmss',
  `mavg` decimal(14,2) DEFAULT NULL COMMENT '平均值',
  PRIMARY KEY (`companyId`,`getDate`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='企业日最值';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `t_company_date_ruikang`
--

DROP TABLE IF EXISTS `t_company_date_ruikang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_company_date_ruikang` (
  `companyId` bigint(20) NOT NULL COMMENT '企业编号',
  `getDate` int(8) NOT NULL COMMENT '得到数据时间yyyyMMdd',
  `tpe` decimal(12,3) DEFAULT NULL COMMENT '每日电量，乘过ct，pt后的值',
  PRIMARY KEY (`companyId`,`getDate`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='瑞康企业每日电量表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `t_company_date_ruikang_forecast`
--

DROP TABLE IF EXISTS `t_company_date_ruikang_forecast`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_company_date_ruikang_forecast` (
  `companyId` bigint(20) NOT NULL COMMENT '企业编号',
  `getDate` int(8) NOT NULL COMMENT '预测数据时间yyyyMMdd',
  `tpe` decimal(12,3) DEFAULT NULL COMMENT '预测每日电量，乘过ct，pt后的值',
  PRIMARY KEY (`companyId`,`getDate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='瑞康企业日数据预测表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `t_company_fgp`
--

DROP TABLE IF EXISTS `t_company_fgp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_company_fgp` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `companyId` bigint(20) NOT NULL COMMENT '企业编号',
  `getDate` int(8) NOT NULL COMMENT '得到数据时间',
  `ftpe` decimal(14,2) DEFAULT NULL COMMENT '峰电量',
  `gtpe` decimal(14,2) DEFAULT NULL COMMENT '谷电量',
  `ptpe` decimal(14,2) DEFAULT NULL COMMENT '平电量',
  `jtpe` decimal(14,2) DEFAULT NULL COMMENT '尖峰电量',
  PRIMARY KEY (`id`),
  UNIQUE KEY `cid_getDate_index` (`companyId`,`getDate`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=108008436 DEFAULT CHARSET=utf8 COMMENT='企业日电量';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `t_company_online`
--

DROP TABLE IF EXISTS `t_company_online`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_company_online` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `companyId` bigint(20) NOT NULL COMMENT '企业编号',
  `getTime` bigint(18) NOT NULL COMMENT '得到数据时间',
  `p` decimal(20,2) DEFAULT NULL COMMENT '负荷数据值',
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_companyId_getTime` (`companyId`,`getTime`) USING BTREE,
  KEY `getTime` (`getTime`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1933224655 DEFAULT CHARSET=utf8 COMMENT='企业实时负荷';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `t_district_date_fgp`
--

DROP TABLE IF EXISTS `t_district_date_fgp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_district_date_fgp` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `province` int(12) NOT NULL COMMENT '县区编码',
  `city` int(12) NOT NULL COMMENT '县区编码',
  `district` int(12) NOT NULL COMMENT '县区编码',
  `getDate` int(8) NOT NULL,
  `ftpe` decimal(14,2) DEFAULT NULL COMMENT '峰电量',
  `gtpe` decimal(14,2) DEFAULT NULL COMMENT '谷电量',
  `ptpe` decimal(14,2) DEFAULT NULL COMMENT '谷电量',
  `jtpe` decimal(14,2) DEFAULT NULL COMMENT '尖峰电量',
  PRIMARY KEY (`id`,`province`,`city`,`district`,`getDate`),
  UNIQUE KEY `district_index` (`province`,`city`,`district`,`getDate`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7609429 DEFAULT CHARSET=utf8 COMMENT='县区日电量';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `t_district_date_m`
--

DROP TABLE IF EXISTS `t_district_date_m`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_district_date_m` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `province` int(12) NOT NULL COMMENT '县区编码',
  `city` int(12) NOT NULL COMMENT '县区编码',
  `district` int(12) NOT NULL COMMENT '县区编码',
  `getDate` int(8) NOT NULL,
  `mmin` decimal(14,2) DEFAULT NULL COMMENT '最小值',
  `minTime` bigint(18) DEFAULT NULL COMMENT '最小值时间',
  `mmax` decimal(14,2) DEFAULT NULL COMMENT '最大值',
  `maxTime` bigint(18) DEFAULT NULL COMMENT '最大值时间',
  `mavg` decimal(14,2) DEFAULT NULL COMMENT '平均值',
  PRIMARY KEY (`id`,`province`,`city`,`district`,`getDate`),
  UNIQUE KEY `district_date_index` (`district`,`getDate`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10899338 DEFAULT CHARSET=utf8 COMMENT='县区日最值';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `t_district_month_m`
--

DROP TABLE IF EXISTS `t_district_month_m`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_district_month_m` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `province` int(12) NOT NULL COMMENT '县区编码',
  `city` int(12) NOT NULL COMMENT '县区编码',
  `district` int(12) NOT NULL COMMENT '县区编码',
  `year` int(4) NOT NULL,
  `month` int(2) NOT NULL,
  `mmin` decimal(14,2) DEFAULT NULL COMMENT '最小值',
  `minTime` bigint(18) DEFAULT NULL COMMENT '最小值时间',
  `mmax` decimal(14,2) DEFAULT NULL COMMENT '最大值',
  `maxTime` bigint(18) DEFAULT NULL COMMENT '最大值时间',
  `mavg` decimal(14,2) DEFAULT NULL COMMENT '平均值',
  PRIMARY KEY (`id`),
  UNIQUE KEY `district_month_index` (`district`,`year`,`month`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=356161 DEFAULT CHARSET=utf8 COMMENT='县区月最值';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `t_district_online`
--

DROP TABLE IF EXISTS `t_district_online`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_district_online` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `province` int(12) NOT NULL COMMENT '县区编码',
  `city` int(12) NOT NULL COMMENT '县区编码',
  `district` int(12) NOT NULL COMMENT '县区编码',
  `getTime` bigint(18) NOT NULL,
  `p` decimal(14,2) DEFAULT NULL COMMENT '负荷值',
  PRIMARY KEY (`id`),
  UNIQUE KEY `district_online_index` (`district`,`getTime`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=352231815 DEFAULT CHARSET=utf8 COMMENT='县区实时负荷';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `t_holidays`
--

DROP TABLE IF EXISTS `t_holidays`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_holidays` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `start` varchar(18) DEFAULT NULL COMMENT '日期',
  `htype` int(11) DEFAULT NULL COMMENT '类型(1：周末、2：春节、3：清明节 4：劳动节 5：端午节、 6：中秋节 7：国庆节、 8：其它，默认为1)',
  `color` varchar(12) DEFAULT NULL,
  `title` varchar(12) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `t_industry_energy`
--

DROP TABLE IF EXISTS `t_industry_energy`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_industry_energy` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `city` int(12) NOT NULL COMMENT '城市编码',
  `industry` bigint(20) NOT NULL COMMENT '行业1',
  `productId` bigint(20) DEFAULT NULL,
  `getDate` int(12) NOT NULL COMMENT '日期',
  `tpe` decimal(14,2) NOT NULL COMMENT '用电量',
  `price` decimal(12,3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `industry_energy_index` (`city`,`industry`,`getDate`,`productId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=39549689 DEFAULT CHARSET=utf8 COMMENT='行业日用电量';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `t_industry_price`
--

DROP TABLE IF EXISTS `t_industry_price`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_industry_price` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '自动编号',
  `cityId` bigint(20) DEFAULT NULL COMMENT '行业区域编号',
  `industry` bigint(20) DEFAULT NULL COMMENT '行业编号',
  `productId` bigint(20) DEFAULT NULL COMMENT '产品编号',
  `startDate` int(11) DEFAULT NULL COMMENT '开始日期',
  `price` decimal(12,3) DEFAULT NULL COMMENT '价格',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `t_industry_product`
--

DROP TABLE IF EXISTS `t_industry_product`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_industry_product` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `cityId` bigint(12) DEFAULT NULL COMMENT '区域编号',
  `industry` bigint(20) DEFAULT NULL COMMENT '行业',
  `year` int(11) DEFAULT NULL COMMENT '年份',
  `productId` bigint(11) DEFAULT NULL COMMENT '产品编号',
  `minVal` decimal(12,3) DEFAULT NULL COMMENT '最小值(万千瓦时)',
  `maxVal` decimal(12,3) DEFAULT NULL COMMENT '最大值(万千瓦时)',
  `punit` decimal(12,3) DEFAULT NULL COMMENT '产品单耗',
  `capacity` decimal(12,3) DEFAULT NULL COMMENT '产品产能',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `t_monitor_date_ruikang_forecast`
--

DROP TABLE IF EXISTS `t_monitor_date_ruikang_forecast`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_monitor_date_ruikang_forecast` (
  `terminalId` varchar(20) NOT NULL COMMENT '监测点编号',
  `getDate` int(8) NOT NULL COMMENT '预测数据时间yyyyMMdd',
  `tpe` decimal(12,3) DEFAULT NULL COMMENT '预测每日电量',
  PRIMARY KEY (`terminalId`,`getDate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='瑞康监测点日数据预测表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `t_parks_date_m`
--

DROP TABLE IF EXISTS `t_parks_date_m`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_parks_date_m` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `parkId` int(12) NOT NULL COMMENT '园区编码',
  `getDate` int(8) NOT NULL,
  `mmin` decimal(14,2) DEFAULT NULL COMMENT '最小值',
  `minTime` bigint(18) DEFAULT NULL COMMENT '最小值时间',
  `mmax` decimal(14,2) DEFAULT NULL COMMENT '最大值',
  `maxTime` bigint(18) DEFAULT NULL COMMENT '最大值时间',
  `mavg` decimal(14,2) DEFAULT NULL COMMENT '平均值',
  PRIMARY KEY (`id`,`parkId`,`getDate`),
  UNIQUE KEY `park_date_index` (`parkId`,`getDate`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=77270 DEFAULT CHARSET=utf8 COMMENT='园区日最值';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `t_parks_month_m`
--

DROP TABLE IF EXISTS `t_parks_month_m`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_parks_month_m` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `parkId` int(12) NOT NULL COMMENT '园区编码',
  `year` int(4) NOT NULL,
  `month` int(2) NOT NULL,
  `mmin` decimal(14,2) DEFAULT NULL COMMENT '最小值',
  `minTime` bigint(18) DEFAULT NULL COMMENT '最小值时间',
  `mmax` decimal(14,2) DEFAULT NULL COMMENT '最大值',
  `maxTime` bigint(18) DEFAULT NULL COMMENT '最大值时间',
  `mavg` decimal(14,2) DEFAULT NULL COMMENT '平均值',
  PRIMARY KEY (`id`,`parkId`,`year`,`month`),
  UNIQUE KEY `park_year_month` (`parkId`,`year`,`month`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3601 DEFAULT CHARSET=utf8 COMMENT='园区日最值';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `t_parks_online`
--

DROP TABLE IF EXISTS `t_parks_online`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_parks_online` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `parkId` bigint(10) DEFAULT NULL COMMENT '园区编码',
  `getTime` bigint(18) DEFAULT NULL COMMENT '得到数据时间',
  `p` decimal(20,0) DEFAULT NULL COMMENT '数据值',
  PRIMARY KEY (`id`),
  UNIQUE KEY `park_online_index` (`parkId`,`getTime`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3710218 DEFAULT CHARSET=utf8 COMMENT='园区实时负荷';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `t_powerplant_fgp`
--

DROP TABLE IF EXISTS `t_powerplant_fgp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_powerplant_fgp` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `province` int(12) DEFAULT NULL COMMENT '省份编码',
  `city` int(12) DEFAULT NULL COMMENT '城市编码',
  `district` int(12) DEFAULT NULL COMMENT '县区编码',
  `companyId` int(12) DEFAULT NULL COMMENT '企业编号',
  `getDate` int(8) DEFAULT NULL COMMENT '得到数据时间',
  `dtype` int(1) DEFAULT '1' COMMENT '电厂类型(1：自备电厂、2：公共电厂、3：风电、4：太阳能)',
  `ftpe` decimal(12,2) DEFAULT NULL COMMENT '峰电量',
  `ptpe` decimal(12,2) DEFAULT NULL COMMENT '平电量',
  `gtpe` decimal(12,2) DEFAULT NULL COMMENT '谷电量',
  `jtpe` decimal(12,2) DEFAULT NULL COMMENT '尖峰电量',
  PRIMARY KEY (`id`),
  UNIQUE KEY `companyId_getDate_index` (`companyId`,`getDate`,`dtype`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8348 DEFAULT CHARSET=utf8 COMMENT='电厂日电量';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `t_province_date_info`
--

DROP TABLE IF EXISTS `t_province_date_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_province_date_info` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `province` int(11) DEFAULT NULL,
  `getDate` int(11) DEFAULT NULL,
  `etotal` float(14,2) DEFAULT NULL COMMENT '总发电量(万千瓦时)',
  `ewind` float(14,2) DEFAULT NULL COMMENT '风发电量(万千瓦时)',
  `ewater` float(14,2) DEFAULT NULL COMMENT '水发电量(万千瓦时)',
  `epv` float(14,2) DEFAULT NULL COMMENT '光伏发电量(万千瓦时)',
  `usetotal` float(14,2) DEFAULT NULL COMMENT '总用电量(万千瓦时)',
  `esupply` float(14,2) DEFAULT NULL COMMENT '供电量(万千瓦时)',
  `eline` float(14,2) DEFAULT NULL COMMENT '联络线送出电量(万千瓦时)',
  `edc` float(14,2) DEFAULT NULL COMMENT '直流送出电量(万千瓦时)',
  PRIMARY KEY (`id`),
  UNIQUE KEY `province_date_info_index` (`province`,`getDate`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='省日发/用电量信息';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `t_province_date_m`
--

DROP TABLE IF EXISTS `t_province_date_m`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_province_date_m` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `province` int(12) NOT NULL COMMENT '县区编码',
  `getDate` int(8) NOT NULL,
  `mmin` decimal(14,2) DEFAULT NULL COMMENT '最小值',
  `minTime` bigint(18) DEFAULT NULL COMMENT '最小值时间',
  `mmax` decimal(14,2) DEFAULT NULL COMMENT '最大值',
  `maxTime` bigint(18) DEFAULT NULL COMMENT '最大值时间',
  `mavg` decimal(14,2) DEFAULT NULL COMMENT '平均值',
  `gnhfh` decimal(14,2) DEFAULT NULL COMMENT '高能耗负荷',
  `djlfh` decimal(14,2) DEFAULT NULL COMMENT '电解铝负荷',
  PRIMARY KEY (`id`,`province`,`getDate`),
  UNIQUE KEY `province_date_index` (`province`,`getDate`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=994084 DEFAULT CHARSET=utf8 COMMENT='省日最值';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `t_province_month_m`
--

DROP TABLE IF EXISTS `t_province_month_m`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_province_month_m` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `province` int(12) NOT NULL COMMENT '县区编码',
  `year` int(4) NOT NULL,
  `month` int(2) NOT NULL,
  `mmin` decimal(14,2) DEFAULT NULL COMMENT '最小值',
  `minTime` bigint(18) DEFAULT NULL COMMENT '最小值时间',
  `mmax` decimal(14,2) DEFAULT NULL COMMENT '最大值',
  `maxTime` bigint(18) DEFAULT NULL COMMENT '最大值时间',
  `mavg` decimal(14,2) DEFAULT NULL COMMENT '平均值',
  PRIMARY KEY (`id`,`province`,`year`,`month`),
  UNIQUE KEY `province_month_index` (`province`,`year`,`month`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=33396 DEFAULT CHARSET=utf8 COMMENT='省月最值';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `t_province_online`
--

DROP TABLE IF EXISTS `t_province_online`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_province_online` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `province` int(10) DEFAULT NULL COMMENT '省份编码',
  `getTime` bigint(18) DEFAULT NULL COMMENT '得到数据时间',
  `p` decimal(12,2) DEFAULT NULL COMMENT '数据值',
  PRIMARY KEY (`id`),
  UNIQUE KEY `province_online_index` (`province`,`getTime`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=45188740 DEFAULT CHARSET=utf8 COMMENT='省实时负荷';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `t_resident_water`
--

DROP TABLE IF EXISTS `t_resident_water`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_resident_water` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `accounts` bigint(20) NOT NULL COMMENT '用户账户',
  `getDate` int(8) NOT NULL COMMENT '得到数据时间',
  `waterNum` decimal(14,2) DEFAULT NULL COMMENT '用水量',
  PRIMARY KEY (`id`,`accounts`,`getDate`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8 COMMENT='居民日用水量';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2022-01-12 11:11:27