56,912
社区成员




CREATE TABLE `t_daq_arc_point_day` (
`POINTID` decimal(19,0) NOT NULL COMMENT '测点ID',
`DATADAY` decimal(8,0) NOT NULL COMMENT '日期',
`DAYVAL` decimal(22,6) DEFAULT NULL COMMENT '日值',
`POINT1` decimal(22,6) DEFAULT NULL COMMENT '00:15',
`POINT2` decimal(22,6) DEFAULT NULL COMMENT '00:30',
`POINT3` decimal(22,6) DEFAULT NULL COMMENT '00:45',
`POINT4` decimal(22,6) DEFAULT NULL COMMENT '01:00',
`POINT5` decimal(22,6) DEFAULT NULL COMMENT '01:15',
`POINT6` decimal(22,6) DEFAULT NULL COMMENT '01:30',
`POINT7` decimal(22,6) DEFAULT NULL COMMENT '01:45',
`POINT8` decimal(22,6) DEFAULT NULL COMMENT '02:00',
`POINT9` decimal(22,6) DEFAULT NULL COMMENT '02:15',
`POINT10` decimal(22,6) DEFAULT NULL COMMENT '02:30',
`POINT11` decimal(22,6) DEFAULT NULL COMMENT '02:45',
`POINT12` decimal(22,6) DEFAULT NULL COMMENT '03:00',
`POINT13` decimal(22,6) DEFAULT NULL COMMENT '03:15',
`POINT14` decimal(22,6) DEFAULT NULL COMMENT '03:30',
`POINT15` decimal(22,6) DEFAULT NULL COMMENT '03:45',
`POINT16` decimal(22,6) DEFAULT NULL COMMENT '04:00',
`POINT17` decimal(22,6) DEFAULT NULL COMMENT '04:15',
`POINT18` decimal(22,6) DEFAULT NULL COMMENT '04:30',
`POINT19` decimal(22,6) DEFAULT NULL COMMENT '04:45',
`POINT20` decimal(22,6) DEFAULT NULL COMMENT '05:00',
`POINT21` decimal(22,6) DEFAULT NULL COMMENT '05:15',
`POINT22` decimal(22,6) DEFAULT NULL COMMENT '05:30',
`POINT23` decimal(22,6) DEFAULT NULL COMMENT '05:45',
`POINT24` decimal(22,6) DEFAULT NULL COMMENT '06:00',
`POINT25` decimal(22,6) DEFAULT NULL COMMENT '06:15',
`POINT26` decimal(22,6) DEFAULT NULL COMMENT '06:30',
`POINT27` decimal(22,6) DEFAULT NULL COMMENT '06:45',
`POINT28` decimal(22,6) DEFAULT NULL COMMENT '07:00',
`POINT29` decimal(22,6) DEFAULT NULL COMMENT '07:15',
`POINT30` decimal(22,6) DEFAULT NULL COMMENT '07:30',
`POINT31` decimal(22,6) DEFAULT NULL COMMENT '07:45',
`POINT32` decimal(22,6) DEFAULT NULL COMMENT '08:00',
`POINT33` decimal(22,6) DEFAULT NULL COMMENT '08:15',
`POINT34` decimal(22,6) DEFAULT NULL COMMENT '08:30',
`POINT35` decimal(22,6) DEFAULT NULL COMMENT '08:45',
`POINT36` decimal(22,6) DEFAULT NULL COMMENT '09:00',
`POINT37` decimal(22,6) DEFAULT NULL COMMENT '09:15',
`POINT38` decimal(22,6) DEFAULT NULL COMMENT '09:30',
`POINT39` decimal(22,6) DEFAULT NULL COMMENT '09::45',
`POINT40` decimal(22,6) DEFAULT NULL COMMENT '10:00',
`POINT41` decimal(22,6) DEFAULT NULL COMMENT '10:15',
`POINT42` decimal(22,6) DEFAULT NULL COMMENT '10:30',
`POINT43` decimal(22,6) DEFAULT NULL COMMENT '10:45',
`POINT44` decimal(22,6) DEFAULT NULL COMMENT '11:00',
`POINT45` decimal(22,6) DEFAULT NULL COMMENT '11:15',
`POINT46` decimal(22,6) DEFAULT NULL COMMENT '11:30',
`POINT47` decimal(22,6) DEFAULT NULL COMMENT '11:45',
`POINT48` decimal(22,6) DEFAULT NULL COMMENT '12:00',
`POINT49` decimal(22,6) DEFAULT NULL COMMENT '12:15',
`POINT50` decimal(22,6) DEFAULT NULL COMMENT '12:30',
`POINT51` decimal(22,6) DEFAULT NULL COMMENT '12:45',
`POINT52` decimal(22,6) DEFAULT NULL COMMENT '13:00',
`POINT53` decimal(22,6) DEFAULT NULL COMMENT '13:15',
`POINT54` decimal(22,6) DEFAULT NULL COMMENT '13:30',
`POINT55` decimal(22,6) DEFAULT NULL COMMENT '13:45',
`POINT56` decimal(22,6) DEFAULT NULL COMMENT '14:00',
`POINT57` decimal(22,6) DEFAULT NULL COMMENT '14:15',
`POINT58` decimal(22,6) DEFAULT NULL COMMENT '14:30',
`POINT59` decimal(22,6) DEFAULT NULL COMMENT '14:45',
`POINT60` decimal(22,6) DEFAULT NULL COMMENT '15:00',
`POINT61` decimal(22,6) DEFAULT NULL COMMENT '15:15',
`POINT62` decimal(22,6) DEFAULT NULL COMMENT '15:30',
`POINT63` decimal(22,6) DEFAULT NULL COMMENT '15:45',
`POINT64` decimal(22,6) DEFAULT NULL COMMENT '16:00',
`POINT65` decimal(22,6) DEFAULT NULL COMMENT '16:15',
`POINT66` decimal(22,6) DEFAULT NULL COMMENT '16:30',
`POINT67` decimal(22,6) DEFAULT NULL COMMENT '16:45',
`POINT68` decimal(22,6) DEFAULT NULL COMMENT '17:00',
`POINT69` decimal(22,6) DEFAULT NULL COMMENT '17:15',
`POINT70` decimal(22,6) DEFAULT NULL COMMENT '17:30',
`POINT71` decimal(22,6) DEFAULT NULL COMMENT '17:45',
`POINT72` decimal(22,6) DEFAULT NULL COMMENT '18:00',
`POINT73` decimal(22,6) DEFAULT NULL COMMENT '18:15',
`POINT74` decimal(22,6) DEFAULT NULL COMMENT '18:30',
`POINT75` decimal(22,6) DEFAULT NULL COMMENT '18:45',
`POINT76` decimal(22,6) DEFAULT NULL COMMENT '19:00',
`POINT77` decimal(22,6) DEFAULT NULL COMMENT '19:15',
`POINT78` decimal(22,6) DEFAULT NULL COMMENT '19:30',
`POINT79` decimal(22,6) DEFAULT NULL COMMENT '19:45',
`POINT80` decimal(22,6) DEFAULT NULL COMMENT '20:00',
`POINT81` decimal(22,6) DEFAULT NULL COMMENT '20:15',
`POINT82` decimal(22,6) DEFAULT NULL COMMENT '20:30',
`POINT83` decimal(22,6) DEFAULT NULL COMMENT '20:45',
`POINT84` decimal(22,6) DEFAULT NULL COMMENT '21:00',
`POINT85` decimal(22,6) DEFAULT NULL COMMENT '21:15',
`POINT86` decimal(22,6) DEFAULT NULL COMMENT '21:30',
`POINT87` decimal(22,6) DEFAULT NULL COMMENT '21:45',
`POINT88` decimal(22,6) DEFAULT NULL COMMENT '22:00',
`POINT89` decimal(22,6) DEFAULT NULL COMMENT '22:15',
`POINT90` decimal(22,6) DEFAULT NULL COMMENT '22:30',
`POINT91` decimal(22,6) DEFAULT NULL COMMENT '22:45',
`POINT92` decimal(22,6) DEFAULT NULL COMMENT '23:00',
`POINT93` decimal(22,6) DEFAULT NULL COMMENT '23:15',
`POINT94` decimal(22,6) DEFAULT NULL COMMENT '23:30',
`POINT95` decimal(22,6) DEFAULT NULL COMMENT '23:45',
`POINT96` decimal(22,6) DEFAULT NULL COMMENT '24:00',
PRIMARY KEY (`POINTID`,`DATADAY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='测量参数日曲线统计表';
INSERT INTO `t_daq_arc_point_day` VALUES (10001, 20171024, 24.000000, 1.000000, 2.000000, 3.000000, 4.000000, 5.000000, 6.000000, 7.000000, 8.000000, 9.000000, 10.000000, 11.000000, 12.000000, 13.000000, 14.000000, 15.000000, 16.000000, 17.000000, 18.000000, 19.000000, 20.000000, 21.000000, 22.000000, 23.000000, 24.000000, 25.000000, 26.000000, 27.000000, 28.000000, 29.000000, 30.000000, 31.000000, 32.000000, 33.000000, 34.000000, 35.000000, 36.000000, 37.000000, 38.000000, 39.000000, 40.000000, 41.000000, 42.000000, 43.000000, 44.000000, 45.000000, 46.000000, 47.000000, 48.000000, 49.000000, 50.000000, 51.000000, 52.000000, 53.000000, 54.000000, 55.000000, 56.000000, 57.000000, 58.000000, 59.000000, 60.000000, 61.000000, 62.000000, 63.000000, 64.000000, 65.000000, 66.000000, 67.000000, 68.000000, 69.000000, 70.000000, 71.000000, 72.000000, 73.000000, 74.000000, 75.000000, 76.000000, 77.000000, 78.000000, 79.000000, 80.000000, 81.000000, 82.000000, 83.000000, 84.000000, 85.000000, 86.000000, 87.000000, 88.000000, 89.000000, 90.000000, 91.000000, 92.000000, 93.000000, 94.000000, 95.000000, 96.000000);