X-Git-Url: http://git.pippins.net/embedvideo/.git/static/git-logo.png?a=blobdiff_plain;f=sql%2Fschema.dot;h=864151927d8725dca218328b54d04f147d4783ab;hb=refs%2Fheads%2Fowenleonard%2Fdjango_db_prep;hp=c554f04bf6fdd3dd12abedd3c0c510bdc96722d2;hpb=9cbfdccb986373952fc820285cbc027b41c44b5e;p=eq%2F.git diff --git a/sql/schema.dot b/sql/schema.dot index c554f04..8641519 100644 --- a/sql/schema.dot +++ b/sql/schema.dot @@ -51,11 +51,11 @@ digraph schema { shape = "record" ]; leader [ - label = "leader|| leader| individual| district| email| president| counselor| secreatary| valid" + label = "leader|| leader| individual| email| type| valid" shape = "record" ]; visit [ - label = "visit|| visit| family| companionship| companion1| companion2| date| notes| visited| type" + label = "visit|| visit| family| companionship| date| notes| visited| type" shape = "record" ]; willingness [ @@ -75,7 +75,7 @@ digraph schema { shape = "record" ]; accomplishment [ - label = "accomplishment|| accomplishment| individual| date| task| note" + label = "accomplishment|| accomplishment| individual| date| task| notes" shape = "record" ]; task [ @@ -115,7 +115,7 @@ digraph schema { companionship:d -> district:d - district:l -> individual:i + district:l -> leader:l individual:sp -> scheduling_priority:sp @@ -127,15 +127,12 @@ digraph schema { participation:a -> activity:a interview:il -> individual:i - interview:i -> individual:i + interview:i -> leader:l leader:i -> individual:i - leader:d -> district:d visit:c -> companionship:c visit:f -> family:f - visit:c1 -> leader:i - visit:c2 -> leader:i willingness:i -> individual:i willingness:a -> assignment:a @@ -146,7 +143,7 @@ digraph schema { accomplishment:i -> individual:i accomplishment:t -> task:t - district_sandbox:l -> individual:i + district_sandbox:l -> leader:l companion_sandbox:i -> individual:i companion_sandbox:cp -> companionship_sandbox:cp companionship_sandbox:tcp -> companionship:c