CREATE TABLE `alarm_indicator_recording2` (
`id` varchar(64) NOT NULL COMMENT 'ID',
`sn_num` varchar(10) DEFAULT NULL COMMENT '网关号',
`num` varchar(64) DEFAULT NULL COMMENT '传感器位号',
`indicator_name` varchar(255) DEFAULT NULL COMMENT '传感器名称',
`indicator_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '传感器检测项',
`indicator_factor` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '传感器检测因子',
`indicator_num` decimal(20,15) DEFAULT NULL COMMENT '数值',
`quality` tinyint(2) DEFAULT NULL COMMENT '设备质量 0 good 1 bad',
`alarm_level` varchar(20) DEFAULT NULL COMMENT '报警级别',
`alarm_location` varchar(255) DEFAULT NULL COMMENT '报警位置(报警的设备名称)',
`create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建人',
`create_time` datetime NOT NULL COMMENT '创建时间',
`update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '更新人',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`del_flag` int(3) NOT NULL COMMENT '是否删除 0:未删除1:已删除',
`description` varchar(255) DEFAULT NULL COMMENT '描述(设备设施类型+几级报警)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='传感器管理表'
PARTITION BY RANGE(TO_DAYS(create_time))(
PARTITION p2404 VALUES LESS THAN (TO_DAYS('2024-04-01')),
PARTITION p2405 VALUES LESS THAN (TO_DAYS('2024-05-01')),
PARTITION p2406 VALUES LESS THAN (TO_DAYS('2024-06-01')),
PARTITION p2407 VALUES LESS THAN (TO_DAYS('2024-07-01')),
PARTITION p2408 VALUES LESS THAN (TO_DAYS('2024-08-01')),
PARTITION p2409 VALUES LESS THAN (TO_DAYS('2024-09-01')),
PARTITION p2410 VALUES LESS THAN (TO_DAYS('2024-10-01')),
PARTITION p2411 VALUES LESS THAN (TO_DAYS('2024-11-01')),
PARTITION p2412 VALUES LESS THAN (TO_DAYS('2024-12-01')),
PARTITION p2501 VALUES LESS THAN (TO_DAYS('2025-01-01')),
PARTITION p2502 VALUES LESS THAN (TO_DAYS('2025-02-01')),
PARTITION p2503 VALUES LESS THAN (TO_DAYS('2025-03-01')),
PARTITION p2504 VALUES LESS THAN (TO_DAYS('2025-04-01')),
PARTITION p2505 VALUES LESS THAN (TO_DAYS('2025-05-01')),
PARTITION p2506 VALUES LESS THAN (TO_DAYS('2025-06-01')),
PARTITION p2507 VALUES LESS THAN (TO_DAYS('2025-07-01')),
PARTITION p2508 VALUES LESS THAN (TO_DAYS('2025-08-01')),
PARTITION p2509 VALUES LESS THAN (TO_DAYS('2025-09-01')),
PARTITION p2510 VALUES LESS THAN (TO_DAYS('2025-10-01')),
PARTITION p2511 VALUES LESS THAN (TO_DAYS('2025-11-01')),
PARTITION p2512 VALUES LESS THAN (TO_DAYS('2025-12-01')),
PARTITION p2601 VALUES LESS THAN (TO_DAYS('2026-01-01')),
PARTITION p2602 VALUES LESS THAN (TO_DAYS('2026-02-01')),
PARTITION p2603 VALUES LESS THAN (TO_DAYS('2026-03-01')),
PARTITION p2604 VALUES LESS THAN (TO_DAYS('2026-04-01')),
PARTITION p2605 VALUES LESS THAN (TO_DAYS('2026-05-01')),
PARTITION p2606 VALUES LESS THAN (TO_DAYS('2026-06-01')),
PARTITION p2607 VALUES LESS THAN (TO_DAYS('2026-07-01')),
PARTITION p2608 VALUES LESS THAN (TO_DAYS('2026-08-01')),
PARTITION p2609 VALUES LESS THAN (TO_DAYS('2026-09-01')),
PARTITION p2610 VALUES LESS THAN (TO_DAYS('2026-10-01')),
PARTITION p2611 VALUES LESS THAN (TO_DAYS('2026-11-01')),
PARTITION p2612 VALUES LESS THAN (TO_DAYS('2026-12-01')),
PARTITION p2701 VALUES LESS THAN (TO_DAYS('2027-01-01')),
PARTITION p2702 VALUES LESS THAN (TO_DAYS('2027-02-01')),
PARTITION p2703 VALUES LESS THAN (TO_DAYS('2027-03-01')),
PARTITION p2704 VALUES LESS THAN (TO_DAYS('2027-04-01')),
PARTITION p2705 VALUES LESS THAN (TO_DAYS('2027-05-01')),
PARTITION p2706 VALUES LESS THAN (TO_DAYS('2027-06-01')),
PARTITION p2707 VALUES LESS THAN (TO_DAYS('2027-07-01')),
PARTITION p2708 VALUES LESS THAN (TO_DAYS('2027-08-01')),
PARTITION p2709 VALUES LESS THAN (TO_DAYS('2027-09-01')),
PARTITION p2710 VALUES LESS THAN (TO_DAYS('2027-10-01')),
PARTITION p2711 VALUES LESS THAN (TO_DAYS('2027-11-01')),
PARTITION p2712 VALUES LESS THAN (TO_DAYS('2027-12-01')),
PARTITION p2801 VALUES LESS THAN (TO_DAYS('2028-01-01')),
PARTITION p2802 VALUES LESS THAN (TO_DAYS('2028-02-01')),
PARTITION p2803 VALUES LESS THAN (TO_DAYS('2028-03-01')),
PARTITION p2804 VALUES LESS THAN (TO_DAYS('2028-04-01')),
PARTITION p2805 VALUES LESS THAN (TO_DAYS('2028-05-01')),
PARTITION p2806 VALUES LESS THAN (TO_DAYS('2028-06-01')),
PARTITION p2807 VALUES LESS THAN (TO_DAYS('2028-07-01')),
PARTITION p2808 VALUES LESS THAN (TO_DAYS('2028-08-01')),
PARTITION p2809 VALUES LESS THAN (TO_DAYS('2028-09-01')),
PARTITION p2810 VALUES LESS THAN (TO_DAYS('2028-10-01')),
PARTITION p2811 VALUES LESS THAN (TO_DAYS('2028-11-01')),
PARTITION p2812 VALUES LESS THAN (TO_DAYS('2028-12-01')),
PARTITION p2901 VALUES LESS THAN (TO_DAYS('2029-01-01')),
PARTITION p2902 VALUES LESS THAN (TO_DAYS('2029-02-01')),
PARTITION p2903 VALUES LESS THAN (TO_DAYS('2029-03-01')),
PARTITION p2904 VALUES LESS THAN (TO_DAYS('2029-04-01')),
PARTITION p2905 VALUES LESS THAN (TO_DAYS('2029-05-01')),
PARTITION p2906 VALUES LESS THAN (TO_DAYS('2029-06-01')),
PARTITION p2907 VALUES LESS THAN (TO_DAYS('2029-07-01')),
PARTITION p2908 VALUES LESS THAN (TO_DAYS('2029-08-01')),
PARTITION p2909 VALUES LESS THAN (TO_DAYS('2029-09-01')),
PARTITION p2910 VALUES LESS THAN (TO_DAYS('2029-10-01')),
PARTITION p2911 VALUES LESS THAN (TO_DAYS('2029-11-01')),
PARTITION p2912 VALUES LESS THAN (TO_DAYS('2029-12-01')),
PARTITION p3001 VALUES LESS THAN (TO_DAYS('2030-01-01')),
PARTITION p3002 VALUES LESS THAN (TO_DAYS('2030-02-01')),
PARTITION p3003 VALUES LESS THAN (TO_DAYS('2030-03-01')),
PARTITION p3004 VALUES LESS THAN (TO_DAYS('2030-04-01')),
PARTITION p3005 VALUES LESS THAN (TO_DAYS('2030-05-01')),
PARTITION p3006 VALUES LESS THAN (TO_DAYS('2030-06-01')),
PARTITION p3007 VALUES LESS THAN (TO_DAYS('2030-07-01')),
PARTITION p3008 VALUES LESS THAN (TO_DAYS('2030-08-01')),
PARTITION p3009 VALUES LESS THAN (TO_DAYS('2030-09-01')),
PARTITION p3010 VALUES LESS THAN (TO_DAYS('2030-10-01')),
PARTITION p3011 VALUES LESS THAN (TO_DAYS('2030-11-01')),
PARTITION p3012 VALUES LESS THAN (TO_DAYS('2030-12-01')),
PARTITION p3101 VALUES LESS THAN (TO_DAYS('2031-01-01')),
PARTITION p3102 VALUES LESS THAN (TO_DAYS('2031-02-01')),
PARTITION p3103 VALUES LESS THAN (TO_DAYS('2031-03-01')),
PARTITION p3104 VALUES LESS THAN (TO_DAYS('2031-04-01')),
PARTITION p3105 VALUES LESS THAN (TO_DAYS('2031-05-01')),
PARTITION p3106 VALUES LESS THAN (TO_DAYS('2031-06-01')),
PARTITION p3107 VALUES LESS THAN (TO_DAYS('2031-07-01')),
PARTITION p3108 VALUES LESS THAN (TO_DAYS('2031-08-01')),
PARTITION p3109 VALUES LESS THAN (TO_DAYS('2031-09-01')),
PARTITION p3110 VALUES LESS THAN (TO_DAYS('2031-10-01')),
PARTITION p3111 VALUES LESS THAN (TO_DAYS('2031-11-01')),
PARTITION p3112 VALUES LESS THAN (TO_DAYS('2031-12-01')),
PARTITION p3201 VALUES LESS THAN (TO_DAYS('2032-01-01')),
PARTITION p3202 VALUES LESS THAN (TO_DAYS('2032-02-01')),
PARTITION p3203 VALUES LESS THAN (TO_DAYS('2032-03-01')),
PARTITION p3204 VALUES LESS THAN (TO_DAYS('2032-04-01')),
PARTITION p3205 VALUES LESS THAN (TO_DAYS('2032-05-01')),
PARTITION p3206 VALUES LESS THAN (TO_DAYS('2032-06-01')),
PARTITION p3207 VALUES LESS THAN (TO_DAYS('2032-07-01')),
PARTITION p3208 VALUES LESS THAN (TO_DAYS('2032-08-01')),
PARTITION p3209 VALUES LESS THAN (TO_DAYS('2032-09-01')),
PARTITION p3210 VALUES LESS THAN (TO_DAYS('2032-10-01')),
PARTITION p3211 VALUES LESS THAN (TO_DAYS('2032-11-01')),
PARTITION p3212 VALUES LESS THAN (TO_DAYS('2032-12-01')),
PARTITION p3301 VALUES LESS THAN (TO_DAYS('2033-01-01')),
PARTITION p3302 VALUES LESS THAN (TO_DAYS('2033-02-01')),
PARTITION p3303 VALUES LESS THAN (TO_DAYS('2033-03-01')),
PARTITION p3304 VALUES LESS THAN (TO_DAYS('2033-04-01')),
PARTITION p3305 VALUES LESS THAN (TO_DAYS('2033-05-01')),
PARTITION p3306 VALUES LESS THAN (TO_DAYS('2033-06-01')),
PARTITION p3307 VALUES LESS THAN (TO_DAYS('2033-07-01')),
PARTITION p3308 VALUES LESS THAN (TO_DAYS('2033-08-01')),
PARTITION p3309 VALUES LESS THAN (TO_DAYS('2033-09-01')),
PARTITION p3310 VALUES LESS THAN (TO_DAYS('2033-10-01')),
PARTITION p3311 VALUES LESS THAN (TO_DAYS('2033-11-01')),
PARTITION p3312 VALUES LESS THAN (TO_DAYS('2033-12-01')),
PARTITION p3401 VALUES LESS THAN (TO_DAYS('2034-01-01')),
PARTITION p3402 VALUES LESS THAN (TO_DAYS('2034-02-01')),
PARTITION p3403 VALUES LESS THAN (TO_DAYS('2034-03-01')),
PARTITION p3404 VALUES LESS THAN (TO_DAYS('2034-04-01')),
PARTITION p3405 VALUES LESS THAN (TO_DAYS('2034-05-01')),
PARTITION p3406 VALUES LESS THAN (TO_DAYS('2034-06-01')),
PARTITION p3407 VALUES LESS THAN (TO_DAYS('2034-07-01')),
PARTITION p3408 VALUES LESS THAN (TO_DAYS('2034-08-01')),
PARTITION p3409 VALUES LESS THAN (TO_DAYS('2034-09-01')),
PARTITION p3410 VALUES LESS THAN (TO_DAYS('2034-10-01')),
PARTITION p3411 VALUES LESS THAN (TO_DAYS('2034-11-01')),
PARTITION p3412 VALUES LESS THAN (TO_DAYS('2034-12-01')),
PARTITION p3501 VALUES LESS THAN (TO_DAYS('2035-01-01')),
PARTITION p3502 VALUES LESS THAN (TO_DAYS('2035-02-01')),
PARTITION p3503 VALUES LESS THAN (TO_DAYS('2035-03-01')),
PARTITION p3504 VALUES LESS THAN (TO_DAYS('2035-04-01')),
PARTITION p3505 VALUES LESS THAN (TO_DAYS('2035-05-01')),
PARTITION p3506 VALUES LESS THAN (TO_DAYS('2035-06-01')),
PARTITION p3507 VALUES LESS THAN (TO_DAYS('2035-07-01')),
PARTITION p3508 VALUES LESS THAN (TO_DAYS('2035-08-01')),
PARTITION p3509 VALUES LESS THAN (TO_DAYS('2035-09-01')),
PARTITION p3510 VALUES LESS THAN (TO_DAYS('2035-10-01')),
PARTITION p3511 VALUES LESS THAN (TO_DAYS('2035-11-01')),
PARTITION p3512 VALUES LESS THAN (TO_DAYS('2035-12-01')),
PARTITION p3601 VALUES LESS THAN (TO_DAYS('2036-01-01')),
PARTITION p3602 VALUES LESS THAN (TO_DAYS('2036-02-01')),
PARTITION p3603 VALUES LESS THAN (TO_DAYS('2036-03-01')),
PARTITION p3604 VALUES LESS THAN (TO_DAYS('2036-04-01')),
PARTITION p3605 VALUES LESS THAN (TO_DAYS('2036-05-01')),
PARTITION p3606 VALUES LESS THAN (TO_DAYS('2036-06-01')),
PARTITION p3607 VALUES LESS THAN (TO_DAYS('2036-07-01')),
PARTITION p3608 VALUES LESS THAN (TO_DAYS('2036-08-01')),
PARTITION p3609 VALUES LESS THAN (TO_DAYS('2036-09-01')),
PARTITION p3610 VALUES LESS THAN (TO_DAYS('2036-10-01')),
PARTITION p3611 VALUES LESS THAN (TO_DAYS('2036-11-01')),
PARTITION p3612 VALUES LESS THAN (TO_DAYS('2036-12-01')),
PARTITION p3701 VALUES LESS THAN (TO_DAYS('2037-01-01')),
PARTITION p3702 VALUES LESS THAN (TO_DAYS('2037-02-01')),
PARTITION p3703 VALUES LESS THAN (TO_DAYS('2037-03-01')),
PARTITION p3704 VALUES LESS THAN (TO_DAYS('2037-04-01')),
PARTITION p3705 VALUES LESS THAN (TO_DAYS('2037-05-01')),
PARTITION p3706 VALUES LESS THAN (TO_DAYS('2037-06-01')),
PARTITION p3707 VALUES LESS THAN (TO_DAYS('2037-07-01')),
PARTITION p3708 VALUES LESS THAN (TO_DAYS('2037-08-01')),
PARTITION p3709 VALUES LESS THAN (TO_DAYS('2037-09-01')),
PARTITION p3710 VALUES LESS THAN (TO_DAYS('2037-10-01')),
PARTITION p3711 VALUES LESS THAN (TO_DAYS('2037-11-01')),
PARTITION p3712 VALUES LESS THAN (TO_DAYS('2037-12-01')),
PARTITION p3801 VALUES LESS THAN (TO_DAYS('2038-01-01')),
PARTITION p3802 VALUES LESS THAN (TO_DAYS('2038-02-01')),
PARTITION p3803 VALUES LESS THAN (TO_DAYS('2038-03-01')),
PARTITION p3804 VALUES LESS THAN (TO_DAYS('2038-04-01')),
PARTITION p3805 VALUES LESS THAN (TO_DAYS('2038-05-01')),
PARTITION p3806 VALUES LESS THAN (TO_DAYS('2038-06-01')),
PARTITION p3807 VALUES LESS THAN (TO_DAYS('2038-07-01')),
PARTITION p3808 VALUES LESS THAN (TO_DAYS('2038-08-01')),
PARTITION p3809 VALUES LESS THAN (TO_DAYS('2038-09-01')),
PARTITION p3810 VALUES LESS THAN (TO_DAYS('2038-10-01')),
PARTITION p3811 VALUES LESS THAN (TO_DAYS('2038-11-01')),
PARTITION p3812 VALUES LESS THAN (TO_DAYS('2038-12-01')),
PARTITION p3901 VALUES LESS THAN (TO_DAYS('2039-01-01')),
PARTITION p3902 VALUES LESS THAN (TO_DAYS('2039-02-01')),
PARTITION p3903 VALUES LESS THAN (TO_DAYS('2039-03-01')),
PARTITION p3904 VALUES LESS THAN (TO_DAYS('2039-04-01')),
PARTITION p3905 VALUES LESS THAN (TO_DAYS('2039-05-01')),
PARTITION p3906 VALUES LESS THAN (TO_DAYS('2039-06-01')),
PARTITION p3907 VALUES LESS THAN (TO_DAYS('2039-07-01')),
PARTITION p3908 VALUES LESS THAN (TO_DAYS('2039-08-01')),
PARTITION p3909 VALUES LESS THAN (TO_DAYS('2039-09-01')),
PARTITION p3910 VALUES LESS THAN (TO_DAYS('2039-10-01')),
PARTITION p3911 VALUES LESS THAN (TO_DAYS('2039-11-01')),
PARTITION p3912 VALUES LESS THAN (TO_DAYS('2039-12-01')),
PARTITION p4001 VALUES LESS THAN (TO_DAYS('2040-01-01')),
PARTITION p4002 VALUES LESS THAN (TO_DAYS('2040-02-01')),
PARTITION p4003 VALUES LESS THAN (TO_DAYS('2040-03-01')),
PARTITION p4004 VALUES LESS THAN (TO_DAYS('2040-04-01')),
PARTITION p4005 VALUES LESS THAN (TO_DAYS('2040-05-01')),
PARTITION p4006 VALUES LESS THAN (TO_DAYS('2040-06-01')),
PARTITION p4007 VALUES LESS THAN (TO_DAYS('2040-07-01')),
PARTITION p4008 VALUES LESS THAN (TO_DAYS('2040-08-01')),
PARTITION p4009 VALUES LESS THAN (TO_DAYS('2040-09-01')),
PARTITION p4010 VALUES LESS THAN (TO_DAYS('2040-10-01')),
PARTITION p4011 VALUES LESS THAN (TO_DAYS('2040-11-01')),
PARTITION p4012 VALUES LESS THAN (TO_DAYS('2040-12-01'))
);
最后修改:2024 年 05 月 13 日
© 允许规范转载