graph [
rankdir = "LR"
];
- family [
- label = "<f> family||<i> hofh_id|<n> name|<ni> name_id|<i> indiv_id|<c> companionship|<vp> visit_pri|<vn> visit_notes|<v> valid"
+ activity [
+ label = "activity||<a> activity|<s> assignment|<t> date|<n> notes"
shape = "record"
];
- indiv [
- label = "<i> indiv||<id> indiv_id|<n> name|<a> address|<p> phone|<em> email|<f> family|<hh> hh position|<po> priesthood|<st> steward|<pr> prospective|<pp> ppi_pri|<t> ppi_notes|<hp> hti_pri|<hn> hti_notes|<a> attending|<v> valid"
+ appointment [
+ label = "appointment||<a> appointment|<p> presidency|<f> family|<i> individual |<d> date|<t> time|<l> location|<u> uid"
shape = "record"
];
- companionship [
- label = "<c> companionship||<i> indiv|<d> district|<v> valid"
+ assignment [
+ label = "assignment||<a> assignment|<n> name|<ab> abbreviation"
shape = "record"
];
- visit [
- label = "<v> visit||<f> family|<c> companionship|<c1> companion1|<c2> companion2|<t> date|<n> notes|<v> visited|<vt> visit_type"
+ attendance [
+ label = "attendance||<i> individual|<d> date"
shape = "record"
];
- interview [
- label = "<in> interview||<i> interviewer|<il> indiv|<t> date|<n> notes|<it> interview_type"
+ calling [
+ label = "calling||<i> individual|<o> organization|<p> position|<s> sustained"
shape = "record"
];
- activity [
- label = "<a> activity||<s> assignment|<t> date|<n> notes"
+ companion [
+ label = "companion||<c> companion|<i> individual|<cp> companionship|<sp> scheduling_priority|<v> valid"
shape = "record"
];
- participation [
- label = "participation||<i> indiv|<a> activity"
+ companionship [
+ label = "companionship||<c> companionship|<d> district|<v> valid"
shape = "record"
];
- attendance [
- label = "attendance||<i> indiv|<d> date"
+ district [
+ label = "district||<d> district|<s> supervisor|<v> valid"
shape = "record"
];
- appointment [
- label = "<a> appointment||<p> presidency|<f> family|<i> indiv |<d> date|<t> time|<l> location|<u> uid"
+ 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"
];
- assignment [
- label = "<a> assignment||<n> name|<c> code"
+ family [
+ label = "family||<f> family|<i> individual|<c> companionship|<sp> scheduling_priority|<v> valid"
shape = "record"
];
- calling [
- label = "calling||<i> indiv_id|<n> name|<o> organization|<p> position|<s> sequence|<t> sustained"
+ participation [
+ label = "participation||<i> individual|<a> activity"
shape = "record"
];
- district [
- label = "<d> district||<n> name|<s> supervisor|<v> valid"
+ interview [
+ label = "interview||<in> interview|<i> interviewer|<il> individual|<t> date|<n> notes|<it> interview_type"
shape = "record"
];
presidency [
- label = "<p> presidency||<i> indiv|<d> district|<n> name|<em> email|<pr> president|<cn> counselor|<sec> secreatary|<v> valid"
+ label = "presidency||<p> presidency|<i> individual|<d> district|<em> email|<pr> president|<cn> counselor|<sec> secreatary|<v> valid"
+ shape = "record"
+ ];
+ visit [
+ label = "visit||<v> visit|<f> family|<c> companionship|<c1> companion1|<c2> companion2|<t> date|<n> notes|<v> visited|<vt> visit_type"
shape = "record"
];
willingness [
- label = "<i> indiv||<a> assignment|<w> willing"
+ label = "willingness||<i> individual|<a> assignment|<w> willing"
+ shape = "record"
+ ];
+ scheduling_priority [
+ label = "scheduling_priority||<sp> scheduling_priority|<p> priority|<n> notes"
+ shape = "record"
+ ];
+ email_list [
+ label = "email_list||<e> email_list|<n> name"
+ shape = "record"
+ ];
+ email_list_membership [
+ label = "email_list_membership||<i> individual|<e> email_list"
+ shape = "record"
+ ];
+ accomplishment [
+ label = "accomplishment||<a> accomplishment|<i> individual|<d> date|<t> task|<n> note"
+ shape = "record"
+ ];
+ task [
+ label = "task||<t> task|<n> name|<d> description"
+ shape = "record"
+ ];
+ district_sandbox [
+ label = "district_sandbox||<d> district|<s> supervisor"
+ 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:i -> indiv:i
+ activity:s -> assignment:a
- appointment:i -> indiv:i
+ appointment:p -> presidency:p
appointment:f -> family:f
+ appointment:i -> individual:i
- interview:il -> indiv:i
- interview:i -> indiv:i
+ attendance:i -> individual:i
+
+ calling:i -> individual:i
- presidency:i -> indiv:i
- presidency:d -> district:d
+ companion:cp -> companionship:c
+ companion:i -> individual:i
+ companion:sp -> scheduling_priority:sp
- willingness:i -> indiv:i
- willingness:a -> assignment:a
+ companionship:d -> district:d
+
+ district:s -> individual:i
+
+ 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
+
+ presidency:i -> individual:i
+ presidency:d -> district:d
visit:c -> companionship:c
visit:f -> family:f
visit:c1 -> presidency:i
visit:c2 -> presidency:i
- participation:i -> indiv:i
- participation:a -> activity:a
-
- attendance:i -> indiv:i
+ willingness:i -> individual:i
+ willingness:a -> assignment:a
- indiv: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: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
+
}