Time keeping in DB

From: 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

« previous php.general (#296341) next »