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

diff --git a/sql/schema.dot b/sql/schema.dot
index b5d91fa..d53f0b6 100644
--- a/sql/schema.dot
+++ b/sql/schema.dot
@@ -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|<v> valid"
     shape = "record"
   ];
   district      [
-    label = "district||<d> district|<n> name|<s> supervisor|<v> valid"
+    label = "district||<d> district|<s> supervisor|<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   [
@@ -47,7 +51,7 @@ digraph schema {
     shape = "record"
   ];
   presidency    [
-    label = "presidency||<p> presidency||<i> individual|<d> district|<em> email|<pr> president|<cn> counselor|<sec> secreatary|<v> valid"
+    label = "presidency||<p> presidency|<i> individual|<d> district|<em> email|<pr> president|<cn> counselor|<sec> secreatary|<v> valid"
     shape = "record"
   ];
   visit   [
@@ -78,6 +82,22 @@ digraph schema {
     label = "task||<t> task|<n> name|<d> description"
     shape = "record"
   ];
+  district_sandbox   [
+    label = "district_sandbox||<d> district|<s> supervisor"
+    shape = "record"
+  ];
+  companion_sandbox   [
+    label = "companion_sandbox||<c> companion|<i> individual|<cp> companionship"
+    shape = "record"
+  ];
+  companionship_sandbox   [
+    label = "companionship_sandbox||<cp> 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
 
@@ -86,10 +106,14 @@ digraph schema {
   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
   
@@ -121,5 +145,13 @@ digraph schema {
   
   accomplishment:i   -> individual:i
   accomplishment:t   -> task:t
+ 
+  district_sandbox:s      -> individual:i
+  companion_sandbox:i     -> individual:i
+  companion_sandbox:cp    -> companionship_sandbox:cp
+  companionship_sandbox:d -> district_sandbox:d
+  family_sandbox:tcf      -> family:f
+  family_sandbox:i        -> individual:i
+  family_sandbox:cp       -> companionship_sandbox:cp
   
 }