Re: Time keeping in DB
| From: | Ben Dunlap | Date: | Wed, 05 Aug 2009 21:53:02 +0000 |
| Subject: | Re: Time keeping in DB | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-296350@lists.php.net to get a copy of this message | ||
> sorry man, but a good data design keeps only data in a table u can not
> calculate. in ur case that would be only <date> <start> and <end> time.
> refernces to user and project/tasks in other tables.
>
> ur time sheet is definately a job for a report. that type of design limits u
> to nothing. a user can start ans stop as many times he wants a day or time
> range. u can report any number of time bits to any number of project a day
> or time range
I agree (unless the app just doesn't have access to the start/stop data).
Ben