装备实体
## 装备实体 xy_sys_equipment : xy_equipment_fields
## 表名 xy_sys_equipment
### 字段参数
|字段|类型|说明|
|----|----|---|
|xy_id|int|主键|
|xy_equipment_type|int|0终端装备 1 乘用车装备|
|xy_equipment_code|string|装备号|
|xy_client_id|int|终端主键|
|xy_client_code|string|终端号|
|xy_client_sim_code|string|终端SIM号|
|xy_client_gps_start_time|datetime|终端GPS服务开始时间|
|xy_client_gps_end_time|datetime|终端GPS服务结束时间|
|xy_client_storage_time|datetime|终端入库时间|
|xy_client_addtime|datetime|终端添加时间|
|xy_device_type_id|int|装备类型id|
|xy_device_type|string|装备类型|
|xy_device_number_id|int|装备型号id|
|xy_device_number|string|装备型号|
|xy_factory_parent_equipment_state|xy_sys_device_state|父级厂商装备状态|
|xy_factory_equipment_state|xy_sys_device_state|厂商装备状态|
|xy_office_equipment_state|xy_sys_device_state|办事处装备状态|
|xy_agent_equipment_state|xy_sys_device_state|代理商装备状态|
|xy_user_equipment_state|xy_sys_device_state|最终用户装备状态|
|xy_equipment_sales_state|int| 付款类型 1:全款 2:按揭 3:分期 4:其他|
|xy_factory_parent_id|int|父级厂商主键|
|xy_factory_parent_name | string | 父级厂商名称 |是|
|xy_factory_id|int|厂商主键|
|xy_factory_equipment_samples | int | 是否是样机 0 不是 1是 |
|xy_factory_name | string | 厂商名称 |是|
|xy_office_id|int|办事处id|
|xy_office_name|string|办事处名称|
|xy_agent_id|int|代理商id|
|xy_agent_name|string|代理商名称|
|xy_user_id|int|最终用户id|
|xy_user_name|string|最终用户名称|
|xy_service_agent_id|int|服务代理商id|
|xy_service_agent_name|string|服务代理商|
|xy_service_start_time|datetime|服务开始时间|
|xy_service_end_time|datetime|服务结束时间|
|xy_receipt_time|datetime|签收时间|
|xy_buyout_time|datetime|买断时间|
|xy_sales_time|datetime|销售时间|
|xy_leavefactory_time|datetime|出厂时间|
|xy_equipment_alarm|List<string>|报警信息|
|xy_equipment_install|xy_equipment_install|装备测试信息|
|xy_equipment_operation |xy_equipment_operation |装备工况信息|
|xy_hour_revise|string| 工时修正|
|xy_fuel_revise|string|油耗修正|
|xy_unservice_time|datetime|出保时间|
|xy_unenable_time|datetime|停用时间|
|xy_unenable_state|int|0 启用 1停用|
|xy_uninstall_state|int|0 未卸载终端 1 已卸载终端|
|xy_uninstall_time|datetime|卸载时间|
|xy_equipment_service|int| 0 未转服务 1 已转服务 2 服务|
|xy_equipment_capital_lease|int| 0 融资中 1 融资结束 |
|xy_remark|string|备注 |
|xy_option_account|string|操作人|
|xy_push_off|int|通知状态 0 需要通知 1不需要通知 2 已通知|
|xy_push_count|int|通知次数|
|xy_client_bindtime|datetime|添加时间|
|xy_addtime|datetime|添加时间|
|xy_isdel|int|0 正常 1删除 |
## 装备数据报警实体 xy_equipment_alarm
### 字段参数
|字段|类型|说明|
|----|----|---|
|xy_alarm_txgzbj|int| GPS天线故障 0 无报警 1有报警|
|xy_alarm_ddbjbj|int| 断电报警 0 无报警 1有报警|
|xy_alarm_gzbjbj|int| 故障报警 0 无报警 1有报警|
|xy_alarm_Wdwbj|int| 无定位 0 无报警 1有报警|
|xy_alarm_ywbjbj|int| 油温报警 0 无报警 1有报警|
|xy_alarm_dpqybj|int| 电瓶欠压 0 无报警 1有报警|
|xy_alarm_lqswbj|int| 冷去水温报警 0 无报警 1有报警|
|xy_alarm_fdjbj|int| 发动机 0 无报警 1有报警|
|xy_alarm_fdjdybj|int| 发动机电压报警 0 无报警 1有报警|
|xy_alarm_yylbj|int| 燃油量报警 0 无报警 1有报警|
|xy_alarm_dydybj|int| 电源电压报警 0 无报警 1有报警|
|xy_alarm_jyylbj|int| 机油压力报警 0 无报警 1有报警|
|xy_alarm_kjbj|int| 开机报警 0 无报警 1有报警|
|xy_alarm_wbjtxzdbj|int| 无报警通信中断 0 无报警 1有报警|
|xy_alarm_csjbgzbj|int| 长时间不工作报警 0 无报警 1有报警|
|xy_alarm_yjwgbj|int| 样机违规报警 0 无报警 1有报警|
|xy_alarm_wlbj|int| 围栏报警 0 无报警 1有报警|
|xy_alarm_rgscbj|int| 人工锁车报警 0 无报警 1有报警|
|xy_alarm_bscbj|int| 被锁车报警 0 无报警 1有报警|
|xy_alarm_ybybj|int| 应保养报警 0 无报警 1有报警|
## 装备数据测试实体 xy_equipment_install
### 字段参数
|字段|类型|说明|
|----|----|---|
|xy_setup_person|string|安装人|
|xy_setup_time|datetime|安装时间|
|xy_setup_place|string|安装地点|
|xy_test_time|datetime|装备测试时间|
|xy_test_state|int|装备测试信息测试状态:默认为空;0:待测试;1:测试中;2:测试成功;3:测试失败 |
## 获取工况信息 xy_data_operation_info
### 字段参数
|字段|类型|说明|
|----|----|---|
|xy_operation_time|string|信息时刻|
|xy_operation_type|string|信息类型|
|xy_operation_gps|string|定位方式|
|xy_operation_total_worktime|string|累计工时|
|xy_operation_day_worktime|string|当天累计工时|
|xy_operation_acc_worktime|string|Acc累计工时|
|xy_operation_last_worktime|string|发动机末次工作时间|
|xy_operation_lock_state|string|锁车状态|
|xy_operation_work_state|string|发动机状态|
|xy_operation_speed|string|发动机转速|
|xy_operation_oil_pressure|string|发动机机油压力|
|xy_operation_electric|string|发动机系统电压|
|xy_operation_gear|string|发动机挡位|
|xy_operation_fuel|string|发动机燃油量|
|xy_operation_transmission_temperature |string|传动温度|
|xy_operation_cooling_temperature |string|冷却温度|
|xy_operation_altitude |string|海拔|
|xy_operation_weather |string|天气|
|xy_operation_location1 |string|位置1|
|xy_operation_location2 |string|位置2|
|xy_operation_point |string|经纬度|
## 装备类型实体 xy_sys_device_type
## 表名 xy_sys_device_type
### 字段
|字段|类型|说明|
|----|----|---|
|xy_id|int|主键|
|xy_name|string|装备名称|
|xy_type|int|0 普通装备类型 1乘用车装备类型|
|xy_isdel|int|0 正常 1删除|
## 装备型号实体 xy_sys_device_model
## 表名 xy_sys_device_model
### 字段
|字段|类型|说明|
|----|----|----|
|xy_id|int|主键|
|xy_name|string|装备型号名称|
|xy_device_type_id|int|设备类型主键|
|xy_device_type|string|设备类型|
|xy_type|int|0 普通装备型号 1乘用车装备型号|
|xy_isdel|int|0 正常 1删除|
## 装备状态实体 xy_sys_device_state
## 表名 xy_sys_device_state
### 字段
|字段|类型|说明|
|----|----|----|
|xy_id|int|主键|
|xy_name|string|装备状态名称|
|xy_device_state_level|xy_role_level| 装备状态级别 |
|xy_level_id|string| 对应级别唯一编号 |
|xy_isdefault|int| 1 是默认值 无法进行任何的修改操作|
|xy_isdel|int|0 正常 1删除|
## 装备详情日志 xy_sys_equipment_log
## 表名 xy_sys_equipment_log
### 字段
|字段|类型|说明|
|-----|------|-----|
|xy_id|int|装备主键|
|xy_equipment_operation|xy_equipment_operation|装备工况信息|
|xy_equipment_alarm|xy_equipment_alarm|装备报警信息|