linked district table to leader table by leader id, removed district field from leade...
[eq/.git] / sql / schema.dot
index 6c3999a5127d853a832593348fc7b8ab27ea7283..a5a91392cab6a212482cba5a9e0b396044a4b243 100644 (file)
@@ -2,102 +2,156 @@ digraph schema {
   graph [
     rankdir = "LR"
   ];
-  family   [
-    label = "<f> family||<c> companionship|<n> name_id|<i> hofh_id|<e> elder_id|<vp> visit_pri|<vn> visit_notes|<v> valid"
+  activity   [
+    label = "activity||<a> activity|<s> assignment|<t> date|<n> notes"
+    shape = "record"
+  ];
+  appointment   [
+    label = "appointment||<a> appointment|<l> leader|<f> family|<i> individual |<d> date|<t> time|<l> location|<u> uid"
+    shape = "record"
+  ];
+  assignment    [
+    label = "assignment||<a> assignment|<n> name|<ab> abbreviation"
+    shape = "record"
+  ];
+  attendance   [
+    label = "attendance||<i> individual|<d> date"
+    shape = "record"
+  ];
+  calling       [
+    label = "calling||<i> individual|<o> organization|<p> position|<s> sustained"
     shape = "record"
   ];
-  elder   [
-    label = "<e> elder||<n> name|<p> phone|<em> email|<po> priesthood|<pr> prospective|<pp> ppi_pri|<t> ppi_notes|<ip> int_pri|<in> int_notes|<a> attending|<v> valid"
+  companion   [
+    label = "companion||<c> companion|<i> individual|<cp> companionship|<sp> scheduling_priority|<v> valid"
     shape = "record"
   ];
   companionship   [
-    label = "<c> companionship||<e> elder|<a> aaronic|<d> district|<v> valid"
+    label = "companionship||<c> companionship|<d> district|<t> type|<v> valid"
     shape = "record"
   ];
-  visit   [
-    label = "<v> visit||<f> family|<c> companionship|<c1> companion1|<c2> companion2|<t> date|<n> notes|<v> visited|<vt> visit_type"
+  district      [
+    label = "district||<d> district|<l> leader|<v> valid"
     shape = "record"
   ];
-  interview   [
-    label = "<in> interview||<i> interviewer|<e> elder|<a> aaronic|<t> date|<n> notes|<it> interview_type"
+  individual   [
+    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"
   ];
-  activity   [
-    label = "<a> activity||<s> assignment|<t> date|<n> notes"
+  family   [
+    label = "family||<f> family|<i> individual|<c> companionship|<sp> scheduling_priority|<v> valid"
     shape = "record"
   ];
   participation   [
-    label = "participation||<e> elder|<a> activity"
+    label = "participation||<i> individual|<a> activity"
     shape = "record"
   ];
-  attendance   [
-    label = "attendance||<e> elder|<d> date"
+  interview   [
+    label = "interview||<in> interview|<i> interviewer|<il> individual|<t> date|<n> notes|<t> type"
     shape = "record"
   ];
-  child        [
-    label = "<c> child||<f> family|<i> indiv_id|<n> name|<b> birthday|<v> valid"
+  leader    [
+    label = "leader||<l> leader|<i> individual|<em> email|<t> type|<v> valid"
     shape = "record"
-  ]; 
-  parent       [
-    label = "<p> parent||<f> family|<n> name|<b> birthday|<p> phone|<a> address|<i>indiv_id|<v> valid"
+  ];
+  visit   [
+    label = "visit||<v> visit|<f> family|<c> companionship|<c1> companion1|<c2> companion2|<t> date|<n> notes|<v> visited|<vt> type"
     shape = "record"
-  ]; 
-  aaronic       [
-    label = "<a> aaronic||<n> name|<p> phone|<em> email|<v> valid"
+  ];
+  willingness   [
+    label = "willingness||<i> individual|<a> assignment|<w> willing"
     shape = "record"
   ];
-  appointment   [
-    label = "<a> appointment||<p> presidency|<f> family|<e> elder |<d> date|<t> time|<u> uid"
+  scheduling_priority   [
+    label = "scheduling_priority||<sp> scheduling_priority|<p> priority|<n> notes"
     shape = "record"
   ];
-  assignment    [
-    label = "<a> assignment||<n> name|<c> code"
+  email_list   [
+    label = "email_list||<e> email_list|<n> name"
     shape = "record"
   ];
-  calling       [
-    label = "calling||<i> indiv_id|<n> name|<o> organization|<p> position|<s> sequence|<t> sustained"
+  email_list_membership   [
+    label = "email_list_membership||<i> individual|<e> email_list"
     shape = "record"
   ];
-  district      [
-    label = "<d> district||<n> name|<s> supervisor|<v> valid"
+  accomplishment   [
+    label = "accomplishment||<a> accomplishment|<i> individual|<d> date|<t> task|<n> note"
     shape = "record"
   ];
-  presidency    [
-    label = "<p> presidency||<e> elder|<d> district|<n> name|<em> email|<pr> president|<cn> counselor|<sec> secreatary|<v> valid"
+  task   [
+    label = "task||<t> task|<n> name|<d> description"
     shape = "record"
   ];
-  willingness   [
-    label = "<e> elder||<a> assignment|<w> willing"
+  district_sandbox   [
+    label = "district_sandbox||<d> district|<l> leader"
+    shape = "record"
+  ];
+  companion_sandbox   [
+    label = "companion_sandbox||<c> companion|<i> individual|<cp> companionship"
+    shape = "record"
+  ];
+  companionship_sandbox   [
+    label = "companionship_sandbox||<cp> companionship|<tcp> tc_companionship|<d> district"
+    shape = "record"
+  ];
+  family_sandbox   [
+    label = "family_sandbox||<f> family|<tcf> tc_family|<i> individual|<cp> companionship"
     shape = "record"
   ];
 
-  family:c        -> companionship:c
-  companionship:e -> elder:e
-  companionship:a -> aaronic:a
+  activity:s      -> assignment:a
 
-  appointment:e   -> elder:e
+  appointment:l   -> leader:l
   appointment:f   -> family:f
+  appointment:i   -> individual:i
 
-  interview:e     -> elder:e
-  interview:i     -> elder:e
-  interview:a     -> aaronic:a
+  attendance:i    -> individual:i
+  
+  calling:i       -> individual:i
 
-  presidency:e    -> elder:e
-  presidency:d    -> district:d
+  companion:cp    -> companionship:c
+  companion:i     -> individual:i
+  companion:sp    -> scheduling_priority:sp
 
-  willingness:e   -> elder:e
-  willingness:a   -> assignment:a
+  companionship:d -> district:d
+  
+  district:l      -> leader:l
+  
+  individual:sp   -> scheduling_priority:sp
+  
+  family:i        -> individual:i
+  family:c        -> companionship:c
+  family:sp       -> scheduling_priority:sp
 
-  activity:s      -> assignment:a
+  participation:i -> individual:i
+  participation:a -> activity:a
+
+  interview:il    -> individual:i
+  interview:i     -> individual:i
+
+  leader:i    -> individual:i
 
   visit:c         -> companionship:c
   visit:f         -> family:f
+  visit:c1        -> leader:i
+  visit:c2        -> leader:i
 
-  participation:e -> elder:e
-  participation:a -> activity:a
-
-  attendance:e    -> elder:e
+  willingness:i   -> individual:i
+  willingness:a   -> assignment:a
 
-  child:f         -> family:f
-  parent:f        -> family:f
+  email_list_membership:i  -> individual:i
+  email_list_membership:e  -> email_list:e
+  
+  accomplishment:i   -> individual:i
+  accomplishment:t   -> task:t
+  district_sandbox:l      -> leader:l
+  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
+  
 }