Difference between revisions of "User:Rfs/Scratch"
< User:Rfs
Jump to navigation
Jump to search
| Line 13: | Line 13: | ||
groupings_schedules -> groupings [arrowhead = "crow"] | groupings_schedules -> groupings [arrowhead = "crow"] | ||
| − | groupings_schedules -> schedules[arrowhead = "crow"] | + | groupings_schedules -> schedules [arrowhead = "crow"] |
schedules -> virtual_shifts [arrowhead = "crow"] | schedules -> virtual_shifts [arrowhead = "crow"] | ||
| Line 30: | Line 30: | ||
} | } | ||
</graphviz> | </graphviz> | ||
| + | |||
| + | |||
| + | ;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) | ||
| + | :job_id | ||
| + | :volunteer_id (null allowed) | ||
| + | :schedule_id | ||
| + | |||
| + | ;volunteers | ||
| + | :contact_id | ||
| + | :name (until hooked up to main app when name will come from contacts table) | ||
Revision as of 18:09, 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)
- job_id
- volunteer_id (null allowed)
- schedule_id
- volunteers
- contact_id
- name (until hooked up to main app when name will come from contacts table)