Re: Time keeping in DB

On Wed, 2009-08-05 at 14:18 -0500, Shawn McKenzie wrote: > 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 > I'd go with a record per timesheet, so you might end up with more than one timesheet per day. That way, it's just simple SQL to find out how many hours you've worked on one day, or on one job, etc. Thanks, Ash http://www.ashleysheridan.co.uk