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
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
|
<?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="1325px" height="918px"
viewBox = "-1 -1 1324 917"
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="661" y="900">Specifications</text>
<g id="node1" class="node"><title>specification</title>
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="442,671 442,287 870,287 870,671 442,671"/>
<polygon style="fill:white;stroke:white;" points="445,304 445,290 867,290 867,304 445,304"/>
<text text-anchor="middle" style="font-size:8.00;" x="656" y="300">specification</text>
<polygon style="fill:none;stroke:black;" points="445,304 445,290 867,290 867,304 445,304"/>
<text text-anchor="middle" style="font-size:8.00;" x="451" y="315">id</text>
<text text-anchor="middle" style="font-size:8.00;" x="527" y="315">serial</text>
<text text-anchor="middle" style="font-size:8.00;" x="589" y="315"> PRIMARY KEY </text>
<text text-anchor="middle" style="font-size:8.00;" x="457" y="329">name</text>
<text text-anchor="middle" style="font-size:8.00;" x="525" y="329">text</text>
<text text-anchor="middle" style="font-size:8.00;" x="593" y="329"> UNIQUE UNIQUE </text>
<text text-anchor="middle" style="font-size:8.00;" x="454" y="343">title</text>
<text text-anchor="middle" style="font-size:8.00;" x="525" y="343">text</text>
<text text-anchor="middle" style="font-size:8.00;" x="463" y="357">summary</text>
<text text-anchor="middle" style="font-size:8.00;" x="525" y="357">text</text>
<text text-anchor="middle" style="font-size:8.00;" x="458" y="371">owner</text>
<text text-anchor="middle" style="font-size:8.00;" x="530" y="371">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="599" y="371"> REFERENCES person </text>
<text text-anchor="middle" style="font-size:8.00;" x="461" y="385">assignee</text>
<text text-anchor="middle" style="font-size:8.00;" x="530" y="385">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="599" y="385"> REFERENCES person </text>
<text text-anchor="middle" style="font-size:8.00;" x="458" y="399">drafter</text>
<text text-anchor="middle" style="font-size:8.00;" x="530" y="399">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="599" y="399"> REFERENCES person </text>
<text text-anchor="middle" style="font-size:8.00;" x="462" y="413">approver</text>
<text text-anchor="middle" style="font-size:8.00;" x="530" y="413">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="599" y="413"> REFERENCES person </text>
<text text-anchor="middle" style="font-size:8.00;" x="466" y="427">datecreated</text>
<text text-anchor="middle" style="font-size:8.00;" x="536" y="427">timestamp</text>
<text text-anchor="middle" style="font-size:8.00;" x="460" y="441">product</text>
<text text-anchor="middle" style="font-size:8.00;" x="530" y="441">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="707" y="441"> REFERENCES product REFERENCES milestone UNIQUE REFERENCES productseries </text>
<text text-anchor="middle" style="font-size:8.00;" x="470" y="455">productseries</text>
<text text-anchor="middle" style="font-size:8.00;" x="530" y="455">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="609" y="455"> REFERENCES productseries </text>
<text text-anchor="middle" style="font-size:8.00;" x="466" y="469">distribution</text>
<text text-anchor="middle" style="font-size:8.00;" x="530" y="469">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="712" y="469"> REFERENCES distribution REFERENCES milestone UNIQUE REFERENCES distrorelease </text>
<text text-anchor="middle" style="font-size:8.00;" x="468" y="483">distrorelease</text>
<text text-anchor="middle" style="font-size:8.00;" x="530" y="483">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="608" y="483"> REFERENCES distrorelease </text>
<text text-anchor="middle" style="font-size:8.00;" x="464" y="497">milestone</text>
<text text-anchor="middle" style="font-size:8.00;" x="530" y="497">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="646" y="497"> REFERENCES milestone REFERENCES milestone </text>
<text text-anchor="middle" style="font-size:8.00;" x="457" y="511">status</text>
<text text-anchor="middle" style="font-size:8.00;" x="530" y="511">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="460" y="525">priority</text>
<text text-anchor="middle" style="font-size:8.00;" x="530" y="525">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="459" y="539">specurl</text>
<text text-anchor="middle" style="font-size:8.00;" x="525" y="539">text</text>
<text text-anchor="middle" style="font-size:8.00;" x="577" y="539"> UNIQUE </text>
<text text-anchor="middle" style="font-size:8.00;" x="466" y="553">whiteboard</text>
<text text-anchor="middle" style="font-size:8.00;" x="525" y="553">text</text>
<text text-anchor="middle" style="font-size:8.00;" x="472" y="567">superseded_by</text>
<text text-anchor="middle" style="font-size:8.00;" x="530" y="567">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="608" y="567"> REFERENCES specification </text>
<text text-anchor="middle" style="font-size:8.00;" x="476" y="581">needs_discussion</text>
<text text-anchor="middle" style="font-size:8.00;" x="532" y="581">boolean</text>
<text text-anchor="middle" style="font-size:8.00;" x="479" y="595">direction_approved</text>
<text text-anchor="middle" style="font-size:8.00;" x="532" y="595">boolean</text>
<text text-anchor="middle" style="font-size:8.00;" x="465" y="609">man_days</text>
<text text-anchor="middle" style="font-size:8.00;" x="530" y="609">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="461" y="623">delivery</text>
<text text-anchor="middle" style="font-size:8.00;" x="530" y="623">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="464" y="637">goalstatus</text>
<text text-anchor="middle" style="font-size:8.00;" x="530" y="637">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="470" y="651">informational</text>
<text text-anchor="middle" style="font-size:8.00;" x="532" y="651">boolean</text>
<text text-anchor="middle" style="font-size:8.00;" x="452" y="665">fti</text>
<text text-anchor="middle" style="font-size:8.00;" x="532" y="665">tsvector</text>
<polygon style="fill:none;stroke:black;" points="442,671 442,287 870,287 870,671 442,671"/>
</g>
<g id="edge22" class="edge"><title>specification->specification</title>
<path style="fill:none;stroke:black;" d="M878,575C889,551 896,519 896,479 896,444 891,415 882,392"/>
<polygon style="fill:black;stroke:black;" points="879,394 878,383 885,391 879,394"/>
</g>
<g id="node6" class="node"><title>fake_person_340</title>
<ellipse cx="291" cy="459" rx="27" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="291" y="462">person</text>
</g>
<g id="edge2" class="edge"><title>specification->fake_person_340</title>
<path style="fill:none;stroke:black;" d="M434,467C394,465 355,463 328,461"/>
<polygon style="fill:black;stroke:black;" points="328,464 318,461 328,457 328,464"/>
</g>
<g id="node8" class="node"><title>fake_person_342</title>
<ellipse cx="922" cy="492" rx="27" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="922" y="495">person</text>
</g>
<g id="edge4" class="edge"><title>specification->fake_person_342</title>
<path style="fill:none;stroke:black;" d="M878,490C880,490 883,490 885,490"/>
<polygon style="fill:black;stroke:black;" points="885,487 895,491 885,493 885,487"/>
</g>
<g id="node10" class="node"><title>fake_person_344</title>
<ellipse cx="335" cy="299" rx="27" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="335" y="302">person</text>
</g>
<g id="edge6" class="edge"><title>specification->fake_person_344</title>
<path style="fill:none;stroke:black;" d="M434,354C407,340 383,326 365,316"/>
<polygon style="fill:black;stroke:black;" points="363,319 356,311 366,313 363,319"/>
</g>
<g id="node12" class="node"><title>fake_person_346</title>
<ellipse cx="738" cy="248" rx="27" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="738" y="251">person</text>
</g>
<g id="edge8" class="edge"><title>specification->fake_person_346</title>
<path style="fill:none;stroke:black;" d="M726,283C727,280 728,278 728,276"/>
<polygon style="fill:black;stroke:black;" points="725,274 732,266 732,277 725,274"/>
</g>
<g id="node14" class="node"><title>fake_product_348</title>
<ellipse cx="388" cy="728" rx="27" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="388" y="731">product</text>
</g>
<g id="edge10" class="edge"><title>specification->fake_product_348</title>
<path style="fill:none;stroke:black;" d="M445,675C433,687 421,698 412,706"/>
<polygon style="fill:black;stroke:black;" points="414,709 404,713 409,704 414,709"/>
</g>
<g id="node16" class="node"><title>fake_milestone_350</title>
<ellipse cx="509" cy="821" rx="28" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="509" y="824">milestone</text>
</g>
<g id="edge12" class="edge"><title>specification->fake_milestone_350</title>
<path style="fill:none;stroke:black;" d="M572,675C552,723 533,767 521,795"/>
<polygon style="fill:black;stroke:black;" points="524,796 517,804 518,793 524,796"/>
</g>
<g id="node18" class="node"><title>fake_productseries_352</title>
<ellipse cx="867" cy="163" rx="34" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="867" y="166">productseries</text>
</g>
<g id="edge14" class="edge"><title>specification->fake_productseries_352</title>
<path style="fill:none;stroke:black;" d="M787,283C812,245 835,211 849,189"/>
<polygon style="fill:black;stroke:black;" points="847,186 855,180 852,190 847,186"/>
</g>
<g id="node20" class="node"><title>fake_distribution_354</title>
<ellipse cx="696" cy="711" rx="30" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="696" y="714">distribution</text>
</g>
<g id="edge16" class="edge"><title>specification->fake_distribution_354</title>
<path style="fill:none;stroke:black;" d="M690,675C690,678 691,681 691,683"/>
<polygon style="fill:black;stroke:black;" points="694,683 693,693 688,684 694,683"/>
</g>
<g id="node22" class="node"><title>fake_milestone_356</title>
<ellipse cx="991" cy="315" rx="28" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="991" y="318">milestone</text>
</g>
<g id="edge18" class="edge"><title>specification->fake_milestone_356</title>
<path style="fill:none;stroke:black;" d="M878,370C910,355 939,341 959,331"/>
<polygon style="fill:black;stroke:black;" points="958,328 968,326 961,334 958,328"/>
</g>
<g id="node24" class="node"><title>fake_distrorelease_358</title>
<ellipse cx="696" cy="857" rx="32" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="696" y="860">distrorelease</text>
</g>
<g id="edge20" class="edge"><title>specification->fake_distrorelease_358</title>
<path style="fill:none;stroke:black;" d="M661,675C662,687 664,699 665,711 670,753 681,799 689,829"/>
<polygon style="fill:black;stroke:black;" points="692,829 691,839 686,830 692,829"/>
</g>
<g id="node2" class="node"><title>specificationbug</title>
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="1006,670 1006,608 1226,608 1226,670 1006,670"/>
<polygon style="fill:white;stroke:white;" points="1009,625 1009,611 1223,611 1223,625 1009,625"/>
<text text-anchor="middle" style="font-size:8.00;" x="1116" y="621">specificationbug</text>
<polygon style="fill:none;stroke:black;" points="1009,625 1009,611 1223,611 1223,625 1009,625"/>
<text text-anchor="middle" style="font-size:8.00;" x="1015" y="636">id</text>
<text text-anchor="middle" style="font-size:8.00;" x="1069" y="636">serial</text>
<text text-anchor="middle" style="font-size:8.00;" x="1120" y="636"> PRIMARY KEY </text>
<text text-anchor="middle" style="font-size:8.00;" x="1032" y="650">specification</text>
<text text-anchor="middle" style="font-size:8.00;" x="1072" y="650">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="1156" y="650"> UNIQUE REFERENCES specification </text>
<text text-anchor="middle" style="font-size:8.00;" x="1018" y="664">bug</text>
<text text-anchor="middle" style="font-size:8.00;" x="1072" y="664">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="1141" y="664"> UNIQUE REFERENCES bug </text>
<polygon style="fill:none;stroke:black;" points="1006,670 1006,608 1226,608 1226,670 1006,670"/>
</g>
<g id="edge24" class="edge"><title>specificationbug->specification</title>
<path style="fill:none;stroke:black;" d="M1015,604C978,591 932,575 888,559"/>
<polygon style="fill:black;stroke:black;" points="887,562 878,556 889,556 887,562"/>
</g>
<g id="node28" class="node"><title>fake_bug_362</title>
<ellipse cx="1290" cy="702" rx="27" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="1290" y="705">bug</text>
</g>
<g id="edge26" class="edge"><title>specificationbug->fake_bug_362</title>
<path style="fill:none;stroke:black;" d="M1213,674C1229,680 1244,685 1257,690"/>
<polygon style="fill:black;stroke:black;" points="1258,687 1266,694 1255,693 1258,687"/>
</g>
<g id="node3" class="node"><title>specificationdependency</title>
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="761,759 761,697 981,697 981,759 761,759"/>
<polygon style="fill:white;stroke:white;" points="764,714 764,700 978,700 978,714 764,714"/>
<text text-anchor="middle" style="font-size:8.00;" x="871" y="710">specificationdependency</text>
<polygon style="fill:none;stroke:black;" points="764,714 764,700 978,700 978,714 764,714"/>
<text text-anchor="middle" style="font-size:8.00;" x="770" y="725">id</text>
<text text-anchor="middle" style="font-size:8.00;" x="824" y="725">serial</text>
<text text-anchor="middle" style="font-size:8.00;" x="875" y="725"> PRIMARY KEY </text>
<text text-anchor="middle" style="font-size:8.00;" x="787" y="739">specification</text>
<text text-anchor="middle" style="font-size:8.00;" x="827" y="739">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="911" y="739"> REFERENCES specification UNIQUE </text>
<text text-anchor="middle" style="font-size:8.00;" x="786" y="753">dependency</text>
<text text-anchor="middle" style="font-size:8.00;" x="827" y="753">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="911" y="753"> REFERENCES specification UNIQUE </text>
<polygon style="fill:none;stroke:black;" points="761,759 761,697 981,697 981,759 761,759"/>
</g>
<g id="edge28" class="edge"><title>specificationdependency->specification</title>
<path style="fill:none;stroke:black;" d="M841,693C838,689 835,686 832,682"/>
<polygon style="fill:black;stroke:black;" points="830,685 825,675 835,680 830,685"/>
</g>
<g id="edge30" class="edge"><title>specificationdependency->specification</title>
<path style="fill:none;stroke:black;" d="M841,693C838,689 835,686 832,682"/>
<polygon style="fill:black;stroke:black;" points="830,685 825,675 835,680 830,685"/>
</g>
<g id="node4" class="node"><title>specificationfeedback</title>
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="432,263 432,173 652,173 652,263 432,263"/>
<polygon style="fill:white;stroke:white;" points="435,190 435,176 649,176 649,190 435,190"/>
<text text-anchor="middle" style="font-size:8.00;" x="542" y="186">specificationfeedback</text>
<polygon style="fill:none;stroke:black;" points="435,190 435,176 649,176 649,190 435,190"/>
<text text-anchor="middle" style="font-size:8.00;" x="441" y="201">id</text>
<text text-anchor="middle" style="font-size:8.00;" x="495" y="201">serial</text>
<text text-anchor="middle" style="font-size:8.00;" x="546" y="201"> PRIMARY KEY </text>
<text text-anchor="middle" style="font-size:8.00;" x="458" y="215">specification</text>
<text text-anchor="middle" style="font-size:8.00;" x="498" y="215">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="582" y="215"> REFERENCES specification UNIQUE </text>
<text text-anchor="middle" style="font-size:8.00;" x="452" y="229">reviewer</text>
<text text-anchor="middle" style="font-size:8.00;" x="498" y="229">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="572" y="229"> REFERENCES person UNIQUE </text>
<text text-anchor="middle" style="font-size:8.00;" x="453" y="243">requester</text>
<text text-anchor="middle" style="font-size:8.00;" x="498" y="243">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="572" y="243"> REFERENCES person UNIQUE </text>
<text text-anchor="middle" style="font-size:8.00;" x="454" y="257">queuemsg</text>
<text text-anchor="middle" style="font-size:8.00;" x="493" y="257">text</text>
<polygon style="fill:none;stroke:black;" points="432,263 432,173 652,173 652,263 432,263"/>
</g>
<g id="edge32" class="edge"><title>specificationfeedback->specification</title>
<path style="fill:none;stroke:black;" d="M563,267C564,269 565,271 566,274"/>
<polygon style="fill:black;stroke:black;" points="569,272 570,283 563,275 569,272"/>
</g>
<g id="node33" class="node"><title>fake_person_367</title>
<ellipse cx="544" cy="23" rx="27" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="544" y="26">person</text>
</g>
<g id="edge34" class="edge"><title>specificationfeedback->fake_person_367</title>
<path style="fill:none;stroke:black;" d="M543,169C543,131 544,82 544,51"/>
<polygon style="fill:black;stroke:black;" points="541,51 544,41 548,51 541,51"/>
</g>
<g id="node35" class="node"><title>fake_person_369</title>
<ellipse cx="417" cy="68" rx="27" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="417" y="71">person</text>
</g>
<g id="edge36" class="edge"><title>specificationfeedback->fake_person_369</title>
<path style="fill:none;stroke:black;" d="M501,169C480,143 454,112 436,92"/>
<polygon style="fill:black;stroke:black;" points="433,94 430,84 439,90 433,94"/>
</g>
<g id="node5" class="node"><title>specificationsubscription</title>
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="95,693 95,631 315,631 315,693 95,693"/>
<polygon style="fill:white;stroke:white;" points="98,648 98,634 312,634 312,648 98,648"/>
<text text-anchor="middle" style="font-size:8.00;" x="205" y="644">specificationsubscription</text>
<polygon style="fill:none;stroke:black;" points="98,648 98,634 312,634 312,648 98,648"/>
<text text-anchor="middle" style="font-size:8.00;" x="104" y="659">id</text>
<text text-anchor="middle" style="font-size:8.00;" x="158" y="659">serial</text>
<text text-anchor="middle" style="font-size:8.00;" x="209" y="659"> PRIMARY KEY </text>
<text text-anchor="middle" style="font-size:8.00;" x="121" y="673">specification</text>
<text text-anchor="middle" style="font-size:8.00;" x="161" y="673">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="245" y="673"> UNIQUE REFERENCES specification </text>
<text text-anchor="middle" style="font-size:8.00;" x="112" y="687">person</text>
<text text-anchor="middle" style="font-size:8.00;" x="161" y="687">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="235" y="687"> REFERENCES person UNIQUE </text>
<polygon style="fill:none;stroke:black;" points="95,693 95,631 315,631 315,693 95,693"/>
</g>
<g id="edge38" class="edge"><title>specificationsubscription->specification</title>
<path style="fill:none;stroke:black;" d="M291,627C330,611 377,592 425,573"/>
<polygon style="fill:black;stroke:black;" points="423,570 434,569 426,576 423,570"/>
</g>
<g id="node38" class="node"><title>fake_person_372</title>
<ellipse cx="33" cy="735" rx="27" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="33" y="738">person</text>
</g>
<g id="edge40" class="edge"><title>specificationsubscription->fake_person_372</title>
<path style="fill:none;stroke:black;" d="M123,697C102,705 82,714 65,721"/>
<polygon style="fill:black;stroke:black;" points="67,724 56,725 64,718 67,724"/>
</g>
</g>
</svg>
|