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
|
<?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="807px" height="919px"
viewBox = "-1 -1 806 918"
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="402" y="901">Shipit</text>
<g id="node1" class="node"><title>requestedcds</title>
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="79,872 79,754 291,754 291,872 79,872"/>
<polygon style="fill:white;stroke:white;" points="82,771 82,757 288,757 288,771 82,771"/>
<text text-anchor="middle" style="font-size:8.00;" x="185" y="767">requestedcds</text>
<polygon style="fill:none;stroke:black;" points="82,771 82,757 288,757 288,771 82,771"/>
<text text-anchor="middle" style="font-size:8.00;" x="88" y="782">id</text>
<text text-anchor="middle" style="font-size:8.00;" x="157" y="782">serial</text>
<text text-anchor="middle" style="font-size:8.00;" x="208" y="782"> PRIMARY KEY </text>
<text text-anchor="middle" style="font-size:8.00;" x="97" y="796">request</text>
<text text-anchor="middle" style="font-size:8.00;" x="160" y="796">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="232" y="796"> REFERENCES shippingrequest </text>
<text text-anchor="middle" style="font-size:8.00;" x="98" y="810">quantity</text>
<text text-anchor="middle" style="font-size:8.00;" x="160" y="810">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="97" y="824">flavour</text>
<text text-anchor="middle" style="font-size:8.00;" x="160" y="824">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="105" y="838">distrorelease</text>
<text text-anchor="middle" style="font-size:8.00;" x="160" y="838">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="104" y="852">architecture</text>
<text text-anchor="middle" style="font-size:8.00;" x="160" y="852">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="113" y="866">quantityapproved</text>
<text text-anchor="middle" style="font-size:8.00;" x="160" y="866">integer</text>
<polygon style="fill:none;stroke:black;" points="79,872 79,754 291,754 291,872 79,872"/>
</g>
<g id="node4" class="node"><title>shippingrequest</title>
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="238,725 238,425 468,425 468,725 238,725"/>
<polygon style="fill:white;stroke:white;" points="241,442 241,428 465,428 465,442 241,442"/>
<text text-anchor="middle" style="font-size:8.00;" x="353" y="438">shippingrequest</text>
<polygon style="fill:none;stroke:black;" points="241,442 241,428 465,428 465,442 241,442"/>
<text text-anchor="middle" style="font-size:8.00;" x="247" y="453">id</text>
<text text-anchor="middle" style="font-size:8.00;" x="330" y="453">serial</text>
<text text-anchor="middle" style="font-size:8.00;" x="392" y="453"> PRIMARY KEY </text>
<text text-anchor="middle" style="font-size:8.00;" x="258" y="467">recipient</text>
<text text-anchor="middle" style="font-size:8.00;" x="333" y="467">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="402" y="467"> REFERENCES person </text>
<text text-anchor="middle" style="font-size:8.00;" x="266" y="481">whoapproved</text>
<text text-anchor="middle" style="font-size:8.00;" x="333" y="481">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="402" y="481"> REFERENCES person </text>
<text text-anchor="middle" style="font-size:8.00;" x="259" y="495">cancelled</text>
<text text-anchor="middle" style="font-size:8.00;" x="335" y="495">boolean</text>
<text text-anchor="middle" style="font-size:8.00;" x="266" y="509">whocancelled</text>
<text text-anchor="middle" style="font-size:8.00;" x="333" y="509">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="402" y="509"> REFERENCES person </text>
<text text-anchor="middle" style="font-size:8.00;" x="266" y="523">daterequested</text>
<text text-anchor="middle" style="font-size:8.00;" x="339" y="523">timestamp</text>
<text text-anchor="middle" style="font-size:8.00;" x="259" y="537">approved</text>
<text text-anchor="middle" style="font-size:8.00;" x="335" y="537">boolean</text>
<text text-anchor="middle" style="font-size:8.00;" x="265" y="551">shockandawe</text>
<text text-anchor="middle" style="font-size:8.00;" x="333" y="551">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="413" y="551"> REFERENCES shockandawe </text>
<text text-anchor="middle" style="font-size:8.00;" x="255" y="565">reason</text>
<text text-anchor="middle" style="font-size:8.00;" x="328" y="565">text</text>
<text text-anchor="middle" style="font-size:8.00;" x="263" y="579">highpriority</text>
<text text-anchor="middle" style="font-size:8.00;" x="335" y="579">boolean</text>
<text text-anchor="middle" style="font-size:8.00;" x="279" y="593">recipientdisplayname</text>
<text text-anchor="middle" style="font-size:8.00;" x="328" y="593">text</text>
<text text-anchor="middle" style="font-size:8.00;" x="264" y="607">addressline1</text>
<text text-anchor="middle" style="font-size:8.00;" x="328" y="607">text</text>
<text text-anchor="middle" style="font-size:8.00;" x="264" y="621">addressline2</text>
<text text-anchor="middle" style="font-size:8.00;" x="328" y="621">text</text>
<text text-anchor="middle" style="font-size:8.00;" x="264" y="635">organization</text>
<text text-anchor="middle" style="font-size:8.00;" x="328" y="635">text</text>
<text text-anchor="middle" style="font-size:8.00;" x="250" y="649">city</text>
<text text-anchor="middle" style="font-size:8.00;" x="328" y="649">text</text>
<text text-anchor="middle" style="font-size:8.00;" x="258" y="663">province</text>
<text text-anchor="middle" style="font-size:8.00;" x="328" y="663">text</text>
<text text-anchor="middle" style="font-size:8.00;" x="256" y="677">country</text>
<text text-anchor="middle" style="font-size:8.00;" x="333" y="677">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="403" y="677"> REFERENCES country </text>
<text text-anchor="middle" style="font-size:8.00;" x="258" y="691">postcode</text>
<text text-anchor="middle" style="font-size:8.00;" x="328" y="691">text</text>
<text text-anchor="middle" style="font-size:8.00;" x="254" y="705">phone</text>
<text text-anchor="middle" style="font-size:8.00;" x="328" y="705">text</text>
<text text-anchor="middle" style="font-size:8.00;" x="248" y="719">fti</text>
<text text-anchor="middle" style="font-size:8.00;" x="335" y="719">tsvector</text>
<polygon style="fill:none;stroke:black;" points="238,725 238,425 468,425 468,725 238,725"/>
</g>
<g id="edge2" class="edge"><title>requestedcds->shippingrequest</title>
<path style="fill:none;stroke:black;" d="M230,750C233,746 236,742 238,738"/>
<polygon style="fill:black;stroke:black;" points="236,735 244,729 241,739 236,735"/>
</g>
<g id="node2" class="node"><title>shipitreport</title>
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="504,669 504,607 702,607 702,669 504,669"/>
<polygon style="fill:white;stroke:white;" points="507,624 507,610 699,610 699,624 507,624"/>
<text text-anchor="middle" style="font-size:8.00;" x="603" y="620">shipitreport</text>
<polygon style="fill:none;stroke:black;" points="507,624 507,610 699,610 699,624 507,624"/>
<text text-anchor="middle" style="font-size:8.00;" x="513" y="635">id</text>
<text text-anchor="middle" style="font-size:8.00;" x="561" y="635">serial</text>
<text text-anchor="middle" style="font-size:8.00;" x="623" y="635"> PRIMARY KEY </text>
<text text-anchor="middle" style="font-size:8.00;" x="528" y="649">datecreated</text>
<text text-anchor="middle" style="font-size:8.00;" x="570" y="649">timestamp</text>
<text text-anchor="middle" style="font-size:8.00;" x="520" y="663">csvfile</text>
<text text-anchor="middle" style="font-size:8.00;" x="564" y="663">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="645" y="663"> REFERENCES libraryfilealias </text>
<polygon style="fill:none;stroke:black;" points="504,669 504,607 702,607 702,669 504,669"/>
</g>
<g id="node9" class="node"><title>fake_libraryfilealias_319</title>
<ellipse cx="764" cy="662" rx="35" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="764" y="665">libraryfilealias</text>
</g>
<g id="edge4" class="edge"><title>shipitreport->fake_libraryfilealias_319</title>
<path style="fill:none;stroke:black;" d="M710,654C713,654 717,655 720,655"/>
<polygon style="fill:black;stroke:black;" points="721,652 730,657 720,658 721,652"/>
</g>
<g id="node3" class="node"><title>shipment</title>
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="287,401 287,283 537,283 537,401 287,401"/>
<polygon style="fill:white;stroke:white;" points="290,300 290,286 534,286 534,300 290,300"/>
<text text-anchor="middle" style="font-size:8.00;" x="412" y="296">shipment</text>
<polygon style="fill:none;stroke:black;" points="290,300 290,286 534,286 534,300 290,300"/>
<text text-anchor="middle" style="font-size:8.00;" x="296" y="311">id</text>
<text text-anchor="middle" style="font-size:8.00;" x="359" y="311">serial</text>
<text text-anchor="middle" style="font-size:8.00;" x="421" y="311"> PRIMARY KEY </text>
<text text-anchor="middle" style="font-size:8.00;" x="310" y="325">logintoken</text>
<text text-anchor="middle" style="font-size:8.00;" x="357" y="325">text</text>
<text text-anchor="middle" style="font-size:8.00;" x="409" y="325"> UNIQUE </text>
<text text-anchor="middle" style="font-size:8.00;" x="312" y="339">shippingrun</text>
<text text-anchor="middle" style="font-size:8.00;" x="362" y="339">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="439" y="339"> REFERENCES shippingrun </text>
<text text-anchor="middle" style="font-size:8.00;" x="312" y="353">dateshipped</text>
<text text-anchor="middle" style="font-size:8.00;" x="368" y="353">timestamp</text>
<text text-anchor="middle" style="font-size:8.00;" x="318" y="367">shippingservice</text>
<text text-anchor="middle" style="font-size:8.00;" x="362" y="367">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="314" y="381">trackingcode</text>
<text text-anchor="middle" style="font-size:8.00;" x="357" y="381">text</text>
<text text-anchor="middle" style="font-size:8.00;" x="305" y="395">request</text>
<text text-anchor="middle" style="font-size:8.00;" x="362" y="395">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="462" y="395"> REFERENCES shippingrequest UNIQUE </text>
<polygon style="fill:none;stroke:black;" points="287,401 287,283 537,283 537,401 287,401"/>
</g>
<g id="edge8" class="edge"><title>shipment->shippingrequest</title>
<path style="fill:none;stroke:black;" d="M396,405C396,407 395,409 394,411"/>
<polygon style="fill:black;stroke:black;" points="397,412 392,421 391,411 397,412"/>
</g>
<g id="node5" class="node"><title>shippingrun</title>
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="323,256 323,180 567,180 567,256 323,256"/>
<polygon style="fill:white;stroke:white;" points="326,197 326,183 564,183 564,197 326,197"/>
<text text-anchor="middle" style="font-size:8.00;" x="445" y="193">shippingrun</text>
<polygon style="fill:none;stroke:black;" points="326,197 326,183 564,183 564,197 326,197"/>
<text text-anchor="middle" style="font-size:8.00;" x="332" y="208">id</text>
<text text-anchor="middle" style="font-size:8.00;" x="394" y="208">serial</text>
<text text-anchor="middle" style="font-size:8.00;" x="456" y="208"> PRIMARY KEY </text>
<text text-anchor="middle" style="font-size:8.00;" x="347" y="222">datecreated</text>
<text text-anchor="middle" style="font-size:8.00;" x="403" y="222">timestamp</text>
<text text-anchor="middle" style="font-size:8.00;" x="354" y="236">sentforshipping</text>
<text text-anchor="middle" style="font-size:8.00;" x="399" y="236">boolean</text>
<text text-anchor="middle" style="font-size:8.00;" x="339" y="250">csvfile</text>
<text text-anchor="middle" style="font-size:8.00;" x="397" y="250">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="494" y="250"> REFERENCES libraryfilealias UNIQUE </text>
<polygon style="fill:none;stroke:black;" points="323,256 323,180 567,180 567,256 323,256"/>
</g>
<g id="edge6" class="edge"><title>shipment->shippingrun</title>
<path style="fill:none;stroke:black;" d="M429,279C430,276 431,273 431,270"/>
<polygon style="fill:black;stroke:black;" points="428,269 434,260 434,271 428,269"/>
</g>
<g id="node6" class="node"><title>shockandawe</title>
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="14,451 14,375 150,375 150,451 14,451"/>
<polygon style="fill:white;stroke:white;" points="17,392 17,378 147,378 147,392 17,392"/>
<text text-anchor="middle" style="font-size:8.00;" x="82" y="388">shockandawe</text>
<polygon style="fill:none;stroke:black;" points="17,392 17,378 147,378 147,392 17,392"/>
<text text-anchor="middle" style="font-size:8.00;" x="23" y="403">id</text>
<text text-anchor="middle" style="font-size:8.00;" x="70" y="403">serial</text>
<text text-anchor="middle" style="font-size:8.00;" x="115" y="403"> PRIMARY KEY </text>
<text text-anchor="middle" style="font-size:8.00;" x="29" y="417">name</text>
<text text-anchor="middle" style="font-size:8.00;" x="68" y="417">text</text>
<text text-anchor="middle" style="font-size:8.00;" x="26" y="431">title</text>
<text text-anchor="middle" style="font-size:8.00;" x="68" y="431">text</text>
<text text-anchor="middle" style="font-size:8.00;" x="37" y="445">description</text>
<text text-anchor="middle" style="font-size:8.00;" x="68" y="445">text</text>
<polygon style="fill:none;stroke:black;" points="14,451 14,375 150,375 150,451 14,451"/>
</g>
<g id="edge16" class="edge"><title>shippingrequest->shockandawe</title>
<path style="fill:none;stroke:black;" d="M230,501C206,487 183,473 161,460"/>
<polygon style="fill:black;stroke:black;" points="159,463 152,455 162,457 159,463"/>
</g>
<g id="node13" class="node"><title>fake_person_323</title>
<ellipse cx="100" cy="628" rx="27" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="100" y="631">person</text>
</g>
<g id="edge10" class="edge"><title>shippingrequest->fake_person_323</title>
<path style="fill:none;stroke:black;" d="M230,601C195,608 161,615 136,620"/>
<polygon style="fill:black;stroke:black;" points="136,623 126,622 135,617 136,623"/>
</g>
<g id="node15" class="node"><title>fake_person_325</title>
<ellipse cx="552" cy="743" rx="27" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="552" y="746">person</text>
</g>
<g id="edge12" class="edge"><title>shippingrequest->fake_person_325</title>
<path style="fill:none;stroke:black;" d="M476,679C496,696 514,711 527,722"/>
<polygon style="fill:black;stroke:black;" points="530,720 535,729 525,725 530,720"/>
</g>
<g id="node17" class="node"><title>fake_person_327</title>
<ellipse cx="610" cy="554" rx="27" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="610" y="557">person</text>
</g>
<g id="edge14" class="edge"><title>shippingrequest->fake_person_327</title>
<path style="fill:none;stroke:black;" d="M476,565C511,562 547,560 573,557"/>
<polygon style="fill:black;stroke:black;" points="573,554 583,556 573,560 573,554"/>
</g>
<g id="node20" class="node"><title>fake_country_330</title>
<ellipse cx="384" cy="834" rx="27" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="384" y="837">country</text>
</g>
<g id="edge18" class="edge"><title>shippingrequest->fake_country_330</title>
<path style="fill:none;stroke:black;" d="M371,729C374,758 378,786 380,806"/>
<polygon style="fill:black;stroke:black;" points="383,806 382,816 377,807 383,806"/>
</g>
<g id="node22" class="node"><title>fake_libraryfilealias_332</title>
<ellipse cx="497" cy="23" rx="35" ry="18" style="fill:none;stroke:red;"/>
<text text-anchor="middle" style="font-size:8.00;" x="497" y="26">libraryfilealias</text>
</g>
<g id="edge20" class="edge"><title>shippingrun->fake_libraryfilealias_332</title>
<path style="fill:none;stroke:black;" d="M456,176C467,138 481,84 489,51"/>
<polygon style="fill:black;stroke:black;" points="486,50 492,41 492,52 486,50"/>
</g>
<g id="node7" class="node"><title>standardshipitrequest</title>
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="602,480 602,376 760,376 760,480 602,480"/>
<polygon style="fill:white;stroke:white;" points="605,393 605,379 757,379 757,393 605,393"/>
<text text-anchor="middle" style="font-size:8.00;" x="681" y="389">standardshipitrequest</text>
<polygon style="fill:none;stroke:black;" points="605,393 605,379 757,379 757,393 605,393"/>
<text text-anchor="middle" style="font-size:8.00;" x="611" y="404">id</text>
<text text-anchor="middle" style="font-size:8.00;" x="671" y="404">serial</text>
<text text-anchor="middle" style="font-size:8.00;" x="725" y="404"> PRIMARY KEY </text>
<text text-anchor="middle" style="font-size:8.00;" x="627" y="418">quantityx86</text>
<text text-anchor="middle" style="font-size:8.00;" x="674" y="418">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="713" y="418"> UNIQUE </text>
<text text-anchor="middle" style="font-size:8.00;" x="627" y="432">quantityppc</text>
<text text-anchor="middle" style="font-size:8.00;" x="674" y="432">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="713" y="432"> UNIQUE </text>
<text text-anchor="middle" style="font-size:8.00;" x="632" y="446">quantityamd64</text>
<text text-anchor="middle" style="font-size:8.00;" x="674" y="446">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="713" y="446"> UNIQUE </text>
<text text-anchor="middle" style="font-size:8.00;" x="622" y="460">isdefault</text>
<text text-anchor="middle" style="font-size:8.00;" x="676" y="460">boolean</text>
<text text-anchor="middle" style="font-size:8.00;" x="620" y="474">flavour</text>
<text text-anchor="middle" style="font-size:8.00;" x="674" y="474">integer</text>
<text text-anchor="middle" style="font-size:8.00;" x="713" y="474"> UNIQUE </text>
<polygon style="fill:none;stroke:black;" points="602,480 602,376 760,376 760,480 602,480"/>
</g>
</g>
</svg>
|