考勤表结构设计.docx

考勤表结构设计编写者版本号日期甄志莲V1.02016-02-25假别表:ps_vacation_type字段名类型是否为空备注Idbigint(20)否自增 IDvacation_typeVarchar(30)是假期类型vacation_noVarchar(30)是旧的历史记录同步现有ps系统，新的可以自己定义vacation_rule_oneVarchar(50)是假期规则定义：如病假一年之内不允许超过两个月vacation_rule_twoVarchar(20)是假期规则定义：比如哺乳假、产检假等只允许女性员工享受org_idbigint(20)是组织id二、考勤类型表:ps_ attendance_type字段名类型是否为空备注Idbigint(20)否自增 IDattendance_type_nobigint(20)是考勤类型编号attendance_typeVarchar(20)是考勤类型org_idbigint(20)是组织id三、班别设置表：ps_ attendance_class_type字段名类型是否为空备注Idbigint(20)否自增 IDclass _type_nobigint(20)是班别类型编号class _typeVarchar(20)是班别类型begin_timebigint(20)是开始时间end_timebigint(20)是结束时间org_idbigint(20)是组织id四、缺勤原因表：ps_ absence字段名类型是否为空备注Idbigint(20)否自增 IDabsence_nobigint(20)是缺勤类型编号absence_reason_typeVarchar(20)是缺勤原因org_idbigint(20)是组织id五、加班类型表：ps_ work_overtime_type字段名类型是否为空备注Idbigint(20)否自增 IDwork_overtime _nobigint(20)是加班类型编号work_overtime _typeVarchar(20)是加班类型org_idbigint(20)是组织id六、附件表：ps_attachment_info字段名类型是否为空备注Idbigint(20)否自增 IDattendance_info_idbigint(20)是员工请假、补考勤、调班的信息表主键attendance_noVarchar(30)是所有假别编号、补考勤编号、调班编号等等attachmentVarchar(200)是附件图片url七、员工请假信息表：ps_employee_vacation_info字段名类型是否为空备注Idbigint(20)否自增 IDposition_idbigint(20)是岗位编号position_nameVarchar(20)是岗位名称employee_idbigint(20)是员工编号employee_nameVarchar(20)是员工姓名employee_imageVarchar(200)是头像图片保存的URL地址vacation_idVarchar(20)是假期类型编号begin_timebigint(20)是开始日期，精确到小时end_timebigint(20)是结束日期，精确到小时reason _for_vacationVarchar(50)是请假事由attachment_idVarchar(50)是附件图片保存的URL地址获取，与附件表关联，因为附件与请假id是一对多关系，所以单独放到附件表vacation_process_idVarchar(50)是调用审批业务流程的编号org_idbigint(20)是组织id八、审批流程抄送人信息表：ps_ vacation_ approval_cc_Info字段名类型是否为空备注Idbigint(20)否自增 IDvacation_process_idVarchar(50)是调用审批业务流程的编号position_idbigint(20)是抄送人岗位Idposition_nameVarchar(20)是抄送人岗位名称employee_nameVarchar(20)是员工名称employee_imageVarchar(200)是员工头像employee_vacation_idbigint(20)员工请假信息表主键九、员工补考勤信息表：ps_ employee_supplement_attendance_info字段名类型是否为空备注Idbigint(20)否自增 IDposition_idbigint(20)是岗位编号position_nameVarchar(20)是岗位名称employee_idbigint(20)是员工编号employee_nameVar