时钟 - 表设计 [英] Time Clock - Table Design

问题描述

你可以在同一张桌子还是单独的表格中存储/打印？为什么？

修改 - 小时员工在轮班开始时就打了一拳，在换班结束时打了出来。每小时 - 免除雇员在开始/结束时除了入/出之外，还必须打入午餐。

解决方案

p>只要把它当成一个'事件'表格，那么在和 之间 em>。 （ 可能不适用于这种情况。）

What is the best design for a punch in/out table?

Would you store the punch in/out in the same table or separate tables? Why?

Edit - Hourly employees punch in at the beginning of their shift and punch out at the end of their shift. Hourly - Exempt employees must punch out/in for lunch in addition to the in/out at the beginning/end of the day.

解决方案

Just think of it as an 'events' table, with attributes for the usual who, what (punched in or out), when and where. (How probably doesn't apply in this case.)

这篇关于时钟 - 表设计的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！