From 00c06374dc63c9be5114d38e224204d3e171dda7 Mon Sep 17 00:00:00 2001 From: Administrator <1525436766@qq.com> Date: 星期一, 19 六月 2023 15:36:08 +0800 Subject: [PATCH] CREATE TABLE `tb_battinf_update_record` ( `num` int(11) NOT NULL AUTO_INCREMENT, `record_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00', `update_reason` text COMMENT '电池信息更改原因', `update_name` varchar(20) DEFAULT ' ' COMMENT '更改人', `StationId` varchar(20) DEFAULT '0', `StationId_ex` varchar(20) DEFAULT '0', `StationName` varchar(100) DEFAULT ' ', `StationName1` varchar(100) DEFAULT ' ', `StationName2` varchar(100) DEFAULT ' ', `StationName3` varchar(100) DEFAULT ' ', `StationName4` varchar(100) DEFAULT ' ', `StationName5` varchar(100) DEFAULT ' ', `StationName6` varchar(100) DEFAULT ' ', `StationName7` varchar(100) DEFAULT ' ', `StationName8` varchar(100) DEFAULT ' ', `StationName9` varchar(100) DEFAULT ' ', `StationIP` varchar(20) DEFAULT '0', `FBSDeviceId` bigint(11) DEFAULT '0', `FBSDeviceIp` varchar(50) DEFAULT '192.168.0.88', `FBSDeviceIp_WG` varchar(64) DEFAULT '192.168.0.1', `FBSDeviceIp_YM` varchar(64) DEFAULT '255.255.255.0', `FBSDeviceName` varchar(100) DEFAULT '0', `GroupIndexInFBSDevice` int(11) DEFAULT '0', `BattModel` varchar(100) DEFAULT ' ', `BattGroupId` int(11) DEFAULT '0', `BattGroupNum` int(11) DEFAULT '0', `BattGroupName` varchar(100) DEFAULT ' ', `BattGroupName1` varchar(100) DEFAULT ' ', `BattGroupName2` varchar(100) DEFAULT ' ', `BattGroupName3` varchar(100) DEFAULT ' ', `BattGroupName4` varchar(100) DEFAULT ' ', `BattGroupName5` varchar(100) DEFAULT ' ', `BattGroupName6` varchar(100) DEFAULT ' ', `FloatVolLevel` float DEFAULT '1.12', `OfflineVolLevel` float DEFAULT '1.06', `BattFloatCurrent` float DEFAULT '0', `DeviceId` varchar(20) DEFAULT '0', `DeviceName` varchar(100) DEFAULT '0', `MonCount` int(11) DEFAULT '0', `MonCapStd` float DEFAULT '0', `MonVolStd` float DEFAULT '0', `MonResStd` float DEFAULT '0', `MonSerStd` float DEFAULT '0', `MonTmpStd` float DEFAULT '0', `MonVolLowToAvg` float DEFAULT '0', `MonNum` int(11) DEFAULT '0', `BattProducer` varchar(45) DEFAULT '0', `BattProductDate` date DEFAULT '2006-07-06', `BattInUseDate` date DEFAULT '2006-07-06', `BattGuarantDayCount` int(11) DEFAULT '1095', `SignalId` varchar(20) DEFAULT '0', `CInterFaceId` int(11) DEFAULT '0', `SignalName` varchar(50) DEFAULT '0', `Load_curr` float DEFAULT '15', `DisCurrMax` float DEFAULT '0', `station_phone` varchar(32) DEFAULT '', `station_install` tinyint(1) DEFAULT '0', `install_user` varchar(64) DEFAULT '', `charge_curr_max` float DEFAULT '20', `Vol_grade` float DEFAULT '0', `Manufacturers` varchar(64) DEFAULT '', `Assetequipment` varchar(64) DEFAULT '', `Deviceclasspath` varchar(64) DEFAULT '', `DeviceOperationDepartment` varchar(64) DEFAULT '', `PropertyRightUnit` varchar(64) DEFAULT '', `PropertyAttribute` varchar(64) DEFAULT '', `FactoryNumber` varchar(64) DEFAULT '', `OperationTeam` varchar(64) DEFAULT '', `DeviceIdentityCode` varchar(64) DEFAULT '', `ProjectType` varchar(64) DEFAULT '', `BatteryApplicationType` varchar(64) DEFAULT '', `SingleRatedVoltage` float DEFAULT '0', `RemoteMonitor` varchar(64) DEFAULT '', `BatttIndependentPlaced` varchar(64) DEFAULT '', `JunChargeVoltageValue` float DEFAULT '0', `PublicKeyX` varchar(200) DEFAULT '', `PublicKeyY` varchar(200) DEFAULT '', `KeyID` varchar(200) DEFAULT '', `SerialNumber` varchar(200) DEFAULT '', `sort_id` int(3) DEFAULT '0', `video_url` varchar(200) DEFAULT NULL, `charge_type` int(11) DEFAULT '1' COMMENT '充放电状态：1:限流充电；2；逆变充电', `buscouple_state` int(11) DEFAULT '0' COMMENT '母联状态：0：无母联；1:有母联', `tmp_id` int(11) DEFAULT '0', `price_factor` float DEFAULT '1' COMMENT '电价系数', `smps_brand` varchar(50) DEFAULT NULL COMMENT '开关电源品牌', `smps_model` varchar(50) DEFAULT NULL COMMENT '开关电源型号', `PackCount` int(11) DEFAULT '1' COMMENT '锂电池包数量', `dev_num` varchar(255) NOT NULL DEFAULT '0' COMMENT '设备编号[a059用于标识设备]', `mId` bigint(20) DEFAULT '0' COMMENT '二维码信息标识位', `cellShowType` int(11) NOT NULL DEFAULT '0' COMMENT '电池类型[0：铅酸 1：锂电]', `NomCapWH` float NOT NULL DEFAULT '0' COMMENT '标称容量[KWH]', `NomCapAH` float NOT NULL DEFAULT '0' COMMENT '标称容量AH', `LoadCurrFromDis` float NOT NULL DEFAULT '0' COMMENT '负载电流-[来源核容放电数据]', `NodeStation` int(11) NOT NULL DEFAULT '0' COMMENT '节点站标识:0:不是节点站[默认] 1:节点站', `StationType` varchar(255) DEFAULT NULL COMMENT '站点类型[例如110V/22V]', PRIMARY KEY (`num`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='电池信息更改记录表'; --- BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java | 1 + 1 files changed, 1 insertions(+), 0 deletions(-) diff --git a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java index fad1435..d4e8712 100644 --- a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java +++ b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java @@ -265,6 +265,7 @@ public final static String Battmon_Standardcurve_TABLE = DB_BATT_INF + ".`tb_battmon_standardcurve`"; //标准曲线表 public final static String Station_Inf_Table = DB_BATT_INF + ".`tb_station_inf`"; //机房信息总表 + public final static String Battinf_Update_Record_Table = DB_BATT_INF + ".`tb_battinf_update_record`"; //电池信息更新记录表 -- Gitblit v1.9.1