c554f04bf6fdd3dd12abedd3c0c510bdc96722d2
[eq/.git] / 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|<pr> president|<cn> counselor|<sec> secreatary|<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 }