{"text_format":"2","workbook":"xlsx","n_sheets":23,"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":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_record"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["name","varchar(255)","校区名称"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","bigint","创建人员"]
["update_user","bigint","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"报修区域","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_air"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["school_id","bigint","校区ID"]
["parent_id","bigint","父级ID"]
["name","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":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_article_type"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["work_id","bigint","报修工种ID"]
["name","varchar(255)","报修故障类型名称"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","bigint","创建人员"]
["update_user","bigint","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"消息留言","index":3,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_leave_message"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["order_id","bigint","订单ID"]
["recipient_id","bigint","接收人员ID"]
["sender_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":4,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["表名：","system_messages"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["order_id","bigint","订单ID"]
["recipient_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":5,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_user"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["card_number","varchar(64)","微校卡号"]
["user_name","varchar(32)","用户名称"]
["user_phone","varchar(255)","用户手机号"]
["user_zzid","int","用户身份"]
["work_type","int","工种"]
["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(255)","微信唯一标识openid"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","bigint","创建人员"]
["update_user","bigint","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]
[]
[]
[]
[]
["注：用户表和师傅通讯录用同一张表"]
["最终以师傅状态为准 例如，班次处于上班时间"]

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

{"sheet":"退款记录","index":7,"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(255)","要退的那笔订单的微信订单号（对应微信的）"]
["refund_no","varchar(255)","退款时产生的流水号（对应微信的）"]
["refund_price","decimal","退款金额"]
["is_success","int","是否退款成功 退款成功1；退款失败0"]
["remark","varchar(255)","备注"]
["refund_time","datetime","退款时间"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","bigint","创建人员"]
["update_user","bigint","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"系统设置","index":8,"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(255)","非工作时间 多个时间用逗号隔开"]
["emergency_call","varchar(255)","紧急电话"]
["service_phone","varchar(255)","服务监督电话"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","bigint","创建人员"]
["update_user","bigint","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"账号","index":9,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_admin"]
["字段名","字段类型","注释"]
["id","varchar(255)","主键ID(uuid)"]
["account","varchar(255)","账号"]
["password","varchar(255)","密码"]
["username","varchar(255)","用户姓名"]
["phone","varchar(32)","手机号"]
["statu","varchar(32)","状态\n正常：0\n冻结：1"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","bigint","创建人员"]
["update_user","bigint","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"报修记录","index":10,"n_rows":39,"n_cols":3,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_record"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["area_id","bigint","报修区域ID"]
["address","varchar(255)","详细地址"]
["description","varchar(255)","故障描述"]
["images","varchar(255)","故障照片（多张照片用逗号隔开,最多三张）"]
["maintenancer_images","varchar(255)","维修照片（多张照片用逗号隔开,最多三张）"]
["user_id","bigint","报修用户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","bigint","关单人ID（只要一个人关了就行）"]
["maintenance_state","int","维修状态(派单中，维修中，协作，转后勤，已完成，待确认，转单待审核，协作待审核，已取消，已关单)"]
["is_duty","int","是否是值班单 不是值班单0 是值班单1  定时到正常班次时间重新分配"]
["is_collaborate","int","是否是协作单 不是协作单0 是协作单1  判断关单用的"]
["logistics_personnel","bigint","后勤人员ID"]
["report_time","datetime","报修时间"]
["acceptance_assess_time","int","接单考核时间 "]
["maintenance_assess_time","int","维修考核时间"]
["remark","varchar(255)","关单原因"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","bigint","创建人员"]
["update_user","bigint","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]
[]
[]
["只有接单、派单了才能协作"]
[]
[]
["值班","不考核","分单池"]
["正常班次","考核接单时间 维修时间","直接分给人"]
["非工作时间的单子","给考核时间加上非工作时间长度"]
[]
[]
["值班的单子隔天来分"]

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

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

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

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

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

{"sheet":"接单记录","index":16,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["表名：","receiving_record"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["order_id","bigint","订单ID"]
["dispatch_id","bigint","派单ID"]
["user_id","bigint","接单人ID"]
["receiving_time","datetime","接单时间"]
["acceptance_assess_time","int","接单考核时间"]
["repair_distribute_time","datetime","订单分发时间"]
["is_lose_efficacy","int","是否已失效（0未失效，1已失效）"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","bigint","创建人员"]
["update_user","bigint","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"派单记录","index":17,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_dispatch_record"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["order_id","bigint","订单ID"]
["users_id","varchar(64)","被派单人ID（多人用逗号隔开）"]
["assigned_time","datetime","被派单/被协作时间"]
["acceptance_assess_time","int","接单考核时间"]
["source_id","bigint","协作或转单ID"]
["order_type","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":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["表名：","transfer_record"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["order_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":19,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["表名：","collaborate_record"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["order_id","bigint","订单ID"]
["collaborator","varchar(255)","协作人（多个人用逗号隔开）"]
["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":20,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_evaluate"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["record_id","bigint","维修记录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":21,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["表名：","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":22,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_consumables"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["record_id","bigint","维修记录ID"]
["consumables","bigint","耗材ID"]
["article_type_id","bigint","故障类型ID"]
["price","decimal","耗材价格"]
["number","double","耗材数量"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","bigint","创建人员"]
["update_user","bigint","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]