change supervisor field in tc_district and tc_district_sandbox to leader

[eq/.git] / sql / schema.dot

diff --git a/sql/schema.dot b/sql/schema.dot
index 9fb24285cf092e8e83c9a9d1308bd57f62c3e12e..cbd156a4bf92d27a643db673dc3cf3076383f725 100644 (file)
--- a/sql/schema.dot
+++ b/sql/schema.dot
@@ -27,11 +27,11 @@ digraph schema {
     shape = "record"
   ];
   companionship   [
-    label = "companionship||<c> companionship|<d> district|<v> valid"
+    label = "companionship||<c> companionship|<d> district|<t> type|<v> valid"
     shape = "record"
   ];
   district      [
-    label = "district||<d> district|<s> supervisor|<v> valid"
+    label = "district||<d> district|<l> leader|<v> valid"
     shape = "record"
   ];
   individual   [
@@ -47,7 +47,7 @@ digraph schema {
     shape = "record"
   ];
   interview   [
-    label = "interview||<in> interview|<i> interviewer|<il> individual|<t> date|<n> notes|<it> interview_type"
+    label = "interview||<in> interview|<i> interviewer|<il> individual|<t> date|<n> notes|<t> type"
     shape = "record"
   ];
   presidency    [
@@ -55,7 +55,7 @@ digraph schema {
     shape = "record"
   ];
   visit   [
-    label = "visit||<v> visit|<f> family|<c> companionship|<c1> companion1|<c2> companion2|<t> date|<n> notes|<v> visited|<vt> visit_type"
+    label = "visit||<v> visit|<f> family|<c> companionship|<c1> companion1|<c2> companion2|<t> date|<n> notes|<v> visited|<vt> type"
     shape = "record"
   ];
   willingness   [
@@ -82,6 +82,22 @@ digraph schema {
     label = "task||<t> task|<n> name|<d> description"
     shape = "record"
   ];
+  district_sandbox   [
+    label = "district_sandbox||<d> district|<l> leader"
+    shape = "record"
+  ];
+  companion_sandbox   [
+    label = "companion_sandbox||<c> companion|<i> individual|<cp> companionship"
+    shape = "record"
+  ];
+  companionship_sandbox   [
+    label = "companionship_sandbox||<cp> companionship|<tcp> tc_companionship|<d> district"
+    shape = "record"
+  ];
+  family_sandbox   [
+    label = "family_sandbox||<f> family|<tcf> tc_family|<i> individual|<cp> companionship"
+    shape = "record"
+  ];
 
   activity:s      -> assignment:a
 
@@ -99,7 +115,7 @@ digraph schema {
 
   companionship:d -> district:d
   
-  district:s      -> individual:i
+  district:l      -> individual:i
   
   individual:sp   -> scheduling_priority:sp
   
@@ -129,5 +145,14 @@ digraph schema {
   
   accomplishment:i   -> individual:i
   accomplishment:t   -> task:t
+ 
+  district_sandbox:l      -> individual:i
+  companion_sandbox:i     -> individual:i
+  companion_sandbox:cp    -> companionship_sandbox:cp
+  companionship_sandbox:tcp -> companionship:c
+  companionship_sandbox:d -> district_sandbox:d
+  family_sandbox:tcf      -> family:f
+  family_sandbox:i        -> individual:i
+  family_sandbox:cp       -> companionship_sandbox:cp
   
 }