How to Structure MySQL Tables for a Timesheet
I am thoroughly stumped as to how to efficiently structure the tables for a timesheet, in a flexible manner... There are also other aspects to the project that I am working on, that I am having difficulty with, but I figured this would be the best place to start.
It is a mysql database, and is being accessed through PHP. The original timesheet is attached, and needs to be flexible regarding the number and names of employees worked, days and hours worked, and the dates associated with the timesheet.
Each week, I need to be able to pull a timesheet, according to its week ending date and the project, that displays the hours of X number of employees that worked on that job, Y number of days from Sunday through Saturday..
Any [detailed] help would be greatly appreciated!