|
1681.1.57
by Stuart Bishop
Update database diagrams |
1 |
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
|
2 |
<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.0//EN"
|
|
3 |
"http://www.w3.org/TR/2001/REC-SVG-20010904/DTD/svg10.dtd">
|
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
4 |
<!-- Generated by fdp version 2.2.1 (Thu Apr 6 00:32:47 UTC 2006)
|
|
1681.1.57
by Stuart Bishop
Update database diagrams |
5 |
For user: (stub) Stuart Bishop,,, Title: g Pages: 1 -->
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
6 |
<svg width="955px" height="749px" |
7 |
viewBox = "-1 -1 954 748" |
|
|
1681.1.57
by Stuart Bishop
Update database diagrams |
8 |
xmlns="http://www.w3.org/2000/svg"> |
|
3322.1.13
by Stuart Bishop
Update database diagrams |
9 |
<g id="graph0" class="graph" style="font-family:Times-Roman;font-size:14.00;"> |
|
1681.1.57
by Stuart Bishop
Update database diagrams |
10 |
<title>g</title> |
|
3691.17.2
by Stuart Bishop
Update database diagrams |
11 |
<text text-anchor="middle" style="font-size:22.00;" x="476" y="731">Voting</text> |
|
1681.1.57
by Stuart Bishop
Update database diagrams |
12 |
<g id="node1" class="node"><title>person</title> |
|
3691.17.2
by Stuart Bishop
Update database diagrams |
13 |
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="509,591 509,193 767,193 767,591 509,591"/> |
14 |
<polygon style="fill:white;stroke:white;" points="512,210 512,196 764,196 764,210 512,210"/> |
|
15 |
<text text-anchor="middle" style="font-size:8.00;" x="638" y="206">person</text> |
|
16 |
<polygon style="fill:none;stroke:black;" points="512,210 512,196 764,196 764,210 512,210"/> |
|
17 |
<text text-anchor="middle" style="font-size:8.00;" x="518" y="221">id</text> |
|
18 |
<text text-anchor="middle" style="font-size:8.00;" x="613" y="221">serial</text> |
|
19 |
<text text-anchor="middle" style="font-size:8.00;" x="675" y="221"> PRIMARY KEY </text> |
|
20 |
<text text-anchor="middle" style="font-size:8.00;" x="535" y="235">displayname</text> |
|
21 |
<text text-anchor="middle" style="font-size:8.00;" x="611" y="235">text</text> |
|
22 |
<text text-anchor="middle" style="font-size:8.00;" x="530" y="249">password</text> |
|
23 |
<text text-anchor="middle" style="font-size:8.00;" x="611" y="249">text</text> |
|
24 |
<text text-anchor="middle" style="font-size:8.00;" x="533" y="263">teamowner</text> |
|
25 |
<text text-anchor="middle" style="font-size:8.00;" x="616" y="263">integer</text> |
|
26 |
<text text-anchor="middle" style="font-size:8.00;" x="685" y="263"> REFERENCES person </text> |
|
27 |
<text text-anchor="middle" style="font-size:8.00;" x="541" y="277">teamdescription</text> |
|
28 |
<text text-anchor="middle" style="font-size:8.00;" x="611" y="277">text</text> |
|
29 |
<text text-anchor="middle" style="font-size:8.00;" x="524" y="291">name</text> |
|
30 |
<text text-anchor="middle" style="font-size:8.00;" x="611" y="291">text</text> |
|
31 |
<text text-anchor="middle" style="font-size:8.00;" x="530" y="305">language</text> |
|
32 |
<text text-anchor="middle" style="font-size:8.00;" x="616" y="305">integer</text> |
|
33 |
<text text-anchor="middle" style="font-size:8.00;" x="689" y="305"> REFERENCES language </text> |
|
34 |
<text text-anchor="middle" style="font-size:8.00;" x="519" y="319">fti</text> |
|
35 |
<text text-anchor="middle" style="font-size:8.00;" x="618" y="319">tsvector</text> |
|
36 |
<text text-anchor="middle" style="font-size:8.00;" x="556" y="333">defaultmembershipperiod</text> |
|
37 |
<text text-anchor="middle" style="font-size:8.00;" x="616" y="333">integer</text> |
|
38 |
<text text-anchor="middle" style="font-size:8.00;" x="549" y="347">defaultrenewalperiod</text> |
|
39 |
<text text-anchor="middle" style="font-size:8.00;" x="616" y="347">integer</text> |
|
40 |
<text text-anchor="middle" style="font-size:8.00;" x="544" y="361">subscriptionpolicy</text> |
|
41 |
<text text-anchor="middle" style="font-size:8.00;" x="616" y="361">integer</text> |
|
42 |
<text text-anchor="middle" style="font-size:8.00;" x="527" y="375">merged</text> |
|
43 |
<text text-anchor="middle" style="font-size:8.00;" x="616" y="375">integer</text> |
|
44 |
<text text-anchor="middle" style="font-size:8.00;" x="685" y="375"> REFERENCES person </text> |
|
45 |
<text text-anchor="middle" style="font-size:8.00;" x="533" y="389">datecreated</text> |
|
46 |
<text text-anchor="middle" style="font-size:8.00;" x="622" y="389">timestamp</text> |
|
47 |
<text text-anchor="middle" style="font-size:8.00;" x="528" y="403">calendar</text> |
|
48 |
<text text-anchor="middle" style="font-size:8.00;" x="616" y="403">integer</text> |
|
49 |
<text text-anchor="middle" style="font-size:8.00;" x="704" y="403"> REFERENCES calendar UNIQUE </text> |
|
50 |
<text text-anchor="middle" style="font-size:8.00;" x="530" y="417">timezone</text> |
|
51 |
<text text-anchor="middle" style="font-size:8.00;" x="611" y="417">text</text> |
|
52 |
<text text-anchor="middle" style="font-size:8.00;" x="535" y="431">addressline1</text> |
|
53 |
<text text-anchor="middle" style="font-size:8.00;" x="611" y="431">text</text> |
|
54 |
<text text-anchor="middle" style="font-size:8.00;" x="535" y="445">addressline2</text> |
|
55 |
<text text-anchor="middle" style="font-size:8.00;" x="611" y="445">text</text> |
|
56 |
<text text-anchor="middle" style="font-size:8.00;" x="535" y="459">organization</text> |
|
57 |
<text text-anchor="middle" style="font-size:8.00;" x="611" y="459">text</text> |
|
58 |
<text text-anchor="middle" style="font-size:8.00;" x="521" y="473">city</text> |
|
59 |
<text text-anchor="middle" style="font-size:8.00;" x="611" y="473">text</text> |
|
60 |
<text text-anchor="middle" style="font-size:8.00;" x="529" y="487">province</text> |
|
61 |
<text text-anchor="middle" style="font-size:8.00;" x="611" y="487">text</text> |
|
62 |
<text text-anchor="middle" style="font-size:8.00;" x="527" y="501">country</text> |
|
63 |
<text text-anchor="middle" style="font-size:8.00;" x="616" y="501">integer</text> |
|
64 |
<text text-anchor="middle" style="font-size:8.00;" x="686" y="501"> REFERENCES country </text> |
|
65 |
<text text-anchor="middle" style="font-size:8.00;" x="529" y="515">postcode</text> |
|
66 |
<text text-anchor="middle" style="font-size:8.00;" x="611" y="515">text</text> |
|
67 |
<text text-anchor="middle" style="font-size:8.00;" x="525" y="529">phone</text> |
|
68 |
<text text-anchor="middle" style="font-size:8.00;" x="611" y="529">text</text> |
|
69 |
<text text-anchor="middle" style="font-size:8.00;" x="546" y="543">homepage_content</text> |
|
70 |
<text text-anchor="middle" style="font-size:8.00;" x="611" y="543">text</text> |
|
71 |
<text text-anchor="middle" style="font-size:8.00;" x="528" y="557">emblem</text> |
|
72 |
<text text-anchor="middle" style="font-size:8.00;" x="616" y="557">integer</text> |
|
73 |
<text text-anchor="middle" style="font-size:8.00;" x="697" y="557"> REFERENCES libraryfilealias </text> |
|
74 |
<text text-anchor="middle" style="font-size:8.00;" x="536" y="571">hackergotchi</text> |
|
75 |
<text text-anchor="middle" style="font-size:8.00;" x="616" y="571">integer</text> |
|
76 |
<text text-anchor="middle" style="font-size:8.00;" x="697" y="571"> REFERENCES libraryfilealias </text> |
|
77 |
<text text-anchor="middle" style="font-size:8.00;" x="550" y="585">hide_email_addresses</text> |
|
78 |
<text text-anchor="middle" style="font-size:8.00;" x="618" y="585">boolean</text> |
|
79 |
<polygon style="fill:none;stroke:black;" points="509,591 509,193 767,193 767,591 509,591"/> |
|
|
1681.1.57
by Stuart Bishop
Update database diagrams |
80 |
</g>
|
81 |
<g id="edge2" class="edge"><title>person->person</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
82 |
<path style="fill:none;stroke:black;" d="M775,450C786,437 793,418 793,392 793,371 788,355 781,342"/> |
83 |
<polygon style="fill:black;stroke:black;" points="778,344 775,334 784,340 778,344"/> |
|
|
1681.1.57
by Stuart Bishop
Update database diagrams |
84 |
</g>
|
85 |
<g id="edge6" class="edge"><title>person->person</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
86 |
<path style="fill:none;stroke:black;" d="M775,530C797,510 811,463 811,392 811,329 800,285 782,262"/> |
87 |
<polygon style="fill:black;stroke:black;" points="779,264 775,254 784,259 779,264"/> |
|
88 |
</g>
|
|
89 |
<g id="node7" class="node"><title>fake_language_201</title> |
|
90 |
<ellipse cx="482" cy="656" rx="27" ry="18" style="fill:none;stroke:red;"/> |
|
91 |
<text text-anchor="middle" style="font-size:8.00;" x="482" y="659">language</text> |
|
92 |
</g>
|
|
93 |
<g id="edge4" class="edge"><title>person->fake_language_201</title> |
|
94 |
<path style="fill:none;stroke:black;" d="M518,595C510,608 503,620 497,630"/> |
|
95 |
<polygon style="fill:black;stroke:black;" points="500,632 492,639 494,629 500,632"/> |
|
96 |
</g>
|
|
97 |
<g id="node10" class="node"><title>fake_calendar_204</title> |
|
98 |
<ellipse cx="712" cy="688" rx="27" ry="18" style="fill:none;stroke:red;"/> |
|
99 |
<text text-anchor="middle" style="font-size:8.00;" x="712" y="691">calendar</text> |
|
100 |
</g>
|
|
101 |
<g id="edge8" class="edge"><title>person->fake_calendar_204</title> |
|
102 |
<path style="fill:none;stroke:black;" d="M689,595C696,620 701,643 705,660"/> |
|
103 |
<polygon style="fill:black;stroke:black;" points="708,659 708,670 702,661 708,659"/> |
|
104 |
</g>
|
|
105 |
<g id="node12" class="node"><title>fake_country_206</title> |
|
106 |
<ellipse cx="830" cy="148" rx="27" ry="18" style="fill:none;stroke:red;"/> |
|
107 |
<text text-anchor="middle" style="font-size:8.00;" x="830" y="151">country</text> |
|
108 |
</g>
|
|
109 |
<g id="edge10" class="edge"><title>person->fake_country_206</title> |
|
110 |
<path style="fill:none;stroke:black;" d="M775,218C789,200 801,184 811,172"/> |
|
111 |
<polygon style="fill:black;stroke:black;" points="808,170 817,164 814,174 808,170"/> |
|
112 |
</g>
|
|
113 |
<g id="node14" class="node"><title>fake_libraryfilealias_208</title> |
|
114 |
<ellipse cx="912" cy="548" rx="35" ry="18" style="fill:none;stroke:red;"/> |
|
115 |
<text text-anchor="middle" style="font-size:8.00;" x="912" y="551">libraryfilealias</text> |
|
116 |
</g>
|
|
117 |
<g id="edge12" class="edge"><title>person->fake_libraryfilealias_208</title> |
|
118 |
<path style="fill:none;stroke:black;" d="M775,470C814,492 853,515 879,529"/> |
|
119 |
<polygon style="fill:black;stroke:black;" points="881,526 888,534 878,532 881,526"/> |
|
120 |
</g>
|
|
121 |
<g id="node16" class="node"><title>fake_libraryfilealias_210</title> |
|
122 |
<ellipse cx="826" cy="367" rx="35" ry="18" style="fill:none;stroke:red;"/> |
|
123 |
<text text-anchor="middle" style="font-size:8.00;" x="826" y="370">libraryfilealias</text> |
|
124 |
</g>
|
|
125 |
<g id="edge14" class="edge"><title>person->fake_libraryfilealias_210</title> |
|
126 |
<path style="fill:none;stroke:black;" d="M775,374C777,374 780,373 782,373"/> |
|
127 |
<polygon style="fill:black;stroke:black;" points="782,370 792,372 782,376 782,370"/> |
|
|
1681.1.57
by Stuart Bishop
Update database diagrams |
128 |
</g>
|
129 |
<g id="node2" class="node"><title>poll</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
130 |
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="270,298 270,138 476,138 476,298 270,298"/> |
131 |
<polygon style="fill:white;stroke:white;" points="273,155 273,141 473,141 473,155 273,155"/> |
|
132 |
<text text-anchor="middle" style="font-size:8.00;" x="373" y="151">poll</text> |
|
133 |
<polygon style="fill:none;stroke:black;" points="273,155 273,141 473,141 473,155 273,155"/> |
|
134 |
<text text-anchor="middle" style="font-size:8.00;" x="279" y="166">id</text> |
|
135 |
<text text-anchor="middle" style="font-size:8.00;" x="328" y="166">serial</text> |
|
136 |
<text text-anchor="middle" style="font-size:8.00;" x="390" y="166"> PRIMARY KEY </text> |
|
137 |
<text text-anchor="middle" style="font-size:8.00;" x="284" y="180">team</text> |
|
138 |
<text text-anchor="middle" style="font-size:8.00;" x="331" y="180">integer</text> |
|
139 |
<text text-anchor="middle" style="font-size:8.00;" x="416" y="180"> REFERENCES person UNIQUE </text> |
|
140 |
<text text-anchor="middle" style="font-size:8.00;" x="285" y="194">name</text> |
|
141 |
<text text-anchor="middle" style="font-size:8.00;" x="326" y="194">text</text> |
|
142 |
<text text-anchor="middle" style="font-size:8.00;" x="378" y="194"> UNIQUE </text> |
|
143 |
<text text-anchor="middle" style="font-size:8.00;" x="282" y="208">title</text> |
|
144 |
<text text-anchor="middle" style="font-size:8.00;" x="326" y="208">text</text> |
|
145 |
<text text-anchor="middle" style="font-size:8.00;" x="292" y="222">dateopens</text> |
|
146 |
<text text-anchor="middle" style="font-size:8.00;" x="337" y="222">timestamp</text> |
|
147 |
<text text-anchor="middle" style="font-size:8.00;" x="292" y="236">datecloses</text> |
|
148 |
<text text-anchor="middle" style="font-size:8.00;" x="337" y="236">timestamp</text> |
|
149 |
<text text-anchor="middle" style="font-size:8.00;" x="294" y="250">proposition</text> |
|
150 |
<text text-anchor="middle" style="font-size:8.00;" x="326" y="250">text</text> |
|
151 |
<text text-anchor="middle" style="font-size:8.00;" x="283" y="264">type</text> |
|
152 |
<text text-anchor="middle" style="font-size:8.00;" x="331" y="264">integer</text> |
|
153 |
<text text-anchor="middle" style="font-size:8.00;" x="293" y="278">allowspoilt</text> |
|
154 |
<text text-anchor="middle" style="font-size:8.00;" x="333" y="278">boolean</text> |
|
155 |
<text text-anchor="middle" style="font-size:8.00;" x="288" y="292">secrecy</text> |
|
156 |
<text text-anchor="middle" style="font-size:8.00;" x="331" y="292">integer</text> |
|
157 |
<polygon style="fill:none;stroke:black;" points="270,298 270,138 476,138 476,298 270,298"/> |
|
|
1681.1.57
by Stuart Bishop
Update database diagrams |
158 |
</g>
|
|
1681.1.131
by Stuart Bishop
Update diagrams |
159 |
<g id="edge16" class="edge"><title>poll->person</title> |
|
3691.17.2
by Stuart Bishop
Update database diagrams |
160 |
<path style="fill:none;stroke:black;" d="M484,291C487,293 490,295 493,296"/> |
161 |
<polygon style="fill:black;stroke:black;" points="495,293 501,302 491,299 495,293"/> |
|
|
1681.1.57
by Stuart Bishop
Update database diagrams |
162 |
</g>
|
163 |
<g id="node3" class="node"><title>polloption</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
164 |
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="14,137 14,47 218,47 218,137 14,137"/> |
165 |
<polygon style="fill:white;stroke:white;" points="17,64 17,50 215,50 215,64 17,64"/> |
|
166 |
<text text-anchor="middle" style="font-size:8.00;" x="116" y="60">polloption</text> |
|
167 |
<polygon style="fill:none;stroke:black;" points="17,64 17,50 215,50 215,64 17,64"/> |
|
168 |
<text text-anchor="middle" style="font-size:8.00;" x="23" y="75">id</text> |
|
169 |
<text text-anchor="middle" style="font-size:8.00;" x="54" y="75">serial</text> |
|
170 |
<text text-anchor="middle" style="font-size:8.00;" x="125" y="75"> PRIMARY KEY UNIQUE </text> |
|
171 |
<text text-anchor="middle" style="font-size:8.00;" x="26" y="89">poll</text> |
|
172 |
<text text-anchor="middle" style="font-size:8.00;" x="57" y="89">integer</text> |
|
173 |
<text text-anchor="middle" style="font-size:8.00;" x="146" y="89"> REFERENCES poll UNIQUE UNIQUE </text> |
|
174 |
<text text-anchor="middle" style="font-size:8.00;" x="29" y="103">name</text> |
|
175 |
<text text-anchor="middle" style="font-size:8.00;" x="52" y="103">text</text> |
|
176 |
<text text-anchor="middle" style="font-size:8.00;" x="96" y="103"> UNIQUE </text> |
|
177 |
<text text-anchor="middle" style="font-size:8.00;" x="26" y="117">title</text> |
|
178 |
<text text-anchor="middle" style="font-size:8.00;" x="52" y="117">text</text> |
|
179 |
<text text-anchor="middle" style="font-size:8.00;" x="29" y="131">active</text> |
|
180 |
<text text-anchor="middle" style="font-size:8.00;" x="59" y="131">boolean</text> |
|
181 |
<polygon style="fill:none;stroke:black;" points="14,137 14,47 218,47 218,137 14,137"/> |
|
|
1681.1.57
by Stuart Bishop
Update database diagrams |
182 |
</g>
|
|
1681.1.131
by Stuart Bishop
Update diagrams |
183 |
<g id="edge18" class="edge"><title>polloption->poll</title> |
|
3691.17.2
by Stuart Bishop
Update database diagrams |
184 |
<path style="fill:none;stroke:black;" d="M216,141C228,147 241,153 253,159"/> |
185 |
<polygon style="fill:black;stroke:black;" points="254,156 262,163 251,162 254,156"/> |
|
|
1681.1.57
by Stuart Bishop
Update database diagrams |
186 |
</g>
|
187 |
<g id="node4" class="node"><title>vote</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
188 |
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="263,113 263,9 503,9 503,113 263,113"/> |
189 |
<polygon style="fill:white;stroke:white;" points="266,26 266,12 500,12 500,26 266,26"/> |
|
190 |
<text text-anchor="middle" style="font-size:8.00;" x="383" y="22">vote</text> |
|
191 |
<polygon style="fill:none;stroke:black;" points="266,26 266,12 500,12 500,26 266,26"/> |
|
192 |
<text text-anchor="middle" style="font-size:8.00;" x="272" y="37">id</text> |
|
193 |
<text text-anchor="middle" style="font-size:8.00;" x="320" y="37">serial</text> |
|
194 |
<text text-anchor="middle" style="font-size:8.00;" x="371" y="37"> PRIMARY KEY </text> |
|
195 |
<text text-anchor="middle" style="font-size:8.00;" x="280" y="51">person</text> |
|
196 |
<text text-anchor="middle" style="font-size:8.00;" x="323" y="51">integer</text> |
|
197 |
<text text-anchor="middle" style="font-size:8.00;" x="381" y="51"> REFERENCES person </text> |
|
198 |
<text text-anchor="middle" style="font-size:8.00;" x="275" y="65">poll</text> |
|
199 |
<text text-anchor="middle" style="font-size:8.00;" x="323" y="65">integer</text> |
|
200 |
<text text-anchor="middle" style="font-size:8.00;" x="420" y="65"> REFERENCES poll REFERENCES polloption </text> |
|
201 |
<text text-anchor="middle" style="font-size:8.00;" x="286" y="79">preference</text> |
|
202 |
<text text-anchor="middle" style="font-size:8.00;" x="323" y="79">integer</text> |
|
203 |
<text text-anchor="middle" style="font-size:8.00;" x="279" y="93">option</text> |
|
204 |
<text text-anchor="middle" style="font-size:8.00;" x="323" y="93">integer</text> |
|
205 |
<text text-anchor="middle" style="font-size:8.00;" x="386" y="93"> REFERENCES polloption </text> |
|
206 |
<text text-anchor="middle" style="font-size:8.00;" x="278" y="107">token</text> |
|
207 |
<text text-anchor="middle" style="font-size:8.00;" x="318" y="107">text</text> |
|
208 |
<polygon style="fill:none;stroke:black;" points="263,113 263,9 503,9 503,113 263,113"/> |
|
|
1681.1.131
by Stuart Bishop
Update diagrams |
209 |
</g>
|
210 |
<g id="edge20" class="edge"><title>vote->person</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
211 |
<path style="fill:none;stroke:black;" d="M476,117C481,121 486,126 490,130 505,146 518,163 531,181"/> |
212 |
<polygon style="fill:black;stroke:black;" points="534,179 537,189 528,183 534,179"/> |
|
|
1681.1.131
by Stuart Bishop
Update diagrams |
213 |
</g>
|
214 |
<g id="edge22" class="edge"><title>vote->poll</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
215 |
<path style="fill:none;stroke:black;" d="M379,117C379,119 379,122 379,124"/> |
216 |
<polygon style="fill:black;stroke:black;" points="382,124 378,134 376,124 382,124"/> |
|
|
1681.1.131
by Stuart Bishop
Update diagrams |
217 |
</g>
|
218 |
<g id="edge24" class="edge"><title>vote->polloption</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
219 |
<path style="fill:none;stroke:black;" d="M255,76C248,77 242,77 236,78"/> |
220 |
<polygon style="fill:black;stroke:black;" points="236,81 226,79 236,75 236,81"/> |
|
|
1681.1.57
by Stuart Bishop
Update database diagrams |
221 |
</g>
|
222 |
<g id="node5" class="node"><title>votecast</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
223 |
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="296,384 296,322 476,322 476,384 296,384"/> |
224 |
<polygon style="fill:white;stroke:white;" points="299,339 299,325 473,325 473,339 299,339"/> |
|
225 |
<text text-anchor="middle" style="font-size:8.00;" x="386" y="335">votecast</text> |
|
226 |
<polygon style="fill:none;stroke:black;" points="299,339 299,325 473,325 473,339 299,339"/> |
|
227 |
<text text-anchor="middle" style="font-size:8.00;" x="305" y="350">id</text> |
|
228 |
<text text-anchor="middle" style="font-size:8.00;" x="339" y="350">serial</text> |
|
229 |
<text text-anchor="middle" style="font-size:8.00;" x="390" y="350"> PRIMARY KEY </text> |
|
230 |
<text text-anchor="middle" style="font-size:8.00;" x="313" y="364">person</text> |
|
231 |
<text text-anchor="middle" style="font-size:8.00;" x="342" y="364">integer</text> |
|
232 |
<text text-anchor="middle" style="font-size:8.00;" x="416" y="364"> REFERENCES person UNIQUE </text> |
|
233 |
<text text-anchor="middle" style="font-size:8.00;" x="308" y="378">poll</text> |
|
234 |
<text text-anchor="middle" style="font-size:8.00;" x="342" y="378">integer</text> |
|
235 |
<text text-anchor="middle" style="font-size:8.00;" x="411" y="378"> UNIQUE REFERENCES poll </text> |
|
236 |
<polygon style="fill:none;stroke:black;" points="296,384 296,322 476,322 476,384 296,384"/> |
|
|
1681.1.131
by Stuart Bishop
Update diagrams |
237 |
</g>
|
238 |
<g id="edge26" class="edge"><title>votecast->person</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
239 |
<path style="fill:none;stroke:black;" d="M484,368C486,368 489,369 491,369"/> |
240 |
<polygon style="fill:black;stroke:black;" points="492,366 501,371 491,372 492,366"/> |
|
|
1681.1.131
by Stuart Bishop
Update diagrams |
241 |
</g>
|
242 |
<g id="edge28" class="edge"><title>votecast->poll</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
243 |
<path style="fill:none;stroke:black;" d="M383,318C383,316 383,314 383,312"/> |
244 |
<polygon style="fill:black;stroke:black;" points="380,312 381,302 386,311 380,312"/> |
|
|
1681.1.57
by Stuart Bishop
Update database diagrams |
245 |
</g>
|
246 |
</g>
|
|
247 |
</svg>
|
