projects
/
eq
/
.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
changed note field in tc_accomplishment to notes
[eq/.git]
/
sql
/
schema.dot
diff --git
a/sql/schema.dot
b/sql/schema.dot
index 7d5d187d81b1e676ae3a3f0c81c9243492517128..864151927d8725dca218328b54d04f147d4783ab 100644
(file)
--- a/
sql/schema.dot
+++ b/
sql/schema.dot
@@
-7,7
+7,7
@@
digraph schema {
shape = "record"
];
appointment [
shape = "record"
];
appointment [
- label = "appointment||<a> appointment|<
p> presidency
|<f> family|<i> individual |<d> date|<t> time|<l> location|<u> uid"
+ label = "appointment||<a> appointment|<
l> leader
|<f> family|<i> individual |<d> date|<t> time|<l> location|<u> uid"
shape = "record"
];
assignment [
shape = "record"
];
assignment [
@@
-27,11
+27,11
@@
digraph schema {
shape = "record"
];
companionship [
shape = "record"
];
companionship [
- label = "companionship||<c> companionship|<d> district|<v> valid"
+ label = "companionship||<c> companionship|<d> district|<
t> type|<
v> valid"
shape = "record"
];
district [
shape = "record"
];
district [
- label = "district||<d> district|<
s> superviso
r|<v> valid"
+ label = "district||<d> district|<
l> leade
r|<v> valid"
shape = "record"
];
individual [
shape = "record"
];
individual [
@@
-47,15
+47,15
@@
digraph schema {
shape = "record"
];
interview [
shape = "record"
];
interview [
- label = "interview||<in> interview|<i> interviewer|<il> individual|<t> date|<n> notes|<
it> interview_
type"
+ label = "interview||<in> interview|<i> interviewer|<il> individual|<t> date|<n> notes|<
t>
type"
shape = "record"
];
shape = "record"
];
-
presidency
[
- label = "
presidency||<p> presidency|<i> individual|<d> district|<em> email|<pr> president|<cn> counselor|<sec> secreatary
|<v> valid"
+
leader
[
+ label = "
leader||<l> leader|<i> individual|<em> email|<t> type
|<v> valid"
shape = "record"
];
visit [
shape = "record"
];
visit [
- label = "visit||<v> visit|<f> family|<c> companionship|<
c1> companion1|<c2> companion2|<t> date|<n> notes|<v> visited|<vt> visit_
type"
+ label = "visit||<v> visit|<f> family|<c> companionship|<
t> date|<n> notes|<v> visited|<vt>
type"
shape = "record"
];
willingness [
shape = "record"
];
willingness [
@@
-75,7
+75,7
@@
digraph schema {
shape = "record"
];
accomplishment [
shape = "record"
];
accomplishment [
- label = "accomplishment||<a> accomplishment|<i> individual|<d> date|<t> task|<n> note"
+ label = "accomplishment||<a> accomplishment|<i> individual|<d> date|<t> task|<n> note
s
"
shape = "record"
];
task [
shape = "record"
];
task [
@@
-83,7
+83,7
@@
digraph schema {
shape = "record"
];
district_sandbox [
shape = "record"
];
district_sandbox [
- label = "district_sandbox||<d> district|<
s> superviso
r"
+ label = "district_sandbox||<d> district|<
l> leade
r"
shape = "record"
];
companion_sandbox [
shape = "record"
];
companion_sandbox [
@@
-91,17
+91,17
@@
digraph schema {
shape = "record"
];
companionship_sandbox [
shape = "record"
];
companionship_sandbox [
- label = "companionship_sandbox||<cp> companionship|<d> district"
+ label = "companionship_sandbox||<cp> companionship|<
tcp> tc_companionship|<
d> district"
shape = "record"
];
family_sandbox [
shape = "record"
];
family_sandbox [
- label = "family_sandbox||<f> family|<tcf> tc_family|<cp> companionship"
+ label = "family_sandbox||<f> family|<tcf> tc_family|<
i> individual|<
cp> companionship"
shape = "record"
];
activity:s -> assignment:a
shape = "record"
];
activity:s -> assignment:a
- appointment:
p -> presidency:p
+ appointment:
l -> leader:l
appointment:f -> family:f
appointment:i -> individual:i
appointment:f -> family:f
appointment:i -> individual:i
@@
-115,7
+115,7
@@
digraph schema {
companionship:d -> district:d
companionship:d -> district:d
- district:
s -> individual:i
+ district:
l -> leader:l
individual:sp -> scheduling_priority:sp
individual:sp -> scheduling_priority:sp
@@
-127,15
+127,12
@@
digraph schema {
participation:a -> activity:a
interview:il -> individual:i
participation:a -> activity:a
interview:il -> individual:i
- interview:i ->
individual:i
+ interview:i ->
leader:l
- presidency:i -> individual:i
- presidency:d -> district:d
+ leader:i -> individual:i
visit:c -> companionship:c
visit:f -> family:f
visit:c -> companionship:c
visit:f -> family:f
- visit:c1 -> presidency:i
- visit:c2 -> presidency:i
willingness:i -> individual:i
willingness:a -> assignment:a
willingness:i -> individual:i
willingness:a -> assignment:a
@@
-146,11
+143,13
@@
digraph schema {
accomplishment:i -> individual:i
accomplishment:t -> task:t
accomplishment:i -> individual:i
accomplishment:t -> task:t
- district_sandbox:
s -> individual:i
+ district_sandbox:
l -> leader:l
companion_sandbox:i -> individual:i
companion_sandbox:cp -> companionship_sandbox:cp
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
companionship_sandbox:d -> district_sandbox:d
family_sandbox:tcf -> family:f
+ family_sandbox:i -> individual:i
family_sandbox:cp -> companionship_sandbox:cp
}
family_sandbox:cp -> companionship_sandbox:cp
}