Professional Web Applications Themes

How to store a schedule - MySQL

I'm trying to store schedules for student's work schedules. I cannot seem to come up with a good design of the data though. The biggested problem is that the students can work any number of shifts in a given day, so storing start and end times as two fields, or even multiple sets as two fields is not really an option. Currently the day is broken into 15 min increments and a series of 1's and 0's is scattered through a 64 character string to indicate when they work. This is horribly inefficent when trying to use the schedule to ...

  1. #1

    Default How to store a schedule

    I'm trying to store schedules for student's work schedules. I cannot
    seem to come up with a good design of the data though. The biggested
    problem is that the students can work any number of shifts in a given
    day, so storing start and end times as two fields, or even multiple
    sets as two fields is not really an option. Currently the day is
    broken into 15 min increments and a series of 1's and 0's is scattered
    through a 64 character string to indicate when they work. This is
    horribly inefficent when trying to use the schedule to calculate
    anything though. Surely I'm missing some obvious or well known way to
    store this kind of information. Any ideas or suggestions would be
    welcome.

    rfusca@gmail.com Guest

  2. #2

    Default Re: How to store a schedule

    com wrote: 

    Why isn't storing start and end times as two fields an option? Using a
    TIMESTAMP type you even have the date in there. Or you can keep the
    date as a third column (and the student id as the fourth).

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    net
    ==================
    Jerry Guest

  3. #3

    Default Re: How to store a schedule

    == Quote from rfusca (com)'s article 

    you don't need to do any of that stuff. just divide up the whole day by 15 min.
    intervals and create a column for each one of them. then if the kid works in say
    period 5, update it with a 'y' or something like that.
    lark Guest

  4. #4

    Default Re: How to store a schedule

    com wrote: 

    Why would you want to have a schedule for a schedule?


    Paul Guest

Similar Threads

  1. Schedule Tasks
    By MANIQuaker in forum Coldfusion Server Administration
    Replies: 1
    Last Post: January 29th, 08:09 PM
  2. SCHEDULE Event
    By Iceweasel in forum Coldfusion Server Administration
    Replies: 0
    Last Post: January 4th, 08:27 PM
  3. NTBackup will not schedule.
    By Geoff in forum Windows Server
    Replies: 41
    Last Post: August 17th, 02:55 PM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139