|
|
| (3 intermediate revisions by the same user not shown) |
| Line 2: |
Line 2: |
| | | | |
| | | | |
| − | [[FGVwiki:Signs|Signs]] at vancouver's wiki
| + | {| class="wikitable sortable" border="1" |
| | + | |+Sortable table |
| | + | |- |
| | + | ! Alphabetic !! Numeric !! Date !! class="unsortable" | Unsortable |
| | + | |- |
| | + | | d || 20 || 2008-11-24 || This |
| | + | |- |
| | + | | b || 8 || 2004-03-01 || column |
| | + | |- |
| | + | | a || 6 || 1979-07-23 || cannot |
| | + | |- |
| | + | | c || 4 || 1492-12-08 || be |
| | + | |- |
| | + | | e || 0 || 1601-08-13 || sorted. |
| | + | |} |
| | | | |
| | | | |
| − | == Volunteer scheduling schema diagram ==
| |
| − | <graphviz>
| |
| − | digraph g {
| |
| | | | |
| − | node [shape="box", fontname="Helvetica", fontsize="11"]
| + | [[FGVwiki:Signs|Signs]] at vancouver's wiki |
| − | edge [fontname="Helvetica"]
| |
| − | | |
| − | groupings_schedules -> groupings [arrowhead = "crow"]
| |
| − | groupings_schedules -> schedules [arrowhead = "crow"]
| |
| − | | |
| − | schedules -> virtual_shifts [arrowhead = "crow"]
| |
| − | schedules -> jobs [arrowhead = "crow"]
| |
| − | schedules -> actual_shifts [arrowhead = "crow"]
| |
| − | | |
| − | virtual_shifts -> actual_shifts [arrowhead = "crow"]
| |
| − | | |
| − | jobs -> actual_shifts [arrowhead = "crow"]
| |
| − | jobs -> virtual_shifts [arrowhead = "crow"]
| |
| − | | |
| − | volunteers -> actual_shifts [arrowhead = "crow"]
| |
| − | volunteers -> virtual_shifts [arrowhead = "crow"]
| |
| | | | |
| | + | <graphviz> |
| | + | digraph D { |
| | + | a -> b |
| | + | a -> c |
| | + | a -> d |
| | + | a -> d |
| | + | a -> d |
| | + | b -> c |
| | + | b -> c |
| | + | b -> c |
| | + | b -> d |
| | + | c -> d |
| | | | |
| | } | | } |
| | </graphviz> | | </graphviz> |
| | | | |
| − | | + | 'circo': |
| − | ;actual_shifts (representing a single shift on an actual schedule with a defined date)
| + | 'dot': |
| − | :shift_date (date shift will be scheduled)
| + | 'fdp': |
| − | :start_time (start time of shift on that date)
| + | 'neato': |
| − | :end_time (end time of shift on that date)
| + | 'twopi': |
| − | :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) | |
