projects
/
eq
/
.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
started changing app name to 3rd, changing file names to not have eq in them
[eq/.git]
/
sql
/
schema.dot
diff --git
a/sql/schema.dot
b/sql/schema.dot
index 99fb6c422a2ae8389ba03f37933e82d126b03223..8435656f5f7042ad06d6fdc4b7f645272192e714 100644
(file)
--- a/
sql/schema.dot
+++ b/
sql/schema.dot
@@
-3,23
+3,23
@@
digraph schema {
rankdir = "LR"
];
family [
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"
+ label = "<f> family||<
i> hofh_id|<n> name|<ni> name_id|<i> indiv_id|<c> companionship
|<vp> visit_pri|<vn> visit_notes|<v> valid"
shape = "record"
];
shape = "record"
];
-
elder
[
- label = "<
e> elder||<n> name|<p> phon
e|<pp> ppi_pri|<t> ppi_notes|<ip> int_pri|<in> int_notes|<a> attending|<v> valid"
+
indiv
[
+ label = "<
i> indiv||<id> indiv_id|<n> name|<p> phone|<em> email|<po> priesthood|<pr> prospectiv
e|<pp> ppi_pri|<t> ppi_notes|<ip> int_pri|<in> int_notes|<a> attending|<v> valid"
shape = "record"
];
companionship [
shape = "record"
];
companionship [
- label = "<c> companionship||<
e> elder
|<a> aaronic|<d> district|<v> valid"
+ label = "<c> companionship||<
i> indiv
|<a> aaronic|<d> district|<v> valid"
shape = "record"
];
visit [
shape = "record"
];
visit [
- label = "<v> visit||<f> family|<c> companionship|<
t> date|<n> notes|<v> visited
"
+ label = "<v> visit||<f> family|<c> companionship|<
c1> companion1|<c2> companion2|<t> date|<n> notes|<v> visited|<vt> visit_type
"
shape = "record"
];
shape = "record"
];
-
ppi
[
- label = "<
p> ppi||<i> interviewer|<e> elder|<t> date|<n> notes|<p> eqpresppi
"
+
interview
[
+ label = "<
in> interview||<i> interviewer|<il> indiv|<a> aaronic|<t> date|<n> notes|<it> interview_type
"
shape = "record"
];
activity [
shape = "record"
];
activity [
@@
-27,15
+27,15
@@
digraph schema {
shape = "record"
];
participation [
shape = "record"
];
participation [
- label = "participation||<
e> elder
|<a> activity"
+ label = "participation||<
i> indiv
|<a> activity"
shape = "record"
];
attendance [
shape = "record"
];
attendance [
- label = "attendance||<
e> elder
|<d> date"
+ label = "attendance||<
i> indiv
|<d> date"
shape = "record"
];
child [
shape = "record"
];
child [
- label = "<c> child||<f> family|<
i> indiv_id|<n> name|<b> birthday
|<v> valid"
+ label = "<c> child||<f> family|<
n> name|<b> birthday|<i> indiv_id
|<v> valid"
shape = "record"
];
parent [
shape = "record"
];
parent [
@@
-43,11
+43,11
@@
digraph schema {
shape = "record"
];
aaronic [
shape = "record"
];
aaronic [
- label = "<a> aaronic||<n> name|<p> phone|<v> valid"
+ label = "<a> aaronic||<n> name|<p> phone|<
em> email|<
v> valid"
shape = "record"
];
appointment [
shape = "record"
];
appointment [
- label = "<a> appointment||<p> presidency|<f> family|<
e> elder |<d> date|<t> time
|<u> uid"
+ label = "<a> appointment||<p> presidency|<f> family|<
i> indiv |<d> date|<t> time|<l> location
|<u> uid"
shape = "record"
];
assignment [
shape = "record"
];
assignment [
@@
-62,48
+62,43
@@
digraph schema {
label = "<d> district||<n> name|<s> supervisor|<v> valid"
shape = "record"
];
label = "<d> district||<n> name|<s> supervisor|<v> valid"
shape = "record"
];
- interview [
- label = "<i> interview||<in> interviewer|<e> elder|<a> aaronic|<d> date|<n> notes"
- shape = "record"
- ];
presidency [
presidency [
- label = "<p> presidency||<
e> elder
|<d> district|<n> name|<em> email|<pr> president|<cn> counselor|<sec> secreatary|<v> valid"
+ label = "<p> presidency||<
i> indiv
|<d> district|<n> name|<em> email|<pr> president|<cn> counselor|<sec> secreatary|<v> valid"
shape = "record"
];
willingness [
shape = "record"
];
willingness [
- label = "<
e> elder
||<a> assignment|<w> willing"
+ label = "<
i> indiv
||<a> assignment|<w> willing"
shape = "record"
];
family:c -> companionship:c
shape = "record"
];
family:c -> companionship:c
- companionship:
e -> elder:e
+ companionship:
i -> indiv:i
companionship:a -> aaronic:a
companionship:a -> aaronic:a
- appointment:
e -> elder:e
+ appointment:
i -> indiv:i
appointment:f -> family:f
appointment:f -> family:f
- interview:
e -> elder:e
- interview:i
n -> elder:e
+ interview:
il -> indiv:i
+ interview:i
-> indiv:i
interview:a -> aaronic:a
interview:a -> aaronic:a
- presidency:
e -> elder:e
+ presidency:
i -> indiv:i
presidency:d -> district:d
presidency:d -> district:d
- willingness:
e -> elder:e
+ willingness:
i -> indiv:i
willingness:a -> assignment:a
activity:s -> assignment:a
visit:c -> companionship:c
visit:f -> family:f
willingness:a -> assignment:a
activity:s -> assignment:a
visit:c -> companionship:c
visit:f -> family:f
+ visit:c1 -> presidency:i
+ visit:c2 -> presidency:i
- ppi:i -> elder:e
- ppi:e -> elder:e
-
- participation:e -> elder:e
+ participation:i -> indiv:i
participation:a -> activity:a
participation:a -> activity:a
- attendance:
e -> elder:e
+ attendance:
i -> indiv:i
child:f -> family:f
parent:f -> family:f
child:f -> family:f
parent:f -> family:f