考勤系统数据表结构

1、考勤系统数据表结构考勤员信息设置 t_kqemp_infoman_idvarchar2(20)n工号post_infovarchar2(20)y岗位描述power_uservarchar2(20)y创建人power_datedatey创建时间power_user_deptvarchar2(20)y创建人部门power_popedomvarchar2(1)y锁定按钮排班设置 t_kqpb_setman_idvarchar2(20)n员工编号department_codevarchar2(20)y部门编号class_codevarchar2(10)y班次编号cyc_daysnumbery循环天数c

2、yc_nonumbery循环序号cyc_begindaten开始日期cyc_enddaten结束日期if_restvarchar2(2)y是否休息power_uservarchar2(20)y创建人power_datedatey创建时间power_user_deptvarchar2(20)y创建人部门power_popedomvarchar2(1)y锁定按钮idnumbern职工请假申请 t_kqqj_applyman_idvarchar2(20)n员工编号apply_datedaten申请日期kind_codevarchar2(10)y类别编号start_datedatey假期开始时间end

3、_datedatey假期结束时间apply_daysnumbery请假天数fake_causevarchar2(200)y请假原因power_uservarchar2(20)y创建人power_datedatey创建时间power_user_deptvarchar2(20)y创建人部门power_popedomvarchar2(1)y锁定按钮apply_codenumbern编号flow_statevarchar2(1)y'0'流程审批状态:0:未启用,1:执行中,2:执行完毕curoperatoridvarchar2(1000)y当前执行人curoperatorid_allv

4、archar2(2000)y全部执行人curnodenamevarchar2(100)y当前步聚sub_timedateydept_codevarchar2(20)y员工部门db_codevarchar2(20)y调班后的部门db_manidvarchar2(20)y替班人姓名db_datedatey换班日期db_classvarchar2(20)y换班班次this_classvarchar2(20)y换班人班次last_moitymanvarchar2(20)y最后修改人last_moitydatedatey最后修改日期职工销假管理 t_kqqj_sellman_idvarchar2(20)

5、n员工编号apply_datedaten申请日期start_datedatey假期开始时间end_datedatey假期结束时间apply_daysnumbery请假天数fake_typevarchar2(20)y请假类别fake_causevarchar2(200)y请假原因apply_statevarchar2(10)y审批状态type_kindvarchar2(20)y类别power_uservarchar2(20)y创建人power_datedatey创建时间power_user_deptvarchar2(20)y创建人部门power_popedomvarchar2(1)y锁定按钮ap

6、ply_codenumbern编号dept_codevarchar2(20)y部门last_moitymanvarchar2(20)y最后修改人last_moitydatedatey最后修改日期日历设置 t_kq_calendarsetup_datedaten日期week_dayvarchar2(10)y星期is_restvarchar2(2)y是否休息feast_namevarchar2(20)y节日名称power_uservarchar2(20)y创建人power_datedatey创建时间power_user_deptvarchar2(20)y创建人部门power_popedomvarc

7、har2(1)y锁定按钮班次设置 t_kq_class_setclass_codevarchar2(10)n班次编号class_namevarchar2(20)y班次名称on_dutyvarchar2(20)y上班类型on_timevarchar2(20)y上班时间off_dutyvarchar2(20)y下班类型off_timevarchar2(20)y下班时间power_datedatey创建时间power_user_deptvarchar2(20)y创建人部门power_uservarchar2(20)y创建人power_popedomvarchar2(1)y锁定按钮late_on_ti

8、mevarchar2(20)y最迟时间is_restvarchar2(2)y休息日t_kq_dutysum 考勤统计明细duty_datedaten上班日期man_idvarchar2(20)n工号dept_codevarchar2(20)y部门class_codevarchar2(10)y班次duty_countnumbery应出勤数duty_perfitnumbery实际出勤数be_latenumbery 是否迟到leave_earlynumbery是否早退absentnumbery 是否缺席descriptionvarchar2(100)y备注power_user_deptvarchar

9、2(20)y创建人部门power_uservarchar2(20)y创建人power_popedomvarchar2(1)y锁定按钮员工假期表 t_kq_employee_holshols_codenumbern假期编号man_idvarchar2(20)y员工姓名dept_codevarchar2(20)y部门名称hols_yearvarchar2(4)y年份kind_codevarchar2(10)y请假类别hols_daysnumbery假期天数start_datedatey有效开始期限end_datedatey有效期限结束limit_countnumbery限制次数fake_typev

10、archar2(2)y允许休假方式power_uservarchar2(20)y创建人power_datedatey创建时间power_user_deptvarchar2(20)y创建人部门power_popedomvarchar2(1)y锁定按钮use_limitnumbery已使用次数left_daysnumbery剩余天数use_daysnumbery使用天娄leave_timenumbery剩余次数假别定义 t_kq_fakesetfake_codenumbern假别编号fake_descvarchar2(50)y假别描述power_uservarchar2(20)y创建人power_

11、datedatey创建时间power_user_deptvarchar2(20)y创建人部门power_popedomvarchar2(1)y锁定按钮考勤原始数据表 t_kq_his_recordman_idvarchar2(20)y工号car_datedatey上班时间car_timevarchar2(20)y下班时间power_uservarchar2(20)y创建人power_datedatey创建时间power_user_deptvarchar2(20)y创建人部门power_popedomvarchar2(1)y锁定按钮dept_codevarchar2(20)y所属部门请假类别表

12、t_kq_leavekindkind_codevarchar2(10)n类别编号kind_namevarchar2(50)y类别名称fake_codenumbery假别max_daysnumbery天数限制degreenumbery次数限制power_uservarchar2(20)y创建人power_datedatey创建时间power_user_deptvarchar2(20)y创建人部门power_popedomvarchar2(1)y锁定按钮夜班明细表 t_kq_night_detailcar_datedatey日期manidvarchar2(20)y工号man_idvarchar2(

13、20)y工号dept_codevarchar2(20)y部门class_codevarchar2(20)y班次power_uservarchar2(20)ypower_datedateypower_user_deptvarchar2(20)ypower_popedomvarchar2(22)y'0'ifworkvarchar2(5)y是否加夜班出勤统计 t_kq_ondutysumduty_datedaten日期man_idvarchar2(20)n工号dept_codevarchar2(20)y部门class_codevarchar2(10)y班次duty_countnumb

14、ery应出勤duty_perfitnumbery实际出勤be_latenumbery迟到leave_earlynumbery早退absentnumbery旷工descriptionvarchar2(100)y备注power_uservarchar2(20)y创建人power_datedatey创建时间power_user_deptvarchar2(20)y创建人部门power_popedomvarchar2(1)y锁定按钮系统代码设定 t_kq_othercodeother_idvarchar2(20)n系统代码编号other_namevarchar2(30)y系统代码名称power_user

15、varchar2(20)y创建人power_datedatey创建时间power_user_deptvarchar2(20)y创建人部门power_popedomvarchar2(1)y锁定按钮系统代码明细表 t_kq_otherother_idvarchar2(20)n系统代码编号other_codevarchar2(2)n系统代码明细编号other_namevarchar2(30)y系统代码明细名称加班统计 t_kq_outtimeman_idvarchar2(50)y工号dept_codevarchar2(50)y部门car_datedatey日期car_timevarchar2(50)

16、y下班时间count_timenumbery加班小时power_uservarchar2(50)y创建人power_datedatey创建时间power_user_deptvarchar2(20)y创建人部门power_popedomvarchar2(1)y锁定按钮memovarchar2(50)y加班类型说明排班表 t_kq_pbman_idvarchar2(20)n员工编号department_codevarchar2(20)y部门编号d_datedaten排班日期class_codevarchar2(10)y班次编号power_uservarchar2(20)y创建人power_date

17、datey创建时间power_user_deptvarchar2(20)y创建人部门power_popedomvarchar2(1)y锁定按钮is_restvarchar2(2)y是否休息考勤数据表 t_kq_recordman_idvarchar2(20)y工号duty_timedatey上班时间off_timedatey下班时间work_datedatey考勤日期power_uservarchar2(20)y创建人power_datedatey创建时间power_user_deptvarchar2(20)y创建人部门power_popedomvarchar2(1)y锁定按钮补充打卡 t_k

18、q_renewfinger_novarchar2(20)y指模号man_idvarchar2(20)y工号dept_codevarchar2(20)y部门编号dk_timedatey打卡时间dk_flagvarchar2(1)y'1'打卡标志power_uservarchar2(20)y创建人power_datedatey创建时间power_user_deptvarchar2(20)y创建人部门power_popedomvarchar2(1)y锁定按钮dk_codenumbern编号考勤修改人员 t_kq_repiarmanman_idvarchar2(20)n员工编号power_uservarchar2(20)y创建人power_datedatey创建时间power_user_deptvarchar2(20)y创建人部门power_popedomvarchar2(1)y锁定