Results 1 to 2 of 2

Thread: how to design part time an full time employees table

  1. #1
    Join Date
    Sep 2011
    Posts
    9
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Default how to design part time an full time employees table

    i have a project in which client can assign a full time employee and a part time employee. If a full time employee is assigned,then he will not be available for 1 month.But if a part time employee assigned , then he will be available for a half day for 1 month. He can assigned for other half day in the same month.How can we design the tables inorder to solve .

  2. #2
    Join Date
    Jan 2007
    Location
    Davenport, Iowa
    Posts
    1,689
    Thanks
    82
    Thanked 89 Times in 87 Posts

    Default

    Create a table Employees with columns: ID INT, Names TEXT, fulltimeparttime TEXT, dateassigned DATE.

    From here you can use PHP to detect when he was assigned and whether he is employed full time or part time. You can also use PHP to determine when he will be available next and if he is currently available.

    This is just a basic answer, but we need a little more information on what you are trying to do.
    To choose the lesser of two evils is still to choose evil. My personal site

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
  •