您好,欢迎访问三七文档
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
本文标题:HR数据库设计
链接地址:https://www.777doc.com/doc-3163454 .html