User:Rfs/Scratch - Revision history

Rfs at 19:47, 27 February 2010

2010-02-27T19:47:26Z

Rfs at 16:51, 22 October 2009

2009-10-22T16:51:53Z

Rfs at 16:47, 22 October 2009

2009-10-22T16:47:33Z

Rfs: /* Volunteer scheduling schema diagram */

2009-06-17T01:11:53Z

Volunteer scheduling schema diagram

Rfs: /* Volunteer scheduling schema diagram */

2009-06-17T01:11:28Z

Volunteer scheduling schema diagram

Rfs: /* Volunteer scheduling schema diagram */

2009-06-17T01:09:15Z

Volunteer scheduling schema diagram

Rfs at 00:48, 17 June 2009

2009-06-17T00:48:30Z

Rfs at 00:46, 17 June 2009

2009-06-17T00:46:36Z

Rfs at 00:45, 17 June 2009

2009-06-17T00:45:32Z

Rfs at 18:22, 12 June 2009

2009-06-12T18:22:16Z

← Older revision		Revision as of 19:47, 27 February 2010
Line 1:		Line 1:
	[[SFreekiWiki:My Page Name\|My Page Name]] (on the secure wiki		[[SFreekiWiki:My Page Name\|My Page Name]] (on the secure 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.
		+	\|}
		+

@@ Line 4: / Line 4: @@
 [[FGVwiki:Signs|Signs]] at vancouver's wiki
-<graphviz renderer='dot'>
+<graphviz>
 digraph D {
-   a -> b [weight=1]
+   a -> b
-   a -> c [weight=1]
+   a -> c
-   a -> d [weight=8]
+   a -> d
-   b -> c [weight=8]
+  a -> d
-   b -> d [weight=1]
+  a -> d
-   c -> d [weight=1]
+  b -> c
+}

← Older revision		Revision as of 16:47, 22 October 2009
Line 3:		Line 3:

	[[FGVwiki:Signs\|Signs]] at vancouver's wiki		[[FGVwiki:Signs\|Signs]] at vancouver's wiki
		+
		+	<graphviz renderer='dot'>
		+	digraph D {
		+	a -> b [weight=1]
		+	a -> c [weight=1]
		+	a -> d [weight=8]
		+	b -> c [weight=8]
		+	b -> d [weight=1]
		+	c -> d [weight=1]
		+
		+	}
		+	</graphviz>
		+
		+	'circo':
		+	'dot':
		+	'fdp':
		+	'neato':
		+	'twopi':

← Older revision		Revision as of 01:11, 17 June 2009
Line 3:		Line 3:

	[[FGVwiki:Signs\|Signs]] at vancouver's wiki		[[FGVwiki:Signs\|Signs]] at vancouver's wiki
−
−
−	~~== Volunteer scheduling schema diagram ==~~
−	~~<graphviz>~~
−	~~digraph g {~~
−
−	~~node [shape="box", fontname="Helvetica", fontsize="11"]~~
−	~~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>~~
−
−
−	~~;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)~~

@@ Line 59: / Line 59: @@
 :start_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
-:volunteer_id (null allowed)
+:volunteer_id (null allowed, this volunteer will be assigned to slot #1 when actual shifts are generated)
 :schedule_id
-;volunteers
+;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)

@@ Line 13: / Line 13: @@
 groupings_schedules -> groupings [arrowhead = "crow"]
-groupings_schedules -> schedules[arrowhead = "crow"]
+groupings_schedules -> schedules [arrowhead = "crow"]
 schedules -> virtual_shifts [arrowhead = "crow"]
@@ Line 30: / Line 30: @@
+}
 </graphviz>

@@ Line 7: / Line 7: @@
 digraph g {
-node [fontname="Helvetica", fontsize="11"]
+node [shape="box", fontname="Helvetica", fontsize="11"]
 edge [fontname="Helvetica"]

@@ Line 6: / Line 6: @@
 <graphviz>
 digraph g {
-"Records" [shape = record, fontsize = 18, label = "(Any RT::Record)" ];
+node [fontname="Helvetica", fontsize="11"]
-"Records" -> "Principals" [label = "Creator -> id"];
+edge [fontname="Helvetica"]
-"Attachments" [shape = record, fontsize = 18, label = "<col0> \N " ];
+groupings_schedules -> groupings [arrowhead = "crow"]
-"Attachments" -> "Transactions" [label="TransactionId -> id"];
+groupings_schedules -> schedules[arrowhead = "crow"]
-"CachedGroupMemers" [shape = record, fontsize = 18, label = "<col0> \N " ];
+schedules -> virtual_shifts [arrowhead = "crow"]
-"CachedGroupMemers" -> "Groups" [label="GroupId -> id", weight=2];
+schedules -> jobs [arrowhead = "crow"]
-"CachedGroupMemers" -> "Principals" [label="MemberId -> id"];
+schedules -> actual_shifts [arrowhead = "crow"]
-"CustomFields" [shape = record, fontsize = 18, label = "<col0> \N " ];
+virtual_shifts -> actual_shifts [arrowhead = "crow"]
-"CustomFieldValues" [shape = record, fontsize = 18, label = "<col0> \N " ];
+jobs -> actual_shifts [arrowhead = "crow"]
-"CustomFieldValues" -> "CustomFields" [label="CustomField -> id"];
+jobs -> virtual_shifts [arrowhead = "crow"]
-"GroupMembers" [shape = record, fontsize = 18, label = "<col0> \N " ];
+volunteers -> actual_shifts [arrowhead = "crow"]
-"GroupMembers" -> "Groups" [label="GroupId -> id", weight=2];
+volunteers -> virtual_shifts [arrowhead = "crow"]
+}
 </graphviz>

← Older revision		Revision as of 18:22, 12 June 2009
Line 3:		Line 3:

	[[FGVwiki:Signs\|Signs]] at vancouver's wiki		[[FGVwiki:Signs\|Signs]] at vancouver's wiki
		+
		+	<graphviz>
		+	digraph g {
		+	graph [
		+	rankdir = "RL",
		+	concentrate = true,
		+	ratio = auto
		+	];
		+	node [
		+	fontsize = "18",
		+	shape = record, fontsize = 18
		+	];
		+	edge [
		+	];
		+
		+	"Records" [shape = record, fontsize = 18, label = "(Any RT::Record)" ];
		+	"Records" -> "Principals" [label = "Creator -> id"];
		+	"ACL" [shape = record, fontsize = 18, label = "<col0> \N " ];
		+	"ACL" -> "Principals" [label="PrincipalId -> id"];
		+	"ACL" -> "Principals" [label="DelegatedBy -> id"];
		+	"ACL" -> "ACL" [label="DelegatedFrom -> id"];
		+
		+	"Attachments" [shape = record, fontsize = 18, label = "<col0> \N " ];
		+	"Attachments" -> "Transactions" [label="TransactionId -> id"];
		+	"Attachments" -> "Attachments" [label="Parent -> id"];
		+
		+	"CachedGroupMemers" [shape = record, fontsize = 18, label = "<col0> \N " ];
		+	"CachedGroupMemers" -> "Groups" [label="GroupId -> id", weight=2];
		+	"CachedGroupMemers" -> "Principals" [label="MemberId -> id"];
		+	"CachedGroupMemers" -> "CachedGroupMemers" [label="Via -> id"];
		+	"CachedGroupMemers" -> "Groups" [label="ImmediateParentId -> id"];
		+
		+	"CustomFields" [shape = record, fontsize = 18, label = "<col0> \N " ];
		+
		+	"CustomFieldValues" [shape = record, fontsize = 18, label = "<col0> \N " ];
		+	"CustomFieldValues" -> "CustomFields" [label="CustomField -> id"];
		+
		+	"GroupMembers" [shape = record, fontsize = 18, label = "<col0> \N " ];
		+	"GroupMembers" -> "Groups" [label="GroupId -> id", weight=2];
		+	"GroupMembers" -> "Principals" [label="MemberId -> id", weight = 2];
		+
		+	"Groups" [shape = record, fontsize = 18, label = "<col0> \N " ];
		+	"Groups" -> "Principals" [label="Groups.id -> id"];
		+
		+	"Links" [shape = record, fontsize = 18, label = "<col0> \N " ];
		+	"Links" -> "Tickets" [label="LocalBase => id (usually)", style="dotted"];
		+	"Links" -> "Tickets" [label="LocalTarget => id (usually)", style="dotted"];
		+
		+	"Principals" [shape = record, fontsize = 18, label = "<col0> \N " ];
		+
		+	"Attributes" [shape = record, fontsize = 18, label = "<col0> \N " ];
		+	"Attributes" -> "Records" [label="ObjectId -> id"];
		+
		+	"Queues" [shape = record, fontsize = 18, label = "<col0> \N " ];
		+
		+	"ScripActions" [shape = record, fontsize = 18, label = "<col0> \N " ];
		+
		+	"ScripConditions" [shape = record, fontsize = 18, label = "<col0> \N " ];
		+
		+	"Scrips" [shape = record, fontsize = 18, label = "<col0> \N " ];
		+	"Scrips" -> "ScripConditions" [label="ScripCondition -> id"];
		+	"Scrips" -> "ScripActions" [label="ScripAction -> id"];
		+	"Scrips" -> "Templates" [label="Template -> id"];
		+	"Scrips" -> "Queues" [label="Queue -> id"];
		+
		+	"Templates" [shape = record, fontsize = 18, label = "<col0> \N " ];
		+	"Templates" -> "Queues" [label ="Queue -> id" ];
		+
		+	"ObjectCustomFields" [shape = record, fontsize = 18, label = "<col0> \N " ];
		+	"ObjectCustomFields" -> "CustomFields" [label="CustomField -> id"];
		+	"ObjectCustomFields" -> "Records" [label="ObjectId -> id"];
		+
		+	"ObjectCustomFieldValues" [shape = record, fontsize = 18, label = "<col0> \N " ];
		+	"ObjectCustomFieldValues" -> "CustomFields" [label="CustomField -> id"];
		+	"ObjectCustomFieldValues" -> "Records" [label="ObjectId -> id"];
		+
		+	"Tickets" [shape = record, fontsize = 18, label = "<col0> \N " ];
		+	"Tickets" -> "Tickets" [label="EffectiveId -> id"];
		+	"Tickets" -> "Principals" [label="Owner -> id"];
		+	"Queues" -> "Tickets" [style="invis"];
		+	"Tickets" -> "Queues" [label="Queue -> id"];
		+
		+	"Transactions" [shape = record, fontsize = 18, label = "<col0> \N " ];
		+	"Transactions" -> "Records" [label="ObjectId -> id"];
		+
		+	"Users" [shape = record, fontsize = 18, label = "<col0> \N " ];
		+
		+	"Users" -> "Principals" [label="id -> id"];
		+
		+
		+	}
		+	</graphviz>