title: database schema for timesheet
body: <p>Could someone help me with a rough database schema for a timesheet application where the i would be able to</p>
  
  <ol>
  <li><p>Store hours per day for a time period ( 2 weeks ) for different projects. Ex person A can put 3 hours for projectA and 4 hours for projectB on the same day</p></li>
  <li><p>Make it so that its is easy to get a reports on total hours put for a project, or to get total hours on all projects by a certain person</p></li>
  </ol>
  
  <p>EDIT: Another requirement would be that each timesheet for a particular time period for every person needs to have a field indicating that the person has submitted the timesheet and another saying that it has been approved</p>