|
1776
by Canonical.com Patch Queue Manager
[trivial] various fixes that didn't merge before (network?) and new db diagrams |
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">
|
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
4 |
<!-- Generated by fdp version 2.2.1 (Thu Apr 6 00:32:47 UTC 2006)
|
|
1776
by Canonical.com Patch Queue Manager
[trivial] various fixes that didn't merge before (network?) and new db diagrams |
5 |
For user: (stub) Stuart Bishop,,, Title: g Pages: 1 -->
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
6 |
<svg width="4247px" height="2941px" |
7 |
viewBox = "-1 -1 4246 2940" |
|
|
1776
by Canonical.com Patch Queue Manager
[trivial] various fixes that didn't merge before (network?) and new db diagrams |
8 |
xmlns="http://www.w3.org/2000/svg"> |
|
3322.1.13
by Stuart Bishop
Update database diagrams |
9 |
<g id="graph0" class="graph" style="font-family:Times-Roman;font-size:14.00;"> |
|
1776
by Canonical.com Patch Queue Manager
[trivial] various fixes that didn't merge before (network?) and new db diagrams |
10 |
<title>g</title> |
|
3691.17.2
by Stuart Bishop
Update database diagrams |
11 |
<text text-anchor="middle" style="font-size:22.00;" x="2122" y="2923">Rosetta</text> |
|
1776
by Canonical.com Patch Queue Manager
[trivial] various fixes that didn't merge before (network?) and new db diagrams |
12 |
<g id="node1" class="node"><title>country</title> |
|
3691.17.2
by Stuart Bishop
Update database diagrams |
13 |
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="3324,2145 3324,2027 3520,2027 3520,2145 3324,2145"/> |
14 |
<polygon style="fill:white;stroke:white;" points="3327,2044 3327,2030 3517,2030 3517,2044 3327,2044"/> |
|
15 |
<text text-anchor="middle" style="font-size:8.00;" x="3422" y="2040">country</text> |
|
16 |
<polygon style="fill:none;stroke:black;" points="3327,2044 3327,2030 3517,2030 3517,2044 3327,2044"/> |
|
17 |
<text text-anchor="middle" style="font-size:8.00;" x="3333" y="2055">id</text> |
|
18 |
<text text-anchor="middle" style="font-size:8.00;" x="3391" y="2055">serial</text> |
|
19 |
<text text-anchor="middle" style="font-size:8.00;" x="3458" y="2055"> PRIMARY KEY </text> |
|
20 |
<text text-anchor="middle" style="font-size:8.00;" x="3353" y="2069">iso3166code2</text> |
|
21 |
<text text-anchor="middle" style="font-size:8.00;" x="3402" y="2069">character(2)</text> |
|
22 |
<text text-anchor="middle" style="font-size:8.00;" x="3446" y="2069"> UNIQUE </text> |
|
23 |
<text text-anchor="middle" style="font-size:8.00;" x="3353" y="2083">iso3166code3</text> |
|
24 |
<text text-anchor="middle" style="font-size:8.00;" x="3402" y="2083">character(3)</text> |
|
25 |
<text text-anchor="middle" style="font-size:8.00;" x="3446" y="2083"> UNIQUE </text> |
|
26 |
<text text-anchor="middle" style="font-size:8.00;" x="3339" y="2097">name</text> |
|
27 |
<text text-anchor="middle" style="font-size:8.00;" x="3389" y="2097">text</text> |
|
28 |
<text text-anchor="middle" style="font-size:8.00;" x="3446" y="2097"> UNIQUE </text> |
|
29 |
<text text-anchor="middle" style="font-size:8.00;" x="3336" y="2111">title</text> |
|
30 |
<text text-anchor="middle" style="font-size:8.00;" x="3389" y="2111">text</text> |
|
31 |
<text text-anchor="middle" style="font-size:8.00;" x="3347" y="2125">description</text> |
|
32 |
<text text-anchor="middle" style="font-size:8.00;" x="3389" y="2125">text</text> |
|
33 |
<text text-anchor="middle" style="font-size:8.00;" x="3345" y="2139">continent</text> |
|
34 |
<text text-anchor="middle" style="font-size:8.00;" x="3394" y="2139">integer</text> |
|
35 |
<text text-anchor="middle" style="font-size:8.00;" x="3472" y="2139"> REFERENCES continent </text> |
|
36 |
<polygon style="fill:none;stroke:black;" points="3324,2145 3324,2027 3520,2027 3520,2145 3324,2145"/> |
|
37 |
</g>
|
|
38 |
<g id="node24" class="node"><title>fake_continent_94</title> |
|
39 |
<ellipse cx="3545" cy="2208" rx="27" ry="18" style="fill:none;stroke:red;"/> |
|
40 |
<text text-anchor="middle" style="font-size:8.00;" x="3545" y="2211">continent</text> |
|
41 |
</g>
|
|
42 |
<g id="edge2" class="edge"><title>country->fake_continent_94</title> |
|
43 |
<path style="fill:none;stroke:black;" d="M3486,2149C3499,2162 3512,2175 3523,2186"/> |
|
44 |
<polygon style="fill:black;stroke:black;" points="3525,2183 3530,2193 3520,2188 3525,2183"/> |
|
|
1776
by Canonical.com Patch Queue Manager
[trivial] various fixes that didn't merge before (network?) and new db diagrams |
45 |
</g>
|
46 |
<g id="node2" class="node"><title>language</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
47 |
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="2970,1865 2970,1733 3134,1733 3134,1865 2970,1865"/> |
48 |
<polygon style="fill:white;stroke:white;" points="2973,1750 2973,1736 3131,1736 3131,1750 2973,1750"/> |
|
49 |
<text text-anchor="middle" style="font-size:8.00;" x="3052" y="1746">language</text> |
|
50 |
<polygon style="fill:none;stroke:black;" points="2973,1750 2973,1736 3131,1736 3131,1750 2973,1750"/> |
|
51 |
<text text-anchor="middle" style="font-size:8.00;" x="2979" y="1761">id</text> |
|
52 |
<text text-anchor="middle" style="font-size:8.00;" x="3045" y="1761">serial</text> |
|
53 |
<text text-anchor="middle" style="font-size:8.00;" x="3099" y="1761"> PRIMARY KEY </text> |
|
54 |
<text text-anchor="middle" style="font-size:8.00;" x="2983" y="1775">code</text> |
|
55 |
<text text-anchor="middle" style="font-size:8.00;" x="3043" y="1775">text</text> |
|
56 |
<text text-anchor="middle" style="font-size:8.00;" x="3087" y="1775"> UNIQUE </text> |
|
57 |
<text text-anchor="middle" style="font-size:8.00;" x="2996" y="1789">englishname</text> |
|
58 |
<text text-anchor="middle" style="font-size:8.00;" x="3043" y="1789">text</text> |
|
59 |
<text text-anchor="middle" style="font-size:8.00;" x="2995" y="1803">nativename</text> |
|
60 |
<text text-anchor="middle" style="font-size:8.00;" x="3043" y="1803">text</text> |
|
61 |
<text text-anchor="middle" style="font-size:8.00;" x="2995" y="1817">pluralforms</text> |
|
62 |
<text text-anchor="middle" style="font-size:8.00;" x="3048" y="1817">integer</text> |
|
63 |
<text text-anchor="middle" style="font-size:8.00;" x="3003" y="1831">pluralexpression</text> |
|
64 |
<text text-anchor="middle" style="font-size:8.00;" x="3043" y="1831">text</text> |
|
65 |
<text text-anchor="middle" style="font-size:8.00;" x="2987" y="1845">visible</text> |
|
66 |
<text text-anchor="middle" style="font-size:8.00;" x="3050" y="1845">boolean</text> |
|
67 |
<text text-anchor="middle" style="font-size:8.00;" x="2990" y="1859">direction</text> |
|
68 |
<text text-anchor="middle" style="font-size:8.00;" x="3048" y="1859">integer</text> |
|
69 |
<polygon style="fill:none;stroke:black;" points="2970,1865 2970,1733 3134,1733 3134,1865 2970,1865"/> |
|
|
1776
by Canonical.com Patch Queue Manager
[trivial] various fixes that didn't merge before (network?) and new db diagrams |
70 |
</g>
|
71 |
<g id="node3" class="node"><title>license</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
72 |
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="2030,1774 2030,1726 2158,1726 2158,1774 2030,1774"/> |
73 |
<polygon style="fill:white;stroke:white;" points="2033,1743 2033,1729 2155,1729 2155,1743 2033,1743"/> |
|
74 |
<text text-anchor="middle" style="font-size:8.00;" x="2094" y="1739">license</text> |
|
75 |
<polygon style="fill:none;stroke:black;" points="2033,1743 2033,1729 2155,1729 2155,1743 2033,1743"/> |
|
76 |
<text text-anchor="middle" style="font-size:8.00;" x="2039" y="1754">id</text> |
|
77 |
<text text-anchor="middle" style="font-size:8.00;" x="2078" y="1754">serial</text> |
|
78 |
<text text-anchor="middle" style="font-size:8.00;" x="2123" y="1754"> PRIMARY KEY </text> |
|
79 |
<text text-anchor="middle" style="font-size:8.00;" x="2049" y="1768">legalese</text> |
|
80 |
<text text-anchor="middle" style="font-size:8.00;" x="2076" y="1768">text</text> |
|
81 |
<polygon style="fill:none;stroke:black;" points="2030,1774 2030,1726 2158,1726 2158,1774 2030,1774"/> |
|
|
1776
by Canonical.com Patch Queue Manager
[trivial] various fixes that didn't merge before (network?) and new db diagrams |
82 |
</g>
|
83 |
<g id="node4" class="node"><title>pocomment</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
84 |
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="1419,643 1419,511 1619,511 1619,643 1419,643"/> |
85 |
<polygon style="fill:white;stroke:white;" points="1422,528 1422,514 1616,514 1616,528 1422,528"/> |
|
86 |
<text text-anchor="middle" style="font-size:8.00;" x="1519" y="524">pocomment</text> |
|
87 |
<polygon style="fill:none;stroke:black;" points="1422,528 1422,514 1616,514 1616,528 1422,528"/> |
|
88 |
<text text-anchor="middle" style="font-size:8.00;" x="1428" y="539">id</text> |
|
89 |
<text text-anchor="middle" style="font-size:8.00;" x="1483" y="539">serial</text> |
|
90 |
<text text-anchor="middle" style="font-size:8.00;" x="1545" y="539"> PRIMARY KEY </text> |
|
91 |
<text text-anchor="middle" style="font-size:8.00;" x="1443" y="553">potemplate</text> |
|
92 |
<text text-anchor="middle" style="font-size:8.00;" x="1486" y="553">integer</text> |
|
93 |
<text text-anchor="middle" style="font-size:8.00;" x="1562" y="553"> REFERENCES potemplate </text> |
|
94 |
<text text-anchor="middle" style="font-size:8.00;" x="1439" y="567">pomsgid</text> |
|
95 |
<text text-anchor="middle" style="font-size:8.00;" x="1486" y="567">integer</text> |
|
96 |
<text text-anchor="middle" style="font-size:8.00;" x="1558" y="567"> REFERENCES pomsgid </text> |
|
97 |
<text text-anchor="middle" style="font-size:8.00;" x="1440" y="581">language</text> |
|
98 |
<text text-anchor="middle" style="font-size:8.00;" x="1486" y="581">integer</text> |
|
99 |
<text text-anchor="middle" style="font-size:8.00;" x="1559" y="581"> REFERENCES language </text> |
|
100 |
<text text-anchor="middle" style="font-size:8.00;" x="1446" y="595">potranslation</text> |
|
101 |
<text text-anchor="middle" style="font-size:8.00;" x="1486" y="595">integer</text> |
|
102 |
<text text-anchor="middle" style="font-size:8.00;" x="1565" y="595"> REFERENCES potranslation </text> |
|
103 |
<text text-anchor="middle" style="font-size:8.00;" x="1446" y="609">commenttext</text> |
|
104 |
<text text-anchor="middle" style="font-size:8.00;" x="1481" y="609">text</text> |
|
105 |
<text text-anchor="middle" style="font-size:8.00;" x="1443" y="623">datecreated</text> |
|
106 |
<text text-anchor="middle" style="font-size:8.00;" x="1492" y="623">timestamp</text> |
|
107 |
<text text-anchor="middle" style="font-size:8.00;" x="1436" y="637">person</text> |
|
108 |
<text text-anchor="middle" style="font-size:8.00;" x="1486" y="637">integer</text> |
|
109 |
<text text-anchor="middle" style="font-size:8.00;" x="1555" y="637"> REFERENCES person </text> |
|
110 |
<polygon style="fill:none;stroke:black;" points="1419,643 1419,511 1619,511 1619,643 1419,643"/> |
|
|
1776
by Canonical.com Patch Queue Manager
[trivial] various fixes that didn't merge before (network?) and new db diagrams |
111 |
</g>
|
|
1959
by Canonical.com Patch Queue Manager
[trivial] dba maintenance stuff and fixes |
112 |
<g id="node7" class="node"><title>pomsgid</title> |
|
3691.17.2
by Stuart Bishop
Update database diagrams |
113 |
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="1176,433 1176,385 1298,385 1298,433 1176,433"/> |
114 |
<polygon style="fill:white;stroke:white;" points="1179,402 1179,388 1295,388 1295,402 1179,402"/> |
|
115 |
<text text-anchor="middle" style="font-size:8.00;" x="1237" y="398">pomsgid</text> |
|
116 |
<polygon style="fill:none;stroke:black;" points="1179,402 1179,388 1295,388 1295,402 1179,402"/> |
|
117 |
<text text-anchor="middle" style="font-size:8.00;" x="1185" y="413">id</text> |
|
118 |
<text text-anchor="middle" style="font-size:8.00;" x="1218" y="413">serial</text> |
|
119 |
<text text-anchor="middle" style="font-size:8.00;" x="1263" y="413"> PRIMARY KEY </text> |
|
120 |
<text text-anchor="middle" style="font-size:8.00;" x="1192" y="427">msgid</text> |
|
121 |
<text text-anchor="middle" style="font-size:8.00;" x="1216" y="427">text</text> |
|
122 |
<polygon style="fill:none;stroke:black;" points="1176,433 1176,385 1298,385 1298,433 1176,433"/> |
|
|
1776
by Canonical.com Patch Queue Manager
[trivial] various fixes that didn't merge before (network?) and new db diagrams |
123 |
</g>
|
|
3322.1.13
by Stuart Bishop
Update database diagrams |
124 |
<g id="edge6" class="edge"><title>pocomment->pomsgid</title> |
|
3691.17.2
by Stuart Bishop
Update database diagrams |
125 |
<path style="fill:none;stroke:black;" d="M1411,513C1371,489 1327,463 1293,442"/> |
126 |
<polygon style="fill:black;stroke:black;" points="1291,445 1284,437 1294,439 1291,445"/> |
|
|
1776
by Canonical.com Patch Queue Manager
[trivial] various fixes that didn't merge before (network?) and new db diagrams |
127 |
</g>
|
|
1959
by Canonical.com Patch Queue Manager
[trivial] dba maintenance stuff and fixes |
128 |
<g id="node13" class="node"><title>potemplate</title> |
|
3691.17.2
by Stuart Bishop
Update database diagrams |
129 |
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="1961,1411 1961,1111 2281,1111 2281,1411 1961,1411"/> |
130 |
<polygon style="fill:white;stroke:white;" points="1964,1128 1964,1114 2278,1114 2278,1128 1964,1128"/> |
|
131 |
<text text-anchor="middle" style="font-size:8.00;" x="2121" y="1124">potemplate</text> |
|
132 |
<polygon style="fill:none;stroke:black;" points="1964,1128 1964,1114 2278,1114 2278,1128 1964,1128"/> |
|
133 |
<text text-anchor="middle" style="font-size:8.00;" x="1970" y="1139">id</text> |
|
134 |
<text text-anchor="middle" style="font-size:8.00;" x="2069" y="1139">serial</text> |
|
135 |
<text text-anchor="middle" style="font-size:8.00;" x="2131" y="1139"> PRIMARY KEY </text> |
|
136 |
<text text-anchor="middle" style="font-size:8.00;" x="1979" y="1153">priority</text> |
|
137 |
<text text-anchor="middle" style="font-size:8.00;" x="2072" y="1153">integer</text> |
|
138 |
<text text-anchor="middle" style="font-size:8.00;" x="1984" y="1167">description</text> |
|
139 |
<text text-anchor="middle" style="font-size:8.00;" x="2067" y="1167">text</text> |
|
140 |
<text text-anchor="middle" style="font-size:8.00;" x="1982" y="1181">copyright</text> |
|
141 |
<text text-anchor="middle" style="font-size:8.00;" x="2067" y="1181">text</text> |
|
142 |
<text text-anchor="middle" style="font-size:8.00;" x="1978" y="1195">license</text> |
|
143 |
<text text-anchor="middle" style="font-size:8.00;" x="2072" y="1195">integer</text> |
|
144 |
<text text-anchor="middle" style="font-size:8.00;" x="2141" y="1195"> REFERENCES license </text> |
|
145 |
<text text-anchor="middle" style="font-size:8.00;" x="1985" y="1209">datecreated</text> |
|
146 |
<text text-anchor="middle" style="font-size:8.00;" x="2078" y="1209">timestamp</text> |
|
147 |
<text text-anchor="middle" style="font-size:8.00;" x="1974" y="1223">path</text> |
|
148 |
<text text-anchor="middle" style="font-size:8.00;" x="2067" y="1223">text</text> |
|
149 |
<text text-anchor="middle" style="font-size:8.00;" x="1981" y="1237">iscurrent</text> |
|
150 |
<text text-anchor="middle" style="font-size:8.00;" x="2074" y="1237">boolean</text> |
|
151 |
<text text-anchor="middle" style="font-size:8.00;" x="1990" y="1251">messagecount</text> |
|
152 |
<text text-anchor="middle" style="font-size:8.00;" x="2072" y="1251">integer</text> |
|
153 |
<text text-anchor="middle" style="font-size:8.00;" x="1977" y="1265">owner</text> |
|
154 |
<text text-anchor="middle" style="font-size:8.00;" x="2072" y="1265">integer</text> |
|
155 |
<text text-anchor="middle" style="font-size:8.00;" x="2141" y="1265"> REFERENCES person </text> |
|
156 |
<text text-anchor="middle" style="font-size:8.00;" x="1999" y="1279">sourcepackagename</text> |
|
157 |
<text text-anchor="middle" style="font-size:8.00;" x="2072" y="1279">integer</text> |
|
158 |
<text text-anchor="middle" style="font-size:8.00;" x="2179" y="1279"> UNIQUE REFERENCES sourcepackagename </text> |
|
159 |
<text text-anchor="middle" style="font-size:8.00;" x="1987" y="1293">distrorelease</text> |
|
160 |
<text text-anchor="middle" style="font-size:8.00;" x="2072" y="1293">integer</text> |
|
161 |
<text text-anchor="middle" style="font-size:8.00;" x="2166" y="1293"> REFERENCES distrorelease UNIQUE </text> |
|
162 |
<text text-anchor="middle" style="font-size:8.00;" x="2002" y="1307">sourcepackageversion</text> |
|
163 |
<text text-anchor="middle" style="font-size:8.00;" x="2067" y="1307">text</text> |
|
164 |
<text text-anchor="middle" style="font-size:8.00;" x="1978" y="1321">header</text> |
|
165 |
<text text-anchor="middle" style="font-size:8.00;" x="2067" y="1321">text</text> |
|
166 |
<text text-anchor="middle" style="font-size:8.00;" x="1994" y="1335">potemplatename</text> |
|
167 |
<text text-anchor="middle" style="font-size:8.00;" x="2072" y="1335">integer</text> |
|
168 |
<text text-anchor="middle" style="font-size:8.00;" x="2189" y="1335"> UNIQUE REFERENCES potemplatename UNIQUE </text> |
|
169 |
<text text-anchor="middle" style="font-size:8.00;" x="1999" y="1349">binarypackagename</text> |
|
170 |
<text text-anchor="middle" style="font-size:8.00;" x="2072" y="1349">integer</text> |
|
171 |
<text text-anchor="middle" style="font-size:8.00;" x="2162" y="1349"> REFERENCES binarypackagename </text> |
|
172 |
<text text-anchor="middle" style="font-size:8.00;" x="1989" y="1363">languagepack</text> |
|
173 |
<text text-anchor="middle" style="font-size:8.00;" x="2074" y="1363">boolean</text> |
|
174 |
<text text-anchor="middle" style="font-size:8.00;" x="1989" y="1377">productseries</text> |
|
175 |
<text text-anchor="middle" style="font-size:8.00;" x="2072" y="1377">integer</text> |
|
176 |
<text text-anchor="middle" style="font-size:8.00;" x="2168" y="1377"> REFERENCES productseries UNIQUE </text> |
|
177 |
<text text-anchor="middle" style="font-size:8.00;" x="2010" y="1391">from_sourcepackagename</text> |
|
178 |
<text text-anchor="middle" style="font-size:8.00;" x="2072" y="1391">integer</text> |
|
179 |
<text text-anchor="middle" style="font-size:8.00;" x="2163" y="1391"> REFERENCES sourcepackagename </text> |
|
180 |
<text text-anchor="middle" style="font-size:8.00;" x="1996" y="1405">date_last_updated</text> |
|
181 |
<text text-anchor="middle" style="font-size:8.00;" x="2078" y="1405">timestamp</text> |
|
182 |
<polygon style="fill:none;stroke:black;" points="1961,1411 1961,1111 2281,1111 2281,1411 1961,1411"/> |
|
|
1776
by Canonical.com Patch Queue Manager
[trivial] various fixes that didn't merge before (network?) and new db diagrams |
183 |
</g>
|
|
3322.1.13
by Stuart Bishop
Update database diagrams |
184 |
<g id="edge4" class="edge"><title>pocomment->potemplate</title> |
|
3691.17.2
by Stuart Bishop
Update database diagrams |
185 |
<path style="fill:none;stroke:black;" d="M1581,647C1673,753 1852,956 1978,1099"/> |
186 |
<polygon style="fill:black;stroke:black;" points="1981,1097 1985,1107 1976,1102 1981,1097"/> |
|
|
1776
by Canonical.com Patch Queue Manager
[trivial] various fixes that didn't merge before (network?) and new db diagrams |
187 |
</g>
|
|
1959
by Canonical.com Patch Queue Manager
[trivial] dba maintenance stuff and fixes |
188 |
<g id="node16" class="node"><title>potranslation</title> |
|
3691.17.2
by Stuart Bishop
Update database diagrams |
189 |
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="917,755 917,707 1053,707 1053,755 917,755"/> |
190 |
<polygon style="fill:white;stroke:white;" points="920,724 920,710 1050,710 1050,724 920,724"/> |
|
191 |
<text text-anchor="middle" style="font-size:8.00;" x="985" y="720">potranslation</text> |
|
192 |
<polygon style="fill:none;stroke:black;" points="920,724 920,710 1050,710 1050,724 920,724"/> |
|
193 |
<text text-anchor="middle" style="font-size:8.00;" x="926" y="735">id</text> |
|
194 |
<text text-anchor="middle" style="font-size:8.00;" x="973" y="735">serial</text> |
|
195 |
<text text-anchor="middle" style="font-size:8.00;" x="1018" y="735"> PRIMARY KEY </text> |
|
196 |
<text text-anchor="middle" style="font-size:8.00;" x="940" y="749">translation</text> |
|
197 |
<text text-anchor="middle" style="font-size:8.00;" x="971" y="749">text</text> |
|
198 |
<polygon style="fill:none;stroke:black;" points="917,755 917,707 1053,707 1053,755 917,755"/> |
|
|
3322.1.13
by Stuart Bishop
Update database diagrams |
199 |
</g>
|
200 |
<g id="edge10" class="edge"><title>pocomment->potranslation</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
201 |
<path style="fill:none;stroke:black;" d="M1411,608C1311,637 1163,680 1071,706"/> |
202 |
<polygon style="fill:black;stroke:black;" points="1072,709 1061,709 1070,703 1072,709"/> |
|
203 |
</g>
|
|
204 |
<g id="node28" class="node"><title>fake_language_224</title> |
|
205 |
<ellipse cx="1393" cy="175" rx="27" ry="18" style="fill:none;stroke:red;"/> |
|
206 |
<text text-anchor="middle" style="font-size:8.00;" x="1393" y="178">language</text> |
|
207 |
</g>
|
|
208 |
<g id="edge8" class="edge"><title>pocomment->fake_language_224</title> |
|
209 |
<path style="fill:none;stroke:black;" d="M1497,507C1469,417 1422,265 1402,203"/> |
|
210 |
<polygon style="fill:black;stroke:black;" points="1399,204 1399,193 1405,202 1399,204"/> |
|
211 |
</g>
|
|
212 |
<g id="node31" class="node"><title>fake_person_227</title> |
|
213 |
<ellipse cx="1589" cy="176" rx="27" ry="18" style="fill:none;stroke:red;"/> |
|
214 |
<text text-anchor="middle" style="font-size:8.00;" x="1589" y="179">person</text> |
|
215 |
</g>
|
|
216 |
<g id="edge12" class="edge"><title>pocomment->fake_person_227</title> |
|
217 |
<path style="fill:none;stroke:black;" d="M1531,507C1547,417 1573,266 1584,204"/> |
|
218 |
<polygon style="fill:black;stroke:black;" points="1581,203 1586,194 1587,204 1581,203"/> |
|
|
1959
by Canonical.com Patch Queue Manager
[trivial] dba maintenance stuff and fixes |
219 |
</g>
|
220 |
<g id="node5" class="node"><title>poexportrequest</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
221 |
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="1504,1651 1504,1561 1680,1561 1680,1651 1504,1651"/> |
222 |
<polygon style="fill:white;stroke:white;" points="1507,1578 1507,1564 1677,1564 1677,1578 1507,1578"/> |
|
223 |
<text text-anchor="middle" style="font-size:8.00;" x="1592" y="1574">poexportrequest</text> |
|
224 |
<polygon style="fill:none;stroke:black;" points="1507,1578 1507,1564 1677,1564 1677,1578 1507,1578"/> |
|
225 |
<text text-anchor="middle" style="font-size:8.00;" x="1513" y="1589">id</text> |
|
226 |
<text text-anchor="middle" style="font-size:8.00;" x="1561" y="1589">serial</text> |
|
227 |
<text text-anchor="middle" style="font-size:8.00;" x="1612" y="1589"> PRIMARY KEY </text> |
|
228 |
<text text-anchor="middle" style="font-size:8.00;" x="1521" y="1603">person</text> |
|
229 |
<text text-anchor="middle" style="font-size:8.00;" x="1564" y="1603">integer</text> |
|
230 |
<text text-anchor="middle" style="font-size:8.00;" x="1622" y="1603"> REFERENCES person </text> |
|
231 |
<text text-anchor="middle" style="font-size:8.00;" x="1528" y="1617">potemplate</text> |
|
232 |
<text text-anchor="middle" style="font-size:8.00;" x="1564" y="1617">integer</text> |
|
233 |
<text text-anchor="middle" style="font-size:8.00;" x="1629" y="1617"> REFERENCES potemplate </text> |
|
234 |
<text text-anchor="middle" style="font-size:8.00;" x="1519" y="1631">pofile</text> |
|
235 |
<text text-anchor="middle" style="font-size:8.00;" x="1564" y="1631">integer</text> |
|
236 |
<text text-anchor="middle" style="font-size:8.00;" x="1620" y="1631"> REFERENCES pofile </text> |
|
237 |
<text text-anchor="middle" style="font-size:8.00;" x="1521" y="1645">format</text> |
|
238 |
<text text-anchor="middle" style="font-size:8.00;" x="1564" y="1645">integer</text> |
|
239 |
<polygon style="fill:none;stroke:black;" points="1504,1651 1504,1561 1680,1561 1680,1651 1504,1651"/> |
|
|
1959
by Canonical.com Patch Queue Manager
[trivial] dba maintenance stuff and fixes |
240 |
</g>
|
241 |
<g id="node6" class="node"><title>pofile</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
242 |
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="919,1867 919,1539 1187,1539 1187,1867 919,1867"/> |
243 |
<polygon style="fill:white;stroke:white;" points="922,1556 922,1542 1184,1542 1184,1556 922,1556"/> |
|
244 |
<text text-anchor="middle" style="font-size:8.00;" x="1053" y="1552">pofile</text> |
|
245 |
<polygon style="fill:none;stroke:black;" points="922,1556 922,1542 1184,1542 1184,1556 922,1556"/> |
|
246 |
<text text-anchor="middle" style="font-size:8.00;" x="928" y="1567">id</text> |
|
247 |
<text text-anchor="middle" style="font-size:8.00;" x="1027" y="1567">serial</text> |
|
248 |
<text text-anchor="middle" style="font-size:8.00;" x="1089" y="1567"> PRIMARY KEY </text> |
|
249 |
<text text-anchor="middle" style="font-size:8.00;" x="943" y="1581">potemplate</text> |
|
250 |
<text text-anchor="middle" style="font-size:8.00;" x="1030" y="1581">integer</text> |
|
251 |
<text text-anchor="middle" style="font-size:8.00;" x="1106" y="1581"> REFERENCES potemplate </text> |
|
252 |
<text text-anchor="middle" style="font-size:8.00;" x="940" y="1595">language</text> |
|
253 |
<text text-anchor="middle" style="font-size:8.00;" x="1030" y="1595">integer</text> |
|
254 |
<text text-anchor="middle" style="font-size:8.00;" x="1103" y="1595"> REFERENCES language </text> |
|
255 |
<text text-anchor="middle" style="font-size:8.00;" x="942" y="1609">description</text> |
|
256 |
<text text-anchor="middle" style="font-size:8.00;" x="1025" y="1609">text</text> |
|
257 |
<text text-anchor="middle" style="font-size:8.00;" x="945" y="1623">topcomment</text> |
|
258 |
<text text-anchor="middle" style="font-size:8.00;" x="1025" y="1623">text</text> |
|
259 |
<text text-anchor="middle" style="font-size:8.00;" x="936" y="1637">header</text> |
|
260 |
<text text-anchor="middle" style="font-size:8.00;" x="1025" y="1637">text</text> |
|
261 |
<text text-anchor="middle" style="font-size:8.00;" x="945" y="1651">fuzzyheader</text> |
|
262 |
<text text-anchor="middle" style="font-size:8.00;" x="1032" y="1651">boolean</text> |
|
263 |
<text text-anchor="middle" style="font-size:8.00;" x="946" y="1665">lasttranslator</text> |
|
264 |
<text text-anchor="middle" style="font-size:8.00;" x="1030" y="1665">integer</text> |
|
265 |
<text text-anchor="middle" style="font-size:8.00;" x="1099" y="1665"> REFERENCES person </text> |
|
266 |
<text text-anchor="middle" style="font-size:8.00;" x="936" y="1679">license</text> |
|
267 |
<text text-anchor="middle" style="font-size:8.00;" x="1030" y="1679">integer</text> |
|
268 |
<text text-anchor="middle" style="font-size:8.00;" x="1099" y="1679"> REFERENCES license </text> |
|
269 |
<text text-anchor="middle" style="font-size:8.00;" x="945" y="1693">currentcount</text> |
|
270 |
<text text-anchor="middle" style="font-size:8.00;" x="1030" y="1693">integer</text> |
|
271 |
<text text-anchor="middle" style="font-size:8.00;" x="946" y="1707">updatescount</text> |
|
272 |
<text text-anchor="middle" style="font-size:8.00;" x="1030" y="1707">integer</text> |
|
273 |
<text text-anchor="middle" style="font-size:8.00;" x="945" y="1721">rosettacount</text> |
|
274 |
<text text-anchor="middle" style="font-size:8.00;" x="1030" y="1721">integer</text> |
|
275 |
<text text-anchor="middle" style="font-size:8.00;" x="941" y="1735">lastparsed</text> |
|
276 |
<text text-anchor="middle" style="font-size:8.00;" x="1036" y="1735">timestamp</text> |
|
277 |
<text text-anchor="middle" style="font-size:8.00;" x="935" y="1749">owner</text> |
|
278 |
<text text-anchor="middle" style="font-size:8.00;" x="1030" y="1749">integer</text> |
|
279 |
<text text-anchor="middle" style="font-size:8.00;" x="1099" y="1749"> REFERENCES person </text> |
|
280 |
<text text-anchor="middle" style="font-size:8.00;" x="944" y="1763">pluralforms</text> |
|
281 |
<text text-anchor="middle" style="font-size:8.00;" x="1030" y="1763">integer</text> |
|
282 |
<text text-anchor="middle" style="font-size:8.00;" x="936" y="1777">variant</text> |
|
283 |
<text text-anchor="middle" style="font-size:8.00;" x="1025" y="1777">text</text> |
|
284 |
<text text-anchor="middle" style="font-size:8.00;" x="932" y="1791">path</text> |
|
285 |
<text text-anchor="middle" style="font-size:8.00;" x="1025" y="1791">text</text> |
|
286 |
<text text-anchor="middle" style="font-size:8.00;" x="941" y="1805">exportfile</text> |
|
287 |
<text text-anchor="middle" style="font-size:8.00;" x="1030" y="1805">integer</text> |
|
288 |
<text text-anchor="middle" style="font-size:8.00;" x="1111" y="1805"> REFERENCES libraryfilealias </text> |
|
289 |
<text text-anchor="middle" style="font-size:8.00;" x="942" y="1819">exporttime</text> |
|
290 |
<text text-anchor="middle" style="font-size:8.00;" x="1036" y="1819">timestamp</text> |
|
291 |
<text text-anchor="middle" style="font-size:8.00;" x="943" y="1833">datecreated</text> |
|
292 |
<text text-anchor="middle" style="font-size:8.00;" x="1036" y="1833">timestamp</text> |
|
293 |
<text text-anchor="middle" style="font-size:8.00;" x="952" y="1847">latestsubmission</text> |
|
294 |
<text text-anchor="middle" style="font-size:8.00;" x="1030" y="1847">integer</text> |
|
295 |
<text text-anchor="middle" style="font-size:8.00;" x="1110" y="1847"> REFERENCES posubmission </text> |
|
296 |
<text text-anchor="middle" style="font-size:8.00;" x="968" y="1861">from_sourcepackagename</text> |
|
297 |
<text text-anchor="middle" style="font-size:8.00;" x="1030" y="1861">integer</text> |
|
298 |
<text text-anchor="middle" style="font-size:8.00;" x="1121" y="1861"> REFERENCES sourcepackagename </text> |
|
299 |
<polygon style="fill:none;stroke:black;" points="919,1867 919,1539 1187,1539 1187,1867 919,1867"/> |
|
|
3322.1.13
by Stuart Bishop
Update database diagrams |
300 |
</g>
|
301 |
<g id="edge18" class="edge"><title>poexportrequest->pofile</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
302 |
<path style="fill:none;stroke:black;" d="M1496,1623C1415,1637 1299,1658 1205,1675"/> |
303 |
<polygon style="fill:black;stroke:black;" points="1205,1678 1195,1677 1204,1672 1205,1678"/> |
|
|
3322.1.13
by Stuart Bishop
Update database diagrams |
304 |
</g>
|
305 |
<g id="edge16" class="edge"><title>poexportrequest->potemplate</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
306 |
<path style="fill:none;stroke:black;" d="M1667,1557C1739,1510 1850,1437 1945,1376"/> |
307 |
<polygon style="fill:black;stroke:black;" points="1943,1373 1953,1371 1946,1379 1943,1373"/> |
|
308 |
</g>
|
|
309 |
<g id="node33" class="node"><title>fake_person_229</title> |
|
310 |
<ellipse cx="1456" cy="1864" rx="27" ry="18" style="fill:none;stroke:red;"/> |
|
311 |
<text text-anchor="middle" style="font-size:8.00;" x="1456" y="1867">person</text> |
|
312 |
</g>
|
|
313 |
<g id="edge14" class="edge"><title>poexportrequest->fake_person_229</title> |
|
314 |
<path style="fill:none;stroke:black;" d="M1566,1655C1538,1710 1493,1795 1470,1838"/> |
|
315 |
<polygon style="fill:black;stroke:black;" points="1473,1840 1465,1847 1467,1837 1473,1840"/> |
|
|
1681.1.131
by Stuart Bishop
Update diagrams |
316 |
</g>
|
317 |
<g id="node11" class="node"><title>posubmission</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
318 |
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="457,1144 457,1012 687,1012 687,1144 457,1144"/> |
319 |
<polygon style="fill:white;stroke:white;" points="460,1029 460,1015 684,1015 684,1029 460,1029"/> |
|
320 |
<text text-anchor="middle" style="font-size:8.00;" x="572" y="1025">posubmission</text> |
|
321 |
<polygon style="fill:none;stroke:black;" points="460,1029 460,1015 684,1015 684,1029 460,1029"/> |
|
322 |
<text text-anchor="middle" style="font-size:8.00;" x="466" y="1040">id</text> |
|
323 |
<text text-anchor="middle" style="font-size:8.00;" x="530" y="1040">serial</text> |
|
324 |
<text text-anchor="middle" style="font-size:8.00;" x="609" y="1040"> UNIQUE PRIMARY KEY </text> |
|
325 |
<text text-anchor="middle" style="font-size:8.00;" x="478" y="1054">pomsgset</text> |
|
326 |
<text text-anchor="middle" style="font-size:8.00;" x="533" y="1054">integer</text> |
|
327 |
<text text-anchor="middle" style="font-size:8.00;" x="622" y="1054"> UNIQUE REFERENCES pomsgset </text> |
|
328 |
<text text-anchor="middle" style="font-size:8.00;" x="480" y="1068">pluralform</text> |
|
329 |
<text text-anchor="middle" style="font-size:8.00;" x="533" y="1068">integer</text> |
|
330 |
<text text-anchor="middle" style="font-size:8.00;" x="580" y="1068"> UNIQUE </text> |
|
331 |
<text text-anchor="middle" style="font-size:8.00;" x="484" y="1082">potranslation</text> |
|
332 |
<text text-anchor="middle" style="font-size:8.00;" x="533" y="1082">integer</text> |
|
333 |
<text text-anchor="middle" style="font-size:8.00;" x="612" y="1082"> REFERENCES potranslation </text> |
|
334 |
<text text-anchor="middle" style="font-size:8.00;" x="472" y="1096">origin</text> |
|
335 |
<text text-anchor="middle" style="font-size:8.00;" x="533" y="1096">integer</text> |
|
336 |
<text text-anchor="middle" style="font-size:8.00;" x="481" y="1110">datecreated</text> |
|
337 |
<text text-anchor="middle" style="font-size:8.00;" x="539" y="1110">timestamp</text> |
|
338 |
<text text-anchor="middle" style="font-size:8.00;" x="474" y="1124">person</text> |
|
339 |
<text text-anchor="middle" style="font-size:8.00;" x="533" y="1124">integer</text> |
|
340 |
<text text-anchor="middle" style="font-size:8.00;" x="602" y="1124"> REFERENCES person </text> |
|
341 |
<text text-anchor="middle" style="font-size:8.00;" x="488" y="1138">validationstatus</text> |
|
342 |
<text text-anchor="middle" style="font-size:8.00;" x="533" y="1138">integer</text> |
|
343 |
<polygon style="fill:none;stroke:black;" points="457,1144 457,1012 687,1012 687,1144 457,1144"/> |
|
|
3322.1.13
by Stuart Bishop
Update database diagrams |
344 |
</g>
|
345 |
<g id="edge32" class="edge"><title>pofile->posubmission</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
346 |
<path style="fill:none;stroke:black;" d="M923,1535C829,1413 705,1250 632,1156"/> |
347 |
<polygon style="fill:black;stroke:black;" points="629,1158 626,1148 635,1154 629,1158"/> |
|
|
3322.1.13
by Stuart Bishop
Update database diagrams |
348 |
</g>
|
349 |
<g id="edge20" class="edge"><title>pofile->potemplate</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
350 |
<path style="fill:none;stroke:black;" d="M1195,1644C1388,1564 1734,1421 1944,1335"/> |
351 |
<polygon style="fill:black;stroke:black;" points="1942,1332 1953,1331 1945,1338 1942,1332"/> |
|
352 |
</g>
|
|
353 |
<g id="node38" class="node"><title>fake_language_234</title> |
|
354 |
<ellipse cx="537" cy="1916" rx="27" ry="18" style="fill:none;stroke:red;"/> |
|
355 |
<text text-anchor="middle" style="font-size:8.00;" x="537" y="1919">language</text> |
|
356 |
</g>
|
|
357 |
<g id="edge22" class="edge"><title>pofile->fake_language_234</title> |
|
358 |
<path style="fill:none;stroke:black;" d="M911,1762C794,1811 637,1875 570,1902"/> |
|
359 |
<polygon style="fill:black;stroke:black;" points="571,1906 560,1906 568,1899 571,1906"/> |
|
360 |
</g>
|
|
361 |
<g id="node40" class="node"><title>fake_person_236</title> |
|
362 |
<ellipse cx="918" cy="2192" rx="27" ry="18" style="fill:none;stroke:red;"/> |
|
363 |
<text text-anchor="middle" style="font-size:8.00;" x="918" y="2195">person</text> |
|
364 |
</g>
|
|
365 |
<g id="edge24" class="edge"><title>pofile->fake_person_236</title> |
|
366 |
<path style="fill:none;stroke:black;" d="M1007,1871C977,1979 941,2109 926,2164"/> |
|
367 |
<polygon style="fill:black;stroke:black;" points="929,2165 923,2174 923,2163 929,2165"/> |
|
368 |
</g>
|
|
369 |
<g id="node42" class="node"><title>fake_license_238</title> |
|
370 |
<ellipse cx="647" cy="2033" rx="27" ry="18" style="fill:none;stroke:red;"/> |
|
371 |
<text text-anchor="middle" style="font-size:8.00;" x="647" y="2036">license</text> |
|
372 |
</g>
|
|
373 |
<g id="edge26" class="edge"><title>pofile->fake_license_238</title> |
|
374 |
<path style="fill:none;stroke:black;" d="M911,1819C823,1890 720,1975 672,2013"/> |
|
375 |
<polygon style="fill:black;stroke:black;" points="674,2016 664,2019 670,2010 674,2016"/> |
|
376 |
</g>
|
|
377 |
<g id="node44" class="node"><title>fake_person_240</title> |
|
378 |
<ellipse cx="520" cy="1752" rx="27" ry="18" style="fill:none;stroke:red;"/> |
|
379 |
<text text-anchor="middle" style="font-size:8.00;" x="520" y="1755">person</text> |
|
380 |
</g>
|
|
381 |
<g id="edge28" class="edge"><title>pofile->fake_person_240</title> |
|
382 |
<path style="fill:none;stroke:black;" d="M911,1716C792,1727 629,1743 557,1749"/> |
|
383 |
<polygon style="fill:black;stroke:black;" points="557,1752 547,1750 557,1746 557,1752"/> |
|
384 |
</g>
|
|
385 |
<g id="node46" class="node"><title>fake_libraryfilealias_242</title> |
|
386 |
<ellipse cx="545" cy="1573" rx="35" ry="18" style="fill:none;stroke:red;"/> |
|
387 |
<text text-anchor="middle" style="font-size:8.00;" x="545" y="1576">libraryfilealias</text> |
|
388 |
</g>
|
|
389 |
<g id="edge30" class="edge"><title>pofile->fake_libraryfilealias_242</title> |
|
390 |
<path style="fill:none;stroke:black;" d="M911,1667C801,1638 656,1602 586,1584"/> |
|
391 |
<polygon style="fill:black;stroke:black;" points="585,1587 576,1581 587,1581 585,1587"/> |
|
392 |
</g>
|
|
393 |
<g id="node49" class="node"><title>fake_sourcepackagename_245</title> |
|
394 |
<ellipse cx="719" cy="2185" rx="44" ry="18" style="fill:none;stroke:red;"/> |
|
395 |
<text text-anchor="middle" style="font-size:8.00;" x="719" y="2188">sourcepackagename</text> |
|
396 |
</g>
|
|
397 |
<g id="edge34" class="edge"><title>pofile->fake_sourcepackagename_245</title> |
|
398 |
<path style="fill:none;stroke:black;" d="M936,1871C862,1978 774,2106 737,2160"/> |
|
399 |
<polygon style="fill:black;stroke:black;" points="740,2162 731,2168 734,2158 740,2162"/> |
|
|
1959
by Canonical.com Patch Queue Manager
[trivial] dba maintenance stuff and fixes |
400 |
</g>
|
401 |
<g id="node8" class="node"><title>pomsgidsighting</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
402 |
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="904,453 904,335 1096,335 1096,453 904,453"/> |
403 |
<polygon style="fill:white;stroke:white;" points="907,352 907,338 1093,338 1093,352 907,352"/> |
|
404 |
<text text-anchor="middle" style="font-size:8.00;" x="1000" y="348">pomsgidsighting</text> |
|
405 |
<polygon style="fill:none;stroke:black;" points="907,352 907,338 1093,338 1093,352 907,352"/> |
|
406 |
<text text-anchor="middle" style="font-size:8.00;" x="913" y="363">id</text> |
|
407 |
<text text-anchor="middle" style="font-size:8.00;" x="969" y="363">serial</text> |
|
408 |
<text text-anchor="middle" style="font-size:8.00;" x="1031" y="363"> PRIMARY KEY </text> |
|
409 |
<text text-anchor="middle" style="font-size:8.00;" x="926" y="377">potmsgset</text> |
|
410 |
<text text-anchor="middle" style="font-size:8.00;" x="972" y="377">integer</text> |
|
411 |
<text text-anchor="middle" style="font-size:8.00;" x="1046" y="377"> REFERENCES potmsgset </text> |
|
412 |
<text text-anchor="middle" style="font-size:8.00;" x="924" y="391">pomsgid</text> |
|
413 |
<text text-anchor="middle" style="font-size:8.00;" x="972" y="391">integer</text> |
|
414 |
<text text-anchor="middle" style="font-size:8.00;" x="1044" y="391"> REFERENCES pomsgid </text> |
|
415 |
<text text-anchor="middle" style="font-size:8.00;" x="930" y="405">datefirstseen</text> |
|
416 |
<text text-anchor="middle" style="font-size:8.00;" x="978" y="405">timestamp</text> |
|
417 |
<text text-anchor="middle" style="font-size:8.00;" x="929" y="419">datelastseen</text> |
|
418 |
<text text-anchor="middle" style="font-size:8.00;" x="978" y="419">timestamp</text> |
|
419 |
<text text-anchor="middle" style="font-size:8.00;" x="932" y="433">inlastrevision</text> |
|
420 |
<text text-anchor="middle" style="font-size:8.00;" x="974" y="433">boolean</text> |
|
421 |
<text text-anchor="middle" style="font-size:8.00;" x="927" y="447">pluralform</text> |
|
422 |
<text text-anchor="middle" style="font-size:8.00;" x="972" y="447">integer</text> |
|
423 |
<polygon style="fill:none;stroke:black;" points="904,453 904,335 1096,335 1096,453 904,453"/> |
|
|
1959
by Canonical.com Patch Queue Manager
[trivial] dba maintenance stuff and fixes |
424 |
</g>
|
|
1681.1.131
by Stuart Bishop
Update diagrams |
425 |
<g id="edge38" class="edge"><title>pomsgidsighting->pomsgid</title> |
|
3691.17.2
by Stuart Bishop
Update database diagrams |
426 |
<path style="fill:none;stroke:black;" d="M1104,401C1122,402 1141,403 1158,404"/> |
427 |
<polygon style="fill:black;stroke:black;" points="1158,401 1168,405 1158,407 1158,401"/> |
|
|
1959
by Canonical.com Patch Queue Manager
[trivial] dba maintenance stuff and fixes |
428 |
</g>
|
429 |
<g id="node15" class="node"><title>potmsgset</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
430 |
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="1265,879 1265,747 1489,747 1489,879 1265,879"/> |
431 |
<polygon style="fill:white;stroke:white;" points="1268,764 1268,750 1486,750 1486,764 1268,764"/> |
|
432 |
<text text-anchor="middle" style="font-size:8.00;" x="1377" y="760">potmsgset</text> |
|
433 |
<polygon style="fill:none;stroke:black;" points="1268,764 1268,750 1486,750 1486,764 1268,764"/> |
|
434 |
<text text-anchor="middle" style="font-size:8.00;" x="1274" y="775">id</text> |
|
435 |
<text text-anchor="middle" style="font-size:8.00;" x="1338" y="775">serial</text> |
|
436 |
<text text-anchor="middle" style="font-size:8.00;" x="1389" y="775"> PRIMARY KEY </text> |
|
437 |
<text text-anchor="middle" style="font-size:8.00;" x="1290" y="789">primemsgid</text> |
|
438 |
<text text-anchor="middle" style="font-size:8.00;" x="1341" y="789">integer</text> |
|
439 |
<text text-anchor="middle" style="font-size:8.00;" x="1418" y="789"> UNIQUE REFERENCES pomsgid </text> |
|
440 |
<text text-anchor="middle" style="font-size:8.00;" x="1285" y="803">sequence</text> |
|
441 |
<text text-anchor="middle" style="font-size:8.00;" x="1341" y="803">integer</text> |
|
442 |
<text text-anchor="middle" style="font-size:8.00;" x="1289" y="817">potemplate</text> |
|
443 |
<text text-anchor="middle" style="font-size:8.00;" x="1341" y="817">integer</text> |
|
444 |
<text text-anchor="middle" style="font-size:8.00;" x="1422" y="817"> REFERENCES potemplate UNIQUE </text> |
|
445 |
<text text-anchor="middle" style="font-size:8.00;" x="1292" y="831">commenttext</text> |
|
446 |
<text text-anchor="middle" style="font-size:8.00;" x="1336" y="831">text</text> |
|
447 |
<text text-anchor="middle" style="font-size:8.00;" x="1293" y="845">filereferences</text> |
|
448 |
<text text-anchor="middle" style="font-size:8.00;" x="1336" y="845">text</text> |
|
449 |
<text text-anchor="middle" style="font-size:8.00;" x="1296" y="859">sourcecomment</text> |
|
450 |
<text text-anchor="middle" style="font-size:8.00;" x="1336" y="859">text</text> |
|
451 |
<text text-anchor="middle" style="font-size:8.00;" x="1294" y="873">flagscomment</text> |
|
452 |
<text text-anchor="middle" style="font-size:8.00;" x="1336" y="873">text</text> |
|
453 |
<polygon style="fill:none;stroke:black;" points="1265,879 1265,747 1489,747 1489,879 1265,879"/> |
|
|
1959
by Canonical.com Patch Queue Manager
[trivial] dba maintenance stuff and fixes |
454 |
</g>
|
|
1681.1.131
by Stuart Bishop
Update diagrams |
455 |
<g id="edge36" class="edge"><title>pomsgidsighting->potmsgset</title> |
|
3691.17.2
by Stuart Bishop
Update database diagrams |
456 |
<path style="fill:none;stroke:black;" d="M1057,457C1124,532 1235,655 1307,735"/> |
457 |
<polygon style="fill:black;stroke:black;" points="1310,733 1314,743 1305,738 1310,733"/> |
|
|
1959
by Canonical.com Patch Queue Manager
[trivial] dba maintenance stuff and fixes |
458 |
</g>
|
459 |
<g id="node9" class="node"><title>pomsgset</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
460 |
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="719,1118 719,944 953,944 953,1118 719,1118"/> |
461 |
<polygon style="fill:white;stroke:white;" points="722,961 722,947 950,947 950,961 722,961"/> |
|
462 |
<text text-anchor="middle" style="font-size:8.00;" x="836" y="957">pomsgset</text> |
|
463 |
<polygon style="fill:none;stroke:black;" points="722,961 722,947 950,947 950,961 722,961"/> |
|
464 |
<text text-anchor="middle" style="font-size:8.00;" x="728" y="972">id</text> |
|
465 |
<text text-anchor="middle" style="font-size:8.00;" x="802" y="972">serial</text> |
|
466 |
<text text-anchor="middle" style="font-size:8.00;" x="856" y="972"> PRIMARY KEY </text> |
|
467 |
<text text-anchor="middle" style="font-size:8.00;" x="739" y="986">sequence</text> |
|
468 |
<text text-anchor="middle" style="font-size:8.00;" x="805" y="986">integer</text> |
|
469 |
<text text-anchor="middle" style="font-size:8.00;" x="734" y="1000">pofile</text> |
|
470 |
<text text-anchor="middle" style="font-size:8.00;" x="805" y="1000">integer</text> |
|
471 |
<text text-anchor="middle" style="font-size:8.00;" x="880" y="1000"> REFERENCES pofile UNIQUE </text> |
|
472 |
<text text-anchor="middle" style="font-size:8.00;" x="742" y="1014">iscomplete</text> |
|
473 |
<text text-anchor="middle" style="font-size:8.00;" x="807" y="1014">boolean</text> |
|
474 |
<text text-anchor="middle" style="font-size:8.00;" x="738" y="1028">obsolete</text> |
|
475 |
<text text-anchor="middle" style="font-size:8.00;" x="807" y="1028">boolean</text> |
|
476 |
<text text-anchor="middle" style="font-size:8.00;" x="737" y="1042">isfuzzy</text> |
|
477 |
<text text-anchor="middle" style="font-size:8.00;" x="807" y="1042">boolean</text> |
|
478 |
<text text-anchor="middle" style="font-size:8.00;" x="746" y="1056">commenttext</text> |
|
479 |
<text text-anchor="middle" style="font-size:8.00;" x="800" y="1056">text</text> |
|
480 |
<text text-anchor="middle" style="font-size:8.00;" x="741" y="1070">potmsgset</text> |
|
481 |
<text text-anchor="middle" style="font-size:8.00;" x="805" y="1070">integer</text> |
|
482 |
<text text-anchor="middle" style="font-size:8.00;" x="887" y="1070"> REFERENCES potmsgset UNIQUE </text> |
|
483 |
<text text-anchor="middle" style="font-size:8.00;" x="750" y="1084">publishedfuzzy</text> |
|
484 |
<text text-anchor="middle" style="font-size:8.00;" x="807" y="1084">boolean</text> |
|
485 |
<text text-anchor="middle" style="font-size:8.00;" x="756" y="1098">publishedcomplete</text> |
|
486 |
<text text-anchor="middle" style="font-size:8.00;" x="807" y="1098">boolean</text> |
|
487 |
<text text-anchor="middle" style="font-size:8.00;" x="741" y="1112">isupdated</text> |
|
488 |
<text text-anchor="middle" style="font-size:8.00;" x="807" y="1112">boolean</text> |
|
489 |
<polygon style="fill:none;stroke:black;" points="719,1118 719,944 953,944 953,1118 719,1118"/> |
|
|
1681.1.131
by Stuart Bishop
Update diagrams |
490 |
</g>
|
491 |
<g id="edge40" class="edge"><title>pomsgset->pofile</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
492 |
<path style="fill:none;stroke:black;" d="M865,1122C899,1225 954,1395 996,1525"/> |
493 |
<polygon style="fill:black;stroke:black;" points="999,1524 999,1535 993,1526 999,1524"/> |
|
|
1681.1.131
by Stuart Bishop
Update diagrams |
494 |
</g>
|
495 |
<g id="edge42" class="edge"><title>pomsgset->potmsgset</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
496 |
<path style="fill:none;stroke:black;" d="M961,981C1047,946 1161,900 1248,865"/> |
497 |
<polygon style="fill:black;stroke:black;" points="1246,862 1257,861 1249,868 1246,862"/> |
|
|
1959
by Canonical.com Patch Queue Manager
[trivial] dba maintenance stuff and fixes |
498 |
</g>
|
499 |
<g id="node10" class="node"><title>poselection</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
500 |
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="14,739 14,649 446,649 446,739 14,739"/> |
501 |
<polygon style="fill:white;stroke:white;" points="17,666 17,652 443,652 443,666 17,666"/> |
|
502 |
<text text-anchor="middle" style="font-size:8.00;" x="230" y="662">poselection</text> |
|
503 |
<polygon style="fill:none;stroke:black;" points="17,666 17,652 443,652 443,666 17,666"/> |
|
504 |
<text text-anchor="middle" style="font-size:8.00;" x="23" y="677">id</text> |
|
505 |
<text text-anchor="middle" style="font-size:8.00;" x="103" y="677">serial</text> |
|
506 |
<text text-anchor="middle" style="font-size:8.00;" x="154" y="677"> PRIMARY KEY </text> |
|
507 |
<text text-anchor="middle" style="font-size:8.00;" x="35" y="691">pomsgset</text> |
|
508 |
<text text-anchor="middle" style="font-size:8.00;" x="106" y="691">integer</text> |
|
509 |
<text text-anchor="middle" style="font-size:8.00;" x="283" y="691"> REFERENCES pomsgset REFERENCES posubmission REFERENCES posubmission UNIQUE </text> |
|
510 |
<text text-anchor="middle" style="font-size:8.00;" x="37" y="705">pluralform</text> |
|
511 |
<text text-anchor="middle" style="font-size:8.00;" x="106" y="705">integer</text> |
|
512 |
<text text-anchor="middle" style="font-size:8.00;" x="240" y="705"> REFERENCES posubmission REFERENCES posubmission UNIQUE </text> |
|
513 |
<text text-anchor="middle" style="font-size:8.00;" x="47" y="719">activesubmission</text> |
|
514 |
<text text-anchor="middle" style="font-size:8.00;" x="106" y="719">integer</text> |
|
515 |
<text text-anchor="middle" style="font-size:8.00;" x="175" y="719"> REFERENCES posubmission </text> |
|
516 |
<text text-anchor="middle" style="font-size:8.00;" x="54" y="733">publishedsubmission</text> |
|
517 |
<text text-anchor="middle" style="font-size:8.00;" x="106" y="733">integer</text> |
|
518 |
<text text-anchor="middle" style="font-size:8.00;" x="175" y="733"> REFERENCES posubmission </text> |
|
519 |
<polygon style="fill:none;stroke:black;" points="14,739 14,649 446,649 446,739 14,739"/> |
|
|
1681.1.131
by Stuart Bishop
Update diagrams |
520 |
</g>
|
521 |
<g id="edge44" class="edge"><title>poselection->pomsgset</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
522 |
<path style="fill:none;stroke:black;" d="M318,743C418,799 585,891 702,956"/> |
523 |
<polygon style="fill:black;stroke:black;" points="704,953 711,961 701,959 704,953"/> |
|
|
1959
by Canonical.com Patch Queue Manager
[trivial] dba maintenance stuff and fixes |
524 |
</g>
|
525 |
<g id="edge46" class="edge"><title>poselection->posubmission</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
526 |
<path style="fill:none;stroke:black;" d="M274,743C332,808 434,923 503,1000"/> |
527 |
<polygon style="fill:black;stroke:black;" points="506,998 510,1008 501,1003 506,998"/> |
|
|
1681.1.131
by Stuart Bishop
Update diagrams |
528 |
</g>
|
529 |
<g id="edge48" class="edge"><title>poselection->posubmission</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
530 |
<path style="fill:none;stroke:black;" d="M274,743C332,808 434,923 503,1000"/> |
531 |
<polygon style="fill:black;stroke:black;" points="506,998 510,1008 501,1003 506,998"/> |
|
|
1681.1.131
by Stuart Bishop
Update diagrams |
532 |
</g>
|
533 |
<g id="edge50" class="edge"><title>posubmission->pomsgset</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
534 |
<path style="fill:none;stroke:black;" d="M695,1056C697,1056 699,1055 701,1055"/> |
535 |
<polygon style="fill:black;stroke:black;" points="701,1052 711,1053 702,1058 701,1052"/> |
|
|
1681.1.131
by Stuart Bishop
Update diagrams |
536 |
</g>
|
537 |
<g id="edge52" class="edge"><title>posubmission->potranslation</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
538 |
<path style="fill:none;stroke:black;" d="M632,1008C654,984 680,957 705,935 779,869 874,803 932,765"/> |
539 |
<polygon style="fill:black;stroke:black;" points="931,762 941,759 935,767 931,762"/> |
|
540 |
</g>
|
|
541 |
<g id="node60" class="node"><title>fake_person_258</title> |
|
542 |
<ellipse cx="146" cy="1013" rx="27" ry="18" style="fill:none;stroke:red;"/> |
|
543 |
<text text-anchor="middle" style="font-size:8.00;" x="146" y="1016">person</text> |
|
544 |
</g>
|
|
545 |
<g id="edge54" class="edge"><title>posubmission->fake_person_258</title> |
|
546 |
<path style="fill:none;stroke:black;" d="M449,1059C359,1045 242,1027 183,1019"/> |
|
547 |
<polygon style="fill:black;stroke:black;" points="182,1022 173,1017 183,1016 182,1022"/> |
|
|
1959
by Canonical.com Patch Queue Manager
[trivial] dba maintenance stuff and fixes |
548 |
</g>
|
549 |
<g id="node12" class="node"><title>posubscription</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
550 |
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="2382,493 2382,389 2628,389 2628,493 2382,493"/> |
551 |
<polygon style="fill:white;stroke:white;" points="2385,406 2385,392 2625,392 2625,406 2385,406"/> |
|
552 |
<text text-anchor="middle" style="font-size:8.00;" x="2505" y="402">posubscription</text> |
|
553 |
<polygon style="fill:none;stroke:black;" points="2385,406 2385,392 2625,392 2625,406 2385,406"/> |
|
554 |
<text text-anchor="middle" style="font-size:8.00;" x="2391" y="417">id</text> |
|
555 |
<text text-anchor="middle" style="font-size:8.00;" x="2466" y="417">serial</text> |
|
556 |
<text text-anchor="middle" style="font-size:8.00;" x="2528" y="417"> PRIMARY KEY </text> |
|
557 |
<text text-anchor="middle" style="font-size:8.00;" x="2399" y="431">person</text> |
|
558 |
<text text-anchor="middle" style="font-size:8.00;" x="2469" y="431">integer</text> |
|
559 |
<text text-anchor="middle" style="font-size:8.00;" x="2554" y="431"> REFERENCES person UNIQUE </text> |
|
560 |
<text text-anchor="middle" style="font-size:8.00;" x="2406" y="445">potemplate</text> |
|
561 |
<text text-anchor="middle" style="font-size:8.00;" x="2469" y="445">integer</text> |
|
562 |
<text text-anchor="middle" style="font-size:8.00;" x="2561" y="445"> REFERENCES potemplate UNIQUE </text> |
|
563 |
<text text-anchor="middle" style="font-size:8.00;" x="2403" y="459">language</text> |
|
564 |
<text text-anchor="middle" style="font-size:8.00;" x="2469" y="459">integer</text> |
|
565 |
<text text-anchor="middle" style="font-size:8.00;" x="2558" y="459"> REFERENCES language UNIQUE </text> |
|
566 |
<text text-anchor="middle" style="font-size:8.00;" x="2419" y="473">notificationinterval</text> |
|
567 |
<text text-anchor="middle" style="font-size:8.00;" x="2470" y="473">interval</text> |
|
568 |
<text text-anchor="middle" style="font-size:8.00;" x="2406" y="487">lastnotified</text> |
|
569 |
<text text-anchor="middle" style="font-size:8.00;" x="2475" y="487">timestamp</text> |
|
570 |
<polygon style="fill:none;stroke:black;" points="2382,493 2382,389 2628,389 2628,493 2382,493"/> |
|
|
1681.1.131
by Stuart Bishop
Update diagrams |
571 |
</g>
|
572 |
<g id="edge58" class="edge"><title>posubscription->potemplate</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
573 |
<path style="fill:none;stroke:black;" d="M2479,497C2422,619 2285,912 2197,1098"/> |
574 |
<polygon style="fill:black;stroke:black;" points="2200,1099 2193,1107 2194,1096 2200,1099"/> |
|
575 |
</g>
|
|
576 |
<g id="node62" class="node"><title>fake_person_260</title> |
|
577 |
<ellipse cx="2575" cy="23" rx="27" ry="18" style="fill:none;stroke:red;"/> |
|
578 |
<text text-anchor="middle" style="font-size:8.00;" x="2575" y="26">person</text> |
|
579 |
</g>
|
|
580 |
<g id="edge56" class="edge"><title>posubscription->fake_person_260</title> |
|
581 |
<path style="fill:none;stroke:black;" d="M2514,385C2530,294 2559,119 2570,51"/> |
|
582 |
<polygon style="fill:black;stroke:black;" points="2567,50 2572,41 2573,51 2567,50"/> |
|
583 |
</g>
|
|
584 |
<g id="node65" class="node"><title>fake_language_263</title> |
|
585 |
<ellipse cx="2773" cy="116" rx="27" ry="18" style="fill:none;stroke:red;"/> |
|
586 |
<text text-anchor="middle" style="font-size:8.00;" x="2773" y="119">language</text> |
|
587 |
</g>
|
|
588 |
<g id="edge60" class="edge"><title>posubscription->fake_language_263</title> |
|
589 |
<path style="fill:none;stroke:black;" d="M2551,385C2611,313 2712,191 2754,140"/> |
|
590 |
<polygon style="fill:black;stroke:black;" points="2751,138 2760,132 2757,142 2751,138"/> |
|
|
1959
by Canonical.com Patch Queue Manager
[trivial] dba maintenance stuff and fixes |
591 |
</g>
|
592 |
<g id="node14" class="node"><title>potemplatename</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
593 |
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="2312,1799 2312,1709 2472,1709 2472,1799 2312,1799"/> |
594 |
<polygon style="fill:white;stroke:white;" points="2315,1726 2315,1712 2469,1712 2469,1726 2315,1726"/> |
|
595 |
<text text-anchor="middle" style="font-size:8.00;" x="2392" y="1722">potemplatename</text> |
|
596 |
<polygon style="fill:none;stroke:black;" points="2315,1726 2315,1712 2469,1712 2469,1726 2315,1726"/> |
|
597 |
<text text-anchor="middle" style="font-size:8.00;" x="2321" y="1737">id</text> |
|
598 |
<text text-anchor="middle" style="font-size:8.00;" x="2392" y="1737">serial</text> |
|
599 |
<text text-anchor="middle" style="font-size:8.00;" x="2437" y="1737"> PRIMARY KEY </text> |
|
600 |
<text text-anchor="middle" style="font-size:8.00;" x="2327" y="1751">name</text> |
|
601 |
<text text-anchor="middle" style="font-size:8.00;" x="2390" y="1751">text</text> |
|
602 |
<text text-anchor="middle" style="font-size:8.00;" x="2425" y="1751"> UNIQUE </text> |
|
603 |
<text text-anchor="middle" style="font-size:8.00;" x="2324" y="1765">title</text> |
|
604 |
<text text-anchor="middle" style="font-size:8.00;" x="2390" y="1765">text</text> |
|
605 |
<text text-anchor="middle" style="font-size:8.00;" x="2335" y="1779">description</text> |
|
606 |
<text text-anchor="middle" style="font-size:8.00;" x="2390" y="1779">text</text> |
|
607 |
<text text-anchor="middle" style="font-size:8.00;" x="2347" y="1793">translationdomain</text> |
|
608 |
<text text-anchor="middle" style="font-size:8.00;" x="2390" y="1793">text</text> |
|
609 |
<text text-anchor="middle" style="font-size:8.00;" x="2425" y="1793"> UNIQUE </text> |
|
610 |
<polygon style="fill:none;stroke:black;" points="2312,1799 2312,1709 2472,1709 2472,1799 2312,1799"/> |
|
|
1959
by Canonical.com Patch Queue Manager
[trivial] dba maintenance stuff and fixes |
611 |
</g>
|
|
3322.1.13
by Stuart Bishop
Update database diagrams |
612 |
<g id="edge70" class="edge"><title>potemplate->potemplatename</title> |
|
3691.17.2
by Stuart Bishop
Update database diagrams |
613 |
<path style="fill:none;stroke:black;" d="M2206,1415C2258,1511 2322,1627 2360,1696"/> |
614 |
<polygon style="fill:black;stroke:black;" points="2363,1695 2365,1705 2357,1698 2363,1695"/> |
|
|
1681.1.57
by Stuart Bishop
Update database diagrams |
615 |
</g>
|
616 |
<g id="node17" class="node"><title>productseries</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
617 |
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="2485,2519 2485,2079 2759,2079 2759,2519 2485,2519"/> |
618 |
<polygon style="fill:white;stroke:white;" points="2488,2096 2488,2082 2756,2082 2756,2096 2488,2096"/> |
|
619 |
<text text-anchor="middle" style="font-size:8.00;" x="2622" y="2092">productseries</text> |
|
620 |
<polygon style="fill:none;stroke:black;" points="2488,2096 2488,2082 2756,2082 2756,2096 2488,2096"/> |
|
621 |
<text text-anchor="middle" style="font-size:8.00;" x="2494" y="2107">id</text> |
|
622 |
<text text-anchor="middle" style="font-size:8.00;" x="2575" y="2107">serial</text> |
|
623 |
<text text-anchor="middle" style="font-size:8.00;" x="2654" y="2107"> PRIMARY KEY UNIQUE </text> |
|
624 |
<text text-anchor="middle" style="font-size:8.00;" x="2503" y="2121">product</text> |
|
625 |
<text text-anchor="middle" style="font-size:8.00;" x="2578" y="2121">integer</text> |
|
626 |
<text text-anchor="middle" style="font-size:8.00;" x="2681" y="2121"> REFERENCES product UNIQUE UNIQUE </text> |
|
627 |
<text text-anchor="middle" style="font-size:8.00;" x="2500" y="2135">name</text> |
|
628 |
<text text-anchor="middle" style="font-size:8.00;" x="2573" y="2135">text</text> |
|
629 |
<text text-anchor="middle" style="font-size:8.00;" x="2625" y="2135"> UNIQUE </text> |
|
630 |
<text text-anchor="middle" style="font-size:8.00;" x="2506" y="2149">summary</text> |
|
631 |
<text text-anchor="middle" style="font-size:8.00;" x="2573" y="2149">text</text> |
|
632 |
<text text-anchor="middle" style="font-size:8.00;" x="2502" y="2163">branch</text> |
|
633 |
<text text-anchor="middle" style="font-size:8.00;" x="2578" y="2163">integer</text> |
|
634 |
<text text-anchor="middle" style="font-size:8.00;" x="2663" y="2163"> REFERENCES branch UNIQUE </text> |
|
635 |
<text text-anchor="middle" style="font-size:8.00;" x="2511" y="2177">importstatus</text> |
|
636 |
<text text-anchor="middle" style="font-size:8.00;" x="2578" y="2177">integer</text> |
|
637 |
<text text-anchor="middle" style="font-size:8.00;" x="2514" y="2191">datelastsynced</text> |
|
638 |
<text text-anchor="middle" style="font-size:8.00;" x="2584" y="2191">timestamp</text> |
|
639 |
<text text-anchor="middle" style="font-size:8.00;" x="2510" y="2205">syncinterval</text> |
|
640 |
<text text-anchor="middle" style="font-size:8.00;" x="2579" y="2205">interval</text> |
|
641 |
<text text-anchor="middle" style="font-size:8.00;" x="2503" y="2219">rcstype</text> |
|
642 |
<text text-anchor="middle" style="font-size:8.00;" x="2578" y="2219">integer</text> |
|
643 |
<text text-anchor="middle" style="font-size:8.00;" x="2502" y="2233">cvsroot</text> |
|
644 |
<text text-anchor="middle" style="font-size:8.00;" x="2573" y="2233">text</text> |
|
645 |
<text text-anchor="middle" style="font-size:8.00;" x="2625" y="2233"> UNIQUE </text> |
|
646 |
<text text-anchor="middle" style="font-size:8.00;" x="2508" y="2247">cvsmodule</text> |
|
647 |
<text text-anchor="middle" style="font-size:8.00;" x="2573" y="2247">text</text> |
|
648 |
<text text-anchor="middle" style="font-size:8.00;" x="2625" y="2247"> UNIQUE </text> |
|
649 |
<text text-anchor="middle" style="font-size:8.00;" x="2507" y="2261">cvsbranch</text> |
|
650 |
<text text-anchor="middle" style="font-size:8.00;" x="2573" y="2261">text</text> |
|
651 |
<text text-anchor="middle" style="font-size:8.00;" x="2625" y="2261"> UNIQUE </text> |
|
652 |
<text text-anchor="middle" style="font-size:8.00;" x="2510" y="2275">cvstarfileurl</text> |
|
653 |
<text text-anchor="middle" style="font-size:8.00;" x="2573" y="2275">text</text> |
|
654 |
<text text-anchor="middle" style="font-size:8.00;" x="2513" y="2289">svnrepository</text> |
|
655 |
<text text-anchor="middle" style="font-size:8.00;" x="2573" y="2289">text</text> |
|
656 |
<text text-anchor="middle" style="font-size:8.00;" x="2625" y="2289"> UNIQUE </text> |
|
657 |
<text text-anchor="middle" style="font-size:8.00;" x="2511" y="2303">bkrepository</text> |
|
658 |
<text text-anchor="middle" style="font-size:8.00;" x="2573" y="2303">text</text> |
|
659 |
<text text-anchor="middle" style="font-size:8.00;" x="2625" y="2303"> UNIQUE </text> |
|
660 |
<text text-anchor="middle" style="font-size:8.00;" x="2509" y="2317">releaseroot</text> |
|
661 |
<text text-anchor="middle" style="font-size:8.00;" x="2573" y="2317">text</text> |
|
662 |
<text text-anchor="middle" style="font-size:8.00;" x="2515" y="2331">releasefileglob</text> |
|
663 |
<text text-anchor="middle" style="font-size:8.00;" x="2573" y="2331">text</text> |
|
664 |
<text text-anchor="middle" style="font-size:8.00;" x="2515" y="2345">releaseverstyle</text> |
|
665 |
<text text-anchor="middle" style="font-size:8.00;" x="2578" y="2345">integer</text> |
|
666 |
<text text-anchor="middle" style="font-size:8.00;" x="2519" y="2359">targetarcharchive</text> |
|
667 |
<text text-anchor="middle" style="font-size:8.00;" x="2573" y="2359">text</text> |
|
668 |
<text text-anchor="middle" style="font-size:8.00;" x="2625" y="2359"> UNIQUE </text> |
|
669 |
<text text-anchor="middle" style="font-size:8.00;" x="2521" y="2373">targetarchcategory</text> |
|
670 |
<text text-anchor="middle" style="font-size:8.00;" x="2573" y="2373">text</text> |
|
671 |
<text text-anchor="middle" style="font-size:8.00;" x="2625" y="2373"> UNIQUE </text> |
|
672 |
<text text-anchor="middle" style="font-size:8.00;" x="2518" y="2387">targetarchbranch</text> |
|
673 |
<text text-anchor="middle" style="font-size:8.00;" x="2573" y="2387">text</text> |
|
674 |
<text text-anchor="middle" style="font-size:8.00;" x="2625" y="2387"> UNIQUE </text> |
|
675 |
<text text-anchor="middle" style="font-size:8.00;" x="2519" y="2401">targetarchversion</text> |
|
676 |
<text text-anchor="middle" style="font-size:8.00;" x="2573" y="2401">text</text> |
|
677 |
<text text-anchor="middle" style="font-size:8.00;" x="2625" y="2401"> UNIQUE </text> |
|
678 |
<text text-anchor="middle" style="font-size:8.00;" x="2514" y="2415">dateautotested</text> |
|
679 |
<text text-anchor="middle" style="font-size:8.00;" x="2584" y="2415">timestamp</text> |
|
680 |
<text text-anchor="middle" style="font-size:8.00;" x="2525" y="2429">dateprocessapproved</text> |
|
681 |
<text text-anchor="middle" style="font-size:8.00;" x="2584" y="2429">timestamp</text> |
|
682 |
<text text-anchor="middle" style="font-size:8.00;" x="2520" y="2443">datesyncapproved</text> |
|
683 |
<text text-anchor="middle" style="font-size:8.00;" x="2584" y="2443">timestamp</text> |
|
684 |
<text text-anchor="middle" style="font-size:8.00;" x="2508" y="2457">datestarted</text> |
|
685 |
<text text-anchor="middle" style="font-size:8.00;" x="2584" y="2457">timestamp</text> |
|
686 |
<text text-anchor="middle" style="font-size:8.00;" x="2510" y="2471">datefinished</text> |
|
687 |
<text text-anchor="middle" style="font-size:8.00;" x="2584" y="2471">timestamp</text> |
|
688 |
<text text-anchor="middle" style="font-size:8.00;" x="2509" y="2485">datecreated</text> |
|
689 |
<text text-anchor="middle" style="font-size:8.00;" x="2584" y="2485">timestamp</text> |
|
690 |
<text text-anchor="middle" style="font-size:8.00;" x="2500" y="2499">driver</text> |
|
691 |
<text text-anchor="middle" style="font-size:8.00;" x="2578" y="2499">integer</text> |
|
692 |
<text text-anchor="middle" style="font-size:8.00;" x="2647" y="2499"> REFERENCES person </text> |
|
693 |
<text text-anchor="middle" style="font-size:8.00;" x="2501" y="2513">owner</text> |
|
694 |
<text text-anchor="middle" style="font-size:8.00;" x="2578" y="2513">integer</text> |
|
695 |
<text text-anchor="middle" style="font-size:8.00;" x="2647" y="2513"> REFERENCES person </text> |
|
696 |
<polygon style="fill:none;stroke:black;" points="2485,2519 2485,2079 2759,2079 2759,2519 2485,2519"/> |
|
|
3322.1.13
by Stuart Bishop
Update database diagrams |
697 |
</g>
|
698 |
<g id="edge74" class="edge"><title>potemplate->productseries</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
699 |
<path style="fill:none;stroke:black;" d="M2160,1415C2191,1526 2239,1679 2300,1805 2347,1905 2412,2008 2471,2095"/> |
700 |
<polygon style="fill:black;stroke:black;" points="2474,2093 2477,2103 2468,2097 2474,2093"/> |
|
701 |
</g>
|
|
702 |
<g id="node67" class="node"><title>fake_license_265</title> |
|
703 |
<ellipse cx="2485" cy="951" rx="27" ry="18" style="fill:none;stroke:red;"/> |
|
704 |
<text text-anchor="middle" style="font-size:8.00;" x="2485" y="954">license</text> |
|
705 |
</g>
|
|
706 |
<g id="edge62" class="edge"><title>potemplate->fake_license_265</title> |
|
707 |
<path style="fill:none;stroke:black;" d="M2289,1118C2356,1062 2425,1002 2460,972"/> |
|
708 |
<polygon style="fill:black;stroke:black;" points="2458,969 2468,965 2463,974 2458,969"/> |
|
709 |
</g>
|
|
710 |
<g id="node69" class="node"><title>fake_person_267</title> |
|
711 |
<ellipse cx="2605" cy="1357" rx="27" ry="18" style="fill:none;stroke:red;"/> |
|
712 |
<text text-anchor="middle" style="font-size:8.00;" x="2605" y="1360">person</text> |
|
713 |
</g>
|
|
714 |
<g id="edge64" class="edge"><title>potemplate->fake_person_267</title> |
|
715 |
<path style="fill:none;stroke:black;" d="M2289,1294C2390,1314 2510,1338 2569,1350"/> |
|
716 |
<polygon style="fill:black;stroke:black;" points="2570,1347 2579,1352 2569,1353 2570,1347"/> |
|
717 |
</g>
|
|
718 |
<g id="node71" class="node"><title>fake_sourcepackagename_269</title> |
|
719 |
<ellipse cx="2628" cy="1136" rx="44" ry="18" style="fill:none;stroke:red;"/> |
|
720 |
<text text-anchor="middle" style="font-size:8.00;" x="2628" y="1139">sourcepackagename</text> |
|
721 |
</g>
|
|
722 |
<g id="edge66" class="edge"><title>potemplate->fake_sourcepackagename_269</title> |
|
723 |
<path style="fill:none;stroke:black;" d="M2289,1220C2392,1194 2514,1164 2580,1147"/> |
|
724 |
<polygon style="fill:black;stroke:black;" points="2580,1144 2590,1145 2581,1150 2580,1144"/> |
|
725 |
</g>
|
|
726 |
<g id="node73" class="node"><title>fake_distrorelease_271</title> |
|
727 |
<ellipse cx="2508" cy="1544" rx="32" ry="18" style="fill:none;stroke:red;"/> |
|
728 |
<text text-anchor="middle" style="font-size:8.00;" x="2508" y="1547">distrorelease</text> |
|
729 |
</g>
|
|
730 |
<g id="edge68" class="edge"><title>potemplate->fake_distrorelease_271</title> |
|
731 |
<path style="fill:none;stroke:black;" d="M2289,1384C2362,1437 2440,1494 2480,1524"/> |
|
732 |
<polygon style="fill:black;stroke:black;" points="2482,1521 2488,1530 2478,1527 2482,1521"/> |
|
733 |
</g>
|
|
734 |
<g id="node76" class="node"><title>fake_binarypackagename_274</title> |
|
735 |
<ellipse cx="2028" cy="797" rx="44" ry="18" style="fill:none;stroke:red;"/> |
|
736 |
<text text-anchor="middle" style="font-size:8.00;" x="2028" y="800">binarypackagename</text> |
|
737 |
</g>
|
|
738 |
<g id="edge72" class="edge"><title>potemplate->fake_binarypackagename_274</title> |
|
739 |
<path style="fill:none;stroke:black;" d="M2090,1107C2069,1005 2044,880 2034,825"/> |
|
740 |
<polygon style="fill:black;stroke:black;" points="2031,825 2032,815 2037,824 2031,825"/> |
|
741 |
</g>
|
|
742 |
<g id="node79" class="node"><title>fake_sourcepackagename_277</title> |
|
743 |
<ellipse cx="2294" cy="792" rx="44" ry="18" style="fill:none;stroke:red;"/> |
|
744 |
<text text-anchor="middle" style="font-size:8.00;" x="2294" y="795">sourcepackagename</text> |
|
745 |
</g>
|
|
746 |
<g id="edge76" class="edge"><title>potemplate->fake_sourcepackagename_277</title> |
|
747 |
<path style="fill:none;stroke:black;" d="M2178,1107C2216,1003 2263,875 2284,819"/> |
|
748 |
<polygon style="fill:black;stroke:black;" points="2281,818 2287,810 2287,821 2281,818"/> |
|
|
3322.1.13
by Stuart Bishop
Update database diagrams |
749 |
</g>
|
750 |
<g id="edge78" class="edge"><title>potmsgset->pomsgid</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
751 |
<path style="fill:none;stroke:black;" d="M1353,743C1324,657 1274,515 1250,447"/> |
752 |
<polygon style="fill:black;stroke:black;" points="1247,448 1247,437 1253,446 1247,448"/> |
|
|
3322.1.13
by Stuart Bishop
Update database diagrams |
753 |
</g>
|
754 |
<g id="edge80" class="edge"><title>potmsgset->potemplate</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
755 |
<path style="fill:none;stroke:black;" d="M1493,883C1614,955 1805,1070 1944,1155"/> |
756 |
<polygon style="fill:black;stroke:black;" points="1946,1152 1953,1160 1943,1158 1946,1152"/> |
|
757 |
</g>
|
|
758 |
<g id="node83" class="node"><title>fake_product_301</title> |
|
759 |
<ellipse cx="2712" cy="2880" rx="27" ry="18" style="fill:none;stroke:red;"/> |
|
760 |
<text text-anchor="middle" style="font-size:8.00;" x="2712" y="2883">product</text> |
|
761 |
</g>
|
|
762 |
<g id="edge82" class="edge"><title>productseries->fake_product_301</title> |
|
763 |
<path style="fill:none;stroke:black;" d="M2657,2523C2676,2649 2698,2792 2707,2852"/> |
|
764 |
<polygon style="fill:black;stroke:black;" points="2710,2852 2709,2862 2704,2853 2710,2852"/> |
|
765 |
</g>
|
|
766 |
<g id="node85" class="node"><title>fake_branch_303</title> |
|
767 |
<ellipse cx="3081" cy="2677" rx="27" ry="18" style="fill:none;stroke:red;"/> |
|
768 |
<text text-anchor="middle" style="font-size:8.00;" x="3081" y="2680">branch</text> |
|
769 |
</g>
|
|
770 |
<g id="edge84" class="edge"><title>productseries->fake_branch_303</title> |
|
771 |
<path style="fill:none;stroke:black;" d="M2767,2419C2871,2504 3002,2611 3056,2656"/> |
|
772 |
<polygon style="fill:black;stroke:black;" points="3059,2654 3064,2663 3054,2659 3059,2654"/> |
|
773 |
</g>
|
|
774 |
<g id="node87" class="node"><title>fake_person_305</title> |
|
775 |
<ellipse cx="2922" cy="2815" rx="27" ry="18" style="fill:none;stroke:red;"/> |
|
776 |
<text text-anchor="middle" style="font-size:8.00;" x="2922" y="2818">person</text> |
|
777 |
</g>
|
|
778 |
<g id="edge86" class="edge"><title>productseries->fake_person_305</title> |
|
779 |
<path style="fill:none;stroke:black;" d="M2752,2523C2813,2627 2879,2740 2907,2789"/> |
|
780 |
<polygon style="fill:black;stroke:black;" points="2910,2788 2912,2798 2904,2791 2910,2788"/> |
|
781 |
</g>
|
|
782 |
<g id="node89" class="node"><title>fake_person_307</title> |
|
783 |
<ellipse cx="3175" cy="2472" rx="27" ry="18" style="fill:none;stroke:red;"/> |
|
784 |
<text text-anchor="middle" style="font-size:8.00;" x="3175" y="2475">person</text> |
|
785 |
</g>
|
|
786 |
<g id="edge88" class="edge"><title>productseries->fake_person_307</title> |
|
787 |
<path style="fill:none;stroke:black;" d="M2767,2344C2894,2384 3068,2439 3140,2461"/> |
|
788 |
<polygon style="fill:black;stroke:black;" points="3141,2458 3150,2464 3139,2464 3141,2458"/> |
|
|
1681.1.57
by Stuart Bishop
Update database diagrams |
789 |
</g>
|
790 |
<g id="node18" class="node"><title>spokenin</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
791 |
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="3160,1957 3160,1895 3324,1895 3324,1957 3160,1957"/> |
792 |
<polygon style="fill:white;stroke:white;" points="3163,1912 3163,1898 3321,1898 3321,1912 3163,1912"/> |
|
793 |
<text text-anchor="middle" style="font-size:8.00;" x="3242" y="1908">spokenin</text> |
|
794 |
<polygon style="fill:none;stroke:black;" points="3163,1912 3163,1898 3321,1898 3321,1912 3163,1912"/> |
|
795 |
<text text-anchor="middle" style="font-size:8.00;" x="3181" y="1923">language</text> |
|
796 |
<text text-anchor="middle" style="font-size:8.00;" x="3214" y="1923">integer</text> |
|
797 |
<text text-anchor="middle" style="font-size:8.00;" x="3276" y="1923"> REFERENCES language </text> |
|
798 |
<text text-anchor="middle" style="font-size:8.00;" x="3178" y="1937">country</text> |
|
799 |
<text text-anchor="middle" style="font-size:8.00;" x="3214" y="1937">integer</text> |
|
800 |
<text text-anchor="middle" style="font-size:8.00;" x="3273" y="1937"> REFERENCES country </text> |
|
801 |
<text text-anchor="middle" style="font-size:8.00;" x="3169" y="1951">id</text> |
|
802 |
<text text-anchor="middle" style="font-size:8.00;" x="3214" y="1951">integer</text> |
|
803 |
<text text-anchor="middle" style="font-size:8.00;" x="3262" y="1951"> PRIMARY KEY </text> |
|
804 |
<polygon style="fill:none;stroke:black;" points="3160,1957 3160,1895 3324,1895 3324,1957 3160,1957"/> |
|
805 |
</g>
|
|
806 |
<g id="edge92" class="edge"><title>spokenin->country</title> |
|
807 |
<path style="fill:none;stroke:black;" d="M3282,1961C3300,1977 3322,1997 3343,2016"/> |
|
808 |
<polygon style="fill:black;stroke:black;" points="3346,2014 3351,2023 3341,2019 3346,2014"/> |
|
809 |
</g>
|
|
810 |
<g id="edge90" class="edge"><title>spokenin->language</title> |
|
811 |
<path style="fill:none;stroke:black;" d="M3190,1891C3178,1883 3164,1874 3151,1865"/> |
|
812 |
<polygon style="fill:black;stroke:black;" points="3148,1867 3142,1859 3152,1862 3148,1867"/> |
|
|
1681.1.57
by Stuart Bishop
Update database diagrams |
813 |
</g>
|
814 |
<g id="node19" class="node"><title>translationeffort</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
815 |
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="3764,809 3764,677 3928,677 3928,809 3764,809"/> |
816 |
<polygon style="fill:white;stroke:white;" points="3767,694 3767,680 3925,680 3925,694 3767,694"/> |
|
817 |
<text text-anchor="middle" style="font-size:8.00;" x="3846" y="690">translationeffort</text> |
|
818 |
<polygon style="fill:none;stroke:black;" points="3767,694 3767,680 3925,680 3925,694 3767,694"/> |
|
819 |
<text text-anchor="middle" style="font-size:8.00;" x="3773" y="705">id</text> |
|
820 |
<text text-anchor="middle" style="font-size:8.00;" x="3820" y="705">serial</text> |
|
821 |
<text text-anchor="middle" style="font-size:8.00;" x="3871" y="705"> PRIMARY KEY </text> |
|
822 |
<text text-anchor="middle" style="font-size:8.00;" x="3780" y="719">owner</text> |
|
823 |
<text text-anchor="middle" style="font-size:8.00;" x="3823" y="719">integer</text> |
|
824 |
<text text-anchor="middle" style="font-size:8.00;" x="3881" y="719"> REFERENCES person </text> |
|
825 |
<text text-anchor="middle" style="font-size:8.00;" x="3781" y="733">project</text> |
|
826 |
<text text-anchor="middle" style="font-size:8.00;" x="3823" y="733">integer</text> |
|
827 |
<text text-anchor="middle" style="font-size:8.00;" x="3881" y="733"> REFERENCES project </text> |
|
828 |
<text text-anchor="middle" style="font-size:8.00;" x="3779" y="747">name</text> |
|
829 |
<text text-anchor="middle" style="font-size:8.00;" x="3818" y="747">text</text> |
|
830 |
<text text-anchor="middle" style="font-size:8.00;" x="3859" y="747"> UNIQUE </text> |
|
831 |
<text text-anchor="middle" style="font-size:8.00;" x="3776" y="761">title</text> |
|
832 |
<text text-anchor="middle" style="font-size:8.00;" x="3818" y="761">text</text> |
|
833 |
<text text-anchor="middle" style="font-size:8.00;" x="3785" y="775">summary</text> |
|
834 |
<text text-anchor="middle" style="font-size:8.00;" x="3818" y="775">text</text> |
|
835 |
<text text-anchor="middle" style="font-size:8.00;" x="3787" y="789">description</text> |
|
836 |
<text text-anchor="middle" style="font-size:8.00;" x="3818" y="789">text</text> |
|
837 |
<text text-anchor="middle" style="font-size:8.00;" x="3786" y="803">categories</text> |
|
838 |
<text text-anchor="middle" style="font-size:8.00;" x="3823" y="803">integer</text> |
|
839 |
<text text-anchor="middle" style="font-size:8.00;" x="3882" y="803"> REFERENCES schema </text> |
|
840 |
<polygon style="fill:none;stroke:black;" points="3764,809 3764,677 3928,677 3928,809 3764,809"/> |
|
841 |
</g>
|
|
842 |
<g id="node93" class="node"><title>fake_person_416</title> |
|
843 |
<ellipse cx="4099" cy="467" rx="27" ry="18" style="fill:none;stroke:red;"/> |
|
844 |
<text text-anchor="middle" style="font-size:8.00;" x="4099" y="470">person</text> |
|
845 |
</g>
|
|
846 |
<g id="edge94" class="edge"><title>translationeffort->fake_person_416</title> |
|
847 |
<path style="fill:none;stroke:black;" d="M3910,673C3965,613 4041,530 4078,491"/> |
|
848 |
<polygon style="fill:black;stroke:black;" points="4076,488 4085,483 4081,493 4076,488"/> |
|
849 |
</g>
|
|
850 |
<g id="node95" class="node"><title>fake_project_418</title> |
|
851 |
<ellipse cx="4212" cy="626" rx="27" ry="18" style="fill:none;stroke:red;"/> |
|
852 |
<text text-anchor="middle" style="font-size:8.00;" x="4212" y="629">project</text> |
|
853 |
</g>
|
|
854 |
<g id="edge96" class="edge"><title>translationeffort->fake_project_418</title> |
|
855 |
<path style="fill:none;stroke:black;" d="M3936,714C4014,690 4123,654 4178,637"/> |
|
856 |
<polygon style="fill:black;stroke:black;" points="4177,634 4188,634 4179,640 4177,634"/> |
|
857 |
</g>
|
|
858 |
<g id="node97" class="node"><title>fake_schema_420</title> |
|
859 |
<ellipse cx="4211" cy="823" rx="27" ry="18" style="fill:none;stroke:red;"/> |
|
860 |
<text text-anchor="middle" style="font-size:8.00;" x="4211" y="826">schema</text> |
|
861 |
</g>
|
|
862 |
<g id="edge98" class="edge"><title>translationeffort->fake_schema_420</title> |
|
863 |
<path style="fill:none;stroke:black;" d="M3936,763C4013,779 4120,803 4175,815"/> |
|
864 |
<polygon style="fill:black;stroke:black;" points="4176,812 4185,817 4175,818 4176,812"/> |
|
|
1681.1.57
by Stuart Bishop
Update database diagrams |
865 |
</g>
|
866 |
<g id="node20" class="node"><title>translationeffortpotemplate</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
867 |
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="3012,1008 3012,932 3252,932 3252,1008 3012,1008"/> |
868 |
<polygon style="fill:white;stroke:white;" points="3015,949 3015,935 3249,935 3249,949 3015,949"/> |
|
869 |
<text text-anchor="middle" style="font-size:8.00;" x="3132" y="945">translationeffortpotemplate</text> |
|
870 |
<polygon style="fill:none;stroke:black;" points="3015,949 3015,935 3249,935 3249,949 3015,949"/> |
|
871 |
<text text-anchor="middle" style="font-size:8.00;" x="3044" y="960">translationeffort</text> |
|
872 |
<text text-anchor="middle" style="font-size:8.00;" x="3088" y="960">integer</text> |
|
873 |
<text text-anchor="middle" style="font-size:8.00;" x="3177" y="960"> REFERENCES translationeffort UNIQUE </text> |
|
874 |
<text text-anchor="middle" style="font-size:8.00;" x="3036" y="974">potemplate</text> |
|
875 |
<text text-anchor="middle" style="font-size:8.00;" x="3088" y="974">integer</text> |
|
876 |
<text text-anchor="middle" style="font-size:8.00;" x="3169" y="974"> REFERENCES potemplate UNIQUE </text> |
|
877 |
<text text-anchor="middle" style="font-size:8.00;" x="3030" y="988">priority</text> |
|
878 |
<text text-anchor="middle" style="font-size:8.00;" x="3088" y="988">integer</text> |
|
879 |
<text text-anchor="middle" style="font-size:8.00;" x="3031" y="1002">category</text> |
|
880 |
<text text-anchor="middle" style="font-size:8.00;" x="3088" y="1002">integer</text> |
|
881 |
<text text-anchor="middle" style="font-size:8.00;" x="3143" y="1002"> REFERENCES label </text> |
|
882 |
<polygon style="fill:none;stroke:black;" points="3012,1008 3012,932 3252,932 3252,1008 3012,1008"/> |
|
883 |
</g>
|
|
884 |
<g id="edge102" class="edge"><title>translationeffortpotemplate->potemplate</title> |
|
885 |
<path style="fill:none;stroke:black;" d="M3004,1006C2895,1037 2734,1083 2595,1123 2497,1151 2388,1183 2299,1208"/> |
|
886 |
<polygon style="fill:black;stroke:black;" points="2300,1211 2289,1211 2298,1205 2300,1211"/> |
|
887 |
</g>
|
|
888 |
<g id="edge100" class="edge"><title>translationeffortpotemplate->translationeffort</title> |
|
889 |
<path style="fill:none;stroke:black;" d="M3260,929C3399,885 3619,816 3746,775"/> |
|
890 |
<polygon style="fill:black;stroke:black;" points="3745,772 3756,772 3747,778 3745,772"/> |
|
891 |
</g>
|
|
892 |
<g id="node101" class="node"><title>fake_label_424</title> |
|
893 |
<ellipse cx="3496" cy="906" rx="27" ry="18" style="fill:none;stroke:red;"/> |
|
894 |
<text text-anchor="middle" style="font-size:8.00;" x="3496" y="909">label</text> |
|
895 |
</g>
|
|
896 |
<g id="edge104" class="edge"><title>translationeffortpotemplate->fake_label_424</title> |
|
897 |
<path style="fill:none;stroke:black;" d="M3260,947C3331,935 3413,920 3460,913"/> |
|
898 |
<polygon style="fill:black;stroke:black;" points="3460,910 3470,911 3461,916 3460,910"/> |
|
|
1681.1.57
by Stuart Bishop
Update database diagrams |
899 |
</g>
|
900 |
<g id="node21" class="node"><title>translationgroup</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
901 |
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="2757,1835 2757,1731 2931,1731 2931,1835 2757,1835"/> |
902 |
<polygon style="fill:white;stroke:white;" points="2760,1748 2760,1734 2928,1734 2928,1748 2760,1748"/> |
|
903 |
<text text-anchor="middle" style="font-size:8.00;" x="2844" y="1744">translationgroup</text> |
|
904 |
<polygon style="fill:none;stroke:black;" points="2760,1748 2760,1734 2928,1734 2928,1748 2760,1748"/> |
|
905 |
<text text-anchor="middle" style="font-size:8.00;" x="2766" y="1759">id</text> |
|
906 |
<text text-anchor="middle" style="font-size:8.00;" x="2815" y="1759">serial</text> |
|
907 |
<text text-anchor="middle" style="font-size:8.00;" x="2877" y="1759"> PRIMARY KEY </text> |
|
908 |
<text text-anchor="middle" style="font-size:8.00;" x="2772" y="1773">name</text> |
|
909 |
<text text-anchor="middle" style="font-size:8.00;" x="2813" y="1773">text</text> |
|
910 |
<text text-anchor="middle" style="font-size:8.00;" x="2865" y="1773"> UNIQUE </text> |
|
911 |
<text text-anchor="middle" style="font-size:8.00;" x="2769" y="1787">title</text> |
|
912 |
<text text-anchor="middle" style="font-size:8.00;" x="2813" y="1787">text</text> |
|
913 |
<text text-anchor="middle" style="font-size:8.00;" x="2778" y="1801">summary</text> |
|
914 |
<text text-anchor="middle" style="font-size:8.00;" x="2813" y="1801">text</text> |
|
915 |
<text text-anchor="middle" style="font-size:8.00;" x="2781" y="1815">datecreated</text> |
|
916 |
<text text-anchor="middle" style="font-size:8.00;" x="2824" y="1815">timestamp</text> |
|
917 |
<text text-anchor="middle" style="font-size:8.00;" x="2773" y="1829">owner</text> |
|
918 |
<text text-anchor="middle" style="font-size:8.00;" x="2818" y="1829">integer</text> |
|
919 |
<text text-anchor="middle" style="font-size:8.00;" x="2887" y="1829"> REFERENCES person </text> |
|
920 |
<polygon style="fill:none;stroke:black;" points="2757,1835 2757,1731 2931,1731 2931,1835 2757,1835"/> |
|
921 |
</g>
|
|
922 |
<g id="node103" class="node"><title>fake_person_426</title> |
|
923 |
<ellipse cx="2721" cy="1882" rx="27" ry="18" style="fill:none;stroke:red;"/> |
|
924 |
<text text-anchor="middle" style="font-size:8.00;" x="2721" y="1885">person</text> |
|
925 |
</g>
|
|
926 |
<g id="edge106" class="edge"><title>translationgroup->fake_person_426</title> |
|
927 |
<path style="fill:none;stroke:black;" d="M2774,1839C2764,1846 2755,1855 2746,1861"/> |
|
928 |
<polygon style="fill:black;stroke:black;" points="2748,1864 2738,1868 2743,1859 2748,1864"/> |
|
|
3322.1.13
by Stuart Bishop
Update database diagrams |
929 |
</g>
|
930 |
<g id="node22" class="node"><title>translationimportqueueentry</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
931 |
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="1682,2278 1682,2076 1930,2076 1930,2278 1682,2278"/> |
932 |
<polygon style="fill:white;stroke:white;" points="1685,2093 1685,2079 1927,2079 1927,2093 1685,2093"/> |
|
933 |
<text text-anchor="middle" style="font-size:8.00;" x="1806" y="2089">translationimportqueueentry</text> |
|
934 |
<polygon style="fill:none;stroke:black;" points="1685,2093 1685,2079 1927,2079 1927,2093 1685,2093"/> |
|
935 |
<text text-anchor="middle" style="font-size:8.00;" x="1691" y="2104">id</text> |
|
936 |
<text text-anchor="middle" style="font-size:8.00;" x="1770" y="2104">serial</text> |
|
937 |
<text text-anchor="middle" style="font-size:8.00;" x="1832" y="2104"> PRIMARY KEY </text> |
|
938 |
<text text-anchor="middle" style="font-size:8.00;" x="1695" y="2118">path</text> |
|
939 |
<text text-anchor="middle" style="font-size:8.00;" x="1768" y="2118">text</text> |
|
940 |
<text text-anchor="middle" style="font-size:8.00;" x="1699" y="2132">content</text> |
|
941 |
<text text-anchor="middle" style="font-size:8.00;" x="1773" y="2132">integer</text> |
|
942 |
<text text-anchor="middle" style="font-size:8.00;" x="1854" y="2132"> REFERENCES libraryfilealias </text> |
|
943 |
<text text-anchor="middle" style="font-size:8.00;" x="1702" y="2146">importer</text> |
|
944 |
<text text-anchor="middle" style="font-size:8.00;" x="1773" y="2146">integer</text> |
|
945 |
<text text-anchor="middle" style="font-size:8.00;" x="1842" y="2146"> REFERENCES person </text> |
|
946 |
<text text-anchor="middle" style="font-size:8.00;" x="1709" y="2160">dateimported</text> |
|
947 |
<text text-anchor="middle" style="font-size:8.00;" x="1779" y="2160">timestamp</text> |
|
948 |
<text text-anchor="middle" style="font-size:8.00;" x="1708" y="2174">distrorelease</text> |
|
949 |
<text text-anchor="middle" style="font-size:8.00;" x="1773" y="2174">integer</text> |
|
950 |
<text text-anchor="middle" style="font-size:8.00;" x="1851" y="2174"> REFERENCES distrorelease </text> |
|
951 |
<text text-anchor="middle" style="font-size:8.00;" x="1720" y="2188">sourcepackagename</text> |
|
952 |
<text text-anchor="middle" style="font-size:8.00;" x="1773" y="2188">integer</text> |
|
953 |
<text text-anchor="middle" style="font-size:8.00;" x="1864" y="2188"> REFERENCES sourcepackagename </text> |
|
954 |
<text text-anchor="middle" style="font-size:8.00;" x="1710" y="2202">productseries</text> |
|
955 |
<text text-anchor="middle" style="font-size:8.00;" x="1773" y="2202">integer</text> |
|
956 |
<text text-anchor="middle" style="font-size:8.00;" x="1852" y="2202"> REFERENCES productseries </text> |
|
957 |
<text text-anchor="middle" style="font-size:8.00;" x="1708" y="2216">is_published</text> |
|
958 |
<text text-anchor="middle" style="font-size:8.00;" x="1775" y="2216">boolean</text> |
|
959 |
<text text-anchor="middle" style="font-size:8.00;" x="1697" y="2230">pofile</text> |
|
960 |
<text text-anchor="middle" style="font-size:8.00;" x="1773" y="2230">integer</text> |
|
961 |
<text text-anchor="middle" style="font-size:8.00;" x="1840" y="2230"> REFERENCES pofile </text> |
|
962 |
<text text-anchor="middle" style="font-size:8.00;" x="1706" y="2244">potemplate</text> |
|
963 |
<text text-anchor="middle" style="font-size:8.00;" x="1773" y="2244">integer</text> |
|
964 |
<text text-anchor="middle" style="font-size:8.00;" x="1849" y="2244"> REFERENCES potemplate </text> |
|
965 |
<text text-anchor="middle" style="font-size:8.00;" x="1697" y="2258">status</text> |
|
966 |
<text text-anchor="middle" style="font-size:8.00;" x="1773" y="2258">integer</text> |
|
967 |
<text text-anchor="middle" style="font-size:8.00;" x="1721" y="2272">date_status_changed</text> |
|
968 |
<text text-anchor="middle" style="font-size:8.00;" x="1779" y="2272">timestamp</text> |
|
969 |
<polygon style="fill:none;stroke:black;" points="1682,2278 1682,2076 1930,2076 1930,2278 1682,2278"/> |
|
970 |
</g>
|
|
971 |
<g id="edge118" class="edge"><title>translationimportqueueentry->pofile</title> |
|
972 |
<path style="fill:none;stroke:black;" d="M1674,2094C1543,2012 1341,1884 1204,1797"/> |
|
973 |
<polygon style="fill:black;stroke:black;" points="1202,1800 1195,1792 1205,1794 1202,1800"/> |
|
974 |
</g>
|
|
975 |
<g id="edge120" class="edge"><title>translationimportqueueentry->potemplate</title> |
|
976 |
<path style="fill:none;stroke:black;" d="M1842,2072C1897,1914 2000,1613 2065,1425"/> |
|
977 |
<polygon style="fill:black;stroke:black;" points="2062,1424 2068,1415 2068,1426 2062,1424"/> |
|
978 |
</g>
|
|
979 |
<g id="edge116" class="edge"><title>translationimportqueueentry->productseries</title> |
|
980 |
<path style="fill:none;stroke:black;" d="M1938,2197C2083,2219 2314,2253 2467,2276"/> |
|
981 |
<polygon style="fill:black;stroke:black;" points="2467,2273 2477,2277 2467,2279 2467,2273"/> |
|
982 |
</g>
|
|
983 |
<g id="node105" class="node"><title>fake_libraryfilealias_428</title> |
|
984 |
<ellipse cx="1527" cy="2544" rx="35" ry="18" style="fill:none;stroke:red;"/> |
|
985 |
<text text-anchor="middle" style="font-size:8.00;" x="1527" y="2547">libraryfilealias</text> |
|
986 |
</g>
|
|
987 |
<g id="edge108" class="edge"><title>translationimportqueueentry->fake_libraryfilealias_428</title> |
|
988 |
<path style="fill:none;stroke:black;" d="M1726,2282C1664,2364 1583,2471 1546,2519"/> |
|
989 |
<polygon style="fill:black;stroke:black;" points="1549,2521 1540,2527 1543,2517 1549,2521"/> |
|
990 |
</g>
|
|
991 |
<g id="node107" class="node"><title>fake_person_430</title> |
|
992 |
<ellipse cx="2024" cy="2548" rx="27" ry="18" style="fill:none;stroke:red;"/> |
|
993 |
<text text-anchor="middle" style="font-size:8.00;" x="2024" y="2551">person</text> |
|
994 |
</g>
|
|
995 |
<g id="edge110" class="edge"><title>translationimportqueueentry->fake_person_430</title> |
|
996 |
<path style="fill:none;stroke:black;" d="M1868,2282C1916,2365 1980,2474 2009,2522"/> |
|
997 |
<polygon style="fill:black;stroke:black;" points="2012,2521 2014,2531 2006,2524 2012,2521"/> |
|
998 |
</g>
|
|
999 |
<g id="node109" class="node"><title>fake_distrorelease_432</title> |
|
1000 |
<ellipse cx="1689" cy="2629" rx="32" ry="18" style="fill:none;stroke:red;"/> |
|
1001 |
<text text-anchor="middle" style="font-size:8.00;" x="1689" y="2632">distrorelease</text> |
|
1002 |
</g>
|
|
1003 |
<g id="edge112" class="edge"><title>translationimportqueueentry->fake_distrorelease_432</title> |
|
1004 |
<path style="fill:none;stroke:black;" d="M1779,2282C1752,2386 1713,2539 1697,2601"/> |
|
1005 |
<polygon style="fill:black;stroke:black;" points="1700,2602 1694,2611 1694,2600 1700,2602"/> |
|
1006 |
</g>
|
|
1007 |
<g id="node111" class="node"><title>fake_sourcepackagename_434</title> |
|
1008 |
<ellipse cx="1863" cy="2670" rx="44" ry="18" style="fill:none;stroke:red;"/> |
|
1009 |
<text text-anchor="middle" style="font-size:8.00;" x="1863" y="2673">sourcepackagename</text> |
|
1010 |
</g>
|
|
1011 |
<g id="edge114" class="edge"><title>translationimportqueueentry->fake_sourcepackagename_434</title> |
|
1012 |
<path style="fill:none;stroke:black;" d="M1818,2282C1831,2397 1852,2574 1860,2642"/> |
|
1013 |
<polygon style="fill:black;stroke:black;" points="1863,2642 1861,2652 1857,2642 1863,2642"/> |
|
|
3322.1.13
by Stuart Bishop
Update database diagrams |
1014 |
</g>
|
1015 |
<g id="node23" class="node"><title>translator</title> |
|
|
3691.17.2
by Stuart Bishop
Update database diagrams |
1016 |
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="2892,1703 2892,1613 3146,1613 3146,1703 2892,1703"/> |
1017 |
<polygon style="fill:white;stroke:white;" points="2895,1630 2895,1616 3143,1616 3143,1630 2895,1630"/> |
|
1018 |
<text text-anchor="middle" style="font-size:8.00;" x="3019" y="1626">translator</text> |
|
1019 |
<polygon style="fill:none;stroke:black;" points="2895,1630 2895,1616 3143,1616 3143,1630 2895,1630"/> |
|
1020 |
<text text-anchor="middle" style="font-size:8.00;" x="2901" y="1641">id</text> |
|
1021 |
<text text-anchor="middle" style="font-size:8.00;" x="2966" y="1641">serial</text> |
|
1022 |
<text text-anchor="middle" style="font-size:8.00;" x="3028" y="1641"> PRIMARY KEY </text> |
|
1023 |
<text text-anchor="middle" style="font-size:8.00;" x="2924" y="1655">translationgroup</text> |
|
1024 |
<text text-anchor="middle" style="font-size:8.00;" x="2969" y="1655">integer</text> |
|
1025 |
<text text-anchor="middle" style="font-size:8.00;" x="3070" y="1655"> UNIQUE REFERENCES translationgroup </text> |
|
1026 |
<text text-anchor="middle" style="font-size:8.00;" x="2913" y="1669">language</text> |
|
1027 |
<text text-anchor="middle" style="font-size:8.00;" x="2969" y="1669">integer</text> |
|
1028 |
<text text-anchor="middle" style="font-size:8.00;" x="3058" y="1669"> UNIQUE REFERENCES language </text> |
|
1029 |
<text text-anchor="middle" style="font-size:8.00;" x="2913" y="1683">translator</text> |
|
1030 |
<text text-anchor="middle" style="font-size:8.00;" x="2969" y="1683">integer</text> |
|
1031 |
<text text-anchor="middle" style="font-size:8.00;" x="3038" y="1683"> REFERENCES person </text> |
|
1032 |
<text text-anchor="middle" style="font-size:8.00;" x="2916" y="1697">datecreated</text> |
|
1033 |
<text text-anchor="middle" style="font-size:8.00;" x="2975" y="1697">timestamp</text> |
|
1034 |
<polygon style="fill:none;stroke:black;" points="2892,1703 2892,1613 3146,1613 3146,1703 2892,1703"/> |
|
1035 |
</g>
|
|
1036 |
<g id="edge124" class="edge"><title>translator->language</title> |
|
1037 |
<path style="fill:none;stroke:black;" d="M3031,1707C3032,1711 3033,1715 3034,1719"/> |
|
1038 |
<polygon style="fill:black;stroke:black;" points="3037,1719 3036,1729 3031,1720 3037,1719"/> |
|
1039 |
</g>
|
|
1040 |
<g id="edge122" class="edge"><title>translator->translationgroup</title> |
|
1041 |
<path style="fill:none;stroke:black;" d="M2950,1707C2944,1711 2937,1716 2930,1721"/> |
|
1042 |
<polygon style="fill:black;stroke:black;" points="2932,1724 2922,1727 2928,1718 2932,1724"/> |
|
1043 |
</g>
|
|
1044 |
<g id="node118" class="node"><title>fake_person_441</title> |
|
1045 |
<ellipse cx="3101" cy="1482" rx="27" ry="18" style="fill:none;stroke:red;"/> |
|
1046 |
<text text-anchor="middle" style="font-size:8.00;" x="3101" y="1485">person</text> |
|
1047 |
</g>
|
|
1048 |
<g id="edge126" class="edge"><title>translator->fake_person_441</title> |
|
1049 |
<path style="fill:none;stroke:black;" d="M3042,1609C3057,1576 3076,1535 3089,1508"/> |
|
1050 |
<polygon style="fill:black;stroke:black;" points="3086,1507 3093,1499 3092,1510 3086,1507"/> |
|
|
1776
by Canonical.com Patch Queue Manager
[trivial] various fixes that didn't merge before (network?) and new db diagrams |
1051 |
</g>
|
1052 |
</g>
|
|
1053 |
</svg>
|
