{"text_format":"2","workbook":"xlsx","n_sheets":22,"sheets":["账号","评价","报修记录","公告设置","系统设置","用户表","报修区域","班次设置","排班设置","工种管理","报修故障（改名叫物品）类型","耗材管理","报修耗材记录","消息留言","接单记录","派单记录","转单记录","协作记录","跟踪记录","支付记录","退款记录","系统消息"],"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":"账号","index":0,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_admin"]
["字段名","字段类型","注释"]
["id","varchar(32)","主键ID(uuid) 管理端用UUID 移动端用int 便于区分并且在数据量大的情况下int查询效率高"]
["account","varchar(32)","账号"]
["password","varchar(32)","密码"]
["username","varchar(32)","用户姓名"]
["phone","varchar(32)","手机号"]
["is_super","int","是否是超级管理员\n不是：0\n是：1"]
["statu","varchar(32)","状态\n正常：0\n冻结：1"]
["is_mobile","int","是否是移动端创建\n不是：0\n是：1"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","varchar(32)","创建人员"]
["update_user","varchar(32)","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"评价","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_evaluate"]
["字段名","字段类型","注释"]
["id","int","主键ID"]
["record_id","int","维修记录ID"]
["star","int","星级"]
["content","varchar(255)","评价内容"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","bigint","创建人员"]
["update_user","bigint","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"报修记录","index":2,"n_rows":44,"n_cols":3,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_record"]
["字段名","字段类型","注释"]
["id","int","主键ID"]
["area_id","int","报修区域ID"]
["record_no","varchar(32)","报修单号"]
["address","varchar(255)","详细地址"]
["description","varchar(255)","故障描述"]
["image_one","blob","故障照片1（局部）"]
["image_two","blob","故障照片2（全局）"]
["image_three","blob","故障照片3（可填可不填）"]
["maintenancer_one","blob","维修照片1（维修后）"]
["maintenancer_two","blob","维修照片2（维修后）"]
["user_id","int","报修用户ID"]
["user_name","varchar(64)","报修人姓名"]
["user_phone","varchar(64)","报修人联系电话"]
["maintenancer_id","varchar(64)","维修人ID（多个用户用逗号隔开）"]
["maintenancer_name","varchar(64)","维修人姓名（用协作、改派操作之前第一个师傅的名字）"]
["maintenancer_phone","varchar(64)","维修人联系电话（用协作、改派操作之前第一个师傅的电话）"]
["customs_officer_id","varchar(64)","关单人ID（多个关单人用逗号隔开）"]
["maintenance_state","int","维修状态(派单中，维修中，协作，转后勤，已完成，待确认，转单待审核，协作待审核，已取消，已关单)"]
["is_duty","int","是否是值班单 不是值班单0 是值班单1  定时到正常班次时间重新分配"]
["is_collaborate","int","是否是协作单 不是协作单0 是协作单1  判断关单用的"]
["logistics_personnel","int","后勤人员ID"]
["report_time","datetime","报修时间"]
["dispatch_time","datetime","派单时间 判断单子是否超时用的"]
["acceptance_assess_time","int","接单考核时间 有多个师傅记录第一个师傅的 判断单子用的"]
["maintenance_assess_time","int","维修考核时间 有多个师傅记录第一个师傅的 判断单子用的"]
["remark","varchar(255)","关单原因"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","varchar(32)","创建人员"]
["update_user","varchar(32)","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]
[]
[]
["只有接单、派单了才能协作"]
[]
[]
["值班","不考核","分单池"]
["正常班次","考核接单时间 维修时间","直接分给人"]
["非工作时间的单子","给考核时间加上非工作时间长度"]
[]
[]
["值班的单子隔天来分"]

{"sheet":"公告设置","index":3,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_notice_setting"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["content","varchar(255)","公告内容"]
["is_top","int","是否置顶\n不置顶：0\n置顶：1"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","varchar(32)","创建人员"]
["update_user","varchar(32)","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"系统设置","index":4,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_system_settings"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["hour","int","工单完成后多少小时，用户未评价系统默认好评"]
["not_work_time","varchar(32)","非工作时间 多个时间用逗号隔开"]
["emergency_call","varchar(32)","紧急电话"]
["service_phone","varchar(32)","服务监督电话"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","varchar(32)","创建人员"]
["update_user","varchar(32)","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"用户表","index":5,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_user"]
["字段名","字段类型","列1"]
["id","bigint","主键ID"]
["card_number","varchar(64)","微校卡号"]
["user_name","varchar(32)","用户名称"]
["user_phone","varchar(32)","用户手机号"]
["user_zzid","int","用户身份ID 用户：0 维修师傅：1 郭班长：2 后勤人员：3"]
["work_type","int","工种"]
["article_id","varchar(255)","故障类型（改名叫物品）关联ID（多个故障类型用逗号隔开）"]
["state","int","员工状态 大量接单：1；停止接单：2；订单饱和：3"]
["identity_type","int","身份类型ID"]
["school_id","bigint","校区ID"]
["team_id","int","维修班 校方人员 0； 第三方人员 1"]
["build_id","varchar(255)","楼栋关联ID（多个楼栋用逗号隔开）"]
["is_change","int","是否转换 不能转换 0；能转换 1"]
["acceptance_assess_time","int","接单考核时间"]
["maintenance_assess_time","int","维修考核时间"]
["openid","varchar(64)","微信唯一标识openid"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","varchar(32)","创建人员"]
["update_user","varchar(32)","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]
[]
[]
[]
[]
["注：用户表和师傅通讯录用同一张表"]
["最终以师傅状态为准 例如，班次处于上班时间"]

{"sheet":"报修区域","index":6,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_area"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["parent_id","bigint","父级ID(parentid为0的是校区)"]
["name","varchar(64)","区域/具体名称"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","varchar(32)","创建人员"]
["update_user","varchar(32)","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"班次设置","index":7,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_shift_settings"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["name","varchar(64)","班次名称"]
["start_time","varchar(32)","开始时间"]
["end_time","varchar(32)","结束时间"]
["color","varchar(64)","颜色(存储rgb值)"]
["is_duty","int","是否值班 不值班：0；值班：1"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","varchar(32)","创建人员"]
["update_user","varchar(32)","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"排班设置","index":8,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_classes_settings"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["user_id","int","用户ID"]
["start_date","date","开始日期"]
["shift_id","varchar(64)","班次ID(多个班次用逗号隔开)"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","varchar(32)","创建人员"]
["update_user","varchar(32)","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"工种管理","index":9,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_work_type"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["name","varchar(64)","工种名称"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","varchar(32)","创建人员"]
["update_user","varchar(32)","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"报修故障（改名叫物品）类型","index":10,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_article_type"]
["字段名","字段类型","注释"]
["id","int","主键ID"]
["school_id","int","校区ID"]
["parent_id","int","父级ID(parentid为0的是第一级)"]
["name","varchar(64)","报修故障（物品）类型名称"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","varchar(32)","创建人员"]
["update_user","varchar(32)","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"耗材管理","index":11,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_consume"]
["字段名","字段类型","注释"]
["id","int","主键ID"]
["school_id","int","校区ID"]
["article_id","varchar(32)","故障（改名叫物品）类型ID \n（多个ID用逗号隔开）"]
["name","varchar(64)","耗材名称"]
["price","decimal","单价"]
["content","varchar(255)","内容"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","varchar(32)","创建人员"]
["update_user","varchar(32)","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"报修耗材记录","index":12,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_consumables"]
["字段名","字段类型","注释"]
["id","int","主键ID"]
["record_id","int","维修记录ID"]
["consume_list","varchar(255)","耗材json数据"]
["price","decimal","耗材价格"]
["number","double","耗材数量"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","varchar(32)","创建人员"]
["update_user","varchar(32)","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"消息留言","index":13,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_leave_message"]
["字段名","字段类型","注释"]
["id","int","主键ID"]
["record_id","int","维修记录ID"]
["recipient_id","int","接收人员ID"]
["sender_id","int","发送人员ID"]
["content","varchar(255)","内容"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","varchar(32)","创建人员"]
["update_user","varchar(32)","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"接单记录","index":14,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_receiving"]
["字段名","字段类型","注释"]
["id","int","主键ID"]
["record_id","int","报修记录ID"]
["dispatch_id","int","派单ID（关联派单表）"]
["user_id","int","接单人ID"]
["receiving_time","datetime","接单时间"]
["acceptance_assess_time","int","接单考核时间"]
["maintenance_assess_time","int","维修考核时间 "]
["repair_distribute_time","datetime","订单分发时间"]
["is_lose_efficacy","int","是否已失效（0未失效，1已失效）"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","varchar(32)","创建人员"]
["update_user","varchar(32)","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]
{"$rows_empty":7}
["考核时间计算公式：(维修师傅排班的工作结束时间-派单时间) < 员工表中设置的接单考核时间的话 \n接单考核时间加上非工作时间便是接单考核时间"]

{"sheet":"派单记录","index":15,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_dispatch_record"]
["字段名","字段类型","注释"]
["id","int","主键ID"]
["record_id","int","报修记录ID"]
["users_id","varchar(64)","被派单人ID（多人用逗号隔开）"]
["assigned_time","datetime","被派单/被协作时间"]
["acceptance_assess_time","int","接单考核时间"]
["source_id","int","协作或转单ID"]
["order_type","int","派单类型 0派单 1协作 2转单"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","varchar(32)","创建人员"]
["update_user","varchar(32)","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"转单记录","index":16,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_transfer_record"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["record_id","bigint","报修记录ID"]
["voice","varchar(255)","语音"]
["remark","varchar(255)","备注"]
["approval_statu","int","审批状态 0拒绝 1同意 2待审批"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","bigint","创建人员"]
["update_user","bigint","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"协作记录","index":17,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_collaborate_record"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["record_id","bigint","报修记录ID"]
["collaborator","varchar(255)","协作人ID（多个人用逗号隔开）"]
["voice","varchar(255)","语音 可能做成语音文件上传的方式 然后这个字段记录语音文件名"]
["remark","varchar(255)","备注"]
["approval_statu","int","审批状态 0拒绝 1同意 2待审批"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","bigint","创建人员"]
["update_user","bigint","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"跟踪记录","index":18,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_track_record"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["record_id","bigint","报修记录ID"]
["content","varchar(255)","跟踪内容"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","bigint","创建人员"]
["update_user","bigint","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"支付记录","index":19,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_pay_record"]
["字段名","字段类型","注释"]
["id","int","主键ID"]
["record_id","int","维修订单ID"]
["user_id","int","支付人员ID"]
["pay_no","varchar(64)","支付流水号（对应微信的）"]
["pay_price","decimal","交易金额"]
["is_success","int","是否支付成功 未支付：0；支付成功：1；支付失败：2"]
["remark","varchar(255)","备注"]
["pay_time","datetime","交易时间"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","varchar(32)","创建人员"]
["update_user","varchar(32)","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"退款记录","index":20,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_refund_record"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["record_id","bigint","维修订单ID"]
["user_id","bigint","被退款人员ID"]
["wx_no","varchar(64)","要退的那笔订单的微信订单号（对应微信的）"]
["refund_no","varchar(64)","退款时产生的流水号（对应微信的）"]
["refund_price","decimal","退款金额"]
["is_success","int","是否退款成功 退款中0；退款成功1；退款失败2"]
["remark","varchar(255)","备注"]
["refund_time","datetime","退款时间"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","varchar(32)","创建人员"]
["update_user","varchar(32)","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"系统消息","index":21,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_system_messages"]
["字段名","字段类型","注释"]
["id","int","主键ID"]
["record_id","int","报修记录ID"]
["recipient_id","int","接收人员ID"]
["content","varchar(255)","内容"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","varchar(32)","创建人员"]
["update_user","varchar(32)","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]