projects
/
eq
/
.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
change supervisor field in tc_district and tc_district_sandbox to leader
[eq/.git]
/
sql
/
schema.dot
diff --git
a/sql/schema.dot
b/sql/schema.dot
index 7d5d187d81b1e676ae3a3f0c81c9243492517128..cbd156a4bf92d27a643db673dc3cf3076383f725 100644
(file)
--- a/
sql/schema.dot
+++ b/
sql/schema.dot
@@
-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,7
+47,7
@@
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"
];
presidency [
shape = "record"
];
presidency [
@@
-55,7
+55,7
@@
digraph schema {
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|<c1> companion1|<c2> companion2|<t> date|<n> notes|<v> visited|<vt> type"
shape = "record"
];
willingness [
shape = "record"
];
willingness [
@@
-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,11
+91,11
@@
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"
];
shape = "record"
];
@@
-115,7
+115,7
@@
digraph schema {
companionship:d -> district:d
companionship:d -> district:d
- district:
s
-> individual:i
+ district:
l
-> individual:i
individual:sp -> scheduling_priority:sp
individual:sp -> scheduling_priority:sp
@@
-146,11
+146,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
-> individual:i
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
}