bt_iot_space

配电指标

-- bt_iot_space.iot_network_dicator_report definition

CREATE TABLE `iot_network_dicator_report` (
  `ndd_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '指标编码',
  `ndd_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '指标代码',
  `data_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '数据时间',
  `indicators` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '关键指标',
  `formula` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '公式',
  `unit` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '单位',
  `constraints` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '约束性',
  `area_rate0` decimal(6,3) DEFAULT NULL COMMENT '全市',
  `area_rate1` decimal(6,3) DEFAULT NULL COMMENT '区域1',
  `area_rate2` decimal(6,3) DEFAULT NULL COMMENT '区域2',
  `area_rate3` decimal(6,3) DEFAULT NULL COMMENT '区域3',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
  `modify_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  `create_user_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建用户',
  `modify_user_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改用户',
  `audit_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '审核时间',
  `audit_status` int DEFAULT '0' COMMENT '审核状态  0=停用，1=正常（审核通过） 2=待审核 3=驳回',
  `audit_user_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核用户',
  `audit_opinion` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '审核意见',
  `sys_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '所属系统',
  `area_rate4` decimal(6,3) DEFAULT NULL COMMENT '区域4',
  `area_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '行政区码',
  `area_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '行政区名',
  `parent_area_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '上级行政区码',
  `parent_area_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '上级行政区名',
  `area_rate5` decimal(6,3) DEFAULT NULL COMMENT '区域5',
  `area_rate6` decimal(6,3) DEFAULT NULL COMMENT '区域6',
  `area_rate7` decimal(6,3) DEFAULT NULL COMMENT '区域6',
  `area_rate8` decimal(6,3) DEFAULT NULL COMMENT '区域7',
  `area_rate9` decimal(6,3) DEFAULT NULL COMMENT '区域8',
  `area_rate10` decimal(6,3) DEFAULT NULL COMMENT '区域9',
  `area_rate11` decimal(6,3) DEFAULT NULL COMMENT '区域10',
  `area_rate12` decimal(6,3) DEFAULT NULL COMMENT '区域11',
  `area_rate13` decimal(6,3) DEFAULT NULL COMMENT '区域12',
  `area_rate14` decimal(6,3) DEFAULT NULL COMMENT '区域13',
  `area_rate15` decimal(6,3) DEFAULT NULL COMMENT '区域14',
  PRIMARY KEY (`ndd_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='年度配网指标';