title: Best way to structure a TimeSheet table?
body: <p>So I am desiging a db and my site has a <code>TimeSheet</code> in the timesheet there is 7 <code>days</code>, in those 7 days you can choose a <code>project</code> you are working on and how many <code>hours</code> you spent on said <code>project</code>. I'm having trouble designing this in an effiecient way that doesn't hurt my head.</p>
  <p>Originally, I thought to have a <code>TimeSheet</code> table that has an <code>User</code>, <code>Date</code>, <code>Hours</code>, and <code>Project</code> column, but that would store just one day and a <code>TimeSheet</code> has 7 days in it.</p>
  <p>Should I create a seperate table for Day and do a many-to-many between <code>TimeSheet</code> and <code>Day</code> or am I overthinking this and there could be an easier more effecient way,but then if I do that whats the point of having a TimeSheet?</p>