SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Threaded View

  1. #1
    SitePoint Member
    Join Date
    Jan 2011
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How to Structure MySQL Tables for a Timesheet

    Hello,

    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!

    Thanks
    Attached Files Attached Files


Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •