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 2a88bf6072a955f82ac12042a9eb313b59de2526..9fb24285cf092e8e83c9a9d1308bd57f62c3e12e 100644
(file)
--- a/
sql/schema.dot
+++ b/
sql/schema.dot
@@
-19,11
+19,15
@@
digraph schema {
shape = "record"
];
calling [
shape = "record"
];
calling [
- label = "calling||<n> name|<o> organization|<p> position|<s> sustained"
+ label = "calling||<i> individual|<o> organization|<p> position|<s> sustained"
+ shape = "record"
+ ];
+ companion [
+ label = "companion||<c> companion|<i> individual|<cp> companionship|<sp> scheduling_priority|<v> valid"
shape = "record"
];
companionship [
shape = "record"
];
companionship [
- label = "companionship||<c> companionship|<
i> individual|<d> district|<sp> scheduling_priority
|<v> valid"
+ label = "companionship||<c> companionship|<
d> district
|<v> valid"
shape = "record"
];
district [
shape = "record"
];
district [
@@
-31,7
+35,7
@@
digraph schema {
shape = "record"
];
individual [
shape = "record"
];
individual [
- label = "individual||<i> individual|<id> mls_id|<n> name|<a> address|<p> phone|<em> email|<hh> hh position|<pr> priesthood|<st> steward|<sp> scheduling_priority|<a> attending|<v> valid"
+ 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"
];
family [
shape = "record"
];
family [
@@
-47,7
+51,7
@@
digraph schema {
shape = "record"
];
presidency [
shape = "record"
];
presidency [
- label = "presidency||<p> presidency|
|
<i> individual|<d> district|<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 [
shape = "record"
];
visit [
@@
-86,10
+90,14
@@
digraph schema {
appointment:i -> individual:i
attendance:i -> individual:i
appointment:i -> individual:i
attendance:i -> individual:i
+
+ calling:i -> individual:i
+
+ companion:cp -> companionship:c
+ companion:i -> individual:i
+ companion:sp -> scheduling_priority:sp
- companionship:i -> individual:i
companionship:d -> district:d
companionship:d -> district:d
- companionship:sp -> scheduling_priority:sp
district:s -> individual:i
district:s -> individual:i