CREATE STABLE IF NOT EXISTS battery_info (
ts TIMESTAMP,
battery_voltage INT,
battery_current INT,
battery_soc INT,
battery_work_mode NCHAR(32),
battery_error_code NCHAR(50),
battery_temperature_max INT,
battery_temperature_min INT,
battery_voltage_max INT,
battery_voltage_min INT,
mos_status INT,
mos_temp INT,
battery_cycle_times INT,
longitude NCHAR(20),
longitude_direction NCHAR(10),
latitude NCHAR(20),
latitude_direction NCHAR(10),
gps_signal NCHAR(32),
flag INT,
handled INT,
payload NCHAR(800),
imei NCHAR(32),
iccid NCHAR(32),
battery_kind NCHAR(100),
project_id INT,
tracker_software_version NCHAR(32),
battery_soft_version NCHAR(32)
) TAGS (
battery_id NCHAR(32)
); 这是原来的tdengine表;现在要添加private String sn;
private Integer soh;
private String cellVoltage;
private String batteryHardVersion;
private Integer batteryTemperatureAvg;
private Integer chargeCurrentMax;
private Integer dischargeCurrentMax;
private Integer chargeCurrentAvg;
private Integer dischargeCurrentAvg;
private String gpsCog;
private String gpsSpeed;
private Date createTime;
private Date updateTime;这几个字段到该tdengine表中,参照原mysql表ddl设置字段类型:-- bmsapi.my_battery_info definition
CREATE TABLE `my_battery_info` (
`id` int NOT NULL AUTO_INCREMENT,
`battery_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
`battery_voltage` int DEFAULT NULL,
`battery_current` int DEFAULT NULL,
`battery_soc` int DEFAULT NULL,
`battery_hard_version` varchar(32) DEFAULT NULL,
`battery_soft_version` varchar(32) DEFAULT NULL,
`battery_work_mode` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '0x01(1):放电模式 0x10(16):充电模式 0x21(33):保护模式 0x30(48):待机无输出模式 0x31(49):待机预放电模式 0xFF(255):故障需返厂',
`battery_protect_code` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '保护状态 bit16~bit 31 保留 bit15:Gsensor 故障 bit14:BMS 与 Tracker通讯超时 bit13: 预放电失败 bit12: IC保护 bit11: 智能充电通信超时 bit10:压差过大 bit9:温差过大 bit8:短路 bit7:充电过压 bit6:充电过流 bit5:放电欠压 bit4:放电过流 bit3:充电低温 bit2:充电高温 bit1:放电高温 bit0:放电低温',
`battery_error_code` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '转成2进制, 总共为16位,高8位为电池包工作状态,低8位为故障状态码 bit9BMS 与 Tracker通讯故障,bit8BMS 板 G sensor损坏,(8/9无效)bit7:失效,bit6:失衡,bit5:放电 MOS 损坏,bit4:充电 MOS 损坏,bit3IC 损坏,bit2:温度传感器损坏,bit1:采样线断线,虚焊等故障 保留,置 0,bit0:保留',
`battery_temperature_max` int DEFAULT NULL,
`battery_temperature_min` int DEFAULT NULL,
`battery_voltage_max` int DEFAULT NULL,
`battery_voltage_min` int DEFAULT NULL,
`mos_status` int DEFAULT NULL,
`mos_temp` int DEFAULT NULL,
`battery_cycle_times` int DEFAULT NULL,
`steady_status` int DEFAULT NULL,
`cell_voltage` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`model` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`manufacture` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`imei` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`imsi` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`iccid` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`tracker_hardware_version` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`tracker_software_version` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`csq` varchar(32) DEFAULT NULL,
`network_type` varchar(32) DEFAULT NULL,
`location_mode` varchar(8) DEFAULT NULL,
`longitude` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`longitude_direction` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`latitude` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`latitude_direction` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`gps_speed` varchar(32) DEFAULT NULL,
`gps_signal` varchar(32) DEFAULT NULL,
`satellite_num` varchar(32) DEFAULT NULL,
`accuracy` varchar(32) DEFAULT NULL,
`flag` int DEFAULT '1' COMMENT '1:设备主动请求或上报 2:平台主动推送或下指令 3:平台指令反馈的结果',
`client_id` varchar(20) DEFAULT NULL COMMENT 'MQTT发布消息所需的clientId',
`topic` varchar(100) DEFAULT NULL COMMENT 'MQTT主题',
`product_key` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '主题名称中需要的productKey',
`handled` int DEFAULT '0' COMMENT '配置是否处理 1:已处理 0:待处理',
`todo_now` int DEFAULT NULL COMMENT '是否立即执行 0:等待执行 1:立即执行',
`needack` tinyint DEFAULT NULL COMMENT '是否回复',
`businessmode` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '业务模式 1:关机模式 2:运营模式 3:运输模式 4:通讯充电模式 5:盲充模式 6:存储模式 7:搜寻模式 8:返厂模式',
`upload_time` datetime(3) DEFAULT NULL,
`create_time` datetime DEFAULT NULL,
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`payload` varchar(800) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '原始数据',
`project_id` int DEFAULT NULL COMMENT '项目ID',
`sn` varchar(100) DEFAULT NULL COMMENT 'sn码',
`soh` int DEFAULT NULL COMMENT 'soh',
`battery_temperature_avg` int DEFAULT NULL COMMENT '平均温度',
`charge_mode` int DEFAULT NULL COMMENT '充电模式 1--标准充;2--快充;3--盲充;',
`low_battery_warn` int DEFAULT NULL COMMENT '低电量提示 1--低电量告警',
`charge_current_max` int DEFAULT NULL COMMENT '最大充电电流',
`discharge_current_max` int DEFAULT NULL COMMENT '最大放电电流',
`charge_current_avg` int DEFAULT NULL COMMENT '平均充电电流',
`discharge_current_avg` int DEFAULT NULL COMMENT '平均放电电流',
`gps_cog` varchar(32) DEFAULT NULL COMMENT 'Course Over Ground (COG)对地航向角(0~359°)',
`total_charge_energy` decimal(10,1) DEFAULT NULL COMMENT '历史充电总能量',
`charge_cycles_history` int DEFAULT NULL COMMENT '历史充电次数',
`charge_capacity_history` decimal(10,1) DEFAULT NULL COMMENT '历史充电容量',
`discharge_capacity_history` decimal(10,1) DEFAULT NULL COMMENT '历史放电容量',
`ntc1` int DEFAULT NULL,
`ntc2` int DEFAULT NULL,
`ntc3` int DEFAULT NULL,
`ntc4` int DEFAULT NULL,
`tracker_communication_status` varchar(32) DEFAULT NULL,
`battery_kind` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '2' COMMENT '电池类型: 0-运营、1-售后、2-内测、3-报废 4-其他 5-推广 6-认证',
`dsoc` int DEFAULT NULL,
`correction_rate` int DEFAULT NULL COMMENT '修正速率',
`tsoc` int DEFAULT NULL,
`bsoc` int DEFAULT NULL,
`fcc` int DEFAULT NULL,
`actual_soh` int DEFAULT NULL COMMENT '真实soh',
`charging_sop` int DEFAULT NULL COMMENT '充电sop',
`discharging_sop` int DEFAULT NULL COMMENT '放电sop',
`task_max_delay_1ms` int DEFAULT NULL,
`task_max_delay_10ms` int DEFAULT NULL,
`task_max_delay_100ms` int DEFAULT NULL,
`task_max_delay_500ms` int DEFAULT NULL COMMENT '500ms任务最大延时',
`task_max_time_1ms` int DEFAULT NULL,
`task_max_time_10ms` int DEFAULT NULL,
`task_max_time_100ms` int DEFAULT NULL,
`task_max_time_500ms` int DEFAULT NULL COMMENT '500ms任务最大用时',
`empty_count` int DEFAULT NULL COMMENT '未充满计数',
PRIMARY KEY (`id`),
KEY `battery_id` (`battery_id`) USING BTREE,
KEY `my_battery_info_topic_IDX` (`topic`) USING BTREE,
KEY `my_battery_info_sn_IDX` (`sn`) USING BTREE,
KEY `idx_query_conditions` (`project_id`,`flag`,`battery_kind`,`upload_time` DESC),
KEY `my_battery_info_flag_IDX` (`flag`,`upload_time`,`battery_id`) USING BTREE,
KEY `Algorithm_Index` (`battery_id`,`battery_current`,`battery_temperature_max`,`battery_cycle_times`,`cell_voltage`,`upload_time`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10523594 DEFAULT CHARSET=utf8mb3;
最新发布