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
|
<?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="1065px" height="828px"
viewBox = "-1 -1 1064 827"
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="531" y="810">Ticketing</text>
<g id="node1" class="node"><title>ticket</title>
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="405,546 405,246 651,246 651,546 405,546"/>
<polygon style="fill:white;stroke:white;" points="408,263 408,249 648,249 648,263 408,263"/>
<text text-anchor="middle" style="font-size:8.00;" x="528" y="259">ticket</text>
<polygon style="fill:none;stroke:black;" points="408,263 408,249 648,249 648,263 408,263"/>
<text text-anchor="middle" style="font-size:8.00;" x="414" y="274">id</text>
<text text-anchor="middle" style="font-size:8.00;" x="491" y="274">serial</text>
<text text-anchor="middle" style="font-size:8.00;" x="553" y="274"> PRIMARY KEY </text>
<text text-anchor="middle" style="font-size:8.00;" x="421" y="288">owner</text>
<text text-anchor="middle" style="font-size:8.00;" x="494" y="288">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="563" y="288"> REFERENCES person </text>
<text text-anchor="middle" style="font-size:8.00;" x="417" y="302">title</text>
<text text-anchor="middle" style="font-size:8.00;" x="489" y="302">text</text>
<text text-anchor="middle" style="font-size:8.00;" x="428" y="316">description</text>
<text text-anchor="middle" style="font-size:8.00;" x="489" y="316">text</text>
<text text-anchor="middle" style="font-size:8.00;" x="424" y="330">assignee</text>
<text text-anchor="middle" style="font-size:8.00;" x="494" y="330">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="563" y="330"> REFERENCES person </text>
<text text-anchor="middle" style="font-size:8.00;" x="425" y="344">answerer</text>
<text text-anchor="middle" style="font-size:8.00;" x="494" y="344">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="563" y="344"> REFERENCES person </text>
<text text-anchor="middle" style="font-size:8.00;" x="423" y="358">product</text>
<text text-anchor="middle" style="font-size:8.00;" x="494" y="358">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="564" y="358"> REFERENCES product </text>
<text text-anchor="middle" style="font-size:8.00;" x="429" y="372">distribution</text>
<text text-anchor="middle" style="font-size:8.00;" x="494" y="372">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="570" y="372"> REFERENCES distribution </text>
<text text-anchor="middle" style="font-size:8.00;" x="443" y="386">sourcepackagename</text>
<text text-anchor="middle" style="font-size:8.00;" x="494" y="386">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="585" y="386"> REFERENCES sourcepackagename </text>
<text text-anchor="middle" style="font-size:8.00;" x="420" y="400">status</text>
<text text-anchor="middle" style="font-size:8.00;" x="494" y="400">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="423" y="414">priority</text>
<text text-anchor="middle" style="font-size:8.00;" x="494" y="414">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="429" y="428">datecreated</text>
<text text-anchor="middle" style="font-size:8.00;" x="500" y="428">timestamp</text>
<text text-anchor="middle" style="font-size:8.00;" x="432" y="442">datelastquery</text>
<text text-anchor="middle" style="font-size:8.00;" x="500" y="442">timestamp</text>
<text text-anchor="middle" style="font-size:8.00;" x="431" y="456">dateaccepted</text>
<text text-anchor="middle" style="font-size:8.00;" x="500" y="456">timestamp</text>
<text text-anchor="middle" style="font-size:8.00;" x="423" y="470">datedue</text>
<text text-anchor="middle" style="font-size:8.00;" x="500" y="470">timestamp</text>
<text text-anchor="middle" style="font-size:8.00;" x="437" y="484">datelastresponse</text>
<text text-anchor="middle" style="font-size:8.00;" x="500" y="484">timestamp</text>
<text text-anchor="middle" style="font-size:8.00;" x="433" y="498">dateanswered</text>
<text text-anchor="middle" style="font-size:8.00;" x="500" y="498">timestamp</text>
<text text-anchor="middle" style="font-size:8.00;" x="428" y="512">dateclosed</text>
<text text-anchor="middle" style="font-size:8.00;" x="500" y="512">timestamp</text>
<text text-anchor="middle" style="font-size:8.00;" x="429" y="526">whiteboard</text>
<text text-anchor="middle" style="font-size:8.00;" x="489" y="526">text</text>
<text text-anchor="middle" style="font-size:8.00;" x="415" y="540">fti</text>
<text text-anchor="middle" style="font-size:8.00;" x="496" y="540">tsvector</text>
<polygon style="fill:none;stroke:black;" points="405,546 405,246 651,246 651,546 405,546"/>
</g>
<g id="node6" class="node"><title>fake_person_378</title>
<ellipse cx="703" cy="315" rx="27" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="703" y="318">person</text>
</g>
<g id="edge2" class="edge"><title>ticket->fake_person_378</title>
<path style="fill:none;stroke:black;" d="M659,335C664,333 668,331 672,329"/>
<polygon style="fill:black;stroke:black;" points="670,326 681,325 673,332 670,326"/>
</g>
<g id="node8" class="node"><title>fake_person_380</title>
<ellipse cx="448" cy="653" rx="27" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="448" y="656">person</text>
</g>
<g id="edge4" class="edge"><title>ticket->fake_person_380</title>
<path style="fill:none;stroke:black;" d="M480,550C471,580 462,606 457,625"/>
<polygon style="fill:black;stroke:black;" points="460,626 454,635 454,624 460,626"/>
</g>
<g id="node10" class="node"><title>fake_person_382</title>
<ellipse cx="630" cy="149" rx="27" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="630" y="152">person</text>
</g>
<g id="edge6" class="edge"><title>ticket->fake_person_382</title>
<path style="fill:none;stroke:black;" d="M592,242C602,217 612,194 619,177"/>
<polygon style="fill:black;stroke:black;" points="616,175 623,167 623,178 616,175"/>
</g>
<g id="node12" class="node"><title>fake_product_384</title>
<ellipse cx="473" cy="138" rx="27" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="473" y="141">product</text>
</g>
<g id="edge8" class="edge"><title>ticket->fake_product_384</title>
<path style="fill:none;stroke:black;" d="M495,242C488,212 483,185 479,166"/>
<polygon style="fill:black;stroke:black;" points="476,166 477,156 482,165 476,166"/>
</g>
<g id="node14" class="node"><title>fake_distribution_386</title>
<ellipse cx="785" cy="497" rx="30" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="785" y="500">distribution</text>
</g>
<g id="edge10" class="edge"><title>ticket->fake_distribution_386</title>
<path style="fill:none;stroke:black;" d="M659,448C692,461 726,474 750,483"/>
<polygon style="fill:black;stroke:black;" points="752,480 760,487 749,487 752,480"/>
</g>
<g id="node16" class="node"><title>fake_sourcepackagename_388</title>
<ellipse cx="335" cy="376" rx="44" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="335" y="379">sourcepackagename</text>
</g>
<g id="edge12" class="edge"><title>ticket->fake_sourcepackagename_388</title>
<path style="fill:none;stroke:black;" d="M397,382C394,382 391,381 388,381"/>
<polygon style="fill:black;stroke:black;" points="388,384 378,380 388,378 388,384"/>
</g>
<g id="node2" class="node"><title>ticketbug</title>
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="545,637 545,575 717,575 717,637 545,637"/>
<polygon style="fill:white;stroke:white;" points="548,592 548,578 714,578 714,592 548,592"/>
<text text-anchor="middle" style="font-size:8.00;" x="631" y="588">ticketbug</text>
<polygon style="fill:none;stroke:black;" points="548,592 548,578 714,578 714,592 548,592"/>
<text text-anchor="middle" style="font-size:8.00;" x="554" y="603">id</text>
<text text-anchor="middle" style="font-size:8.00;" x="584" y="603">serial</text>
<text text-anchor="middle" style="font-size:8.00;" x="635" y="603"> PRIMARY KEY </text>
<text text-anchor="middle" style="font-size:8.00;" x="560" y="617">ticket</text>
<text text-anchor="middle" style="font-size:8.00;" x="587" y="617">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="659" y="617"> UNIQUE REFERENCES ticket </text>
<text text-anchor="middle" style="font-size:8.00;" x="557" y="631">bug</text>
<text text-anchor="middle" style="font-size:8.00;" x="587" y="631">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="656" y="631"> REFERENCES bug UNIQUE </text>
<polygon style="fill:none;stroke:black;" points="545,637 545,575 717,575 717,637 545,637"/>
</g>
<g id="edge14" class="edge"><title>ticketbug->ticket</title>
<path style="fill:none;stroke:black;" d="M614,571C612,567 610,564 608,559"/>
<polygon style="fill:black;stroke:black;" points="605,561 604,550 611,558 605,561"/>
</g>
<g id="node19" class="node"><title>fake_bug_391</title>
<ellipse cx="666" cy="676" rx="27" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="666" y="679">bug</text>
</g>
<g id="edge16" class="edge"><title>ticketbug->fake_bug_391</title>
<path style="fill:none;stroke:black;" d="M649,641C651,644 652,647 654,650"/>
<polygon style="fill:black;stroke:black;" points="657,648 658,659 651,651 657,648"/>
</g>
<g id="node3" class="node"><title>ticketmessage</title>
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="775,290 775,228 967,228 967,290 775,290"/>
<polygon style="fill:white;stroke:white;" points="778,245 778,231 964,231 964,245 778,245"/>
<text text-anchor="middle" style="font-size:8.00;" x="871" y="241">ticketmessage</text>
<polygon style="fill:none;stroke:black;" points="778,245 778,231 964,231 964,245 778,245"/>
<text text-anchor="middle" style="font-size:8.00;" x="784" y="256">id</text>
<text text-anchor="middle" style="font-size:8.00;" x="824" y="256">serial</text>
<text text-anchor="middle" style="font-size:8.00;" x="875" y="256"> PRIMARY KEY </text>
<text text-anchor="middle" style="font-size:8.00;" x="790" y="270">ticket</text>
<text text-anchor="middle" style="font-size:8.00;" x="827" y="270">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="899" y="270"> UNIQUE REFERENCES ticket </text>
<text text-anchor="middle" style="font-size:8.00;" x="795" y="284">message</text>
<text text-anchor="middle" style="font-size:8.00;" x="827" y="284">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="904" y="284"> REFERENCES message UNIQUE </text>
<polygon style="fill:none;stroke:black;" points="775,290 775,228 967,228 967,290 775,290"/>
</g>
<g id="edge18" class="edge"><title>ticketmessage->ticket</title>
<path style="fill:none;stroke:black;" d="M800,294C776,306 748,318 723,328 705,335 687,342 668,349"/>
<polygon style="fill:black;stroke:black;" points="670,352 659,353 667,346 670,352"/>
</g>
<g id="node22" class="node"><title>fake_message_394</title>
<ellipse cx="1030" cy="193" rx="27" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="1030" y="196">message</text>
</g>
<g id="edge20" class="edge"><title>ticketmessage->fake_message_394</title>
<path style="fill:none;stroke:black;" d="M956,224C971,218 985,211 998,207"/>
<polygon style="fill:black;stroke:black;" points="996,204 1007,203 999,210 996,204"/>
</g>
<g id="node4" class="node"><title>ticketreopening</title>
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="118,673 118,555 300,555 300,673 118,673"/>
<polygon style="fill:white;stroke:white;" points="121,572 121,558 297,558 297,572 121,572"/>
<text text-anchor="middle" style="font-size:8.00;" x="209" y="568">ticketreopening</text>
<polygon style="fill:none;stroke:black;" points="121,572 121,558 297,558 297,572 121,572"/>
<text text-anchor="middle" style="font-size:8.00;" x="127" y="583">id</text>
<text text-anchor="middle" style="font-size:8.00;" x="184" y="583">serial</text>
<text text-anchor="middle" style="font-size:8.00;" x="246" y="583"> PRIMARY KEY </text>
<text text-anchor="middle" style="font-size:8.00;" x="133" y="597">ticket</text>
<text text-anchor="middle" style="font-size:8.00;" x="187" y="597">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="254" y="597"> REFERENCES ticket </text>
<text text-anchor="middle" style="font-size:8.00;" x="142" y="611">datecreated</text>
<text text-anchor="middle" style="font-size:8.00;" x="193" y="611">timestamp</text>
<text text-anchor="middle" style="font-size:8.00;" x="138" y="625">reopener</text>
<text text-anchor="middle" style="font-size:8.00;" x="187" y="625">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="256" y="625"> REFERENCES person </text>
<text text-anchor="middle" style="font-size:8.00;" x="138" y="639">answerer</text>
<text text-anchor="middle" style="font-size:8.00;" x="187" y="639">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="256" y="639"> REFERENCES person </text>
<text text-anchor="middle" style="font-size:8.00;" x="146" y="653">dateanswered</text>
<text text-anchor="middle" style="font-size:8.00;" x="193" y="653">timestamp</text>
<text text-anchor="middle" style="font-size:8.00;" x="139" y="667">priorstate</text>
<text text-anchor="middle" style="font-size:8.00;" x="187" y="667">integer</text>
<polygon style="fill:none;stroke:black;" points="118,673 118,555 300,555 300,673 118,673"/>
</g>
<g id="edge22" class="edge"><title>ticketreopening->ticket</title>
<path style="fill:none;stroke:black;" d="M301,551C328,533 359,512 389,492"/>
<polygon style="fill:black;stroke:black;" points="387,489 397,486 391,495 387,489"/>
</g>
<g id="node25" class="node"><title>fake_person_397</title>
<ellipse cx="33" cy="645" rx="27" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="33" y="648">person</text>
</g>
<g id="edge24" class="edge"><title>ticketreopening->fake_person_397</title>
<path style="fill:none;stroke:black;" d="M110,631C95,633 81,636 69,638"/>
<polygon style="fill:black;stroke:black;" points="69,641 59,640 68,635 69,641"/>
</g>
<g id="node27" class="node"><title>fake_person_399</title>
<ellipse cx="116" cy="767" rx="27" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="116" y="770">person</text>
</g>
<g id="edge26" class="edge"><title>ticketreopening->fake_person_399</title>
<path style="fill:none;stroke:black;" d="M171,677C158,700 143,724 132,741"/>
<polygon style="fill:black;stroke:black;" points="134,744 126,750 129,740 134,744"/>
</g>
<g id="node5" class="node"><title>ticketsubscription</title>
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="184,175 184,113 364,113 364,175 184,175"/>
<polygon style="fill:white;stroke:white;" points="187,130 187,116 361,116 361,130 187,130"/>
<text text-anchor="middle" style="font-size:8.00;" x="274" y="126">ticketsubscription</text>
<polygon style="fill:none;stroke:black;" points="187,130 187,116 361,116 361,130 187,130"/>
<text text-anchor="middle" style="font-size:8.00;" x="193" y="141">id</text>
<text text-anchor="middle" style="font-size:8.00;" x="227" y="141">serial</text>
<text text-anchor="middle" style="font-size:8.00;" x="278" y="141"> PRIMARY KEY </text>
<text text-anchor="middle" style="font-size:8.00;" x="199" y="155">ticket</text>
<text text-anchor="middle" style="font-size:8.00;" x="230" y="155">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="302" y="155"> REFERENCES ticket UNIQUE </text>
<text text-anchor="middle" style="font-size:8.00;" x="201" y="169">person</text>
<text text-anchor="middle" style="font-size:8.00;" x="230" y="169">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="304" y="169"> REFERENCES person UNIQUE </text>
<polygon style="fill:none;stroke:black;" points="184,175 184,113 364,113 364,175 184,175"/>
</g>
<g id="edge28" class="edge"><title>ticketsubscription->ticket</title>
<path style="fill:none;stroke:black;" d="M309,179C330,200 359,229 390,259"/>
<polygon style="fill:black;stroke:black;" points="392,256 397,266 387,261 392,256"/>
</g>
<g id="node30" class="node"><title>fake_person_402</title>
<ellipse cx="161" cy="23" rx="27" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="161" y="26">person</text>
</g>
<g id="edge30" class="edge"><title>ticketsubscription->fake_person_402</title>
<path style="fill:none;stroke:black;" d="M241,109C222,89 199,64 182,46"/>
<polygon style="fill:black;stroke:black;" points="179,48 175,38 184,43 179,48"/>
</g>
</g>
</svg>
|