{"text_format":"2","workbook":"xlsx","n_sheets":19,"sheets":["校友表","微校部门表","组织分类表","校友组织表","校友组织审核表","模块管理员","相册分类表","校友相册","微校accesstoken","活动管理表","活动图片明细表","审批管理","活动报名","活动签到","母校代言","新闻分类","新闻聚焦","返校申请","心链计划"],"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":36,"n_cols":3,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["表名：","alumni_user"]
["字段名","字段类型","注释"]
["id","int","主键ID"]
["name","varchar(64)","姓名"]
["card_number","varchar(255)","微校卡号"]
["college_id","int","学院ID"]
["college_name","varchar(255)","学院"]
["period_id","int","学段ID"]
["period_name","varchar(255)","学段"]
["major_id","int","专业ID"]
["major_name","varchar(255)","专业"]
["class_id","int","班级ID"]
["class_name","varchar(255)","班级"]
["org_id","int","所属组织ID"]
["org_name","varchar(255)","所属组织"]
["phone","varchar(64)","联系方式"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","int","创建人员"]
["update_user","int","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]
{"$rows_empty":10}
["新增账号的时候去按照微校卡号去微校拿数据 然后绑定处理"]
[]
[]
["获取部门："]
["https://wiki.weixiao.qq.com/api/thirdapp/contact/org/getOrgByIds.html"]

{"sheet":"微校部门表","index":1,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["表名：","alumni_org"]
["字段名","字段类型","注释"]
["id","int","主键ID"]
["parent_id","int","父级ID"]
["name","varchar(255)","姓名"]
["type_id","int","类型  学院:1 学段:2 专业:3\n班级:4 "]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","int","创建人员"]
["update_user","int","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]
[]
[]
[]
[]
[]
[]
["校友：781933"]
["离职校友：777239"]

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

{"sheet":"校友组织表","index":3,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["表名：","alumni_club"]
["字段名","字段类型","注释"]
["id","int","主键ID"]
["name","varchar(255)","组织名称"]
["category_id","int","分类ID"]
["category_name","varchar(255)","分类名称"]
["admin","varchar(255)","管理员ID 多个管理员用逗号隔开"]
["is_top","int","是否置顶 是：1  否：2"]
["description","text","本会简介"]
["contact","text","联系我们"]
["number","int","人数"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","int","创建人员"]
["update_user","int","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"校友组织审核表","index":4,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["表名：","alumni_club_apply"]
["字段名","字段类型","注释"]
["id","int","主键ID"]
["name","varchar(255)","组织名称"]
["club_id","int","组织ID"]
["apply_user","varchar(255)","审核员ID 多个审核员用逗号隔开  这个审核员是设定的管理员"]
["apply_user_name","text","审核员名称 多个管理员用逗号隔开"]
["is_pass","int","是否审核通过    待审核：1   通过：2  拒绝：3"]
["pass_value","text","审核意见"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","int","创建人员"]
["update_user","int","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"模块管理员","index":5,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["表名：","alumni_admin_apply"]
["字段名","字段类型","注释"]
["id","int","主键ID"]
["admin","varchar(255)","管理员ID 多个管理员用逗号隔开"]
["admin_name","varchar(255)","管理员名称 多个管理员用逗号隔开"]
["model_id","int","模块ID  校友相册：1  活动管理：2  母校代言：3"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","int","创建人员"]
["update_user","int","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

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

{"sheet":"校友相册","index":7,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["表名：","alumni_image"]
["字段名","字段类型","注释"]
["id","int","主键ID"]
["image","longtext","图片 多个图片用逗号隔开"]
["category_id","int","图片分类ID"]
["category_name","varchar","分类名称"]
["is_pass","int","是否审核通过    待审核：1   通过：2  拒绝：3"]
["apply_user","varchar","审核员ID 多个审核员用逗号隔开  这个审核员是设定的管理员"]
["apply_user_name","text","审核员名称 多个管理员用逗号隔开"]
["pass_time","datetime","审核时间"]
["pass_value","text","审批意见"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","varchar","创建人员"]
["update_user","varchar","更新人员"]
["deleted","int","逻辑删除 未删除：0；删除：1"]

{"sheet":"微校accesstoken","index":8,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["表名：","wx_access_token"]
["字段名","字段类型","注释"]
["id","int","主键ID"]
["parent_id","int","父级ID"]
["name","varchar","值"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","varchar","创建人员"]
["update_user","varchar","更新人员"]
["deleted","int","逻辑删除 未删除：0；删除：1"]

{"sheet":"活动管理表","index":9,"n_rows":42,"n_cols":3,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["表名：","alumni_activity"]
["字段名","字段类型","注释"]
["id","int","主键ID"]
["org_id","int","组织ID"]
["org_name","varchar","组织名称"]
["theme","varchar","活动主题"]
["theme_detail","longtext","活动详情"]
["start_time","datetime","活动开始时间"]
["end_time","datetime","活动结束时间"]
["poster","text","海报"]
["address","varchar","活动地址"]
["lng","double","经度"]
["lat","double","维度"]
["describe","longtext","参与说明"]
["signs_time","datetime","报名开始时间"]
["signe_time","datetime","报名结束时间"]
["total_number","int","报名总人数"]
["scope","int","报名范围  全部：1 组织成员：2"]
["phone","varchar","咨询方式 活动发起人电话"]
["is_image","int","是否可上传照片 是：1  否：2"]
["apply_user","varchar(255)","审核员ID 多个审核员用逗号隔开  这个审核员是设定的管理员"]
["apply_user_name","text","审核员名称 多个管理员用逗号隔开"]
["is_pass","int","是否审核通过    待审核：1   通过：2  拒绝：3"]
["pass_value","text","审批意见"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","varchar","创建人员"]
["update_user","varchar","更新人员"]
["deleted","int","逻辑删除 未删除：0；删除：1"]
{"$rows_empty":12}
["该表涉及活动审核"]

{"sheet":"活动图片明细表","index":10,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["表名：","activity_image"]
["字段名","字段类型","注释"]
["id","int","主键ID"]
["activity_id","int","活动ID"]
["image","longtext","图片"]
["apply_user","varchar(255)","审核员ID 多个审核员用逗号隔开  这个审核员是设定的管理员"]
["apply_user_name","text","审核员名称 多个管理员用逗号隔开"]
["is_pass","int","是否审核通过    待审核：1   通过：2  拒绝：3"]
["pass_value","text","审批意见"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","varchar","创建人员"]
["update_user","varchar","更新人员"]
["deleted","int","逻辑删除 未删除：0；删除：1"]
{"$rows_empty":8}
["该表涉及图片审核"]

{"sheet":"审批管理","index":11,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["表名：","alumni_apply"]
["字段名","字段类型","注释"]
["id","int","主键ID"]
["data_id","int","数据ID"]
["org_name","varchar","组织名称"]
["user_name","varchar","申请人"]
["phone","varchar","联系方式"]
["college_name","varchar","学院"]
["period_name","varchar","学段"]
["major_name","varchar","专业"]
["class_name","varchar","班级"]
["model_id","int","模块ID  组织：1 活动：2 母校代言：3 相册：4"]
["theme","varchar","活动标题"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","varchar","创建人员"]
["update_user","varchar","更新人员"]
["deleted","int","逻辑删除 未删除：0；删除：1"]
[]
[]
[]
[]
["得做一个汇总审批数据"]

{"sheet":"活动报名","index":12,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["表名：","activity_report"]
["字段名","字段类型","注释"]
["id","int","主键ID"]
["activity_id","int","活动ID"]
["user_id","int","用户ID"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","varchar","创建人员"]
["update_user","varchar","更新人员"]
["deleted","int","逻辑删除 未删除：0；删除：1"]

{"sheet":"活动签到","index":13,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["表名：","activity_signin"]
["字段名","字段类型","注释"]
["id","int","主键ID"]
["activity_id","int","活动ID"]
["user_id","int","用户ID"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","varchar","创建人员"]
["update_user","varchar","更新人员"]
["deleted","int","逻辑删除 未删除：0；删除：1"]

{"sheet":"母校代言","index":14,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["表名：","alumni_endorse"]
["字段名","字段类型","注释"]
["id","int","主键ID"]
["data_no","varchar","编号"]
["card_number","varchar","卡号"]
["name","varchar","姓名"]
["user_id","int","用户ID"]
["image","varchar","照片"]
["descript","text","个人简介"]
["is_pass","int","是否审核通过 待审核：1  通过：2  拒绝：3"]
["pass_time","datetime","审核时间"]
["pass_value","text","审批意见"]
["apply_user","varchar","审核人"]
["apply_user_admin","text","审核人名称"]
["preferred_method","int","推荐方式  自荐：1 分院推荐：2"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","varchar","创建人员"]
["update_user","varchar","更新人员"]
["deleted","int","逻辑删除 未删除：0；删除：1"]

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

{"sheet":"新闻聚焦","index":16,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["表名：","alumni_news"]
["字段名","字段类型","注释"]
["id","int","主键ID"]
["theme","varchar","标题"]
["content","longtext","内容"]
["category_id","int","分类ID"]
["category_name","varchar","分类名称"]
["user_id","int","发件人ID"]
["user_name","varchar","发件人名称"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","varchar","创建人员"]
["update_user","varchar","更新人员"]
["deleted","int","逻辑删除 未删除：0；删除：1"]

{"sheet":"返校申请","index":17,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["表名：","alumni_return"]
["字段名","字段类型","注释"]
["id","int","主键ID"]
["school_id","int","校区ID  黄家湖校区：1  墨轩湖校区：2"]
["name","varchar(255)","校友姓名"]
["card_number","varchar(255)","微校卡号"]
["user_id","id","返校人ID"]
["phone","varchar(255)","手机号"]
["returns_time","datetime","返校开始时间"]
["returne_time","datetime","返校结束时间"]
["remark","longtext","返校事由"]
["is_pass","int","审核状态"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","int","创建人员"]
["update_user","int","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]

{"sheet":"心链计划","index":18,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["表名：","alumni_heart"]
["字段名","字段类型","注释"]
["id","int","主键ID"]
["equity_name","varchar(255)","权益名称"]
["cover_image","text","封面图"]
["content","longtext","权益内容"]
["is_top","int","是否置顶  是：1  否：2"]
["create_time","datetime","创建时间"]
["update_time","datetime","更新时间"]
["create_user","int","创建人员"]
["update_user","int","更新人员"]
["delete","int","逻辑删除\n未删除：0\n删除：1"]