sql/schema.dot

   1 digraph schema {
   2   graph [
   3     rankdir = "LR"
   4   ];
   5   activity   [
   6     label = "activity||<a> activity|<s> assignment|<t> date|<n> notes"
   7     shape = "record"
   8   ];
   9   appointment   [
  10     label = "appointment||<a> appointment|<l> leader|<f> family|<i> individual |<d> date|<t> time|<l> location|<u> uid"
  11     shape = "record"
  12   ];
  13   assignment    [
  14     label = "assignment||<a> assignment|<n> name|<ab> abbreviation"
  15     shape = "record"
  16   ];
  17   attendance   [
  18     label = "attendance||<i> individual|<d> date"
  19     shape = "record"
  20   ];
  21   calling       [
  22     label = "calling||<i> individual|<o> organization|<p> position|<s> sustained"
  23     shape = "record"
  24   ];
  25   companion   [
  26     label = "companion||<c> companion|<i> individual|<cp> companionship|<sp> scheduling_priority|<v> valid"
  27     shape = "record"
  28   ];
  29   companionship   [
  30     label = "companionship||<c> companionship|<d> district|<t> type|<v> valid"
  31     shape = "record"
  32   ];
  33   district      [
  34     label = "district||<d> district|<l> leader|<v> valid"
  35     shape = "record"
  36   ];
  37   individual   [
  38     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"
  39     shape = "record"
  40   ];
  41   family   [
  42     label = "family||<f> family|<i> individual|<c> companionship|<sp> scheduling_priority|<v> valid"
  43     shape = "record"
  44   ];
  45   participation   [
  46     label = "participation||<i> individual|<a> activity"
  47     shape = "record"
  48   ];
  49   interview   [
  50     label = "interview||<in> interview|<i> interviewer|<il> individual|<t> date|<n> notes|<t> type"
  51     shape = "record"
  52   ];
  53   leader    [
  54     label = "leader||<l> leader|<i> individual|<d> district|<em> email|<t> type|<v> valid"
  55     shape = "record"
  56   ];
  57   visit   [
  58     label = "visit||<v> visit|<f> family|<c> companionship|<c1> companion1|<c2> companion2|<t> date|<n> notes|<v> visited|<vt> type"
  59     shape = "record"
  60   ];
  61   willingness   [
  62     label = "willingness||<i> individual|<a> assignment|<w> willing"
  63     shape = "record"
  64   ];
  65   scheduling_priority   [
  66     label = "scheduling_priority||<sp> scheduling_priority|<p> priority|<n> notes"
  67     shape = "record"
  68   ];
  69   email_list   [
  70     label = "email_list||<e> email_list|<n> name"
  71     shape = "record"
  72   ];
  73   email_list_membership   [
  74     label = "email_list_membership||<i> individual|<e> email_list"
  75     shape = "record"
  76   ];
  77   accomplishment   [
  78     label = "accomplishment||<a> accomplishment|<i> individual|<d> date|<t> task|<n> note"
  79     shape = "record"
  80   ];
  81   task   [
  82     label = "task||<t> task|<n> name|<d> description"
  83     shape = "record"
  84   ];
  85   district_sandbox   [
  86     label = "district_sandbox||<d> district|<l> leader"
  87     shape = "record"
  88   ];
  89   companion_sandbox   [
  90     label = "companion_sandbox||<c> companion|<i> individual|<cp> companionship"
  91     shape = "record"
  92   ];
  93   companionship_sandbox   [
  94     label = "companionship_sandbox||<cp> companionship|<tcp> tc_companionship|<d> district"
  95     shape = "record"
  96   ];
  97   family_sandbox   [
  98     label = "family_sandbox||<f> family|<tcf> tc_family|<i> individual|<cp> companionship"
  99     shape = "record"
 100   ];
 101
 102   activity:s      -> assignment:a
 103
 104   appointment:l   -> leader:l
 105   appointment:f   -> family:f
 106   appointment:i   -> individual:i
 107
 108   attendance:i    -> individual:i
 109
 110   calling:i       -> individual:i
 111
 112   companion:cp    -> companionship:c
 113   companion:i     -> individual:i
 114   companion:sp    -> scheduling_priority:sp
 115
 116   companionship:d -> district:d
 117
 118   district:l      -> individual:i
 119
 120   individual:sp   -> scheduling_priority:sp
 121
 122   family:i        -> individual:i
 123   family:c        -> companionship:c
 124   family:sp       -> scheduling_priority:sp
 125
 126   participation:i -> individual:i
 127   participation:a -> activity:a
 128
 129   interview:il    -> individual:i
 130   interview:i     -> individual:i
 131
 132   leader:i    -> individual:i
 133   leader:d    -> district:d
 134
 135   visit:c         -> companionship:c
 136   visit:f         -> family:f
 137   visit:c1        -> leader:i
 138   visit:c2        -> leader:i
 139
 140   willingness:i   -> individual:i
 141   willingness:a   -> assignment:a
 142
 143   email_list_membership:i  -> individual:i
 144   email_list_membership:e  -> email_list:e
 145
 146   accomplishment:i   -> individual:i
 147   accomplishment:t   -> task:t
 148
 149   district_sandbox:l      -> individual:i
 150   companion_sandbox:i     -> individual:i
 151   companion_sandbox:cp    -> companionship_sandbox:cp
 152   companionship_sandbox:tcp -> companionship:c
 153   companionship_sandbox:d -> district_sandbox:d
 154   family_sandbox:tcf      -> family:f
 155   family_sandbox:i        -> individual:i
 156   family_sandbox:cp       -> companionship_sandbox:cp
 157
 158 }