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

diff --git a/sql/schema.dot b/sql/schema.dot
index b5d91fa..9fb2428 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   [
@@ -86,10 +90,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