X-Git-Url: http://git.pippins.net/embedvideo/.git/?a=blobdiff_plain;ds=sidebyside;f=sql%2Fschema.dot;h=a5a91392cab6a212482cba5a9e0b396044a4b243;hb=61df0220f9c24a23b834d1fdf64c2a3630e52560;hp=b5d91fa23ca65badf8787ec5dc7a23017df2535f;hpb=618c7a09c5e0b99ca1ef5381aa2349802d11098b;p=eq%2F.git

diff --git a/sql/schema.dot b/sql/schema.dot
index b5d91fa..a5a9139 100644
--- a/sql/schema.dot
+++ b/sql/schema.dot
@@ -7,7 +7,7 @@ digraph schema {
     shape = "record"
   ];
   appointment   [
-    label = "appointment||<a> appointment|<p> presidency|<f> family|<i> individual |<d> date|<t> time|<l> location|<u> uid"
+    label = "appointment||<a> appointment|<l> leader|<f> family|<i> individual |<d> date|<t> time|<l> location|<u> uid"
     shape = "record"
   ];
   assignment    [
@@ -19,19 +19,23 @@ digraph schema {
     shape = "record"
   ];
   calling       [
-    label = "calling||<n> name|<o> organization|<p> position|<s> sustained"
+    label = "calling||<i> individual|<o> organization|<p> position|<s> sustained"
+    shape = "record"
+  ];
+  companion   [
+    label = "companion||<c> companion|<i> individual|<cp> companionship|<sp> scheduling_priority|<v> valid"
     shape = "record"
   ];
   companionship   [
-    label = "companionship||<c> companionship|<i> individual|<d> district|<sp> scheduling_priority|<v> valid"
+    label = "companionship||<c> companionship|<d> district|<t> type|<v> valid"
     shape = "record"
   ];
   district      [
-    label = "district||<d> district|<n> name|<s> supervisor|<v> valid"
+    label = "district||<d> district|<l> leader|<v> valid"
     shape = "record"
   ];
   individual   [
-    label = "individual||<i> individual|<id> mls_id|<n> name|<a> address|<p> phone|<em> email|<hh> hh position|<pr> priesthood|<st> steward|<sp> scheduling_priority|<a> attending|<v> valid"
+    label = "individual||<i> individual|<id> mls_id|<n> name|<fn> fullname|<a> address|<p> phone|<em> email|<hh> hh position|<pr> priesthood|<st> steward|<sp> scheduling_priority|<a> attending|<v> valid"
     shape = "record"
   ];
   family   [
@@ -43,15 +47,15 @@ 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    [
-    label = "presidency||<p> presidency||<i> individual|<d> district|<em> email|<pr> president|<cn> counselor|<sec> secreatary|<v> valid"
+  leader    [
+    label = "leader||<l> leader|<i> individual|<em> email|<t> type|<v> valid"
     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   [
@@ -78,20 +82,40 @@ 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
 
-  appointment:p   -> presidency:p
+  appointment:l   -> leader:l
   appointment:f   -> family:f
   appointment:i   -> individual:i
 
   attendance:i    -> individual:i
+  
+  calling:i       -> individual:i
+
+  companion:cp    -> companionship:c
+  companion:i     -> individual:i
+  companion:sp    -> scheduling_priority:sp
 
-  companionship:i -> individual:i
   companionship:d -> district:d
-  companionship:sp -> scheduling_priority:sp
   
-  district:s      -> individual:i
+  district:l      -> leader:l
   
   individual:sp   -> scheduling_priority:sp
   
@@ -105,13 +129,12 @@ digraph schema {
   interview:il    -> individual:i
   interview:i     -> individual:i
 
-  presidency:i    -> individual:i
-  presidency:d    -> district:d
+  leader:i    -> individual:i
 
   visit:c         -> companionship:c
   visit:f         -> family:f
-  visit:c1        -> presidency:i
-  visit:c2        -> presidency:i
+  visit:c1        -> leader:i
+  visit:c2        -> leader:i
 
   willingness:i   -> individual:i
   willingness:a   -> assignment:a
@@ -121,5 +144,14 @@ digraph schema {
   
   accomplishment:i   -> individual:i
   accomplishment:t   -> task:t
+ 
+  district_sandbox:l      -> leader:l
+  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
   
 }