changed interview_type to type

[eq/.git] / sql / schema.dot

diff --git a/sql/schema.dot b/sql/schema.dot
index 7d5d187d81b1e676ae3a3f0c81c9243492517128..ec23ab7b4f1b56ede97e1dbd45740ba4a258d68d 100644 (file)
--- 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    [
@@ -91,11 +91,11 @@ 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   [
-    label = "family_sandbox||<f> family|<tcf> tc_family|<cp> companionship"
+    label = "family_sandbox||<f> family|<tcf> tc_family|<i> individual|<cp> companionship"
     shape = "record"
   ];
 
@@ -149,8 +149,10 @@ 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
   family_sandbox:cp       -> companionship_sandbox:cp
   
 }