Difference between revisions of "User:Rfs/Scratch"
< User:Rfs
Jump to navigation
Jump to search
Line 59: | Line 59: | ||
:start_time | :start_time | ||
:end_time | :end_time | ||
− | :slot_count (1-N for use in producing multiple actual shifts) | + | :slot_count (1-N for use in producing multiple actual shifts, default = 1) |
:job_id | :job_id | ||
− | :volunteer_id (null allowed) | + | :volunteer_id (null allowed, this volunteer will be assigned to slot #1 when actual shifts are generated) |
:schedule_id | :schedule_id | ||
− | ;volunteers | + | ;volunteers (volunteer specific information could go here -- i.e. first volunteer date, status, reliability index, etc.) |
:contact_id | :contact_id | ||
:name (until hooked up to main app when name will come from contacts table) | :name (until hooked up to main app when name will come from contacts table) |
Revision as of 18:11, 16 June 2009
My Page Name (on the secure wiki
Signs at vancouver's wiki
Volunteer scheduling schema diagram
- actual_shifts (representing a single shift on an actual schedule with a defined date)
- shift_date (date shift will be scheduled)
- start_time (start time of shift on that date)
- end_time (end time of shift on that date)
- job_id
- volunteer_id
- groupings (a group of schedules that can be displayed together)
- name
- groupings_schedules
- grouping_id
- schedule_id
- jobs (job to be performed during the shift)
- name
- schedule_id
- schedules (for grouping related shifts)
- name
- virtual_shifts (representing a shift or shifts on an "ideal" schedule with no actual date yet attached)
- effective_date (first date this shift can appear on an actual schedule)
- ineffective_date (last date this shift can appear on an actual schedule)
- day_of_week (day of week, 0-6 = sun-sat)
- start_time
- end_time
- slot_count (1-N for use in producing multiple actual shifts, default = 1)
- job_id
- volunteer_id (null allowed, this volunteer will be assigned to slot #1 when actual shifts are generated)
- schedule_id
- volunteers (volunteer specific information could go here -- i.e. first volunteer date, status, reliability index, etc.)
- contact_id
- name (until hooked up to main app when name will come from contacts table)