搜索
1.1.1职位调配表（AllocateInfo）AllocateInfo职位调配表字段名字段说明数据类型不为空唯一值备注Allocate_ID调配编号intTrueTrue主键Allocate_EmployeeNo员工编号intFalsefalseAllocate_LeaveDept调离部门varchar(32)FalseFalseAllocate_LeavePost调离职位varchar(32)FalseFalseAllocate_AppointDept调入部门varchar(32)FalseFalseAllocate_AppointPost调入职位varchar(32)FalseFalseAllocate_Cause处理原因varchar(256)FalseFalseAllocate_Type调配类型varchar(32)FalseFalse表3.2a职位调配表与其它表之间的关联关系键名类型字段备注FK_AllocateInfo_EmployeePublicAllocate_EmployeeNoPK_AllocateInfoPublicAllocate_IDUQ_AllocateInfo_Allocate_EmployeeNoPublicAllocate_EmployeeNoUQ_AllocateInfo_Allocate_IDPublicAllocate_ID表3.2b1.1.2员工档案表（Archives）字段名字段说明数据类型不为空唯一值备注Archives_ID档案编号intTrueTrue主键Archives_EmployeeID员工编号intTrueTrueArchives_TypeName档案名称varchar(50)TrueFalseArchives_Content档案内容textTrueFalseArchives_Remark备注varchar(125)FalseFalse表3.3a键名类型字段备注FK_Archives_EmployeePublicArchives_EmployeeIDPK_ArchivesPublicArchives_IDUQ_Archives_Archives_EmployeeIDPublicArchives_EmployeeIDUQ_Archives_Archives_IDPublicArchives_ID表3.3b1.1.3考勤信息表（AttendanceInfo）字段名字段说明数据类型不为空唯一值备注Attend_ID考勤编号intTrueTrue主键Attend_EmployeeNo员工编号intFalseTrueAttend_Month月份varchar（12）FalseTrueAttend_WorkDay工作天数intFalseFalseAttend_LateDay迟到天数intFalseFalseAttend_EarlyDay早退天数intFalseFalseAttend_LeaveType请假类型varchar（12）FalseTrueAttend_LeaveDay请假天数intFalseFalse表3.4a键名类型字段备注FK_AttendanceInfo_EmployeePublicAttend_EmployeeNoPK_AttendanceInfoPublicAttend_IDUQ_AttendanceInfo_Attend_EmployeeNoPublicAttend_EmployeeNoUQ_AttendanceInfo_Attend_IDPublicAttend_IDUQ_AttendanceInfo_Attend_LeaveTypePublicAttend_LeaveTypeUQ_AttendanceInfo_Attend_MonthPublicAttend_Month表3.4b1.1.4员工证书（Certificate）字段名字段说明数据类型不为空唯一值备注Certificate_ID证书编号intTrueTrueCertificate_PersonID学员编号intTrueTrueCertificate_Name证书名varchar（10）FalseFalseCertificate_Time证书发放时间datetimeFalseFalseCertificate_Picture证书的图片varchar（50）FalseFalseCertificate_Part证书发放单位varchar（50）FalseFalse表3.5a键名类型字段备注FK_Certificate_TrainManagePublicCertificate_PersonIDPK_CertificatePublicCertificate_IDUQ_Certificate_Certificate_IDPublicCertificate_IDUQ_Certificate_Certificate_PersonIDPublicCertificate_PersonID表3.5b1.1.5合同表（Contract）字段名字段说明数据类型不为空唯一值备注Contract_ID合同编号intTrueTrue主键Contract_EmployeeID员工编号intTrueFalseContract_EmployeeName员工姓名varchar（10）TrueFalseContract_Job职务varchar（20）TrueFalseContract_Department部门varchar（20）TrueFalseContract_Type合同类型varchar（20）TrueFalseContract_Statu合同状态varchar（16）TrueFalseContract_StartTime开始时间datetimeTrueFalseContract_EndTime结束时间datetimeTrueFalseContract_Content合同内容textTrueFalse表3.6a键名类型字段备注FK_Contract_EmployeePublicContract_EmployeeIDPK_ContractPublicContract_IDUQ_Contract_Contract_EmployeeIDPublicContract_EmployeeIDUQ_Contract_Contract_IDPublicContract_ID表3.6b1.1.6教育情况表（Education）字段名字段说明数据类型不为空唯一值备注Education_ID教育情况编号intTrueTrue主键Education_EmployeeID员工编号intTrueTrueEducation_HighestXueL最高学历varchar（16）TrueFalseEducation_FinishSchool毕业院校varchar（30）TrueFalseEducation_StartTime开始时间datetimeTrueFalseEducation_EndTime结束时间datetimeTrueFalseEducation_SchoolName学校名称varchar（30）TrueFalseEducation_Major主修专业varchar（30）TrueFalseEducation_IfFinishSchool是否毕业varchar（10）TrueFalseEducation_Certifier证明人char（10）TrueFalse表3.7a键名类型字段备注FK_Education_EmployeePublicEducation_EmployeeIDPK_EducationPublicEducation_IDUQ_Education_Education_EmployeeIDPublicEducation_EmployeeIDUQ_Education_Education_IDPublicEducation_ID表3.7b1.1.7应聘信息表（EmployInfo）字段名字段说明数据类型不为空唯一值备注Employ_ID应聘编号intTrueTrueEmploy_Job应聘职位intTrueTrueEmploy_ResumeID简历编号intTrueTrueEmploy_InterviewTime面试时间datetimeTrueFalseEmploy_InterviewState面试状态bitTrueFalseEmploy_AuditState审核状态bitTrueFalseEmploy_Interviewer面试考官varchar(12)TrueFalseEmploy_SkillScore技能考核得分intFalseFalseEmploy_SkillAppraise技能评价varchar(256)FalseFalseEmploy_Synthesize综合得分intFalseFalseEmploy_SynthesizeAppraise综合评价varchar(256)FalseFalseEmploy_Remark备注varchar(256)FalseFalse表3.8a键名类型字段备注FK_EmployInfo_ArchivesPublicEmploy_ResumeIDPK_EmployInfoPublicEmploy_IDUQ_EmployInfo_Employ_IDPublicEmploy_IDUQ_EmployInfo_Employ_JobPublicEmploy_JobUQ_EmployInfo_Employ_ResumeIDPublicEmploy_ResumeID表3.8b1.1.8员工基本信息表（Employee）字段名字段说明数据类型不为空唯一值备注Employee_ID员工编号intTrueTrueEmployee_Name姓名varchar（10）TrueFalseEmployee_Sex性别char（1）TrueFalseEmployee_Nation名族varchar（12）TrueTrueEmployee_Site籍贯varchar（20）TrueFalseEmployee_PolityFace政治面貌varchar（8）TrueFalseEmployee_IDcard身份证号码char（18）TrueTrueEmployee_XueL学历varchar（16）TrueFalseEmployee_FinishSchool毕业院校varchar（30）TrueFalseEmployee_Age年龄datetimeTrueFalseEmployee_Phone联系电话varchar（16）TrueFalseEmployee_Major专业varchar（20）TrueFalseEmployee_Department部门intTrueFalseEmployee_Height身高varchar（10）TrueFalseEmployee_Job职务intTrueFalseEmployee_Marriage婚姻状况char（4）FalseFalseEmployee_Email电子邮箱varchar(20)FalseFalseEmployee_Address家庭地址varchar(60)FalseFalseEmployee_TeChang特长varchar(100)FalseFalse表3.9a键名类型字段备注FK_Employee_OrganizationInfoPublicEmployee_DepartmentFK_Employee_PositionInfoPublicEmployee_JobPK_EmployeePublicEmployee_IDUQ_Employee_Employee_IDPublicEmployee_IDUQ_Employee_Employee_IDcardPublicEmployee_IDcardUQ_Employee_Employee_NationPublicEmpl