X-Git-Url: http://git.pippins.net/embedvideo/.git/?a=blobdiff_plain;f=sql%2Fschema.dot;h=9f5e512c5d88480735e25145171d2bde1327b149;hb=10d31609e9f447202816d2721333e0d83f5c4f0a;hp=d53f0b6c96c70d8a2e881fa58022584ab6e26b06;hpb=39346e4dae3d877b8aceec8ed6b3dadd2be42d0c;p=eq%2F.git

diff --git a/sql/schema.dot b/sql/schema.dot
index d53f0b6..9f5e512 100644
--- a/sql/schema.dot
+++ b/sql/schema.dot
@@ -47,7 +47,7 @@ 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    [
@@ -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> 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   [
@@ -91,7 +91,7 @@ digraph schema {
     shape = "record"
   ];
   companionship_sandbox   [
-    label = "companionship_sandbox||<cp> companionship|<d> district"
+    label = "companionship_sandbox||<cp> companionship|<tcp> tc_companionship|<d> district"
     shape = "record"
   ];
   family_sandbox   [
@@ -149,6 +149,7 @@ digraph schema {
   district_sandbox:s      -> individual:i
   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