X-Git-Url: http://git.pippins.net/embedvideo/.git/static/%7Bg-%3Eurl%20arg1=?a=blobdiff_plain;f=sql%2Fschema.dot;h=136e25338e737ae545856c7d0a32272a9f6ee412;hb=14cfa28359cc338a5c0697981474bc88f0e008c1;hp=c554f04bf6fdd3dd12abedd3c0c510bdc96722d2;hpb=9cbfdccb986373952fc820285cbc027b41c44b5e;p=eq%2F.git

diff --git a/sql/schema.dot b/sql/schema.dot
index c554f04..136e253 100644
--- a/sql/schema.dot
+++ b/sql/schema.dot
@@ -51,11 +51,11 @@ digraph schema {
     shape = "record"
   ];
   leader    [
-    label = "leader||<l> leader|<i> individual|<d> district|<em> email|<pr> president|<cn> counselor|<sec> secreatary|<v> valid"
+    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> type"
+    label = "visit||<v> visit|<f> family|<c> companionship|<t> date|<n> notes|<v> visited|<vt> type"
     shape = "record"
   ];
   willingness   [
@@ -115,7 +115,7 @@ digraph schema {
 
   companionship:d -> district:d
   
-  district:l      -> individual:i
+  district:l      -> leader:l
   
   individual:sp   -> scheduling_priority:sp
   
@@ -130,12 +130,9 @@ digraph schema {
   interview:i     -> individual:i
 
   leader:i    -> individual:i
-  leader:d    -> district:d
 
   visit:c         -> companionship:c
   visit:f         -> family:f
-  visit:c1        -> leader:i
-  visit:c2        -> leader:i
 
   willingness:i   -> individual:i
   willingness:a   -> assignment:a
@@ -146,7 +143,7 @@ digraph schema {
   accomplishment:i   -> individual:i
   accomplishment:t   -> task:t
  
-  district_sandbox:l      -> individual:i
+  district_sandbox:l      -> leader:l
   companion_sandbox:i     -> individual:i
   companion_sandbox:cp    -> companionship_sandbox:cp
   companionship_sandbox:tcp -> companionship:c