/* Navicat Premium Data Transfer Source Server : 公司pg Source Server Type : PostgreSQL Source Server Version : 180003 (180003) Source Host : 192.168.2.9:5432 Source Catalog : toflymeterdata Source Schema : public Target Server Type : PostgreSQL Target Server Version : 180003 (180003) File Encoding : 65001 Date: 15/04/2026 16:45:50 */ -- ---------------------------- -- Table structure for tofly_nb_data_report -- ---------------------------- DROP TABLE IF EXISTS "public"."tofly_nb_data_report"; CREATE TABLE "public"."tofly_nb_data_report" ( "id" int8 NOT NULL, "device_id" varchar(50) COLLATE "pg_catalog"."default" NOT NULL, "collection_time" varchar(30) COLLATE "pg_catalog"."default" NOT NULL, "mid" int4, "afn" int4, "report_trigger_mode" int4, "total_positive_water" numeric(10,3), "total_reverse_water" numeric(10,3), "daily_max_instant_flow" numeric(10,3), "daily_max_instant_time" varchar(20) COLLATE "pg_catalog"."default", "water_temperature" numeric(5,2), "water_pressure" numeric(5,2) DEFAULT 0.00, "battery_voltage" numeric(5,2), "version" varchar(20) COLLATE "pg_catalog"."default", "diameter" int4, "channel_number" int4, "main_server_ip" varchar(50) COLLATE "pg_catalog"."default", "main_server_port" int4, "sub_server_ip" varchar(50) COLLATE "pg_catalog"."default", "sub_server_port" int4, "report_base_time" varchar(20) COLLATE "pg_catalog"."default", "report_interval_minutes" int4, "dma_report_start_time" varchar(20) COLLATE "pg_catalog"."default", "dma_report_end_time" varchar(20) COLLATE "pg_catalog"."default", "dma_report_interval_minutes" int4, "settlement_day" int4, "high_temperature_alarm_threshold" numeric(5,2), "low_temperature_alarm_threshold" numeric(5,2), "large_flow_alarm_threshold" numeric(10,3), "large_flow_continuous_monitor_time" int4, "continuous_flow_continuous_monitor_time" int4, "leakage_flow_alarm_threshold" numeric(10,3), "leakage_flow_continuous_monitor_time" int4, "high_pressure_alarm_threshold" numeric(5,2) DEFAULT 0.00, "low_pressure_alarm_threshold" numeric(5,2) DEFAULT 0.00, "have_pressure_sensor" int4, "imei" varchar(20) COLLATE "pg_catalog"."default" NOT NULL, "cell_id" int4, "pci" int4, "rsrp" int4, "snr" int4, "csq" int4, "iccid" varchar(30) COLLATE "pg_catalog"."default", "error_no" int4, "create_time" timestamp(6) DEFAULT CURRENT_TIMESTAMP, "update_time" timestamp(6) DEFAULT CURRENT_TIMESTAMP, "create_user" int8, "update_user" int8, "deleted" int4 DEFAULT 0, "is_sync" int2 DEFAULT 0 ) ; COMMENT ON COLUMN "public"."tofly_nb_data_report"."id" IS '主键ID（雪花算法）'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."device_id" IS '设备ID（等于IMEI）'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."collection_time" IS '数据采集时间（等于currentDateTime）'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."mid" IS '消息ID'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."afn" IS 'AFN功能码'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."report_trigger_mode" IS '上报触发模式（1-定时上报，2-事件上报）'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."total_positive_water" IS '累计正向总水量（立方米）'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."total_reverse_water" IS '累计反向总水量（立方米）'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."daily_max_instant_flow" IS '日最高瞬时流量（立方米/小时）'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."daily_max_instant_time" IS '日最高瞬时时间'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."water_temperature" IS '水表当前水温（摄氏度）'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."water_pressure" IS '当前水表压力（MPa）'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."battery_voltage" IS '电池电压（V）'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."version" IS '版本号'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."diameter" IS '水表口径（mm）'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."channel_number" IS '通道数量'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."main_server_ip" IS '主服务器IP'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."main_server_port" IS '主服务器端口'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."sub_server_ip" IS '从服务器IP'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."sub_server_port" IS '从服务器端口'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."report_base_time" IS '上报起始基准时间'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."report_interval_minutes" IS '上报间隔时间（分钟）'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."dma_report_start_time" IS 'DMA上报开始时间'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."dma_report_end_time" IS 'DMA上报结束时间'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."dma_report_interval_minutes" IS 'DMA上报间隔时间（分钟）'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."settlement_day" IS '结算日（1-31）'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."high_temperature_alarm_threshold" IS '高温报警阈值（摄氏度）'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."low_temperature_alarm_threshold" IS '低温报警阈值（摄氏度）'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."large_flow_alarm_threshold" IS '大流量告警阈值（立方米/小时）'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."large_flow_continuous_monitor_time" IS '大流量持续监测时间（秒）'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."continuous_flow_continuous_monitor_time" IS '持续流量持续监测时间（秒）'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."leakage_flow_alarm_threshold" IS '渗漏流量告警阈值（立方米/小时）'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."leakage_flow_continuous_monitor_time" IS '渗漏流量持续监测时间（秒）'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."high_pressure_alarm_threshold" IS '高压力报警阈值（MPa）'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."low_pressure_alarm_threshold" IS '低压力报警阈值（MPa）'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."have_pressure_sensor" IS '是否带水压传感器（0-否，1-是）'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."imei" IS '设备IMEI'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."cell_id" IS '基站ID'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."pci" IS '小区物理ID'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."rsrp" IS '信号功率（dBm）'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."snr" IS '信噪比（dB）'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."csq" IS '信号质量（0-31）'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."iccid" IS 'SIM卡号'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."error_no" IS '异常代码'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."create_time" IS '创建时间'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."update_time" IS '更新时间'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."create_user" IS '创建人'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."update_user" IS '更新人'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."deleted" IS '逻辑删除标志（0-未删除，1-已删除）'; COMMENT ON COLUMN "public"."tofly_nb_data_report"."is_sync" IS '是否同步0否1是'; COMMENT ON TABLE "public"."tofly_nb_data_report" IS '同飞NB-IoT水表数据上报主表';