{"text_format":"2","workbook":"xlsx","n_sheets":7,"sheets":["history","rm_mo","rm_map","rm_deviceinfo","rm_alarm","rm_alarm_set","rm_user"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"history","index":0,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,"序号","日期","修改人","修改点","修改内容"]
[null,null,1,"2024-07-24","陈禹"]
[{"$nulls":5},1,"修改了表rm_device，添加了operation_time字段和mo_offline字段"]
[]
[null,null,3,"2024-07-24","陈禹"]

{"sheet":"rm_mo","index":1,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"rm_mo"]
[null,"序号","字段名","数据类型","是否允许为空","数据长度","主键","字段说明"]
[null,1,"id","nvarchar(50)",{"$nulls":6},"SELECT [id],[type],[up],[name] FROM [rm_mo]"]
[null,2,"type","varchar(50)"]
[null,3,"up","nvarchar(50)",null,null,null,"向上的指针，保存上层的id值"]
[null,4,"name","nvarchar(50)","是"]
[null,5,"updatetime","datetime"]
[]
[]
[null,"字段说明"]
[null,1,"type"]
[null,null,"section","杭州段"]
[null,null,"workshop","杭东高铁车间"]
[null,null,"station","杭南杭甬场"]
[null,null,"mo","HZHNHYC208"]
[null,null,"bureau","上海局"]
[null,2]
[null,null,"当id与up的值完全相同值，表示上层没有了"]
[null,null,100000,"国铁集团"]

{"sheet":"rm_map","index":2,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[null,"rm_map"]
[null,"序号","字段名","数据类型","是否允许为空","数据长度","主键","字段说明"]
[null,1,"mo","nvarchar(50)",null,null,null,"岔道机"]
[null,2,"mp","varchar(50)",null,null,null,"牵引点，X1，X2，X3，J1，J2，J3"]
[null,3,"idx","smallint",null,null,null,"0，1，2"]
[null,4,"name1","nvarchar(10)",null,null,null,"反位测力曲线，定位测力曲线，转换阻力曲线"]
[null,5,"name2","nvarchar(10)"]
[null,6,"name3","nvarchar(10)"]
[null,7,"direct1","nvarchar(10)",null,null,null,"定扳反，反扳定"]
[null,8,"direct2","nvarchar(10)",null,null,null,"定扳反，反扳定"]
[null,9,"IMEI","varchar(50)"]
[null,10,"tow_num","nvarchar(20)"]
[null,11,"zzj_type","varchar(20)"]
[null,12,"mt_ext_loca","nvarchar(20)"]
[null,13,"mt_ext_no","varchar(50)"]
[null,14,"zl_1_loca","nvarchar(20)"]
[null,15,"zl_1_no","varchar(50)"]
[null,16,"zl_2_loca","nvarchar(20)"]
[null,17,"zl_2_no","varchar(50)"]
[null,18,"zl_3_no","varchar(50)"]
[null,19,"updatetime","datetime"]
[null,20,"epos","int"]
[null,21,"install_1","tinyint"]
[null,22,"install_2","tinyint"]
[null,23,"install_3","tinyint"]
[null,24,"zzjno","int"]
[null,25,"operation_state","int",null,null,null,"0、在线正常，1、不在线，2、高频干扰，3、固定值异常"]
[null,26,"mo_offline","smallint",null,null,null,"0、相关检测对象在线，1、相关检测对象不在线"]

{"sheet":"rm_deviceinfo","index":3,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[" ","rm_deviceinfo"]
[null,"序号","字段名","数据类型","是否允许为空","数据长度","主键","字段说明"]
[null,1,"IMEI","varchar(50)",null,null,null,"岔道机"]
[null,2,"name","nvarchar(50)","*"]
[null,3,"CCID","varchar(50)",null,null,null,"4G模块的id"]
[null,4,"longitude","decimal(9, 6)",null,null,null,"经度"]
[null,5,"latitude","decimal(8, 6)",null,null,null,"纬度"]
[null,6,"updatetime","datetime",null,null,null,"设备的最后心跳时间"]
[null,7,"version","varchar(16)"]
[null,8,"type","char(5)",null,null,null,"11，主机，12，主机，13，从机"]
[null,9,"model","tinyint",null,null,null,"model = 0 代表数据模式 1 代表升级模式"]
[null,10,"deviceip","char(16)"]
[null,11,"group0name","nvarchar(50)"]
[null,12,"group1name","nvarchar(50)"]
[null,13,"group2name","nvarchar(50)"]
[null,14,"mo","tinyint"]
[null,15,"normal_0_warn","smallint"]
[null,16,"normal_0_alarm","smallint"]
[null,17,"normal_1_warn","smallint"]
[null,18,"normal_1_alarm","smallint"]
[null,19,"normal_2_warn","smallint"]
[null,20,"normal_2_alarm","smallint"]
[null,21,"reverse_2_warn","smallint"]
[null,22,"reverse_2_alarm","smallint"]
[null,23,"normal_3_warn","smallint"]
[null,24,"normal_3_alarm","smallint"]
[null,25,"normal_4_warn","smallint"]
[null,26,"normal_4_alarm","smallint"]
[null,27,"normal_5_warn","smallint"]
[null,28,"normal_5_alarm","smallint"]
[null,29,"reverse_5_warn","smallint"]
[null,30,"reverse_5_alarm","smallint"]
[null,31,"normal_6_warn","smallint"]
[null,32,"normal_6_alarm","smallint"]
[null,33,"normal_7_warn","smallint"]
[null,34,"normal_7_alarm","smallint"]
[null,35,"normal_8_warn","smallint"]
[null,36,"normal_8_alarm","smallint"]
[null,37,"reverse_8_warn","smallint"]
[null,38,"reverse_8_alarm","smallint"]
[null,39,"st0","smallint",null,null,null,"1在线，0不在线(第1路1号传感器离线)\n2高频干扰、3固定值异常\n11/10/01/00为新铁道设备离线状态，占时不用\n"]
[null,40,"st1","smallint",null,null,null,"1在线，0不在线(第2路1号传感器离线)"]
[null,41,"st2","smallint",null,null,null,"1在线，0不在线(第3路1号传感器离线)"]
[null,42,"st3","smallint",null,null,null,"1在线，0不在线(第1路2号传感器离线)"]
[null,43,"st4","smallint",null,null,null,"1在线，0不在线(第2路2号传感器离线)"]
[null,44,"st5","smallint",null,null,null,"1在线，0不在线(第3路2号传感器离线)"]
[null,45,"st6","smallint",null,null,null,"1在线，0不在线(第1路3号传感器离线)"]
[null,46,"st7","smallint",null,null,null,"1在线，0不在线(第2路3号传感器离线)"]
[null,47,"st8","smallint",null,null,null,"1在线，0不在线(第3路3号传感器离线)"]
[null,48,"dt0","smallint",null,null,null,"1异常，0正常(第1路1号晶振异常)"]
[null,49,"dt1","smallint",null,null,null,"1异常，0正常(第2路1号晶振异常)"]
[null,50,"dt2","smallint",null,null,null,"1异常，0正常(第3路1号晶振异常)"]
[null,51,"dt3","smallint",null,null,null,"1异常，0正常(第1路2号晶振异常)"]
[null,52,"dt4","smallint",null,null,null,"1异常，0正常(第2路2号晶振异常)"]
[null,53,"dt5","smallint",null,null,null,"1异常，0正常(第3路2号晶振异常)"]
[null,54,"dt6","smallint",null,null,null,"1异常，0正常(第1路3号晶振异常)"]
[null,55,"dt7","smallint",null,null,null,"1异常，0正常(第2路3号晶振异常)"]
[null,56,"dt8","smallint",null,null,null,"1异常，0正常(第3路3号晶振异常)"]

{"sheet":"rm_alarm","index":4,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,"rm_alarm"]
[null,"序号","字段名","数据类型","是否允许为空","数据长度","主键","缺省值","索引","字段说明"]
[null,1,"id","int",{"$nulls":5},"报警唯一ID"]
[null,2,"mo","nvarchar(50)",{"$nulls":4},1,"岔道机，监控对象"]
[null,3,"mp","varchar(50)",{"$nulls":4},1,"监控点，牵引点，X1，X2，X3，J1，J2，J3"]
[null,null,"no","tinyint",{"$nulls":5},"通道，片，圈的编号，0，1，2"]
[null,null,"type","tinyint",{"$nulls":5},"报警信号设置表的类型"]
[null,null,"occur_time","datetime"]
[null,null,"[level]","tinyint",{"$nulls":5},"//0 预警  1 报警"]
[null,null,"[desc]","nvarchar(100)"]
[null,null,"suggest","nvarchar(100)"]
[null,null,"val","int"]
[null,null,"ack_result","tinyint",{"$nulls":5},"是否受理"]
[null,null,"ack_name","nvarchar(50)",{"$nulls":5},"受理人"]
[null,null,"ack_time","datetime",{"$nulls":5},"受理时间"]
[null,null,"handle_result","tinyint"]
[null,null,"handle_name","nvarchar(50)"]
[null,null,"handle_time","datetime"]
[null,null,"handle_info","nvarchar(100)"]
[null,null,"event_id","char(36)"]
[null,null,"rel_id","char(36)"]
[null,null,"posi","tinyint"]
[null,null,"loworhigh","tinyint"]
[null,null,"referval","int",{"$nulls":5},"报警参数值"]
[null,null,"recovery_time","datetime",{"$nulls":5},"报警恢复正常的时间"]
[null,null,"sunroof","tinyint",{"$nulls":5},"是否天窗"]
[null,null,"operation_state","int",{"$nulls":5},"0、在线正常，1、不在线，2、高频干扰，3、固定值异常"]
[]
[null,"字段说明"]
[null,1,"这个表保存了报警，报警处理，报警恢复业务流程"]

{"sheet":"rm_alarm_set","index":5,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"rm_alarm_set"]
[null,"序号","字段名","数据类型","是否允许为空","数据长度","主键","缺省值","索引","字段说明"]
[null,1,"mo","varchar(50)",{"$nulls":4},1,"道岔机"]
[null,2,"mp","varchar(50)",{"$nulls":4},1,"牵引点"]
[null,3,"no","tinyint",{"$nulls":4},1,"片，圈编号"]
[null,4,"type","tinyint"]
[null,5,"conf","varchar(500)",{"$nulls":5},"报警的配置参数"]
[null,6,"time","bigint",null,null,null,0]
{"$rows_empty":8}
[null,"字段说明"]
[null,"[{\"name\":\"enable\",\"val\":\"true\"},{\"name\":\"lock_alarm_high_limit\",\"val\":\"17000\"},{\"name\":\"lock_warn_high_limit\",\"val\":\"16000\"}]"]
[]
[null,"lock_alarm_high_limit","高位报警"]
[null,"lock_warn_high_limit","高位预警"]
[null,"name","字段名称"]
[null,"val","字段值"]

{"sheet":"rm_user","index":6,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"rm_user"]
[null,"序号","字段名","数据类型","是否允许为空","数据长度","主键","缺省值","索引","字段说明"]
[null,1,"name","varchar(50)"]
[null,2,"password","varchar(50)"]
[null,3,"admin","tinyint","是",{"$nulls":4},"管理权限"]
[null,4,"token","varchar(50)"]
[null,5,"username","varchar(50)","是"]
[null,6,"node","nvarchar(50)","是",{"$nulls":4},"相关节点（外键）rm_mo表"]
[null,null,"enable","tinyint","是",null,null,1]
[null,null,"mobile","varchar(20)","是"]
[null,null,"email","varchar(50)","是"]
[null,null,"mark","nvarchar(50)","是"]
[]
[]
[]
[]
[null,"字段说明"]
[null,1]