projects
/
eq
/
.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
added new tc_companion table, updated tc_companionship table, linked tc_calling table...
[eq/.git]
/
sql
/
schema.dot
diff --git
a/sql/schema.dot
b/sql/schema.dot
index 99fb6c422a2ae8389ba03f37933e82d126b03223..9fb24285cf092e8e83c9a9d1308bd57f62c3e12e 100644
(file)
--- a/
sql/schema.dot
+++ b/
sql/schema.dot
@@
-2,109
+2,132
@@
digraph schema {
graph [
rankdir = "LR"
];
graph [
rankdir = "LR"
];
-
famil
y [
- label = "
<f> family||<c> companionship|<n> name_id|<i> hofh_id|<e> elder_id|<vp> visit_pri|<vn> visit_notes|<v> valid
"
+
activit
y [
+ label = "
activity||<a> activity|<s> assignment|<t> date|<n> notes
"
shape = "record"
];
shape = "record"
];
-
elder
[
- label = "
<e> elder||<n> name|<p> phone|<pp> ppi_pri|<t> ppi_notes|<ip> int_pri|<in> int_notes|<a> attending|<v> val
id"
+
appointment
[
+ label = "
appointment||<a> appointment|<p> presidency|<f> family|<i> individual |<d> date|<t> time|<l> location|<u> u
id"
shape = "record"
];
shape = "record"
];
-
companionship
[
- label = "
<c> companionship||<e> elder|<a> aaronic|<d> district|<v> valid
"
+
assignment
[
+ label = "
assignment||<a> assignment|<n> name|<ab> abbreviation
"
shape = "record"
];
shape = "record"
];
-
visit
[
- label = "
<v> visit||<f> family|<c> companionship|<t> date|<n> notes|<v> visited
"
+
attendance
[
+ label = "
attendance||<i> individual|<d> date
"
shape = "record"
];
shape = "record"
];
-
ppi
[
- label = "
<p> ppi||<i> interviewer|<e> elder|<t> date|<n> notes|<p> eqpresppi
"
+
calling
[
+ label = "
calling||<i> individual|<o> organization|<p> position|<s> sustained
"
shape = "record"
];
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"
];
shape = "record"
];
-
participation
[
- label = "
participation||<e> elder|<a> activity
"
+
companionship
[
+ label = "
companionship||<c> companionship|<d> district|<v> valid
"
shape = "record"
];
shape = "record"
];
-
attendance
[
- label = "
attendance||<e> elder|<d> date
"
+
district
[
+ label = "
district||<d> district|<s> supervisor|<v> valid
"
shape = "record"
];
shape = "record"
];
-
child
[
- label = "
<c> child||<f> family|<i> indiv_id|<n> name|<b> birthday
|<v> valid"
+
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"
shape = "record"
- ];
-
parent
[
- label = "
<p> parent||<f> family|<n> name|<b> birthday|<p> phone|<a> address|<i>indiv_id
|<v> valid"
+ ];
+
family
[
+ label = "
family||<f> family|<i> individual|<c> companionship|<sp> scheduling_priority
|<v> valid"
shape = "record"
shape = "record"
- ];
-
aaronic
[
- label = "
<a> aaronic||<n> name|<p> phone|<v> valid
"
+ ];
+
participation
[
+ label = "
participation||<i> individual|<a> activity
"
shape = "record"
];
shape = "record"
];
-
appointment
[
- label = "
<a> appointment||<p> presidency|<f> family|<e> elder |<d> date|<t> time|<u> uid
"
+
interview
[
+ label = "
interview||<in> interview|<i> interviewer|<il> individual|<t> date|<n> notes|<it> interview_type
"
shape = "record"
];
shape = "record"
];
-
assignment
[
- label = "
<a> assignment||<n> name|<c> code
"
+
presidency
[
+ label = "
presidency||<p> presidency|<i> individual|<d> district|<em> email|<pr> president|<cn> counselor|<sec> secreatary|<v> valid
"
shape = "record"
];
shape = "record"
];
-
calling
[
- label = "
calling||<i> indiv_id|<n> name|<o> organization|<p> position|<s> sequence|<t> sustained
"
+
visit
[
+ label = "
visit||<v> visit|<f> family|<c> companionship|<c1> companion1|<c2> companion2|<t> date|<n> notes|<v> visited|<vt> visit_type
"
shape = "record"
];
shape = "record"
];
-
district
[
- label = "
<d> district||<n> name|<s> supervisor|<v> valid
"
+
willingness
[
+ label = "
willingness||<i> individual|<a> assignment|<w> willing
"
shape = "record"
];
shape = "record"
];
-
interview
[
- label = "
<i> interview||<in> interviewer|<e> elder|<a> aaronic|<d> date
|<n> notes"
+
scheduling_priority
[
+ label = "
scheduling_priority||<sp> scheduling_priority|<p> priority
|<n> notes"
shape = "record"
];
shape = "record"
];
-
presidency
[
- label = "
<p> presidency||<e> elder|<d> district|<n> name|<em> email|<pr> president|<cn> counselor|<sec> secreatary|<v> valid
"
+
email_list
[
+ label = "
email_list||<e> email_list|<n> name
"
shape = "record"
];
shape = "record"
];
- willingness [
- label = "<e> elder||<a> assignment|<w> willing"
+ 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"
];
shape = "record"
];
- family:c -> companionship:c
- companionship:e -> elder:e
- companionship:a -> aaronic:a
+ activity:s -> assignment:a
- appointment:
e -> elder:e
+ appointment:
p -> presidency:p
appointment:f -> family:f
appointment:f -> family:f
+ appointment:i -> individual:i
- interview:e -> elder:e
- interview:in -> 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: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
- visit:c -> companionship:c
- visit:f -> family:f
+ interview:il -> individual:i
+ interview:i -> individual:i
- p
pi:i -> elder:e
- p
pi:e -> elder:e
+ p
residency:i -> individual:i
+ p
residency:d -> district:d
- participation:e -> elder:e
- participation:a -> activity:a
+ visit:c -> companionship:c
+ visit:f -> family:f
+ visit:c1 -> presidency:i
+ visit:c2 -> presidency:i
- 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
+
}
}