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