X-Git-Url: http://git.pippins.net/embedvideo/.git/static/git-logo.png?a=blobdiff_plain;f=sql%2Fschema.dot;h=c554f04bf6fdd3dd12abedd3c0c510bdc96722d2;hb=9cbfdccb986373952fc820285cbc027b41c44b5e;hp=cbd156a4bf92d27a643db673dc3cf3076383f725;hpb=6164e3a3c2d19b4e1d718ccafd7dddf6da27d270;p=eq%2F.git diff --git a/sql/schema.dot b/sql/schema.dot index cbd156a..c554f04 100644 --- a/sql/schema.dot +++ b/sql/schema.dot @@ -7,7 +7,7 @@ digraph schema { shape = "record" ]; appointment [ - label = "appointment|| appointment|

presidency| family| individual | date| time| location| uid" + label = "appointment|| appointment| leader| family| individual | date| time| location| uid" shape = "record" ]; assignment [ @@ -50,8 +50,8 @@ digraph schema { label = "interview|| interview| interviewer| individual| date| notes| type" shape = "record" ]; - presidency [ - label = "presidency||

presidency| individual| district| email| president| counselor| secreatary| valid" + leader [ + label = "leader|| leader| individual| district| email| president| counselor| secreatary| valid" shape = "record" ]; visit [ @@ -101,7 +101,7 @@ digraph schema { activity:s -> assignment:a - appointment:p -> presidency:p + appointment:l -> leader:l appointment:f -> family:f appointment:i -> individual:i @@ -129,13 +129,13 @@ digraph schema { 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:c1 -> presidency:i - visit:c2 -> presidency:i + visit:c1 -> leader:i + visit:c2 -> leader:i willingness:i -> individual:i willingness:a -> assignment:a