projects
/
eq
/
.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
removed companion1 and companion2 from tc_visit
[eq/.git]
/
sql
/
schema.dot
diff --git
a/sql/schema.dot
b/sql/schema.dot
index d53f0b6c96c70d8a2e881fa58022584ab6e26b06..136e25338e737ae545856c7d0a32272a9f6ee412 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 [
@@
-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 -> leader:l
individual:sp -> scheduling_priority:sp
individual:sp -> scheduling_priority:sp
@@
-129,13
+129,10
@@
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
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,9
+143,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 -> 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
family_sandbox:i -> individual:i
companionship_sandbox:d -> district_sandbox:d
family_sandbox:tcf -> family:f
family_sandbox:i -> individual:i