← Back to branch summary

~launchpad-pqm/launchpad/devel

« back to all changes in this revision

Viewing changes to database/schema/diagrams/voting.svg

  • Committer: Stuart Bishop
  • Date: 2005-11-24 07:47:19 UTC
  • mto: This revision was merged to the branch mainline in revision 2851.
  • Revision ID: stuart.bishop@canonical.com-20051124074719-1f14a54a1d23e0ff
Update database diagrams and documentation

Show diffs side-by-side

added added

removed removed

Lines of Context:
database/schema/diagrams/voting.svg
1
1
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
2
2
<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.0//EN"
3
3
 "http://www.w3.org/TR/2001/REC-SVG-20010904/DTD/svg10.dtd">
4
 
<!-- Generated by fdp version 2.2.1 (Thu Apr 14 05:40:09 UTC 2005)
 
4
<!-- Generated by fdp version 2.2.1 (Tue Oct 11 01:38:21 UTC 2005)
5
5
     For user: (stub) Stuart Bishop,,,   Title: g    Pages: 1 -->
6
 
<svg width="326px" height="535px"
7
 
 viewBox = "-1 -1 325 534"
 
6
<svg width="351px" height="535px"
 
7
 viewBox = "-1 -1 350 534"
8
8
 xmlns="http://www.w3.org/2000/svg">
9
 
<g id="graph0" class="graph" transform = "scale(0.437291)"
 
9
<g id="graph0" class="graph" transform = "scale(0.447391)"
10
10
 style="font-family:Times-Roman;font-size:14.00;">
11
11
<title>g</title>
12
 
<text text-anchor="middle" style="font-size:22.00;" x="364" y="1202">Voting</text>
 
12
<text text-anchor="middle" style="font-size:22.00;" x="384" y="1175">Voting</text>
13
13
<g id="node1" class="node"><title>person</title>
14
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="284,972 284,606 486,606 486,972 284,972"/>
15
 
<polygon style="fill:white;stroke:white;" points="287,621 287,609 483,609 483,621 287,621"/>
16
 
<text text-anchor="middle" style="font-size:6.00;" x="385" y="617">person</text>
17
 
<polygon style="fill:none;stroke:black;" points="287,621 287,609 483,609 483,621 287,621"/>
18
 
<text text-anchor="middle" style="font-size:6.00;" x="292" y="630">id</text>
19
 
<text text-anchor="middle" style="font-size:6.00;" x="367" y="630">serial</text>
20
 
<text text-anchor="middle" style="font-size:6.00;" x="416" y="630"> PRIMARY KEY </text>
21
 
<text text-anchor="middle" style="font-size:6.00;" x="305" y="642">displayname</text>
22
 
<text text-anchor="middle" style="font-size:6.00;" x="366" y="642">text</text>
23
 
<text text-anchor="middle" style="font-size:6.00;" x="303" y="654">givenname</text>
24
 
<text text-anchor="middle" style="font-size:6.00;" x="366" y="654">text</text>
25
 
<text text-anchor="middle" style="font-size:6.00;" x="304" y="666">familyname</text>
26
 
<text text-anchor="middle" style="font-size:6.00;" x="366" y="666">text</text>
27
 
<text text-anchor="middle" style="font-size:6.00;" x="301" y="678">password</text>
28
 
<text text-anchor="middle" style="font-size:6.00;" x="366" y="678">text</text>
29
 
<text text-anchor="middle" style="font-size:6.00;" x="303" y="690">teamowner</text>
30
 
<text text-anchor="middle" style="font-size:6.00;" x="369" y="690">integer</text>
31
 
<text text-anchor="middle" style="font-size:6.00;" x="423" y="690"> REFERENCES person </text>
32
 
<text text-anchor="middle" style="font-size:6.00;" x="310" y="702">teamdescription</text>
33
 
<text text-anchor="middle" style="font-size:6.00;" x="366" y="702">text</text>
34
 
<text text-anchor="middle" style="font-size:6.00;" x="297" y="714">name</text>
35
 
<text text-anchor="middle" style="font-size:6.00;" x="366" y="714">text</text>
36
 
<text text-anchor="middle" style="font-size:6.00;" x="301" y="726">language</text>
37
 
<text text-anchor="middle" style="font-size:6.00;" x="369" y="726">integer</text>
38
 
<text text-anchor="middle" style="font-size:6.00;" x="426" y="726"> REFERENCES language </text>
39
 
<text text-anchor="middle" style="font-size:6.00;" x="293" y="738">fti</text>
40
 
<text text-anchor="middle" style="font-size:6.00;" x="371" y="738">tsvector</text>
41
 
<text text-anchor="middle" style="font-size:6.00;" x="321" y="750">defaultmembershipperiod</text>
42
 
<text text-anchor="middle" style="font-size:6.00;" x="369" y="750">integer</text>
43
 
<text text-anchor="middle" style="font-size:6.00;" x="316" y="762">defaultrenewalperiod</text>
44
 
<text text-anchor="middle" style="font-size:6.00;" x="369" y="762">integer</text>
45
 
<text text-anchor="middle" style="font-size:6.00;" x="312" y="774">subscriptionpolicy</text>
46
 
<text text-anchor="middle" style="font-size:6.00;" x="369" y="774">integer</text>
47
 
<text text-anchor="middle" style="font-size:6.00;" x="299" y="786">merged</text>
48
 
<text text-anchor="middle" style="font-size:6.00;" x="369" y="786">integer</text>
49
 
<text text-anchor="middle" style="font-size:6.00;" x="423" y="786"> REFERENCES person </text>
50
 
<text text-anchor="middle" style="font-size:6.00;" x="304" y="798">datecreated</text>
51
 
<text text-anchor="middle" style="font-size:6.00;" x="374" y="798">timestamp</text>
52
 
<text text-anchor="middle" style="font-size:6.00;" x="300" y="810">calendar</text>
53
 
<text text-anchor="middle" style="font-size:6.00;" x="369" y="810">integer</text>
54
 
<text text-anchor="middle" style="font-size:6.00;" x="437" y="810"> REFERENCES calendar UNIQUE </text>
55
 
<text text-anchor="middle" style="font-size:6.00;" x="301" y="822">timezone</text>
56
 
<text text-anchor="middle" style="font-size:6.00;" x="366" y="822">text</text>
57
 
<text text-anchor="middle" style="font-size:6.00;" x="298" y="834">karma</text>
58
 
<text text-anchor="middle" style="font-size:6.00;" x="369" y="834">integer</text>
59
 
<text text-anchor="middle" style="font-size:6.00;" x="305" y="846">addressline1</text>
60
 
<text text-anchor="middle" style="font-size:6.00;" x="366" y="846">text</text>
61
 
<text text-anchor="middle" style="font-size:6.00;" x="305" y="858">addressline2</text>
62
 
<text text-anchor="middle" style="font-size:6.00;" x="366" y="858">text</text>
63
 
<text text-anchor="middle" style="font-size:6.00;" x="305" y="870">organization</text>
64
 
<text text-anchor="middle" style="font-size:6.00;" x="366" y="870">text</text>
65
 
<text text-anchor="middle" style="font-size:6.00;" x="295" y="882">city</text>
66
 
<text text-anchor="middle" style="font-size:6.00;" x="366" y="882">text</text>
67
 
<text text-anchor="middle" style="font-size:6.00;" x="301" y="894">province</text>
68
 
<text text-anchor="middle" style="font-size:6.00;" x="366" y="894">text</text>
69
 
<text text-anchor="middle" style="font-size:6.00;" x="300" y="906">country</text>
70
 
<text text-anchor="middle" style="font-size:6.00;" x="369" y="906">integer</text>
71
 
<text text-anchor="middle" style="font-size:6.00;" x="425" y="906"> REFERENCES country </text>
72
 
<text text-anchor="middle" style="font-size:6.00;" x="301" y="918">postcode</text>
73
 
<text text-anchor="middle" style="font-size:6.00;" x="366" y="918">text</text>
74
 
<text text-anchor="middle" style="font-size:6.00;" x="298" y="930">phone</text>
75
 
<text text-anchor="middle" style="font-size:6.00;" x="366" y="930">text</text>
76
 
<text text-anchor="middle" style="font-size:6.00;" x="313" y="942">homepage_content</text>
77
 
<text text-anchor="middle" style="font-size:6.00;" x="366" y="942">text</text>
78
 
<text text-anchor="middle" style="font-size:6.00;" x="300" y="954">emblem</text>
79
 
<text text-anchor="middle" style="font-size:6.00;" x="369" y="954">integer</text>
80
 
<text text-anchor="middle" style="font-size:6.00;" x="433" y="954"> REFERENCES libraryfilealias </text>
81
 
<text text-anchor="middle" style="font-size:6.00;" x="306" y="966">hackergotchi</text>
82
 
<text text-anchor="middle" style="font-size:6.00;" x="369" y="966">integer</text>
83
 
<text text-anchor="middle" style="font-size:6.00;" x="433" y="966"> REFERENCES libraryfilealias </text>
84
 
<polygon style="fill:none;stroke:black;" points="284,972 284,606 486,606 486,972 284,972"/>
 
14
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="282,964 282,598 484,598 484,964 282,964"/>
 
15
<polygon style="fill:white;stroke:white;" points="285,613 285,601 481,601 481,613 285,613"/>
 
16
<text text-anchor="middle" style="font-size:6.00;" x="383" y="609">person</text>
 
17
<polygon style="fill:none;stroke:black;" points="285,613 285,601 481,601 481,613 285,613"/>
 
18
<text text-anchor="middle" style="font-size:6.00;" x="290" y="622">id</text>
 
19
<text text-anchor="middle" style="font-size:6.00;" x="365" y="622">serial</text>
 
20
<text text-anchor="middle" style="font-size:6.00;" x="414" y="622"> PRIMARY KEY </text>
 
21
<text text-anchor="middle" style="font-size:6.00;" x="303" y="634">displayname</text>
 
22
<text text-anchor="middle" style="font-size:6.00;" x="364" y="634">text</text>
 
23
<text text-anchor="middle" style="font-size:6.00;" x="301" y="646">givenname</text>
 
24
<text text-anchor="middle" style="font-size:6.00;" x="364" y="646">text</text>
 
25
<text text-anchor="middle" style="font-size:6.00;" x="302" y="658">familyname</text>
 
26
<text text-anchor="middle" style="font-size:6.00;" x="364" y="658">text</text>
 
27
<text text-anchor="middle" style="font-size:6.00;" x="299" y="670">password</text>
 
28
<text text-anchor="middle" style="font-size:6.00;" x="364" y="670">text</text>
 
29
<text text-anchor="middle" style="font-size:6.00;" x="301" y="682">teamowner</text>
 
30
<text text-anchor="middle" style="font-size:6.00;" x="367" y="682">integer</text>
 
31
<text text-anchor="middle" style="font-size:6.00;" x="421" y="682"> REFERENCES person </text>
 
32
<text text-anchor="middle" style="font-size:6.00;" x="308" y="694">teamdescription</text>
 
33
<text text-anchor="middle" style="font-size:6.00;" x="364" y="694">text</text>
 
34
<text text-anchor="middle" style="font-size:6.00;" x="295" y="706">name</text>
 
35
<text text-anchor="middle" style="font-size:6.00;" x="364" y="706">text</text>
 
36
<text text-anchor="middle" style="font-size:6.00;" x="299" y="718">language</text>
 
37
<text text-anchor="middle" style="font-size:6.00;" x="367" y="718">integer</text>
 
38
<text text-anchor="middle" style="font-size:6.00;" x="424" y="718"> REFERENCES language </text>
 
39
<text text-anchor="middle" style="font-size:6.00;" x="291" y="730">fti</text>
 
40
<text text-anchor="middle" style="font-size:6.00;" x="369" y="730">tsvector</text>
 
41
<text text-anchor="middle" style="font-size:6.00;" x="319" y="742">defaultmembershipperiod</text>
 
42
<text text-anchor="middle" style="font-size:6.00;" x="367" y="742">integer</text>
 
43
<text text-anchor="middle" style="font-size:6.00;" x="314" y="754">defaultrenewalperiod</text>
 
44
<text text-anchor="middle" style="font-size:6.00;" x="367" y="754">integer</text>
 
45
<text text-anchor="middle" style="font-size:6.00;" x="310" y="766">subscriptionpolicy</text>
 
46
<text text-anchor="middle" style="font-size:6.00;" x="367" y="766">integer</text>
 
47
<text text-anchor="middle" style="font-size:6.00;" x="297" y="778">merged</text>
 
48
<text text-anchor="middle" style="font-size:6.00;" x="367" y="778">integer</text>
 
49
<text text-anchor="middle" style="font-size:6.00;" x="421" y="778"> REFERENCES person </text>
 
50
<text text-anchor="middle" style="font-size:6.00;" x="302" y="790">datecreated</text>
 
51
<text text-anchor="middle" style="font-size:6.00;" x="372" y="790">timestamp</text>
 
52
<text text-anchor="middle" style="font-size:6.00;" x="298" y="802">calendar</text>
 
53
<text text-anchor="middle" style="font-size:6.00;" x="367" y="802">integer</text>
 
54
<text text-anchor="middle" style="font-size:6.00;" x="435" y="802"> REFERENCES calendar UNIQUE </text>
 
55
<text text-anchor="middle" style="font-size:6.00;" x="299" y="814">timezone</text>
 
56
<text text-anchor="middle" style="font-size:6.00;" x="364" y="814">text</text>
 
57
<text text-anchor="middle" style="font-size:6.00;" x="296" y="826">karma</text>
 
58
<text text-anchor="middle" style="font-size:6.00;" x="367" y="826">integer</text>
 
59
<text text-anchor="middle" style="font-size:6.00;" x="303" y="838">addressline1</text>
 
60
<text text-anchor="middle" style="font-size:6.00;" x="364" y="838">text</text>
 
61
<text text-anchor="middle" style="font-size:6.00;" x="303" y="850">addressline2</text>
 
62
<text text-anchor="middle" style="font-size:6.00;" x="364" y="850">text</text>
 
63
<text text-anchor="middle" style="font-size:6.00;" x="303" y="862">organization</text>
 
64
<text text-anchor="middle" style="font-size:6.00;" x="364" y="862">text</text>
 
65
<text text-anchor="middle" style="font-size:6.00;" x="293" y="874">city</text>
 
66
<text text-anchor="middle" style="font-size:6.00;" x="364" y="874">text</text>
 
67
<text text-anchor="middle" style="font-size:6.00;" x="299" y="886">province</text>
 
68
<text text-anchor="middle" style="font-size:6.00;" x="364" y="886">text</text>
 
69
<text text-anchor="middle" style="font-size:6.00;" x="298" y="898">country</text>
 
70
<text text-anchor="middle" style="font-size:6.00;" x="367" y="898">integer</text>
 
71
<text text-anchor="middle" style="font-size:6.00;" x="423" y="898"> REFERENCES country </text>
 
72
<text text-anchor="middle" style="font-size:6.00;" x="299" y="910">postcode</text>
 
73
<text text-anchor="middle" style="font-size:6.00;" x="364" y="910">text</text>
 
74
<text text-anchor="middle" style="font-size:6.00;" x="296" y="922">phone</text>
 
75
<text text-anchor="middle" style="font-size:6.00;" x="364" y="922">text</text>
 
76
<text text-anchor="middle" style="font-size:6.00;" x="311" y="934">homepage_content</text>
 
77
<text text-anchor="middle" style="font-size:6.00;" x="364" y="934">text</text>
 
78
<text text-anchor="middle" style="font-size:6.00;" x="298" y="946">emblem</text>
 
79
<text text-anchor="middle" style="font-size:6.00;" x="367" y="946">integer</text>
 
80
<text text-anchor="middle" style="font-size:6.00;" x="431" y="946"> REFERENCES libraryfilealias </text>
 
81
<text text-anchor="middle" style="font-size:6.00;" x="304" y="958">hackergotchi</text>
 
82
<text text-anchor="middle" style="font-size:6.00;" x="367" y="958">integer</text>
 
83
<text text-anchor="middle" style="font-size:6.00;" x="431" y="958"> REFERENCES libraryfilealias </text>
 
84
<polygon style="fill:none;stroke:black;" points="282,964 282,598 484,598 484,964 282,964"/>
85
85
</g>
86
86
<g id="edge2" class="edge"><title>person&#45;&gt;person</title>
87
 
<path style="fill:none;stroke:black;" d="M494,846C505,834 512,816 512,789 512,767 508,752 500,740"/>
88
 
<polygon style="fill:black;stroke:black;" points="497,742 494,732 503,738 497,742"/>
 
87
<path style="fill:none;stroke:black;" d="M492,838C503,826 510,808 510,781 510,759 506,744 498,732"/>
 
88
<polygon style="fill:black;stroke:black;" points="495,734 492,724 501,730 495,734"/>
89
89
</g>
90
90
<g id="edge6" class="edge"><title>person&#45;&gt;person</title>
91
 
<path style="fill:none;stroke:black;" d="M494,922C515,906 530,862 530,789 530,725 518,683 501,663"/>
92
 
<polygon style="fill:black;stroke:black;" points="499,666 494,656 504,661 499,666"/>
93
 
</g>
94
 
<g id="node7" class="node"><title>fake_language_168</title>
95
 
<ellipse cx="33" cy="774" rx="27" ry="18" style="fill:none;stroke:red;"/>
96
 
<text text-anchor="middle" style="font-size:6.00;" x="33" y="776">language</text>
97
 
</g>
98
 
<g id="edge4" class="edge"><title>person&#45;&gt;fake_language_168</title>
99
 
<path style="fill:none;stroke:black;" d="M276,784C205,781 119,778 70,775"/>
100
 
<polygon style="fill:black;stroke:black;" points="70,778 60,775 70,771 70,778"/>
101
 
</g>
102
 
<g id="node10" class="node"><title>fake_calendar_171</title>
103
 
<ellipse cx="138" cy="1049" rx="27" ry="18" style="fill:none;stroke:red;"/>
104
 
<text text-anchor="middle" style="font-size:6.00;" x="138" y="1051">calendar</text>
105
 
</g>
106
 
<g id="edge8" class="edge"><title>person&#45;&gt;fake_calendar_171</title>
107
 
<path style="fill:none;stroke:black;" d="M276,904C232,950 186,998 160,1026"/>
108
 
<polygon style="fill:black;stroke:black;" points="162,1029 153,1034 157,1024 162,1029"/>
109
 
</g>
110
 
<g id="node12" class="node"><title>fake_country_173</title>
111
 
<ellipse cx="573" cy="822" rx="27" ry="18" style="fill:none;stroke:red;"/>
112
 
<text text-anchor="middle" style="font-size:6.00;" x="573" y="824">country</text>
113
 
</g>
114
 
<g id="edge10" class="edge"><title>person&#45;&gt;fake_country_173</title>
115
 
<path style="fill:none;stroke:black;" d="M494,808C509,810 524,813 537,815"/>
116
 
<polygon style="fill:black;stroke:black;" points="538,812 547,817 537,818 538,812"/>
117
 
</g>
118
 
<g id="node14" class="node"><title>fake_libraryfilealias_175</title>
119
 
<ellipse cx="694" cy="1013" rx="29" ry="18" style="fill:none;stroke:red;"/>
120
 
<text text-anchor="middle" style="font-size:6.00;" x="694" y="1015">libraryfilealias</text>
121
 
</g>
122
 
<g id="edge12" class="edge"><title>person&#45;&gt;fake_libraryfilealias_175</title>
123
 
<path style="fill:none;stroke:black;" d="M494,868C556,914 628,966 667,993"/>
124
 
<polygon style="fill:black;stroke:black;" points="669,990 675,999 665,996 669,990"/>
125
 
</g>
126
 
<g id="node16" class="node"><title>fake_libraryfilealias_177</title>
127
 
<ellipse cx="407" cy="1159" rx="29" ry="18" style="fill:none;stroke:red;"/>
128
 
<text text-anchor="middle" style="font-size:6.00;" x="407" y="1161">libraryfilealias</text>
129
 
</g>
130
 
<g id="edge14" class="edge"><title>person&#45;&gt;fake_libraryfilealias_177</title>
131
 
<path style="fill:none;stroke:black;" d="M396,976C400,1036 403,1097 405,1131"/>
132
 
<polygon style="fill:black;stroke:black;" points="408,1131 406,1141 402,1131 408,1131"/>
 
91
<path style="fill:none;stroke:black;" d="M492,914C513,898 528,854 528,781 528,717 516,675 499,655"/>
 
92
<polygon style="fill:black;stroke:black;" points="497,658 492,648 502,653 497,658"/>
 
93
</g>
 
94
<g id="node7" class="node"><title>fake_language_173</title>
 
95
<ellipse cx="33" cy="738" rx="27" ry="18" style="fill:none;stroke:red;"/>
 
96
<text text-anchor="middle" style="font-size:6.00;" x="33" y="740">language</text>
 
97
</g>
 
98
<g id="edge4" class="edge"><title>person&#45;&gt;fake_language_173</title>
 
99
<path style="fill:none;stroke:black;" d="M274,768C204,760 118,749 70,742"/>
 
100
<polygon style="fill:black;stroke:black;" points="70,745 60,741 70,739 70,745"/>
 
101
</g>
 
102
<g id="node10" class="node"><title>fake_calendar_176</title>
 
103
<ellipse cx="111" cy="1003" rx="27" ry="18" style="fill:none;stroke:red;"/>
 
104
<text text-anchor="middle" style="font-size:6.00;" x="111" y="1005">calendar</text>
 
105
</g>
 
106
<g id="edge8" class="edge"><title>person&#45;&gt;fake_calendar_176</title>
 
107
<path style="fill:none;stroke:black;" d="M274,870C224,911 168,957 137,983"/>
 
108
<polygon style="fill:black;stroke:black;" points="139,986 129,989 135,980 139,986"/>
 
109
</g>
 
110
<g id="node12" class="node"><title>fake_country_178</title>
 
111
<ellipse cx="736" cy="817" rx="27" ry="18" style="fill:none;stroke:red;"/>
 
112
<text text-anchor="middle" style="font-size:6.00;" x="736" y="819">country</text>
 
113
</g>
 
114
<g id="edge10" class="edge"><title>person&#45;&gt;fake_country_178</title>
 
115
<path style="fill:none;stroke:black;" d="M492,792C563,799 651,809 699,813"/>
 
116
<polygon style="fill:black;stroke:black;" points="699,810 709,814 699,816 699,810"/>
 
117
</g>
 
118
<g id="node14" class="node"><title>fake_libraryfilealias_180</title>
 
119
<ellipse cx="604" cy="1059" rx="29" ry="18" style="fill:none;stroke:red;"/>
 
120
<text text-anchor="middle" style="font-size:6.00;" x="604" y="1061">libraryfilealias</text>
 
121
</g>
 
122
<g id="edge12" class="edge"><title>person&#45;&gt;fake_libraryfilealias_180</title>
 
123
<path style="fill:none;stroke:black;" d="M492,918C528,962 564,1008 585,1035"/>
 
124
<polygon style="fill:black;stroke:black;" points="588,1033 591,1043 582,1037 588,1033"/>
 
125
</g>
 
126
<g id="node16" class="node"><title>fake_libraryfilealias_182</title>
 
127
<ellipse cx="345" cy="1132" rx="29" ry="18" style="fill:none;stroke:red;"/>
 
128
<text text-anchor="middle" style="font-size:6.00;" x="345" y="1134">libraryfilealias</text>
 
129
</g>
 
130
<g id="edge14" class="edge"><title>person&#45;&gt;fake_libraryfilealias_182</title>
 
131
<path style="fill:none;stroke:black;" d="M363,968C358,1022 351,1073 348,1104"/>
 
132
<polygon style="fill:black;stroke:black;" points="351,1104 347,1114 345,1104 351,1104"/>
133
133
</g>
134
134
<g id="node2" class="node"><title>poll</title>
135
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="208,432 208,294 372,294 372,432 208,432"/>
136
 
<polygon style="fill:white;stroke:white;" points="211,309 211,297 369,297 369,309 211,309"/>
137
 
<text text-anchor="middle" style="font-size:6.00;" x="290" y="305">poll</text>
138
 
<polygon style="fill:none;stroke:black;" points="211,309 211,297 369,297 369,309 211,309"/>
139
 
<text text-anchor="middle" style="font-size:6.00;" x="216" y="318">id</text>
140
 
<text text-anchor="middle" style="font-size:6.00;" x="257" y="318">serial</text>
141
 
<text text-anchor="middle" style="font-size:6.00;" x="306" y="318"> PRIMARY KEY </text>
142
 
<text text-anchor="middle" style="font-size:6.00;" x="220" y="330">team</text>
143
 
<text text-anchor="middle" style="font-size:6.00;" x="259" y="330">integer</text>
144
 
<text text-anchor="middle" style="font-size:6.00;" x="325" y="330"> REFERENCES person UNIQUE </text>
145
 
<text text-anchor="middle" style="font-size:6.00;" x="221" y="342">name</text>
146
 
<text text-anchor="middle" style="font-size:6.00;" x="256" y="342">text</text>
147
 
<text text-anchor="middle" style="font-size:6.00;" x="297" y="342"> UNIQUE </text>
148
 
<text text-anchor="middle" style="font-size:6.00;" x="219" y="354">title</text>
149
 
<text text-anchor="middle" style="font-size:6.00;" x="256" y="354">text</text>
150
 
<text text-anchor="middle" style="font-size:6.00;" x="226" y="366">dateopens</text>
151
 
<text text-anchor="middle" style="font-size:6.00;" x="264" y="366">timestamp</text>
152
 
<text text-anchor="middle" style="font-size:6.00;" x="227" y="378">datecloses</text>
153
 
<text text-anchor="middle" style="font-size:6.00;" x="264" y="378">timestamp</text>
154
 
<text text-anchor="middle" style="font-size:6.00;" x="228" y="390">proposition</text>
155
 
<text text-anchor="middle" style="font-size:6.00;" x="256" y="390">text</text>
156
 
<text text-anchor="middle" style="font-size:6.00;" x="219" y="402">type</text>
157
 
<text text-anchor="middle" style="font-size:6.00;" x="259" y="402">integer</text>
158
 
<text text-anchor="middle" style="font-size:6.00;" x="227" y="414">allowspoilt</text>
159
 
<text text-anchor="middle" style="font-size:6.00;" x="261" y="414">boolean</text>
160
 
<text text-anchor="middle" style="font-size:6.00;" x="223" y="426">secrecy</text>
161
 
<text text-anchor="middle" style="font-size:6.00;" x="259" y="426">integer</text>
162
 
<polygon style="fill:none;stroke:black;" points="208,432 208,294 372,294 372,432 208,432"/>
 
135
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="192,424 192,286 356,286 356,424 192,424"/>
 
136
<polygon style="fill:white;stroke:white;" points="195,301 195,289 353,289 353,301 195,301"/>
 
137
<text text-anchor="middle" style="font-size:6.00;" x="274" y="297">poll</text>
 
138
<polygon style="fill:none;stroke:black;" points="195,301 195,289 353,289 353,301 195,301"/>
 
139
<text text-anchor="middle" style="font-size:6.00;" x="200" y="310">id</text>
 
140
<text text-anchor="middle" style="font-size:6.00;" x="241" y="310">serial</text>
 
141
<text text-anchor="middle" style="font-size:6.00;" x="290" y="310"> PRIMARY KEY </text>
 
142
<text text-anchor="middle" style="font-size:6.00;" x="204" y="322">team</text>
 
143
<text text-anchor="middle" style="font-size:6.00;" x="243" y="322">integer</text>
 
144
<text text-anchor="middle" style="font-size:6.00;" x="309" y="322"> REFERENCES person UNIQUE </text>
 
145
<text text-anchor="middle" style="font-size:6.00;" x="205" y="334">name</text>
 
146
<text text-anchor="middle" style="font-size:6.00;" x="240" y="334">text</text>
 
147
<text text-anchor="middle" style="font-size:6.00;" x="281" y="334"> UNIQUE </text>
 
148
<text text-anchor="middle" style="font-size:6.00;" x="203" y="346">title</text>
 
149
<text text-anchor="middle" style="font-size:6.00;" x="240" y="346">text</text>
 
150
<text text-anchor="middle" style="font-size:6.00;" x="210" y="358">dateopens</text>
 
151
<text text-anchor="middle" style="font-size:6.00;" x="248" y="358">timestamp</text>
 
152
<text text-anchor="middle" style="font-size:6.00;" x="211" y="370">datecloses</text>
 
153
<text text-anchor="middle" style="font-size:6.00;" x="248" y="370">timestamp</text>
 
154
<text text-anchor="middle" style="font-size:6.00;" x="212" y="382">proposition</text>
 
155
<text text-anchor="middle" style="font-size:6.00;" x="240" y="382">text</text>
 
156
<text text-anchor="middle" style="font-size:6.00;" x="203" y="394">type</text>
 
157
<text text-anchor="middle" style="font-size:6.00;" x="243" y="394">integer</text>
 
158
<text text-anchor="middle" style="font-size:6.00;" x="211" y="406">allowspoilt</text>
 
159
<text text-anchor="middle" style="font-size:6.00;" x="245" y="406">boolean</text>
 
160
<text text-anchor="middle" style="font-size:6.00;" x="207" y="418">secrecy</text>
 
161
<text text-anchor="middle" style="font-size:6.00;" x="243" y="418">integer</text>
 
162
<polygon style="fill:none;stroke:black;" points="192,424 192,286 356,286 356,424 192,424"/>
163
163
</g>
164
164
<g id="edge16" class="edge"><title>poll&#45;&gt;person</title>
165
 
<path style="fill:none;stroke:black;" d="M306,436C315,479 328,536 341,592"/>
166
 
<polygon style="fill:black;stroke:black;" points="344,592 343,602 338,593 344,592"/>
 
165
<path style="fill:none;stroke:black;" d="M293,428C304,471 318,528 333,584"/>
 
166
<polygon style="fill:black;stroke:black;" points="336,584 335,594 330,585 336,584"/>
167
167
</g>
168
168
<g id="node3" class="node"><title>polloption</title>
169
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="259,99 259,21 455,21 455,99 259,99"/>
170
 
<polygon style="fill:white;stroke:white;" points="262,36 262,24 452,24 452,36 262,36"/>
171
 
<text text-anchor="middle" style="font-size:6.00;" x="357" y="32">polloption</text>
172
 
<polygon style="fill:none;stroke:black;" points="262,36 262,24 452,24 452,36 262,36"/>
173
 
<text text-anchor="middle" style="font-size:6.00;" x="267" y="45">id</text>
174
 
<text text-anchor="middle" style="font-size:6.00;" x="304" y="45">serial</text>
175
 
<text text-anchor="middle" style="font-size:6.00;" x="359" y="45"> PRIMARY KEY UNIQUE </text>
176
 
<text text-anchor="middle" style="font-size:6.00;" x="270" y="57">poll</text>
177
 
<text text-anchor="middle" style="font-size:6.00;" x="306" y="57">integer</text>
178
 
<text text-anchor="middle" style="font-size:6.00;" x="387" y="57"> REFERENCES poll UNIQUE UNIQUE UNIQUE </text>
179
 
<text text-anchor="middle" style="font-size:6.00;" x="272" y="69">name</text>
180
 
<text text-anchor="middle" style="font-size:6.00;" x="303" y="69">text</text>
181
 
<text text-anchor="middle" style="font-size:6.00;" x="338" y="69"> UNIQUE </text>
182
 
<text text-anchor="middle" style="font-size:6.00;" x="277" y="81">shortname</text>
183
 
<text text-anchor="middle" style="font-size:6.00;" x="303" y="81">text</text>
184
 
<text text-anchor="middle" style="font-size:6.00;" x="338" y="81"> UNIQUE </text>
185
 
<text text-anchor="middle" style="font-size:6.00;" x="272" y="93">active</text>
186
 
<text text-anchor="middle" style="font-size:6.00;" x="308" y="93">boolean</text>
187
 
<polygon style="fill:none;stroke:black;" points="259,99 259,21 455,21 455,99 259,99"/>
 
169
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="248,99 248,21 434,21 434,99 248,99"/>
 
170
<polygon style="fill:white;stroke:white;" points="251,36 251,24 431,24 431,36 251,36"/>
 
171
<text text-anchor="middle" style="font-size:6.00;" x="341" y="32">polloption</text>
 
172
<polygon style="fill:none;stroke:black;" points="251,36 251,24 431,24 431,36 251,36"/>
 
173
<text text-anchor="middle" style="font-size:6.00;" x="256" y="45">id</text>
 
174
<text text-anchor="middle" style="font-size:6.00;" x="283" y="45">serial</text>
 
175
<text text-anchor="middle" style="font-size:6.00;" x="338" y="45"> PRIMARY KEY UNIQUE </text>
 
176
<text text-anchor="middle" style="font-size:6.00;" x="259" y="57">poll</text>
 
177
<text text-anchor="middle" style="font-size:6.00;" x="285" y="57">integer</text>
 
178
<text text-anchor="middle" style="font-size:6.00;" x="366" y="57"> REFERENCES poll UNIQUE UNIQUE UNIQUE </text>
 
179
<text text-anchor="middle" style="font-size:6.00;" x="261" y="69">name</text>
 
180
<text text-anchor="middle" style="font-size:6.00;" x="282" y="69">text</text>
 
181
<text text-anchor="middle" style="font-size:6.00;" x="317" y="69"> UNIQUE </text>
 
182
<text text-anchor="middle" style="font-size:6.00;" x="259" y="81">title</text>
 
183
<text text-anchor="middle" style="font-size:6.00;" x="282" y="81">text</text>
 
184
<text text-anchor="middle" style="font-size:6.00;" x="317" y="81"> UNIQUE </text>
 
185
<text text-anchor="middle" style="font-size:6.00;" x="261" y="93">active</text>
 
186
<text text-anchor="middle" style="font-size:6.00;" x="287" y="93">boolean</text>
 
187
<polygon style="fill:none;stroke:black;" points="248,99 248,21 434,21 434,99 248,99"/>
188
188
</g>
189
189
<g id="edge18" class="edge"><title>polloption&#45;&gt;poll</title>
190
 
<path style="fill:none;stroke:black;" d="M347,103C338,149 321,222 308,280"/>
191
 
<polygon style="fill:black;stroke:black;" points="311,281 306,290 305,280 311,281"/>
 
190
<path style="fill:none;stroke:black;" d="M331,103C322,147 306,217 293,272"/>
 
191
<polygon style="fill:black;stroke:black;" points="296,273 291,282 290,272 296,273"/>
192
192
</g>
193
193
<g id="node4" class="node"><title>vote</title>
194
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="405,371 405,281 591,281 591,371 405,371"/>
195
 
<polygon style="fill:white;stroke:white;" points="408,296 408,284 588,284 588,296 408,296"/>
196
 
<text text-anchor="middle" style="font-size:6.00;" x="498" y="292">vote</text>
197
 
<polygon style="fill:none;stroke:black;" points="408,296 408,284 588,284 588,296 408,296"/>
198
 
<text text-anchor="middle" style="font-size:6.00;" x="413" y="305">id</text>
199
 
<text text-anchor="middle" style="font-size:6.00;" x="450" y="305">serial</text>
200
 
<text text-anchor="middle" style="font-size:6.00;" x="490" y="305"> PRIMARY KEY </text>
201
 
<text text-anchor="middle" style="font-size:6.00;" x="419" y="317">person</text>
202
 
<text text-anchor="middle" style="font-size:6.00;" x="452" y="317">integer</text>
203
 
<text text-anchor="middle" style="font-size:6.00;" x="497" y="317"> REFERENCES person </text>
204
 
<text text-anchor="middle" style="font-size:6.00;" x="416" y="329">poll</text>
205
 
<text text-anchor="middle" style="font-size:6.00;" x="452" y="329">integer</text>
206
 
<text text-anchor="middle" style="font-size:6.00;" x="527" y="329"> REFERENCES poll REFERENCES polloption </text>
207
 
<text text-anchor="middle" style="font-size:6.00;" x="424" y="341">preference</text>
208
 
<text text-anchor="middle" style="font-size:6.00;" x="452" y="341">integer</text>
209
 
<text text-anchor="middle" style="font-size:6.00;" x="419" y="353">option</text>
210
 
<text text-anchor="middle" style="font-size:6.00;" x="452" y="353">integer</text>
211
 
<text text-anchor="middle" style="font-size:6.00;" x="502" y="353"> REFERENCES polloption </text>
212
 
<text text-anchor="middle" style="font-size:6.00;" x="418" y="365">token</text>
213
 
<text text-anchor="middle" style="font-size:6.00;" x="449" y="365">text</text>
214
 
<polygon style="fill:none;stroke:black;" points="405,371 405,281 591,281 591,371 405,371"/>
 
194
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="389,363 389,273 575,273 575,363 389,363"/>
 
195
<polygon style="fill:white;stroke:white;" points="392,288 392,276 572,276 572,288 392,288"/>
 
196
<text text-anchor="middle" style="font-size:6.00;" x="482" y="284">vote</text>
 
197
<polygon style="fill:none;stroke:black;" points="392,288 392,276 572,276 572,288 392,288"/>
 
198
<text text-anchor="middle" style="font-size:6.00;" x="397" y="297">id</text>
 
199
<text text-anchor="middle" style="font-size:6.00;" x="434" y="297">serial</text>
 
200
<text text-anchor="middle" style="font-size:6.00;" x="474" y="297"> PRIMARY KEY </text>
 
201
<text text-anchor="middle" style="font-size:6.00;" x="403" y="309">person</text>
 
202
<text text-anchor="middle" style="font-size:6.00;" x="436" y="309">integer</text>
 
203
<text text-anchor="middle" style="font-size:6.00;" x="481" y="309"> REFERENCES person </text>
 
204
<text text-anchor="middle" style="font-size:6.00;" x="400" y="321">poll</text>
 
205
<text text-anchor="middle" style="font-size:6.00;" x="436" y="321">integer</text>
 
206
<text text-anchor="middle" style="font-size:6.00;" x="511" y="321"> REFERENCES poll REFERENCES polloption </text>
 
207
<text text-anchor="middle" style="font-size:6.00;" x="408" y="333">preference</text>
 
208
<text text-anchor="middle" style="font-size:6.00;" x="436" y="333">integer</text>
 
209
<text text-anchor="middle" style="font-size:6.00;" x="403" y="345">option</text>
 
210
<text text-anchor="middle" style="font-size:6.00;" x="436" y="345">integer</text>
 
211
<text text-anchor="middle" style="font-size:6.00;" x="486" y="345"> REFERENCES polloption </text>
 
212
<text text-anchor="middle" style="font-size:6.00;" x="402" y="357">token</text>
 
213
<text text-anchor="middle" style="font-size:6.00;" x="433" y="357">text</text>
 
214
<polygon style="fill:none;stroke:black;" points="389,363 389,273 575,273 575,363 389,363"/>
215
215
</g>
216
216
<g id="edge20" class="edge"><title>vote&#45;&gt;person</title>
217
 
<path style="fill:none;stroke:black;" d="M486,375C474,427 453,512 433,592"/>
218
 
<polygon style="fill:black;stroke:black;" points="436,593 431,602 430,592 436,593"/>
 
217
<path style="fill:none;stroke:black;" d="M471,367C460,419 442,504 425,584"/>
 
218
<polygon style="fill:black;stroke:black;" points="428,585 423,594 422,584 428,585"/>
219
219
</g>
220
220
<g id="edge22" class="edge"><title>vote&#45;&gt;poll</title>
221
 
<path style="fill:none;stroke:black;" d="M397,344C395,344 392,345 390,345"/>
222
 
<polygon style="fill:black;stroke:black;" points="390,348 380,347 389,342 390,348"/>
 
221
<path style="fill:none;stroke:black;" d="M381,336C379,336 376,337 374,337"/>
 
222
<polygon style="fill:black;stroke:black;" points="374,340 364,339 373,334 374,340"/>
223
223
</g>
224
224
<g id="edge24" class="edge"><title>vote&#45;&gt;polloption</title>
225
 
<path style="fill:none;stroke:black;" d="M472,277C447,230 410,160 385,112"/>
226
 
<polygon style="fill:black;stroke:black;" points="382,113 380,103 388,110 382,113"/>
 
225
<path style="fill:none;stroke:black;" d="M455,269C431,224 395,158 370,112"/>
 
226
<polygon style="fill:black;stroke:black;" points="367,113 365,103 373,110 367,113"/>
227
227
</g>
228
228
<g id="node5" class="node"><title>votecast</title>
229
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="508,487 508,433 650,433 650,487 508,487"/>
230
 
<polygon style="fill:white;stroke:white;" points="511,448 511,436 647,436 647,448 511,448"/>
231
 
<text text-anchor="middle" style="font-size:6.00;" x="579" y="444">votecast</text>
232
 
<polygon style="fill:none;stroke:black;" points="511,448 511,436 647,436 647,448 511,448"/>
233
 
<text text-anchor="middle" style="font-size:6.00;" x="516" y="457">id</text>
234
 
<text text-anchor="middle" style="font-size:6.00;" x="544" y="457">serial</text>
235
 
<text text-anchor="middle" style="font-size:6.00;" x="584" y="457"> PRIMARY KEY </text>
236
 
<text text-anchor="middle" style="font-size:6.00;" x="522" y="469">person</text>
237
 
<text text-anchor="middle" style="font-size:6.00;" x="546" y="469">integer</text>
238
 
<text text-anchor="middle" style="font-size:6.00;" x="603" y="469"> REFERENCES person UNIQUE </text>
239
 
<text text-anchor="middle" style="font-size:6.00;" x="519" y="481">poll</text>
240
 
<text text-anchor="middle" style="font-size:6.00;" x="546" y="481">integer</text>
241
 
<text text-anchor="middle" style="font-size:6.00;" x="600" y="481"> UNIQUE REFERENCES poll </text>
242
 
<polygon style="fill:none;stroke:black;" points="508,487 508,433 650,433 650,487 508,487"/>
 
229
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="490,481 490,427 632,427 632,481 490,481"/>
 
230
<polygon style="fill:white;stroke:white;" points="493,442 493,430 629,430 629,442 493,442"/>
 
231
<text text-anchor="middle" style="font-size:6.00;" x="561" y="438">votecast</text>
 
232
<polygon style="fill:none;stroke:black;" points="493,442 493,430 629,430 629,442 493,442"/>
 
233
<text text-anchor="middle" style="font-size:6.00;" x="498" y="451">id</text>
 
234
<text text-anchor="middle" style="font-size:6.00;" x="526" y="451">serial</text>
 
235
<text text-anchor="middle" style="font-size:6.00;" x="566" y="451"> PRIMARY KEY </text>
 
236
<text text-anchor="middle" style="font-size:6.00;" x="504" y="463">person</text>
 
237
<text text-anchor="middle" style="font-size:6.00;" x="528" y="463">integer</text>
 
238
<text text-anchor="middle" style="font-size:6.00;" x="585" y="463"> REFERENCES person UNIQUE </text>
 
239
<text text-anchor="middle" style="font-size:6.00;" x="501" y="475">poll</text>
 
240
<text text-anchor="middle" style="font-size:6.00;" x="528" y="475">integer</text>
 
241
<text text-anchor="middle" style="font-size:6.00;" x="582" y="475"> UNIQUE REFERENCES poll </text>
 
242
<polygon style="fill:none;stroke:black;" points="490,481 490,427 632,427 632,481 490,481"/>
243
243
</g>
244
244
<g id="edge26" class="edge"><title>votecast&#45;&gt;person</title>
245
 
<path style="fill:none;stroke:black;" d="M561,491C546,516 523,554 499,595"/>
246
 
<polygon style="fill:black;stroke:black;" points="502,597 494,604 496,594 502,597"/>
 
245
<path style="fill:none;stroke:black;" d="M544,485C531,509 511,546 490,585"/>
 
246
<polygon style="fill:black;stroke:black;" points="493,587 485,594 487,584 493,587"/>
247
247
</g>
248
248
<g id="edge28" class="edge"><title>votecast&#45;&gt;poll</title>
249
 
<path style="fill:none;stroke:black;" d="M500,433C466,422 425,408 389,396"/>
250
 
<polygon style="fill:black;stroke:black;" points="388,399 380,393 391,393 388,399"/>
 
249
<path style="fill:none;stroke:black;" d="M482,427C448,415 409,402 374,389"/>
 
250
<polygon style="fill:black;stroke:black;" points="373,392 364,386 375,386 373,392"/>
251
251
</g>
252
252
</g>
253
253
</svg>