X-Git-Url: http://git.pippins.net/embedvideo/.git/static/git-logo.png?a=blobdiff_plain;f=sql%2Fschema.dot;h=cbd156a4bf92d27a643db673dc3cf3076383f725;hb=6164e3a3c2d19b4e1d718ccafd7dddf6da27d270;hp=ec23ab7b4f1b56ede97e1dbd45740ba4a258d68d;hpb=40bab501e1ba7d982bead980469dcd975d141130;p=eq%2F.git diff --git a/sql/schema.dot b/sql/schema.dot index ec23ab7..cbd156a 100644 --- a/sql/schema.dot +++ b/sql/schema.dot @@ -27,11 +27,11 @@ digraph schema { shape = "record" ]; companionship [ - label = "companionship|| companionship| district| valid" + label = "companionship|| companionship| district| type| valid" shape = "record" ]; district [ - label = "district|| district| supervisor| valid" + label = "district|| district| leader| valid" shape = "record" ]; individual [ @@ -55,7 +55,7 @@ digraph schema { shape = "record" ]; visit [ - label = "visit|| visit| family| companionship| companion1| companion2| date| notes| visited| visit_type" + label = "visit|| visit| family| companionship| companion1| companion2| date| notes| visited| type" shape = "record" ]; willingness [ @@ -83,7 +83,7 @@ digraph schema { shape = "record" ]; district_sandbox [ - label = "district_sandbox|| district| supervisor" + label = "district_sandbox|| district| leader" shape = "record" ]; companion_sandbox [ @@ -115,7 +115,7 @@ digraph schema { companionship:d -> district:d - district:s -> individual:i + district:l -> individual:i individual:sp -> scheduling_priority:sp @@ -146,7 +146,7 @@ digraph schema { 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 companionship_sandbox:tcp -> companionship:c