X-Git-Url: http://git.pippins.net/embedvideo/.git/static/images/checkmark.gif?a=blobdiff_plain;f=sql%2Fschema.dot;h=b6f961c3737f82eca05d817fb69b6916c08e9e43;hb=1d7d0afcd39dbd2c4c4ebe13ac110cb984270761;hp=a5a91392cab6a212482cba5a9e0b396044a4b243;hpb=61df0220f9c24a23b834d1fdf64c2a3630e52560;p=eq%2F.git

diff --git a/sql/schema.dot b/sql/schema.dot
index a5a9139..b6f961c 100644
--- a/sql/schema.dot
+++ b/sql/schema.dot
@@ -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> type"
+    label = "visit||<v> visit|<f> family|<c> companionship|<t> date|<n> notes|<v> visited|<vt> type"
     shape = "record"
   ];
   willingness   [
@@ -127,14 +127,12 @@ digraph schema {
   participation:a -> activity:a
 
   interview:il    -> individual:i
-  interview:i     -> individual:i
+  interview:i     -> leader:l
 
   leader:i    -> individual:i
 
   visit:c         -> companionship:c
   visit:f         -> family:f
-  visit:c1        -> leader:i
-  visit:c2        -> leader:i
 
   willingness:i   -> individual:i
   willingness:a   -> assignment:a