{"text_format":"2","workbook":"xlsx","n_sheets":3,"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":74,"n_cols":5,"rows_kept":74,"cut":false,"hidden":false,"merged":[[35,0,39,4],[64,0,65,3],[1,0,1,4],[53,0,54,3],[40,0,41,3]]}
["字段名称","字段类型","说明"]
["Resume(简历表)"]
["ResumeID","int","简历id","主键","基本信息"]
["ResumeName","varchar","简历名称",null,"基本信息"]
["UserName","varchar","姓名",null,"基本信息"]
["Gender","varchar","性别",null,"基本信息"]
["Birthday","timestamp","生日",null,"基本信息"]
["Age","varchar","年龄",null,"基本信息"]
["Degree","varchar","学历",null,"基本信息"]
["Experience","varchar","工作年限",null,"基本信息"]
["Mobile","varchar","手机号码",null,"基本信息"]
["CardNo","varchar","身份证账号",null,"基本信息"]
["Email","varchar","电子邮箱",null,"基本信息"]
["IsMarryed","int","是否已婚",null,"基本信息"]
["Residence","varchar","居住地",null,"基本信息"]
["Origin","varchar","籍贯",null,"基本信息"]
["Nationality","varchar","民族",null,"基本信息"]
["GraduateCollege","varchar","毕业院校",null,"基本信息"]
["Major","varchar","专业",null,"基本信息"]
["Lanuage","varchar","语言水平",null,"基本信息"]
["GraduateDate","timestamp","毕业时间"]
["PositionRating","varchar","评级（初级，中级，高级）",null,"由工作经验来区分？"]
["KeyWords","varchar","技能关键字"]
["JobObjective","varchar","求职意向"]
["Salary","varchar","期望工资"]
["SelfIntroduce","varchar","自我介绍",null,"基本信息"]
["UserId","int","用户ID",null,"可以作为外键 关联用户"]
["HeadUrl","varchar","用户图片地址",null,"基本信息"]
["IsPrivate","int","公开还是私密"]
["IsDeleted","int","是否删除"]
["CreateDate","timestamp","创建时间"]
["UpdateUserId","int","修改人id"]
["updateDate","timestamp","修改时间"]
["ResumeDownloadUrl","varchar","文件下载地址"]
["Status","int","状态表",null,"外键关联字典表"]
["简历还包括一些复杂的信息，有：工作经历，项目经验，教育经历。"]
[]
[]
[]
[]
["ResumeWork（工作经历，指工作过的公司）"]
[]
["WorkID","int","工作记录id",null,"主键"]
["CompanyName","varchar","公司名称",null,"基本信息"]
["CompanyPosition","varchar","公司地址",null,"基本信息"]
["LeaderName","varchar","证明人",null,"基本信息"]
["LeaderMobile","varchar","证明人联系方式",null,"基本信息"]
["IinductionStartDate","timestamp","入职时间",null,"基本信息"]
["IinductionEndDate","timestamp","离职时间",null,"基本信息"]
["PostionName","varchar","岗位",null,"基本信息"]
["WorkDetail","varchar","工作描述",null,"基本信息"]
["Reason","varchar","离职原因",null,"基本信息"]
["ResumeID","int","简历ID",null,"外键"]
["ResumeProject(项目经验，曾经参与的项目)"]
[]
["ProjectID","int","项目ID",null,"主键"]
["ProjectName","varchar","项目名称",null,"基本信息"]
["ProjectDetail","varchar","项目描述",null,"基本信息"]
["PartIn","varchar","你参与的内容描述",null,"基本信息"]
["ProjectStartDate","timestamp","项目开始时间",null,"基本信息"]
["ProjectEndDate","timestamp","项目结束时间",null,"基本信息"]
["DevelopEnvironment","varchar","软件环境"]
["DevelopTools","varchar","开发工具"]
["ResumeID","int","简历ID",null,"外键"]
["ResumeEducation（教育经历）"]
[]
["EduId","int","教育ID",null,"主键"]
["SchoolName","varchar","学校名称",null,"基本信息"]
["Major","varchar","专业",null,"基本信息"]
["EduStartDate","timestamp","入学时间",null,"基本信息"]
["EduEndDate","timestamp","毕业时间",null,"基本信息"]
["Detail","varchar","描述",null,"基本信息"]
["Degree","varchar","学历",null,"基本信息"]
["ResumeID","int","简历ID",null,"外键"]

{"sheet":"项目管理","index":1,"n_rows":47,"n_cols":4,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,0,4,3],[22,0,24,2],[34,0,36,2]]}
["字段名称","字段类型","说明"]
["RecruitProject(招聘项目表)"]
[]
[]
[]
["ProjectID","int","主键"]
["ProjectName","varchar","项目名称，（时间+公司名称+职位+人数）自动生成","input框合成"]
["CompanyId","int","外键关联 RecruitCompany的主键","下拉框"]
["PositionName","varchar","招聘职位名称，","input框输入"]
["KeyWords","varchar","关键词，以逗号隔开，可以添加多个标签关键字","下拉框，技术做成字典，和简历解析共用同一份数据"]
["Degree","varchar"," 学历要求","input框"]
["Experience","varchar","工作经验","input输入"]
["Salary","varchar","工资要求","input框输入（更灵活一点）"]
["PositionNumber","varchar","招聘人数","input输入，可以写成 3-6人，更灵活"]
["Detail","varchar","详细描述","textArea"]
["Status","bit","项目状态，false和true","0 代表  热招中， 1招聘结束，只有两个状态"]
["UserId","int","创建人Id"]
["CreateDate","date","创建时间"]
["UpdateUserId","int","更新人"]
["UpdateDate","date","更新时间"]
[]
[]
["ResumeRecruitProject（项目简历绑定关系）"]
[]
[]
["ResumeProjectId","int","主键"]
["ResumeId","int","外键关联Resum表的主键"]
["ProjectId","int","外键关联RecruitProject表的主键"]
["UserId","int","外键关联 SysUser 的主键","绑定人"]
["BindDate","Date","绑定时间"]
["IsDelete","bit","是否被删除（解绑）"]
["DeleteUserId","int","解绑人的userId,外键关联 sysUser"]
["DeleteDate","Date","解绑时间"]
["DeleteReson","varchar","解绑原因(已入职，未录用)"]
["RecruitCompany(招聘公司)"]
[]
[]
["CompanyId","int","主键"]
["CompanyName","varchar","公司名称"]
["CompanyAddress","varchar","公司地址"]
["ContactName","varchar","联系人姓名"]
["ContactMobile","varchar","联系电话"]
["ContactEmail","varchar","联系人电子邮件"]
["createUserId","int","创建人userId"]
["createDate","date","创建时间"]
["updateUserId","int","修改人userId"]
["updateDate","date","修改时间"]

{"sheet":"招聘管理","index":2,"n_rows":53,"n_cols":3,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,0,2,3],[16,0,18,2]]}
["Interview(面试邀约)"]
[]
[]
["InterviewId","int","主键"]
["ResumeId","int","外键关联，Resume表的主键"]
["ProjectId","int","外键关联，RecruitProject表的主键"]
["Interviewer","int","外键关联SysUser主键，面试官"]
["MeetingDate","varchar","面试安排时间"]
["status","varchar","0面试中，1未录用，2已录用，3未入职，4已入职"]
["UnEmplyeeReson","varchar","没有录用，请说明 原因"]
["UnJoineReson","varchar","没有入职原因"]
["JoinDate","date","入职时间"]
["Salary","varchar","工资"]
["UserId","int","面试邀请人,外键关联SysUser主键"]
["InterviewDate","date","邀请时间"]
["IsDeleted","bit","是否取消面试"]
["InterviewRecord"]
[]
[]
["RecordId","int","主键"]
["InterviewId","int","外键关联"]
["ProjectName","varchar","项目名称"]
["Username","varchar","应聘人姓名"]
["Gender","varchar","性别"]
["MobilePhone","varchar","电话"]
["Position","varchar","应聘职位"]
["MeetingDate","date","面试时间"]
["Interviewer","int","面试人"]
["BaseInfo1","varchar","礼貌与仪容"]
["BaseInfo2","varchar","言语表达沟通能力"]
["BaseInfo3","varchar","加班态度"]
["BaseInfo4","varchar","稳定性和忠诚度"]
["BaseInfo5","varchar","时间观念与纪律观念"]
["BaseInfo6","varchar","对公司资料及程序代码管理的风险意识"]
["BaseInfo7","varchar","团队合作及配合情况"]
["BaseInfo8","varchar","自我认识能力"]
["AdvanceInfo1","varchar","程序开发经验"]
["AdvanceInfo2","varchar","擅长的开发工具及数据库"]
["AdvanceInfo3","varchar","是否做过企业管理软件，什么行业？"]
["AdvanceInfo4","varchar","软件开发学习能力"]
["AdvanceInfo5","varchar","思维逻辑性，条理性"]
["AdvanceInfo6","varchar","可培养潜力、可塑造性、与公司的成长适合度"]
["AdvanceInfo7","varchar","所具备的专业知识、工作技能与招聘职位要求的吻合性"]
["FinalInfo1","varchar","责任心"]
["FinalInfo2","varchar","个人工作观念"]
["FinalInfo3","varchar","对企业的忠诚度"]
["FinalInfo4","varchar","个性特征与企业文化的相融性"]
["FinalInfo5","varchar","稳定性、发展潜力"]
["FinalInfo6","varchar","职位胜任能力"]
["Record","varchar","评价结果（文本输入）"]
["Advice","varchar","建议(录用，不录用) 下拉选择"]
["UserId","int","录入人"]
["updateDate","date","最后更新时间"]