projects
/
eq
/
.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
changed tc_presidency to tc_leader
[eq/.git]
/
sql
/
schema.dot
diff --git
a/sql/schema.dot
b/sql/schema.dot
index d53f0b6c96c70d8a2e881fa58022584ab6e26b06..c554f04bf6fdd3dd12abedd3c0c510bdc96722d2 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|<d> district|<em> email|<pr> president|<cn> counselor|<sec> secreatary|<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|<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,7
+91,7
@@
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 [
@@
-101,7
+101,7
@@
digraph schema {
activity:s -> assignment:a
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
-> individual:i
individual:sp -> scheduling_priority:sp
individual:sp -> scheduling_priority:sp
@@
-129,13
+129,13
@@
digraph schema {
interview:il -> individual:i
interview:i -> individual:i
interview:il -> individual:i
interview:i -> individual:i
-
presidency
:i -> individual:i
-
presidency
:d -> district:d
+
leader
:i -> individual:i
+
leader
:d -> district:d
visit:c -> companionship:c
visit:f -> family:f
visit:c -> companionship:c
visit:f -> family:f
- visit:c1 ->
presidency
:i
- visit:c2 ->
presidency
:i
+ visit:c1 ->
leader
:i
+ visit:c2 ->
leader
:i
willingness:i -> individual:i
willingness:a -> assignment:a
willingness:i -> individual:i
willingness:a -> assignment:a
@@
-146,9
+146,10
@@
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
family_sandbox:i -> individual:i
companionship_sandbox:d -> district_sandbox:d
family_sandbox:tcf -> family:f
family_sandbox:i -> individual:i