Time keeping in DB
| From: | Shawn McKenzie | Date: | Wed, 05 Aug 2009 19:18:31 +0000 |
| Subject: | Time keeping in DB | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-296341@lists.php.net to get a copy of this message | ||
So, obviously not PHP related, but I'm looking for thoughts on the best
way to record time sheets in a DB. A time sheet for hours worked per
day, not like a time clock where you start and stop.
The two possibilities that I have thought of are (these are simplistic,
of course I'll be storing references to the user, the project code etc.):
1. One record for each 7 day week (year, week_num, d1, d2, d3, d4, d5,
d6, d7) where the dX field holds the hours worked
2. One record for each day (date, hours)
--
Thanks!
-Shawn
http://www.spidean.com