← Back to branch summary

~launchpad-pqm/launchpad/devel

« back to all changes in this revision

Viewing changes to database/schema/diagrams/subscriptions.svg

  • 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

Show diffs side-by-side

added added

removed removed

Lines of Context:
database/schema/diagrams/subscriptions.svg
 
1
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
 
2
<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.0//EN"
 
3
 "http://www.w3.org/TR/2001/REC-SVG-20010904/DTD/svg10.dtd">
 
4
<!-- Generated by fdp version 2.2.1 (Tue Oct 11 01:38:21 UTC 2005)
 
5
     For user: (stub) Stuart Bishop,,,   Title: g    Pages: 1 -->
 
6
<svg width="457px" height="535px"
 
7
 viewBox = "-1 -1 456 534"
 
8
 xmlns="http://www.w3.org/2000/svg">
 
9
<g id="graph0" class="graph" transform = "scale(0.393529)"
 
10
 style="font-family:Times-Roman;font-size:14.00;">
 
11
<title>g</title>
 
12
<text text-anchor="middle" style="font-size:22.00;" x="571" y="1338">Subscriptions</text>
 
13
<g id="node1" class="node"><title>bountysubscription</title>
 
14
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="122,974 122,920 266,920 266,974 122,974"/>
 
15
<polygon style="fill:white;stroke:white;" points="125,935 125,923 263,923 263,935 125,935"/>
 
16
<text text-anchor="middle" style="font-size:6.00;" x="194" y="931">bountysubscription</text>
 
17
<polygon style="fill:none;stroke:black;" points="125,935 125,923 263,923 263,935 125,935"/>
 
18
<text text-anchor="middle" style="font-size:6.00;" x="130" y="944">id</text>
 
19
<text text-anchor="middle" style="font-size:6.00;" x="159" y="944">serial</text>
 
20
<text text-anchor="middle" style="font-size:6.00;" x="199" y="944"> PRIMARY KEY </text>
 
21
<text text-anchor="middle" style="font-size:6.00;" x="137" y="956">bounty</text>
 
22
<text text-anchor="middle" style="font-size:6.00;" x="161" y="956">integer</text>
 
23
<text text-anchor="middle" style="font-size:6.00;" x="219" y="956"> REFERENCES bounty UNIQUE </text>
 
24
<text text-anchor="middle" style="font-size:6.00;" x="136" y="968">person</text>
 
25
<text text-anchor="middle" style="font-size:6.00;" x="161" y="968">integer</text>
 
26
<text text-anchor="middle" style="font-size:6.00;" x="218" y="968"> REFERENCES person UNIQUE </text>
 
27
<polygon style="fill:none;stroke:black;" points="122,974 122,920 266,920 266,974 122,974"/>
 
28
</g>
 
29
<g id="node6" class="node"><title>person</title>
 
30
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="475,986 475,620 677,620 677,986 475,986"/>
 
31
<polygon style="fill:white;stroke:white;" points="478,635 478,623 674,623 674,635 478,635"/>
 
32
<text text-anchor="middle" style="font-size:6.00;" x="576" y="631">person</text>
 
33
<polygon style="fill:none;stroke:black;" points="478,635 478,623 674,623 674,635 478,635"/>
 
34
<text text-anchor="middle" style="font-size:6.00;" x="483" y="644">id</text>
 
35
<text text-anchor="middle" style="font-size:6.00;" x="558" y="644">serial</text>
 
36
<text text-anchor="middle" style="font-size:6.00;" x="607" y="644"> PRIMARY KEY </text>
 
37
<text text-anchor="middle" style="font-size:6.00;" x="496" y="656">displayname</text>
 
38
<text text-anchor="middle" style="font-size:6.00;" x="557" y="656">text</text>
 
39
<text text-anchor="middle" style="font-size:6.00;" x="494" y="668">givenname</text>
 
40
<text text-anchor="middle" style="font-size:6.00;" x="557" y="668">text</text>
 
41
<text text-anchor="middle" style="font-size:6.00;" x="495" y="680">familyname</text>
 
42
<text text-anchor="middle" style="font-size:6.00;" x="557" y="680">text</text>
 
43
<text text-anchor="middle" style="font-size:6.00;" x="492" y="692">password</text>
 
44
<text text-anchor="middle" style="font-size:6.00;" x="557" y="692">text</text>
 
45
<text text-anchor="middle" style="font-size:6.00;" x="494" y="704">teamowner</text>
 
46
<text text-anchor="middle" style="font-size:6.00;" x="560" y="704">integer</text>
 
47
<text text-anchor="middle" style="font-size:6.00;" x="614" y="704"> REFERENCES person </text>
 
48
<text text-anchor="middle" style="font-size:6.00;" x="501" y="716">teamdescription</text>
 
49
<text text-anchor="middle" style="font-size:6.00;" x="557" y="716">text</text>
 
50
<text text-anchor="middle" style="font-size:6.00;" x="488" y="728">name</text>
 
51
<text text-anchor="middle" style="font-size:6.00;" x="557" y="728">text</text>
 
52
<text text-anchor="middle" style="font-size:6.00;" x="492" y="740">language</text>
 
53
<text text-anchor="middle" style="font-size:6.00;" x="560" y="740">integer</text>
 
54
<text text-anchor="middle" style="font-size:6.00;" x="617" y="740"> REFERENCES language </text>
 
55
<text text-anchor="middle" style="font-size:6.00;" x="484" y="752">fti</text>
 
56
<text text-anchor="middle" style="font-size:6.00;" x="562" y="752">tsvector</text>
 
57
<text text-anchor="middle" style="font-size:6.00;" x="512" y="764">defaultmembershipperiod</text>
 
58
<text text-anchor="middle" style="font-size:6.00;" x="560" y="764">integer</text>
 
59
<text text-anchor="middle" style="font-size:6.00;" x="507" y="776">defaultrenewalperiod</text>
 
60
<text text-anchor="middle" style="font-size:6.00;" x="560" y="776">integer</text>
 
61
<text text-anchor="middle" style="font-size:6.00;" x="503" y="788">subscriptionpolicy</text>
 
62
<text text-anchor="middle" style="font-size:6.00;" x="560" y="788">integer</text>
 
63
<text text-anchor="middle" style="font-size:6.00;" x="490" y="800">merged</text>
 
64
<text text-anchor="middle" style="font-size:6.00;" x="560" y="800">integer</text>
 
65
<text text-anchor="middle" style="font-size:6.00;" x="614" y="800"> REFERENCES person </text>
 
66
<text text-anchor="middle" style="font-size:6.00;" x="495" y="812">datecreated</text>
 
67
<text text-anchor="middle" style="font-size:6.00;" x="565" y="812">timestamp</text>
 
68
<text text-anchor="middle" style="font-size:6.00;" x="491" y="824">calendar</text>
 
69
<text text-anchor="middle" style="font-size:6.00;" x="560" y="824">integer</text>
 
70
<text text-anchor="middle" style="font-size:6.00;" x="628" y="824"> REFERENCES calendar UNIQUE </text>
 
71
<text text-anchor="middle" style="font-size:6.00;" x="492" y="836">timezone</text>
 
72
<text text-anchor="middle" style="font-size:6.00;" x="557" y="836">text</text>
 
73
<text text-anchor="middle" style="font-size:6.00;" x="489" y="848">karma</text>
 
74
<text text-anchor="middle" style="font-size:6.00;" x="560" y="848">integer</text>
 
75
<text text-anchor="middle" style="font-size:6.00;" x="496" y="860">addressline1</text>
 
76
<text text-anchor="middle" style="font-size:6.00;" x="557" y="860">text</text>
 
77
<text text-anchor="middle" style="font-size:6.00;" x="496" y="872">addressline2</text>
 
78
<text text-anchor="middle" style="font-size:6.00;" x="557" y="872">text</text>
 
79
<text text-anchor="middle" style="font-size:6.00;" x="496" y="884">organization</text>
 
80
<text text-anchor="middle" style="font-size:6.00;" x="557" y="884">text</text>
 
81
<text text-anchor="middle" style="font-size:6.00;" x="486" y="896">city</text>
 
82
<text text-anchor="middle" style="font-size:6.00;" x="557" y="896">text</text>
 
83
<text text-anchor="middle" style="font-size:6.00;" x="492" y="908">province</text>
 
84
<text text-anchor="middle" style="font-size:6.00;" x="557" y="908">text</text>
 
85
<text text-anchor="middle" style="font-size:6.00;" x="491" y="920">country</text>
 
86
<text text-anchor="middle" style="font-size:6.00;" x="560" y="920">integer</text>
 
87
<text text-anchor="middle" style="font-size:6.00;" x="616" y="920"> REFERENCES country </text>
 
88
<text text-anchor="middle" style="font-size:6.00;" x="492" y="932">postcode</text>
 
89
<text text-anchor="middle" style="font-size:6.00;" x="557" y="932">text</text>
 
90
<text text-anchor="middle" style="font-size:6.00;" x="489" y="944">phone</text>
 
91
<text text-anchor="middle" style="font-size:6.00;" x="557" y="944">text</text>
 
92
<text text-anchor="middle" style="font-size:6.00;" x="504" y="956">homepage_content</text>
 
93
<text text-anchor="middle" style="font-size:6.00;" x="557" y="956">text</text>
 
94
<text text-anchor="middle" style="font-size:6.00;" x="491" y="968">emblem</text>
 
95
<text text-anchor="middle" style="font-size:6.00;" x="560" y="968">integer</text>
 
96
<text text-anchor="middle" style="font-size:6.00;" x="624" y="968"> REFERENCES libraryfilealias </text>
 
97
<text text-anchor="middle" style="font-size:6.00;" x="497" y="980">hackergotchi</text>
 
98
<text text-anchor="middle" style="font-size:6.00;" x="560" y="980">integer</text>
 
99
<text text-anchor="middle" style="font-size:6.00;" x="624" y="980"> REFERENCES libraryfilealias </text>
 
100
<polygon style="fill:none;stroke:black;" points="475,986 475,620 677,620 677,986 475,986"/>
 
101
</g>
 
102
<g id="edge4" class="edge"><title>bountysubscription&#45;&gt;person</title>
 
103
<path style="fill:none;stroke:black;" d="M274,917C327,897 398,870 458,848"/>
 
104
<polygon style="fill:black;stroke:black;" points="456,845 467,844 459,851 456,845"/>
 
105
</g>
 
106
<g id="node9" class="node"><title>fake_bounty_16</title>
 
107
<ellipse cx="42" cy="1006" rx="27" ry="18" style="fill:none;stroke:red;"/>
 
108
<text text-anchor="middle" style="font-size:6.00;" x="42" y="1008">bounty</text>
 
109
</g>
 
110
<g id="edge2" class="edge"><title>bountysubscription&#45;&gt;fake_bounty_16</title>
 
111
<path style="fill:none;stroke:black;" d="M114,978C100,983 86,989 75,993"/>
 
112
<polygon style="fill:black;stroke:black;" points="76,997 65,997 73,990 76,997"/>
 
113
</g>
 
114
<g id="node2" class="node"><title>branchsubscription</title>
 
115
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="896,927 896,873 1014,873 1014,927 896,927"/>
 
116
<polygon style="fill:white;stroke:white;" points="899,888 899,876 1011,876 1011,888 899,888"/>
 
117
<text text-anchor="middle" style="font-size:6.00;" x="955" y="884">branchsubscription</text>
 
118
<polygon style="fill:none;stroke:black;" points="899,888 899,876 1011,876 1011,888 899,888"/>
 
119
<text text-anchor="middle" style="font-size:6.00;" x="904" y="897">id</text>
 
120
<text text-anchor="middle" style="font-size:6.00;" x="932" y="897">serial</text>
 
121
<text text-anchor="middle" style="font-size:6.00;" x="972" y="897"> PRIMARY KEY </text>
 
122
<text text-anchor="middle" style="font-size:6.00;" x="910" y="909">person</text>
 
123
<text text-anchor="middle" style="font-size:6.00;" x="934" y="909">integer</text>
 
124
<text text-anchor="middle" style="font-size:6.00;" x="979" y="909"> REFERENCES person </text>
 
125
<text text-anchor="middle" style="font-size:6.00;" x="910" y="921">branch</text>
 
126
<text text-anchor="middle" style="font-size:6.00;" x="934" y="921">integer</text>
 
127
<text text-anchor="middle" style="font-size:6.00;" x="979" y="921"> REFERENCES branch </text>
 
128
<polygon style="fill:none;stroke:black;" points="896,927 896,873 1014,873 1014,927 896,927"/>
 
129
</g>
 
130
<g id="edge6" class="edge"><title>branchsubscription&#45;&gt;person</title>
 
131
<path style="fill:none;stroke:black;" d="M888,883C835,870 759,850 695,834"/>
 
132
<polygon style="fill:black;stroke:black;" points="694,837 685,831 696,831 694,837"/>
 
133
</g>
 
134
<g id="node13" class="node"><title>fake_branch_32</title>
 
135
<ellipse cx="1097" cy="940" rx="27" ry="18" style="fill:none;stroke:red;"/>
 
136
<text text-anchor="middle" style="font-size:6.00;" x="1097" y="942">branch</text>
 
137
</g>
 
138
<g id="edge8" class="edge"><title>branchsubscription&#45;&gt;fake_branch_32</title>
 
139
<path style="fill:none;stroke:black;" d="M1022,919C1036,923 1050,927 1062,930"/>
 
140
<polygon style="fill:black;stroke:black;" points="1063,927 1072,933 1061,933 1063,927"/>
 
141
</g>
 
142
<g id="node3" class="node"><title>bugsubscription</title>
 
143
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="344,1185 344,1131 462,1131 462,1185 344,1185"/>
 
144
<polygon style="fill:white;stroke:white;" points="347,1146 347,1134 459,1134 459,1146 347,1146"/>
 
145
<text text-anchor="middle" style="font-size:6.00;" x="403" y="1142">bugsubscription</text>
 
146
<polygon style="fill:none;stroke:black;" points="347,1146 347,1134 459,1134 459,1146 347,1146"/>
 
147
<text text-anchor="middle" style="font-size:6.00;" x="352" y="1155">id</text>
 
148
<text text-anchor="middle" style="font-size:6.00;" x="380" y="1155">serial</text>
 
149
<text text-anchor="middle" style="font-size:6.00;" x="420" y="1155"> PRIMARY KEY </text>
 
150
<text text-anchor="middle" style="font-size:6.00;" x="358" y="1167">person</text>
 
151
<text text-anchor="middle" style="font-size:6.00;" x="382" y="1167">integer</text>
 
152
<text text-anchor="middle" style="font-size:6.00;" x="427" y="1167"> REFERENCES person </text>
 
153
<text text-anchor="middle" style="font-size:6.00;" x="355" y="1179">bug</text>
 
154
<text text-anchor="middle" style="font-size:6.00;" x="382" y="1179">integer</text>
 
155
<text text-anchor="middle" style="font-size:6.00;" x="424" y="1179"> REFERENCES bug </text>
 
156
<polygon style="fill:none;stroke:black;" points="344,1185 344,1131 462,1131 462,1185 344,1185"/>
 
157
</g>
 
158
<g id="edge10" class="edge"><title>bugsubscription&#45;&gt;person</title>
 
159
<path style="fill:none;stroke:black;" d="M418,1127C432,1097 456,1049 481,999"/>
 
160
<polygon style="fill:black;stroke:black;" points="478,998 485,990 484,1001 478,998"/>
 
161
</g>
 
162
<g id="node16" class="node"><title>fake_bug_61</title>
 
163
<ellipse cx="343" cy="1295" rx="27" ry="18" style="fill:none;stroke:red;"/>
 
164
<text text-anchor="middle" style="font-size:6.00;" x="343" y="1297">bug</text>
 
165
</g>
 
166
<g id="edge12" class="edge"><title>bugsubscription&#45;&gt;fake_bug_61</title>
 
167
<path style="fill:none;stroke:black;" d="M389,1189C379,1213 365,1246 355,1269"/>
 
168
<polygon style="fill:black;stroke:black;" points="358,1270 351,1278 352,1267 358,1270"/>
 
169
</g>
 
170
<g id="node4" class="node"><title>message</title>
 
171
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="768,481 768,355 928,355 928,481 768,481"/>
 
172
<polygon style="fill:white;stroke:white;" points="771,370 771,358 925,358 925,370 771,370"/>
 
173
<text text-anchor="middle" style="font-size:6.00;" x="848" y="366">message</text>
 
174
<polygon style="fill:none;stroke:black;" points="771,370 771,358 925,358 925,370 771,370"/>
 
175
<text text-anchor="middle" style="font-size:6.00;" x="776" y="379">id</text>
 
176
<text text-anchor="middle" style="font-size:6.00;" x="818" y="379">serial</text>
 
177
<text text-anchor="middle" style="font-size:6.00;" x="867" y="379"> PRIMARY KEY </text>
 
178
<text text-anchor="middle" style="font-size:6.00;" x="788" y="391">datecreated</text>
 
179
<text text-anchor="middle" style="font-size:6.00;" x="825" y="391">timestamp</text>
 
180
<text text-anchor="middle" style="font-size:6.00;" x="782" y="403">subject</text>
 
181
<text text-anchor="middle" style="font-size:6.00;" x="817" y="403">text</text>
 
182
<text text-anchor="middle" style="font-size:6.00;" x="782" y="415">owner</text>
 
183
<text text-anchor="middle" style="font-size:6.00;" x="820" y="415">integer</text>
 
184
<text text-anchor="middle" style="font-size:6.00;" x="874" y="415"> REFERENCES person </text>
 
185
<text text-anchor="middle" style="font-size:6.00;" x="782" y="427">parent</text>
 
186
<text text-anchor="middle" style="font-size:6.00;" x="820" y="427">integer</text>
 
187
<text text-anchor="middle" style="font-size:6.00;" x="876" y="427"> REFERENCES message </text>
 
188
<text text-anchor="middle" style="font-size:6.00;" x="788" y="439">distribution</text>
 
189
<text text-anchor="middle" style="font-size:6.00;" x="820" y="439">integer</text>
 
190
<text text-anchor="middle" style="font-size:6.00;" x="880" y="439"> REFERENCES distribution </text>
 
191
<text text-anchor="middle" style="font-size:6.00;" x="789" y="451">rfc822msgid</text>
 
192
<text text-anchor="middle" style="font-size:6.00;" x="817" y="451">text</text>
 
193
<text text-anchor="middle" style="font-size:6.00;" x="777" y="463">fti</text>
 
194
<text text-anchor="middle" style="font-size:6.00;" x="822" y="463">tsvector</text>
 
195
<text text-anchor="middle" style="font-size:6.00;" x="778" y="475">raw</text>
 
196
<text text-anchor="middle" style="font-size:6.00;" x="820" y="475">integer</text>
 
197
<text text-anchor="middle" style="font-size:6.00;" x="884" y="475"> REFERENCES libraryfilealias </text>
 
198
<polygon style="fill:none;stroke:black;" points="768,481 768,355 928,355 928,481 768,481"/>
 
199
</g>
 
200
<g id="edge16" class="edge"><title>message&#45;&gt;message</title>
 
201
<path style="fill:none;stroke:black;" d="M936,461C947,454 954,439 954,418 954,402 950,390 943,382"/>
 
202
<polygon style="fill:black;stroke:black;" points="941,385 936,375 946,380 941,385"/>
 
203
</g>
 
204
<g id="edge14" class="edge"><title>message&#45;&gt;person</title>
 
205
<path style="fill:none;stroke:black;" d="M801,485C771,528 729,586 691,641"/>
 
206
<polygon style="fill:black;stroke:black;" points="694,643 685,649 688,639 694,643"/>
 
207
</g>
 
208
<g id="node20" class="node"><title>fake_distribution_149</title>
 
209
<ellipse cx="815" cy="230" rx="27" ry="18" style="fill:none;stroke:red;"/>
 
210
<text text-anchor="middle" style="font-size:6.00;" x="815" y="232">distribution</text>
 
211
</g>
 
212
<g id="edge18" class="edge"><title>message&#45;&gt;fake_distribution_149</title>
 
213
<path style="fill:none;stroke:black;" d="M836,351C831,319 824,283 820,258"/>
 
214
<polygon style="fill:black;stroke:black;" points="817,258 818,248 823,257 817,258"/>
 
215
</g>
 
216
<g id="node22" class="node"><title>fake_libraryfilealias_151</title>
 
217
<ellipse cx="1035" cy="383" rx="29" ry="18" style="fill:none;stroke:red;"/>
 
218
<text text-anchor="middle" style="font-size:6.00;" x="1035" y="385">libraryfilealias</text>
 
219
</g>
 
220
<g id="edge20" class="edge"><title>message&#45;&gt;fake_libraryfilealias_151</title>
 
221
<path style="fill:none;stroke:black;" d="M936,402C958,398 979,394 997,390"/>
 
222
<polygon style="fill:black;stroke:black;" points="997,387 1007,388 998,393 997,387"/>
 
223
</g>
 
224
<g id="node5" class="node"><title>messagechunk</title>
 
225
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="930,229 930,139 1084,139 1084,229 930,229"/>
 
226
<polygon style="fill:white;stroke:white;" points="933,154 933,142 1081,142 1081,154 933,154"/>
 
227
<text text-anchor="middle" style="font-size:6.00;" x="1007" y="150">messagechunk</text>
 
228
<polygon style="fill:none;stroke:black;" points="933,154 933,142 1081,142 1081,154 933,154"/>
 
229
<text text-anchor="middle" style="font-size:6.00;" x="938" y="163">id</text>
 
230
<text text-anchor="middle" style="font-size:6.00;" x="971" y="163">serial</text>
 
231
<text text-anchor="middle" style="font-size:6.00;" x="1014" y="163"> PRIMARY KEY </text>
 
232
<text text-anchor="middle" style="font-size:6.00;" x="946" y="175">message</text>
 
233
<text text-anchor="middle" style="font-size:6.00;" x="973" y="175">integer</text>
 
234
<text text-anchor="middle" style="font-size:6.00;" x="1035" y="175"> REFERENCES message UNIQUE </text>
 
235
<text text-anchor="middle" style="font-size:6.00;" x="947" y="187">sequence</text>
 
236
<text text-anchor="middle" style="font-size:6.00;" x="973" y="187">integer</text>
 
237
<text text-anchor="middle" style="font-size:6.00;" x="1005" y="187"> UNIQUE </text>
 
238
<text text-anchor="middle" style="font-size:6.00;" x="945" y="199">content</text>
 
239
<text text-anchor="middle" style="font-size:6.00;" x="970" y="199">text</text>
 
240
<text text-anchor="middle" style="font-size:6.00;" x="942" y="211">blob</text>
 
241
<text text-anchor="middle" style="font-size:6.00;" x="973" y="211">integer</text>
 
242
<text text-anchor="middle" style="font-size:6.00;" x="1031" y="211"> REFERENCES libraryfilealias </text>
 
243
<text text-anchor="middle" style="font-size:6.00;" x="939" y="223">fti</text>
 
244
<text text-anchor="middle" style="font-size:6.00;" x="975" y="223">tsvector</text>
 
245
<polygon style="fill:none;stroke:black;" points="930,229 930,139 1084,139 1084,229 930,229"/>
 
246
</g>
 
247
<g id="edge22" class="edge"><title>messagechunk&#45;&gt;message</title>
 
248
<path style="fill:none;stroke:black;" d="M974,233C953,264 924,306 900,342"/>
 
249
<polygon style="fill:black;stroke:black;" points="902,345 894,351 897,341 902,345"/>
 
250
</g>
 
251
<g id="node25" class="node"><title>fake_libraryfilealias_154</title>
 
252
<ellipse cx="1107" cy="38" rx="29" ry="18" style="fill:none;stroke:red;"/>
 
253
<text text-anchor="middle" style="font-size:6.00;" x="1107" y="40">libraryfilealias</text>
 
254
</g>
 
255
<g id="edge24" class="edge"><title>messagechunk&#45;&gt;fake_libraryfilealias_154</title>
 
256
<path style="fill:none;stroke:black;" d="M1041,135C1057,111 1077,83 1090,63"/>
 
257
<polygon style="fill:black;stroke:black;" points="1087,61 1096,55 1093,65 1087,61"/>
 
258
</g>
 
259
<g id="edge26" class="edge"><title>person&#45;&gt;person</title>
 
260
<path style="fill:none;stroke:black;" d="M685,860C696,848 703,830 703,803 703,781 699,766 691,754"/>
 
261
<polygon style="fill:black;stroke:black;" points="688,756 685,746 694,752 688,756"/>
 
262
</g>
 
263
<g id="edge30" class="edge"><title>person&#45;&gt;person</title>
 
264
<path style="fill:none;stroke:black;" d="M685,936C706,920 721,876 721,803 721,739 709,697 692,677"/>
 
265
<polygon style="fill:black;stroke:black;" points="690,680 685,670 695,675 690,680"/>
 
266
</g>
 
267
<g id="node28" class="node"><title>fake_language_179</title>
 
268
<ellipse cx="380" cy="551" rx="27" ry="18" style="fill:none;stroke:red;"/>
 
269
<text text-anchor="middle" style="font-size:6.00;" x="380" y="553">language</text>
 
270
</g>
 
271
<g id="edge28" class="edge"><title>person&#45;&gt;fake_language_179</title>
 
272
<path style="fill:none;stroke:black;" d="M467,663C441,629 415,596 398,575"/>
 
273
<polygon style="fill:black;stroke:black;" points="395,577 392,567 401,573 395,577"/>
 
274
</g>
 
275
<g id="node31" class="node"><title>fake_calendar_182</title>
 
276
<ellipse cx="732" cy="764" rx="27" ry="18" style="fill:none;stroke:red;"/>
 
277
<text text-anchor="middle" style="font-size:6.00;" x="732" y="766">calendar</text>
 
278
</g>
 
279
<g id="edge32" class="edge"><title>person&#45;&gt;fake_calendar_182</title>
 
280
<path style="fill:none;stroke:black;" d="M685,776C689,775 693,774 697,773"/>
 
281
<polygon style="fill:black;stroke:black;" points="696,770 707,770 698,776 696,770"/>
 
282
</g>
 
283
<g id="node33" class="node"><title>fake_country_184</title>
 
284
<ellipse cx="600" cy="1116" rx="27" ry="18" style="fill:none;stroke:red;"/>
 
285
<text text-anchor="middle" style="font-size:6.00;" x="600" y="1118">country</text>
 
286
</g>
 
287
<g id="edge34" class="edge"><title>person&#45;&gt;fake_country_184</title>
 
288
<path style="fill:none;stroke:black;" d="M590,990C593,1028 596,1064 597,1088"/>
 
289
<polygon style="fill:black;stroke:black;" points="600,1088 598,1098 594,1088 600,1088"/>
 
290
</g>
 
291
<g id="node35" class="node"><title>fake_libraryfilealias_186</title>
 
292
<ellipse cx="547" cy="484" rx="29" ry="18" style="fill:none;stroke:red;"/>
 
293
<text text-anchor="middle" style="font-size:6.00;" x="547" y="486">libraryfilealias</text>
 
294
</g>
 
295
<g id="edge36" class="edge"><title>person&#45;&gt;fake_libraryfilealias_186</title>
 
296
<path style="fill:none;stroke:black;" d="M559,616C556,575 552,537 550,512"/>
 
297
<polygon style="fill:black;stroke:black;" points="547,512 549,502 553,512 547,512"/>
 
298
</g>
 
299
<g id="node37" class="node"><title>fake_libraryfilealias_188</title>
 
300
<ellipse cx="409" cy="831" rx="29" ry="18" style="fill:none;stroke:red;"/>
 
301
<text text-anchor="middle" style="font-size:6.00;" x="409" y="833">libraryfilealias</text>
 
302
</g>
 
303
<g id="edge38" class="edge"><title>person&#45;&gt;fake_libraryfilealias_188</title>
 
304
<path style="fill:none;stroke:black;" d="M467,821C460,822 453,824 447,825"/>
 
305
<polygon style="fill:black;stroke:black;" points="447,828 437,826 447,822 447,828"/>
 
306
</g>
 
307
<g id="node7" class="node"><title>specificationsubscription</title>
 
308
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="105,649 105,595 277,595 277,649 105,649"/>
 
309
<polygon style="fill:white;stroke:white;" points="108,610 108,598 274,598 274,610 108,610"/>
 
310
<text text-anchor="middle" style="font-size:6.00;" x="191" y="606">specificationsubscription</text>
 
311
<polygon style="fill:none;stroke:black;" points="108,610 108,598 274,598 274,610 108,610"/>
 
312
<text text-anchor="middle" style="font-size:6.00;" x="113" y="619">id</text>
 
313
<text text-anchor="middle" style="font-size:6.00;" x="156" y="619">serial</text>
 
314
<text text-anchor="middle" style="font-size:6.00;" x="196" y="619"> PRIMARY KEY </text>
 
315
<text text-anchor="middle" style="font-size:6.00;" x="126" y="631">specification</text>
 
316
<text text-anchor="middle" style="font-size:6.00;" x="158" y="631">integer</text>
 
317
<text text-anchor="middle" style="font-size:6.00;" x="223" y="631"> UNIQUE REFERENCES specification </text>
 
318
<text text-anchor="middle" style="font-size:6.00;" x="119" y="643">person</text>
 
319
<text text-anchor="middle" style="font-size:6.00;" x="158" y="643">integer</text>
 
320
<text text-anchor="middle" style="font-size:6.00;" x="215" y="643"> REFERENCES person UNIQUE </text>
 
321
<polygon style="fill:none;stroke:black;" points="105,649 105,595 277,595 277,649 105,649"/>
 
322
</g>
 
323
<g id="edge42" class="edge"><title>specificationsubscription&#45;&gt;person</title>
 
324
<path style="fill:none;stroke:black;" d="M257,653C312,679 392,716 458,748"/>
 
325
<polygon style="fill:black;stroke:black;" points="459,745 467,752 456,751 459,745"/>
 
326
</g>
 
327
<g id="node39" class="node"><title>fake_specification_328</title>
 
328
<ellipse cx="33" cy="541" rx="27" ry="18" style="fill:none;stroke:red;"/>
 
329
<text text-anchor="middle" style="font-size:6.00;" x="33" y="543">specification</text>
 
330
</g>
 
331
<g id="edge40" class="edge"><title>specificationsubscription&#45;&gt;fake_specification_328</title>
 
332
<path style="fill:none;stroke:black;" d="M130,591C108,579 83,566 64,557"/>
 
333
<polygon style="fill:black;stroke:black;" points="62,560 55,552 65,554 62,560"/>
 
334
</g>
 
335
<g id="node8" class="node"><title>ticketsubscription</title>
 
336
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="719,1176 719,1122 861,1122 861,1176 719,1176"/>
 
337
<polygon style="fill:white;stroke:white;" points="722,1137 722,1125 858,1125 858,1137 722,1137"/>
 
338
<text text-anchor="middle" style="font-size:6.00;" x="790" y="1133">ticketsubscription</text>
 
339
<polygon style="fill:none;stroke:black;" points="722,1137 722,1125 858,1125 858,1137 722,1137"/>
 
340
<text text-anchor="middle" style="font-size:6.00;" x="727" y="1146">id</text>
 
341
<text text-anchor="middle" style="font-size:6.00;" x="755" y="1146">serial</text>
 
342
<text text-anchor="middle" style="font-size:6.00;" x="795" y="1146"> PRIMARY KEY </text>
 
343
<text text-anchor="middle" style="font-size:6.00;" x="732" y="1158">ticket</text>
 
344
<text text-anchor="middle" style="font-size:6.00;" x="757" y="1158">integer</text>
 
345
<text text-anchor="middle" style="font-size:6.00;" x="813" y="1158"> REFERENCES ticket UNIQUE </text>
 
346
<text text-anchor="middle" style="font-size:6.00;" x="733" y="1170">person</text>
 
347
<text text-anchor="middle" style="font-size:6.00;" x="757" y="1170">integer</text>
 
348
<text text-anchor="middle" style="font-size:6.00;" x="814" y="1170"> REFERENCES person UNIQUE </text>
 
349
<polygon style="fill:none;stroke:black;" points="719,1176 719,1122 861,1122 861,1176 719,1176"/>
 
350
</g>
 
351
<g id="edge46" class="edge"><title>ticketsubscription&#45;&gt;person</title>
 
352
<path style="fill:none;stroke:black;" d="M771,1118C752,1088 722,1039 690,989"/>
 
353
<polygon style="fill:black;stroke:black;" points="687,990 685,980 693,987 687,990"/>
 
354
</g>
 
355
<g id="node42" class="node"><title>fake_ticket_357</title>
 
356
<ellipse cx="868" cy="1291" rx="27" ry="18" style="fill:none;stroke:red;"/>
 
357
<text text-anchor="middle" style="font-size:6.00;" x="868" y="1293">ticket</text>
 
358
</g>
 
359
<g id="edge44" class="edge"><title>ticketsubscription&#45;&gt;fake_ticket_357</title>
 
360
<path style="fill:none;stroke:black;" d="M807,1180C821,1205 841,1241 853,1265"/>
 
361
<polygon style="fill:black;stroke:black;" points="856,1264 858,1274 850,1267 856,1264"/>
 
362
</g>
 
363
</g>
 
364
</svg>