{"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":23,"n_cols":3,"rows_kept":23,"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","bigint","维修用户ID"]
["maintenancer_name","varchar(64)","维修人姓名"]
["maintenancer_phone","varchar(64)","维修人联系电话"]
["level","int","响应等级   \n一般：0\n紧急：1"]
["maintenance_state","int","维修状态"]
["report_time","datetime","报修时间"]
["repair_time","datetime","维修时间"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","bigint","创建人员"]
["update_user","bigint","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"支付记录","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_pay_record"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["record_id","bigint","维修订单ID"]
["pay_no","varchar(255)","支付流水号（对应微信的）"]
["pay_price","decimal","交易金额"]
["pay_time","datetime","交易时间"]
["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_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":3,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_system_settings"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
[]
[]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","bigint","创建人员"]
["update_user","bigint","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"班次设置","index":4,"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":5,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_shift_settings"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["user_id","bigint","用户ID"]
["start_date","date","开始日期"]
["end_date","date","结束日期"]
["mon","bigint","班次ID"]
["tue","bigint","班次ID"]
["wed","bigint","班次ID"]
["thu","bigint","班次ID"]
["fri","bigint","班次ID"]
["sat","bigint","班次ID"]
["sun","bigint","班次ID"]
["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_user"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["card_number","varchar(64)","微校卡号"]
["user_name","varchar(32)","用户名称"]
["user_phone","varchar(255)","用户手机号"]
["user_zzid","int","用户身份"]
["identity_type","int","身份类型ID"]
["school_id","bigint","校区ID"]
["openid","varchar(255)","微信唯一标识openid"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","bigint","创建人员"]
["update_user","bigint","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"校区","index":7,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_school"]
["字段名","字段类型","注释"]
["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":8,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_third_build"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["user_id","bigint","用户ID"]
["school_id","bigint","校区ID"]
["build_id","bigint","楼栋ID"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","bigint","创建人员"]
["update_user","bigint","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"账号","index":9,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_admin"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["account","varchar(255)","账号"]
["password","varchar(255)","密码"]
["username","varchar(255)","用户姓名"]
["phone","varchar(32)","手机号"]
["role_id","bigint","角色ID"]
["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":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_role"]
["字段名","字段类型","注释"]
["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":11,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_department"]
["字段名","字段类型","注释"]
["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":12,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_worker_type"]
["字段名","字段类型","注释"]
["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":13,"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":14,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_schedule"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["record_id","bigint","维修记录ID"]
["statu","int","状态"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","bigint","创建人员"]
["update_user","bigint","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"报修区域","index":15,"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":16,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_work_type"]
["字段名","字段类型","注释"]
["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":17,"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":18,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_message"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["record_id","bigint","维修订单ID"]
["user_id","bigint","用户ID"]
["content","varchar(255)","内容"]
["is_read","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":19,"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":20,"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":21,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["表名：","repair_leave_message"]
["字段名","字段类型","注释"]
["id","bigint","主键ID"]
["order_id","bigint","订单ID"]
["user_id","bigint","用户ID"]
["content","varchar(255)","内容"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","bigint","创建人员"]
["update_user","bigint","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]