------考勤系统数据库设计方案。-----

Question

以下是我们公司用的数据库结构，希望对你有所帮助！
表结构:                 E:\WORK\考勤\DATA\CRFKQ3.DBF //班次表
数据记录数:             62      
最近更新的时间:         11/21/2001
代码页:                 936     
 字段  字段名          类型                 宽度 小数位    索引   排序    Nulls
    1  班次            字符型                  2           升序   PINYIN     否
    2  上班时间1       字符型                  5                             否
    3  下班时间1       字符型                  5                             否
    4  上班时间2       字符型                  5                             否
    5  下班时间2       字符型                  5                             否
    6  加班起始        字符型                  5                             否
    7  加班终止        字符型                  5                             否
    8  标识            字符型                  6                             否表结构:                 E:\WORK\考勤\DATA\CRFKQ4.DBF //员工排班表
数据记录数:             1994    
最近更新的时间:         11/23/2001
代码页:                 936     
 字段  字段名          类型                 宽度 小数位    索引   排序    Nulls
    1  卡号            字符型                  6           升序   PINYIN     否
    2  职号            字符型                  4           升序   PINYIN     否
    3  姓名            字符型                  8           升序   PINYIN     否
    4  部门            字符型                 10                             否
    5  年月份          字符型                  7                             否
    6  D01             字符型                  2                             否
    7  D02             字符型                  2                             否
    8  D03             字符型                  2                             否
    9  D04             字符型                  2                             否
   10  D05             字符型                  2                             否
   11  D06             字符型                  2                             否
   12  D07             字符型                  2                             否
   13  D08             字符型                  2                             否
   14  D09             字符型                  2                             否
   15  D10             字符型                  2                             否
   16  D11             字符型                  2                             否
   17  D12             字符型                  2                             否
   18  D13             字符型                  2                             否
   19  D14             字符型                  2                             否
   20  D15             字符型                  2                             否
   21  D16             字符型                  2                             否
   22  D17             字符型                  2                             否
   23  D18             字符型                  2                             否
   24  D19             字符型                  2                             否
   25  D20             字符型                  2                             否
   26  D21             字符型                  2                             否
   27  D22             字符型                  2                             否
   28  D23             字符型                  2                             否
   29  D24             字符型                  2                             否
   30  D25             字符型                  2                             否
   31  D26             字符型                  2                             否
   32  D27             字符型                  2                             否
   33  D28             字符型                  2                             否
   34  D29             字符型                  2                             否
   35  D30             字符型                  2                             否
   36  D31             字符型                  2                             否
   37  录入员          字符型                 25                             否表结构:                 E:\WORK\考勤\DATA\CRFKQ1.DBF //缺勤表
数据记录数:             3863    
最近更新的时间:         11/07/2001
代码页:                 936     
 字段  字段名          类型                 宽度 小数位    索引   排序    Nulls
    1  日期            日期型                  8           升序   PINYIN     否
    2  职号            字符型                  4           升序   PINYIN     否
    3  姓名            字符型                  8           升序   PINYIN     否
    4  缺勤类别        字符型                  4           升序   PINYIN     否
    5  起始时间        字符型                  5                             否
    6  终止时间        字符型                  5                             否
    7  卡号            字符型                  6           升序   PINYIN     否
    8  录入员          字符型                 25           升序   PINYIN     否

Answer 1

谢谢(韵杰),
但将加班放在班次表中，如果加班时间不确定不是要很多个班次吗？

Answer 2

那是肯定的，你有其它更好的方案吗？

Answer 3

我是将正常上班时间设班组，加班不理，有加班时写加班纸，再将打卡记录直接写到加班纸中，再来计算实际加班时间。

Answer 4

有谁写过比较复杂的考勤系统的呢，请指教指教吧，有分一定送，还有如果你是在珠海的话，一定请吃饭。

Answer 5

我在酒店行业工作，发现市场上的考勤系统对酒店行业不适用，因为酒店的服务员班次太多，且复杂。听说北京和平饭店与安徽合肥和平大酒店用的考勤系统适用班次多的情况。我记不起叫什么，大家可以去问问