最新云架構(gòu)設(shè)計(jì)-在線瀏覽
2024-08-10 03:18本頁面
【正文】 當(dāng)前SOCcurrent_soc當(dāng)前金額current_amount當(dāng)前剩余時(shí)間current_remaining當(dāng)前狀態(tài)current_status0:訂單進(jìn)行中當(dāng)前終端current_device_info當(dāng)前設(shè)備current_charger_info當(dāng)前端口current_charger_port當(dāng)前用時(shí)current_charger_time當(dāng)前車牌號(hào)current_vehicle_no當(dāng)前費(fèi)率current_rate當(dāng)前時(shí)段current_interval尖時(shí)段電量sharp_quantity峰時(shí)段電量peak_quantity平時(shí)段電量flat_quantity谷時(shí)段電量valley_quantity尖時(shí)段金額sharp_cost峰時(shí)段金額peak_cost平時(shí)段金額flat_cost谷時(shí)段金額valley_cost創(chuàng)建人create_by創(chuàng)建時(shí)間create_time更新人update_by更新時(shí)間update_time車隊(duì)信息表:operators_fleet字段名稱字段編碼字段類型字段長(zhǎng)度字段描述車隊(duì)編號(hào)fleet__idInt車隊(duì)名稱fleet_namestring車隊(duì)屬性fleet_propertystring車隊(duì)類型fleet _typeint1:私人 2:公用車隊(duì)負(fù)責(zé)人curatorstring負(fù)責(zé)人電話phonestring結(jié)算方式settlement_methodstring1:日結(jié) 2:月結(jié)結(jié)算時(shí)間settlement_datedate所屬運(yùn)營(yíng)商operator_idInt所屬企業(yè)enterprise_idInt站點(diǎn)編碼station_idint結(jié)算日期settlement_datestring新增創(chuàng)建人create_by創(chuàng)建時(shí)間create_time更新人update_by更新時(shí)間update_time刪除標(biāo)志delete_flagint車輛信息表:vehicles字段名稱字段編碼字段類型字段長(zhǎng)度字段描述車輛編號(hào)vehicle_idint車隊(duì)編號(hào)fleet_idint車輛編碼vehicle_codestring車輛類型vehicle _typeint車牌號(hào)vehicle_plate_nostring生產(chǎn)廠家vehicle_producerstring啟用時(shí)間enable_timedatetime所屬企業(yè)enterprise_codestring所屬運(yùn)營(yíng)商operator_idint車輛狀態(tài) vehicle_statusint1:正常 2:故障品牌型號(hào)brand_modelstring車輛顏色colorstring車架號(hào)vinstring發(fā)動(dòng)機(jī)號(hào)engine_nostring動(dòng)力類型power_typeint0 : 39。,1:39。,2:39。出廠時(shí)間factory_timedatetime車載設(shè)備編號(hào)vehicle_eqcodestring核定載客人數(shù)approved_numint核定載質(zhì)量approved_massfloat當(dāng)前出車?yán)锍蘡urrent_mileagefloat保養(yǎng)間隔里程Interval_mileagefloat電池廠商battery_manufacturersstring電池出廠時(shí)間battery_timedatetime電池類型battery_typeint電池容量battery_capacityfloat使用壽命use_periodfloat能耗比copfloat續(xù)航里程mileagefloat用途usedstring有效期effective_timedatetime創(chuàng)建人create_by創(chuàng)建時(shí)間create_time更新人update_by更新時(shí)間update_time刪除標(biāo)志delete_flagint充電樁實(shí)時(shí)狀態(tài)表:charger_state字段名稱字段編碼字段類型字段長(zhǎng)度字段描述編號(hào)state_idInt設(shè)備序列號(hào)charger_snString連接狀態(tài)connect_stateint（0：閉合，1：斷開）充電狀態(tài)charger_stateint1：待機(jī) 2：充電 3：充滿 4：故障組網(wǎng)狀態(tài)network_state根據(jù)數(shù)據(jù)庫刪除充電槍口charger_portString電池組號(hào)battery_groupIdString車輛識(shí)別碼vinString企業(yè)編碼operatorIdString充電訂單號(hào)order_noString充電樁充電電壓charger_currentFloat(充電float狀態(tài))充電樁充電電壓charger_voltageFloat(充電狀態(tài))當(dāng)前消費(fèi)金額amountFloat當(dāng)前充電總電度charger_quantityFloat(充電狀態(tài))充電持續(xù)時(shí)間charger_durationFloat(充電狀態(tài))BMS請(qǐng)求充電電壓bms_requestvoltageFloat(充電狀態(tài))BMS請(qǐng)求充電電流bms_requestcurrentFloat(充電狀態(tài))單體最高電壓cell_highestvoltageFloat單體截止電壓cell_stopvoltageFloat許可電壓allow_voltageFloat單體最高溫度cell_highest_tempFloat單體最低溫度cell_lowest_tempFloat電池組電壓battery_voltageFloat電池組電流battery_currentFloat充電模塊輸出電壓output_voltageFloat(充電狀態(tài))充電模塊輸出電流output_currentFloat(充電狀態(tài))充電模塊最大溫度max_tempInt(充電狀態(tài))充電模塊最低溫度min_tempInt(充電狀態(tài))充電模塊個(gè)數(shù)module_countInt(充電狀態(tài))剩余時(shí)間remain_timeInt(充電狀態(tài))根據(jù)數(shù)據(jù)庫添加字段報(bào)警信息表:equipment_alarm字段名稱字段編碼字段類型字段長(zhǎng)度字段描述編號(hào)alam _idint編碼alam_codestring等級(jí)alam_levelint報(bào)警值alarmValuestring描述alam_descstring色值alam_colorstring類型alam_typeint設(shè)備eq_idint設(shè)備序列號(hào)charger_snstring運(yùn)營(yíng)商operator_idint站點(diǎn)station_idint報(bào)警模塊組itemNumstring狀態(tài)statusint創(chuàng)建人create_bystring創(chuàng)建時(shí)間create_timestring更新人update_bystring更新時(shí)間update_timestring刪除標(biāo)志delete_flagint設(shè)備維修記錄表:operators_maintain字段名稱字段編碼字段類型字段長(zhǎng)度字段描述編號(hào)m_idint設(shè)備名稱m_titlestring設(shè)備編碼m _codestring故障原因m_reasonstring維修等級(jí)m_levelint1:I級(jí) 2:II級(jí) 3:III級(jí)故障描述m_descstring實(shí)時(shí)狀態(tài)m_statusint1:待處理 2：處理中3：已處理處理人processerstring電話phonestring處理建議suggestionstring創(chuàng)建人crea
研究報(bào)告相關(guān)推薦
鄂ICP備17016276號(hào)-1