« back to all changes in this revision
Viewing changes to database/schema/diagrams/ticketing.svg
- browse files at revision 2850.1.2
- compare with another revision
- compare with revision 14583.1.7
- download diff
- download tarball
- view history from revision 2850.1.2
- Committer: Stuart Bishop
- Date: 2005-11-24 07:47:19 UTC
- mto: This revision was merged to the branch mainline in revision 2851.
- Revision ID: stuart.bishop@canonical.com-20051124074719-1f14a54a1d23e0ff
Update database diagrams and documentation
- files added:
- database/schema/diagrams/subscriptions.svg
- files modified:
- .bzrignore
added
removed
database/schema/diagrams/ticketing.svg
1
1
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
2
2
<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.0//EN"
3
3
"http://www.w3.org/TR/2001/REC-SVG-20010904/DTD/svg10.dtd">
4
<!-- Generated by fdp version 2.2.1 (Thu Apr 14 05:40:09 UTC 2005)
4
<!-- Generated by fdp version 2.2.1 (Tue Oct 11 01:38:21 UTC 2005)
5
5
For user: (stub) Stuart Bishop,,, Title: g Pages: 1 -->
6
6
<svg width="487px" height="535px"
7
7
viewBox = "-1 -1 486 534"
11
11
<title>g</title>
12
12
<text text-anchor="middle" style="font-size:22.00;" x="338" y="731">Ticketing</text>
13
13
<g id="node1" class="node"><title>ticket</title>
14
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="179,524 179,266 369,266 369,524 179,524"/>
15
<polygon style="fill:white;stroke:white;" points="182,281 182,269 366,269 366,281 182,281"/>
16
<text text-anchor="middle" style="font-size:6.00;" x="274" y="277">ticket</text>
17
<polygon style="fill:none;stroke:black;" points="182,281 182,269 366,269 366,281 182,281"/>
18
<text text-anchor="middle" style="font-size:6.00;" x="187" y="290">id</text>
19
<text text-anchor="middle" style="font-size:6.00;" x="246" y="290">serial</text>
20
<text text-anchor="middle" style="font-size:6.00;" x="295" y="290"> PRIMARY KEY </text>
21
<text text-anchor="middle" style="font-size:6.00;" x="193" y="302">owner</text>
22
<text text-anchor="middle" style="font-size:6.00;" x="248" y="302">integer</text>
23
<text text-anchor="middle" style="font-size:6.00;" x="302" y="302"> REFERENCES person </text>
24
<text text-anchor="middle" style="font-size:6.00;" x="190" y="314">title</text>
25
<text text-anchor="middle" style="font-size:6.00;" x="245" y="314">text</text>
26
<text text-anchor="middle" style="font-size:6.00;" x="199" y="326">description</text>
27
<text text-anchor="middle" style="font-size:6.00;" x="245" y="326">text</text>
28
<text text-anchor="middle" style="font-size:6.00;" x="195" y="338">assignee</text>
29
<text text-anchor="middle" style="font-size:6.00;" x="248" y="338">integer</text>
30
<text text-anchor="middle" style="font-size:6.00;" x="302" y="338"> REFERENCES person </text>
31
<text text-anchor="middle" style="font-size:6.00;" x="196" y="350">answerer</text>
32
<text text-anchor="middle" style="font-size:6.00;" x="248" y="350">integer</text>
33
<text text-anchor="middle" style="font-size:6.00;" x="302" y="350"> REFERENCES person </text>
34
<text text-anchor="middle" style="font-size:6.00;" x="194" y="362">product</text>
35
<text text-anchor="middle" style="font-size:6.00;" x="248" y="362">integer</text>
36
<text text-anchor="middle" style="font-size:6.00;" x="303" y="362"> REFERENCES product </text>
37
<text text-anchor="middle" style="font-size:6.00;" x="199" y="374">distribution</text>
38
<text text-anchor="middle" style="font-size:6.00;" x="248" y="374">integer</text>
39
<text text-anchor="middle" style="font-size:6.00;" x="308" y="374"> REFERENCES distribution </text>
40
<text text-anchor="middle" style="font-size:6.00;" x="209" y="386">sourcepackagename</text>
41
<text text-anchor="middle" style="font-size:6.00;" x="248" y="386">integer</text>
42
<text text-anchor="middle" style="font-size:6.00;" x="318" y="386"> REFERENCES sourcepackagename </text>
43
<text text-anchor="middle" style="font-size:6.00;" x="192" y="398">status</text>
44
<text text-anchor="middle" style="font-size:6.00;" x="248" y="398">integer</text>
45
<text text-anchor="middle" style="font-size:6.00;" x="194" y="410">priority</text>
46
<text text-anchor="middle" style="font-size:6.00;" x="248" y="410">integer</text>
47
<text text-anchor="middle" style="font-size:6.00;" x="199" y="422">datecreated</text>
48
<text text-anchor="middle" style="font-size:6.00;" x="253" y="422">timestamp</text>
49
<text text-anchor="middle" style="font-size:6.00;" x="201" y="434">datelastquery</text>
50
<text text-anchor="middle" style="font-size:6.00;" x="253" y="434">timestamp</text>
51
<text text-anchor="middle" style="font-size:6.00;" x="201" y="446">dateaccepted</text>
52
<text text-anchor="middle" style="font-size:6.00;" x="253" y="446">timestamp</text>
53
<text text-anchor="middle" style="font-size:6.00;" x="195" y="458">datedue</text>
54
<text text-anchor="middle" style="font-size:6.00;" x="253" y="458">timestamp</text>
55
<text text-anchor="middle" style="font-size:6.00;" x="205" y="470">datelastresponse</text>
56
<text text-anchor="middle" style="font-size:6.00;" x="253" y="470">timestamp</text>
57
<text text-anchor="middle" style="font-size:6.00;" x="201" y="482">dateanswered</text>
58
<text text-anchor="middle" style="font-size:6.00;" x="253" y="482">timestamp</text>
59
<text text-anchor="middle" style="font-size:6.00;" x="198" y="494">dateclosed</text>
60
<text text-anchor="middle" style="font-size:6.00;" x="253" y="494">timestamp</text>
61
<text text-anchor="middle" style="font-size:6.00;" x="199" y="506">whiteboard</text>
62
<text text-anchor="middle" style="font-size:6.00;" x="245" y="506">text</text>
63
<text text-anchor="middle" style="font-size:6.00;" x="188" y="518">fti</text>
64
<text text-anchor="middle" style="font-size:6.00;" x="250" y="518">tsvector</text>
65
<polygon style="fill:none;stroke:black;" points="179,524 179,266 369,266 369,524 179,524"/>
14
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="180,524 180,266 370,266 370,524 180,524"/>
15
<polygon style="fill:white;stroke:white;" points="183,281 183,269 367,269 367,281 183,281"/>
16
<text text-anchor="middle" style="font-size:6.00;" x="275" y="277">ticket</text>
17
<polygon style="fill:none;stroke:black;" points="183,281 183,269 367,269 367,281 183,281"/>
18
<text text-anchor="middle" style="font-size:6.00;" x="188" y="290">id</text>
19
<text text-anchor="middle" style="font-size:6.00;" x="247" y="290">serial</text>
20
<text text-anchor="middle" style="font-size:6.00;" x="296" y="290"> PRIMARY KEY </text>
21
<text text-anchor="middle" style="font-size:6.00;" x="194" y="302">owner</text>
22
<text text-anchor="middle" style="font-size:6.00;" x="249" y="302">integer</text>
23
<text text-anchor="middle" style="font-size:6.00;" x="303" y="302"> REFERENCES person </text>
24
<text text-anchor="middle" style="font-size:6.00;" x="191" y="314">title</text>
25
<text text-anchor="middle" style="font-size:6.00;" x="246" y="314">text</text>
26
<text text-anchor="middle" style="font-size:6.00;" x="200" y="326">description</text>
27
<text text-anchor="middle" style="font-size:6.00;" x="246" y="326">text</text>
28
<text text-anchor="middle" style="font-size:6.00;" x="196" y="338">assignee</text>
29
<text text-anchor="middle" style="font-size:6.00;" x="249" y="338">integer</text>
30
<text text-anchor="middle" style="font-size:6.00;" x="303" y="338"> REFERENCES person </text>
31
<text text-anchor="middle" style="font-size:6.00;" x="197" y="350">answerer</text>
32
<text text-anchor="middle" style="font-size:6.00;" x="249" y="350">integer</text>
33
<text text-anchor="middle" style="font-size:6.00;" x="303" y="350"> REFERENCES person </text>
34
<text text-anchor="middle" style="font-size:6.00;" x="195" y="362">product</text>
35
<text text-anchor="middle" style="font-size:6.00;" x="249" y="362">integer</text>
36
<text text-anchor="middle" style="font-size:6.00;" x="304" y="362"> REFERENCES product </text>
37
<text text-anchor="middle" style="font-size:6.00;" x="200" y="374">distribution</text>
38
<text text-anchor="middle" style="font-size:6.00;" x="249" y="374">integer</text>
39
<text text-anchor="middle" style="font-size:6.00;" x="309" y="374"> REFERENCES distribution </text>
40
<text text-anchor="middle" style="font-size:6.00;" x="210" y="386">sourcepackagename</text>
41
<text text-anchor="middle" style="font-size:6.00;" x="249" y="386">integer</text>
42
<text text-anchor="middle" style="font-size:6.00;" x="319" y="386"> REFERENCES sourcepackagename </text>
43
<text text-anchor="middle" style="font-size:6.00;" x="193" y="398">status</text>
44
<text text-anchor="middle" style="font-size:6.00;" x="249" y="398">integer</text>
45
<text text-anchor="middle" style="font-size:6.00;" x="195" y="410">priority</text>
46
<text text-anchor="middle" style="font-size:6.00;" x="249" y="410">integer</text>
47
<text text-anchor="middle" style="font-size:6.00;" x="200" y="422">datecreated</text>
48
<text text-anchor="middle" style="font-size:6.00;" x="254" y="422">timestamp</text>
49
<text text-anchor="middle" style="font-size:6.00;" x="202" y="434">datelastquery</text>
50
<text text-anchor="middle" style="font-size:6.00;" x="254" y="434">timestamp</text>
51
<text text-anchor="middle" style="font-size:6.00;" x="202" y="446">dateaccepted</text>
52
<text text-anchor="middle" style="font-size:6.00;" x="254" y="446">timestamp</text>
53
<text text-anchor="middle" style="font-size:6.00;" x="196" y="458">datedue</text>
54
<text text-anchor="middle" style="font-size:6.00;" x="254" y="458">timestamp</text>
55
<text text-anchor="middle" style="font-size:6.00;" x="206" y="470">datelastresponse</text>
56
<text text-anchor="middle" style="font-size:6.00;" x="254" y="470">timestamp</text>
57
<text text-anchor="middle" style="font-size:6.00;" x="202" y="482">dateanswered</text>
58
<text text-anchor="middle" style="font-size:6.00;" x="254" y="482">timestamp</text>
59
<text text-anchor="middle" style="font-size:6.00;" x="199" y="494">dateclosed</text>
60
<text text-anchor="middle" style="font-size:6.00;" x="254" y="494">timestamp</text>
61
<text text-anchor="middle" style="font-size:6.00;" x="200" y="506">whiteboard</text>
62
<text text-anchor="middle" style="font-size:6.00;" x="246" y="506">text</text>
63
<text text-anchor="middle" style="font-size:6.00;" x="189" y="518">fti</text>
64
<text text-anchor="middle" style="font-size:6.00;" x="251" y="518">tsvector</text>
65
<polygon style="fill:none;stroke:black;" points="180,524 180,266 370,266 370,524 180,524"/>
66
66
</g>
67
<g id="node6" class="node"><title>fake_person_316</title>
67
<g id="node6" class="node"><title>fake_person_332</title>
68
68
<ellipse cx="33" cy="317" rx="27" ry="18" style="fill:none;stroke:red;"/>
69
69
<text text-anchor="middle" style="font-size:6.00;" x="33" y="319">person</text>
70
70
</g>
71
<g id="edge2" class="edge"><title>ticket->fake_person_316</title>
72
<path style="fill:none;stroke:black;" d="M171,362C134,350 95,337 68,328"/>
71
<g id="edge2" class="edge"><title>ticket->fake_person_332</title>
72
<path style="fill:none;stroke:black;" d="M172,362C135,350 95,336 68,328"/>
73
73
<polygon style="fill:black;stroke:black;" points="67,331 58,325 69,325 67,331"/>
74
74
</g>
75
<g id="node8" class="node"><title>fake_person_318</title>
75
<g id="node8" class="node"><title>fake_person_334</title>
76
76
<ellipse cx="36" cy="463" rx="27" ry="18" style="fill:none;stroke:red;"/>
77
77
<text text-anchor="middle" style="font-size:6.00;" x="36" y="465">person</text>
78
78
</g>
79
<g id="edge4" class="edge"><title>ticket->fake_person_318</title>
80
<path style="fill:none;stroke:black;" d="M171,424C136,435 97,445 71,453"/>
79
<g id="edge4" class="edge"><title>ticket->fake_person_334</title>
80
<path style="fill:none;stroke:black;" d="M172,424C136,435 97,445 71,453"/>
81
81
<polygon style="fill:black;stroke:black;" points="72,456 61,456 70,450 72,456"/>
82
82
</g>
83
<g id="node10" class="node"><title>fake_person_320</title>
83
<g id="node10" class="node"><title>fake_person_336</title>
84
84
<ellipse cx="490" cy="507" rx="27" ry="18" style="fill:none;stroke:red;"/>
85
85
<text text-anchor="middle" style="font-size:6.00;" x="490" y="509">person</text>
86
86
</g>
87
<g id="edge6" class="edge"><title>ticket->fake_person_320</title>
88
<path style="fill:none;stroke:black;" d="M377,449C407,464 438,480 460,491"/>
87
<g id="edge6" class="edge"><title>ticket->fake_person_336</title>
88
<path style="fill:none;stroke:black;" d="M378,449C408,464 438,480 460,491"/>
89
89
<polygon style="fill:black;stroke:black;" points="462,488 469,496 459,494 462,488"/>
90
90
</g>
91
<g id="node12" class="node"><title>fake_product_322</title>
91
<g id="node12" class="node"><title>fake_product_338</title>
92
92
<ellipse cx="118" cy="591" rx="27" ry="18" style="fill:none;stroke:red;"/>
93
93
<text text-anchor="middle" style="font-size:6.00;" x="118" y="593">product</text>
94
94
</g>
95
<g id="edge8" class="edge"><title>ticket->fake_product_322</title>
96
<path style="fill:none;stroke:black;" d="M171,525C158,541 147,556 138,567"/>
97
<polygon style="fill:black;stroke:black;" points="140,570 131,575 135,565 140,570"/>
95
<g id="edge8" class="edge"><title>ticket->fake_product_338</title>
96
<path style="fill:none;stroke:black;" d="M172,524C158,540 147,556 137,567"/>
97
<polygon style="fill:black;stroke:black;" points="140,569 131,575 134,565 140,569"/>
98
98
</g>
99
<g id="node14" class="node"><title>fake_distribution_324</title>
99
<g id="node14" class="node"><title>fake_distribution_340</title>
100
100
<ellipse cx="231" cy="617" rx="27" ry="18" style="fill:none;stroke:red;"/>
101
101
<text text-anchor="middle" style="font-size:6.00;" x="231" y="619">distribution</text>
102
102
</g>
103
<g id="edge10" class="edge"><title>ticket->fake_distribution_324</title>
104
<path style="fill:none;stroke:black;" d="M248,528C244,551 240,573 236,589"/>
103
<g id="edge10" class="edge"><title>ticket->fake_distribution_340</title>
104
<path style="fill:none;stroke:black;" d="M249,528C244,551 240,573 236,589"/>
105
105
<polygon style="fill:black;stroke:black;" points="239,590 234,599 233,589 239,590"/>
106
106
</g>
107
<g id="node16" class="node"><title>fake_sourcepackagename_326</title>
107
<g id="node16" class="node"><title>fake_sourcepackagename_342</title>
108
108
<ellipse cx="463" cy="245" rx="35" ry="18" style="fill:none;stroke:red;"/>
109
109
<text text-anchor="middle" style="font-size:6.00;" x="463" y="247">sourcepackagename</text>
110
110
</g>
111
<g id="edge12" class="edge"><title>ticket->fake_sourcepackagename_326</title>
112
<path style="fill:none;stroke:black;" d="M377,313C398,296 420,279 436,266"/>
113
<polygon style="fill:black;stroke:black;" points="434,263 444,260 438,269 434,263"/>
111
<g id="edge12" class="edge"><title>ticket->fake_sourcepackagename_342</title>
112
<path style="fill:none;stroke:black;" d="M378,313C399,296 420,279 436,267"/>
113
<polygon style="fill:black;stroke:black;" points="434,264 444,260 439,269 434,264"/>
114
114
</g>
115
115
<g id="node2" class="node"><title>ticketbug</title>
116
116
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="124,233 124,179 260,179 260,233 124,233"/>
132
132
<path style="fill:none;stroke:black;" d="M206,237C208,242 210,247 213,253"/>
133
133
<polygon style="fill:black;stroke:black;" points="216,251 217,262 210,254 216,251"/>
134
134
</g>
135
<g id="node19" class="node"><title>fake_bug_329</title>
136
<ellipse cx="68" cy="143" rx="27" ry="18" style="fill:none;stroke:red;"/>
137
<text text-anchor="middle" style="font-size:6.00;" x="68" y="145">bug</text>
135
<g id="node19" class="node"><title>fake_bug_345</title>
136
<ellipse cx="67" cy="143" rx="27" ry="18" style="fill:none;stroke:red;"/>
137
<text text-anchor="middle" style="font-size:6.00;" x="67" y="145">bug</text>
138
138
</g>
139
<g id="edge16" class="edge"><title>ticketbug->fake_bug_329</title>
140
<path style="fill:none;stroke:black;" d="M131,175C120,169 108,163 98,159"/>
139
<g id="edge16" class="edge"><title>ticketbug->fake_bug_345</title>
140
<path style="fill:none;stroke:black;" d="M130,175C119,169 108,164 98,159"/>
141
141
<polygon style="fill:black;stroke:black;" points="96,162 89,154 99,156 96,162"/>
142
142
</g>
143
143
<g id="node3" class="node"><title>ticketmessage</title>
157
157
<polygon style="fill:none;stroke:black;" points="286,702 286,648 436,648 436,702 286,702"/>
158
158
</g>
159
159
<g id="edge18" class="edge"><title>ticketmessage->ticket</title>
160
<path style="fill:none;stroke:black;" d="M351,644C343,618 331,578 318,538"/>
161
<polygon style="fill:black;stroke:black;" points="315,539 315,528 321,537 315,539"/>
160
<path style="fill:none;stroke:black;" d="M351,644C343,618 331,578 319,538"/>
161
<polygon style="fill:black;stroke:black;" points="316,539 316,528 322,537 316,539"/>
162
162
</g>
163
<g id="node22" class="node"><title>fake_message_332</title>
163
<g id="node22" class="node"><title>fake_message_348</title>
164
164
<ellipse cx="499" cy="646" rx="27" ry="18" style="fill:none;stroke:red;"/>
165
165
<text text-anchor="middle" style="font-size:6.00;" x="499" y="648">message</text>
166
166
</g>
167
<g id="edge20" class="edge"><title>ticketmessage->fake_message_332</title>
167
<g id="edge20" class="edge"><title>ticketmessage->fake_message_348</title>
168
168
<path style="fill:none;stroke:black;" d="M444,658C450,656 457,655 463,653"/>
169
169
<polygon style="fill:black;stroke:black;" points="463,650 473,651 464,656 463,650"/>
170
170
</g>
197
197
<path style="fill:none;stroke:black;" d="M372,144C360,175 345,214 330,253"/>
198
198
<polygon style="fill:black;stroke:black;" points="333,254 326,262 327,251 333,254"/>
199
199
</g>
200
<g id="node25" class="node"><title>fake_person_335</title>
200
<g id="node25" class="node"><title>fake_person_351</title>
201
201
<ellipse cx="542" cy="125" rx="27" ry="18" style="fill:none;stroke:red;"/>
202
202
<text text-anchor="middle" style="font-size:6.00;" x="542" y="127">person</text>
203
203
</g>
204
<g id="edge24" class="edge"><title>ticketreopening->fake_person_335</title>
204
<g id="edge24" class="edge"><title>ticketreopening->fake_person_351</title>
205
205
<path style="fill:none;stroke:black;" d="M473,108C485,111 497,114 507,117"/>
206
206
<polygon style="fill:black;stroke:black;" points="508,114 517,119 507,120 508,114"/>
207
207
</g>
208
<g id="node27" class="node"><title>fake_person_337</title>
208
<g id="node27" class="node"><title>fake_person_353</title>
209
209
<ellipse cx="260" cy="27" rx="27" ry="18" style="fill:none;stroke:red;"/>
210
210
<text text-anchor="middle" style="font-size:6.00;" x="260" y="29">person</text>
211
211
</g>
212
<g id="edge26" class="edge"><title>ticketreopening->fake_person_337</title>
212
<g id="edge26" class="edge"><title>ticketreopening->fake_person_353</title>
213
213
<path style="fill:none;stroke:black;" d="M313,52C306,49 298,45 291,42"/>
214
214
<polygon style="fill:black;stroke:black;" points="290,45 282,38 293,39 290,45"/>
215
215
</g>
230
230
<polygon style="fill:none;stroke:black;" points="508,414 508,360 650,360 650,414 508,414"/>
231
231
</g>
232
232
<g id="edge28" class="edge"><title>ticketsubscription->ticket</title>
233
<path style="fill:none;stroke:black;" d="M500,389C465,390 425,391 387,392"/>
234
<polygon style="fill:black;stroke:black;" points="387,395 377,392 387,388 387,395"/>
233
<path style="fill:none;stroke:black;" d="M500,389C466,390 426,391 388,392"/>
234
<polygon style="fill:black;stroke:black;" points="388,395 378,392 388,388 388,395"/>
235
235
</g>
236
<g id="node30" class="node"><title>fake_person_340</title>
236
<g id="node30" class="node"><title>fake_person_356</title>
237
237
<ellipse cx="644" cy="309" rx="27" ry="18" style="fill:none;stroke:red;"/>
238
238
<text text-anchor="middle" style="font-size:6.00;" x="644" y="311">person</text>
239
239
</g>
240
<g id="edge30" class="edge"><title>ticketsubscription->fake_person_340</title>
240
<g id="edge30" class="edge"><title>ticketsubscription->fake_person_356</title>
241
241
<path style="fill:none;stroke:black;" d="M605,356C612,348 618,340 624,333"/>
242
242
<polygon style="fill:black;stroke:black;" points="622,330 631,325 627,335 622,330"/>
243
243
</g>
Loggerhead is a web-based interface for Breezy
Version: 2.0.1