« back to all changes in this revision
Viewing changes to database/schema/diagrams/foaf.svg
- browse files at revision 3346
- compare with another revision
- compare with revision 13957.2.4
- download diff
- download tarball
- view history from revision 3346
- Committer: Canonical.com Patch Queue Manager
- Date: 2006-03-25 14:51:49 UTC
- mfrom: (3322.1.16 trivial)
- Revision ID: pqm@pqm.ubuntu.com-20060325145149-ce7d26a221483131
[trivial] Update database diagrams
- files added:
- database/schema/diagrams/session.svg
- files modified:
- database/schema/diagram.cfg
added
removed
database/schema/diagrams/foaf.svg
3
3
"http://www.w3.org/TR/2001/REC-SVG-20010904/DTD/svg10.dtd">
4
4
<!-- Generated by fdp version 2.2.1 (Tue Oct 11 01:38:21 UTC 2005)
5
5
For user: (stub) Stuart Bishop,,, Title: g Pages: 1 -->
6
<svg width="312px" height="535px"
7
viewBox = "-1 -1 311 534"
6
<svg width="2096px" height="1695px"
7
viewBox = "-1 -1 2095 1694"
8
8
xmlns="http://www.w3.org/2000/svg">
9
<g id="graph0" class="graph" transform = "scale(0.258911)"
10
style="font-family:Times-Roman;font-size:14.00;">
9
<g id="graph0" class="graph" style="font-family:Times-Roman;font-size:14.00;">
11
10
<title>g</title>
12
<text text-anchor="middle" style="font-size:22.00;" x="586" y="2042">Foaf</text>
11
<text text-anchor="middle" style="font-size:22.00;" x="1047" y="1677">Foaf</text>
13
12
<g id="node1" class="node"><title>calendar</title>
14
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="828,338 828,284 934,284 934,338 828,338"/>
15
<polygon style="fill:white;stroke:white;" points="831,299 831,287 931,287 931,299 831,299"/>
16
<text text-anchor="middle" style="font-size:6.00;" x="881" y="295">calendar</text>
17
<polygon style="fill:none;stroke:black;" points="831,299 831,287 931,287 931,299 831,299"/>
18
<text text-anchor="middle" style="font-size:6.00;" x="836" y="308">id</text>
19
<text text-anchor="middle" style="font-size:6.00;" x="867" y="308">serial</text>
20
<text text-anchor="middle" style="font-size:6.00;" x="907" y="308"> PRIMARY KEY </text>
21
<text text-anchor="middle" style="font-size:6.00;" x="839" y="320">title</text>
22
<text text-anchor="middle" style="font-size:6.00;" x="866" y="320">text</text>
23
<text text-anchor="middle" style="font-size:6.00;" x="844" y="332">revision</text>
24
<text text-anchor="middle" style="font-size:6.00;" x="869" y="332">integer</text>
25
<polygon style="fill:none;stroke:black;" points="828,338 828,284 934,284 934,338 828,338"/>
13
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="1588,1333 1588,1271 1722,1271 1722,1333 1588,1333"/>
14
<polygon style="fill:white;stroke:white;" points="1591,1288 1591,1274 1719,1274 1719,1288 1591,1288"/>
15
<text text-anchor="middle" style="font-size:8.00;" x="1655" y="1284">calendar</text>
16
<polygon style="fill:none;stroke:black;" points="1591,1288 1591,1274 1719,1274 1719,1288 1591,1288"/>
17
<text text-anchor="middle" style="font-size:8.00;" x="1597" y="1299">id</text>
18
<text text-anchor="middle" style="font-size:8.00;" x="1636" y="1299">serial</text>
19
<text text-anchor="middle" style="font-size:8.00;" x="1687" y="1299"> PRIMARY KEY </text>
20
<text text-anchor="middle" style="font-size:8.00;" x="1600" y="1313">title</text>
21
<text text-anchor="middle" style="font-size:8.00;" x="1634" y="1313">text</text>
22
<text text-anchor="middle" style="font-size:8.00;" x="1607" y="1327">revision</text>
23
<text text-anchor="middle" style="font-size:8.00;" x="1639" y="1327">integer</text>
24
<polygon style="fill:none;stroke:black;" points="1588,1333 1588,1271 1722,1271 1722,1333 1588,1333"/>
26
25
</g>
27
26
<g id="node2" class="node"><title>calendarsubscription</title>
28
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="981,103 981,37 1127,37 1127,103 981,103"/>
29
<polygon style="fill:white;stroke:white;" points="984,52 984,40 1124,40 1124,52 984,52"/>
30
<text text-anchor="middle" style="font-size:6.00;" x="1054" y="48">calendarsubscription</text>
31
<polygon style="fill:none;stroke:black;" points="984,52 984,40 1124,40 1124,52 984,52"/>
32
<text text-anchor="middle" style="font-size:6.00;" x="989" y="61">id</text>
33
<text text-anchor="middle" style="font-size:6.00;" x="1017" y="61">serial</text>
34
<text text-anchor="middle" style="font-size:6.00;" x="1057" y="61"> PRIMARY KEY </text>
35
<text text-anchor="middle" style="font-size:6.00;" x="995" y="73">subject</text>
36
<text text-anchor="middle" style="font-size:6.00;" x="1019" y="73">integer</text>
37
<text text-anchor="middle" style="font-size:6.00;" x="1078" y="73"> REFERENCES calendar UNIQUE </text>
38
<text text-anchor="middle" style="font-size:6.00;" x="995" y="85">object</text>
39
<text text-anchor="middle" style="font-size:6.00;" x="1019" y="85">integer</text>
40
<text text-anchor="middle" style="font-size:6.00;" x="1078" y="85"> REFERENCES calendar UNIQUE </text>
41
<text text-anchor="middle" style="font-size:6.00;" x="995" y="97">colour</text>
42
<text text-anchor="middle" style="font-size:6.00;" x="1016" y="97">text</text>
43
<polygon style="fill:none;stroke:black;" points="981,103 981,37 1127,37 1127,103 981,103"/>
27
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="1697,1648 1697,1572 1883,1572 1883,1648 1697,1648"/>
28
<polygon style="fill:white;stroke:white;" points="1700,1589 1700,1575 1880,1575 1880,1589 1700,1589"/>
29
<text text-anchor="middle" style="font-size:8.00;" x="1790" y="1585">calendarsubscription</text>
30
<polygon style="fill:none;stroke:black;" points="1700,1589 1700,1575 1880,1575 1880,1589 1700,1589"/>
31
<text text-anchor="middle" style="font-size:8.00;" x="1706" y="1600">id</text>
32
<text text-anchor="middle" style="font-size:8.00;" x="1740" y="1600">serial</text>
33
<text text-anchor="middle" style="font-size:8.00;" x="1791" y="1600"> PRIMARY KEY </text>
34
<text text-anchor="middle" style="font-size:8.00;" x="1714" y="1614">subject</text>
35
<text text-anchor="middle" style="font-size:8.00;" x="1743" y="1614">integer</text>
36
<text text-anchor="middle" style="font-size:8.00;" x="1820" y="1614"> REFERENCES calendar UNIQUE </text>
37
<text text-anchor="middle" style="font-size:8.00;" x="1712" y="1628">object</text>
38
<text text-anchor="middle" style="font-size:8.00;" x="1743" y="1628">integer</text>
39
<text text-anchor="middle" style="font-size:8.00;" x="1820" y="1628"> REFERENCES calendar UNIQUE </text>
40
<text text-anchor="middle" style="font-size:8.00;" x="1713" y="1642">colour</text>
41
<text text-anchor="middle" style="font-size:8.00;" x="1738" y="1642">text</text>
42
<polygon style="fill:none;stroke:black;" points="1697,1648 1697,1572 1883,1572 1883,1648 1697,1648"/>
44
43
</g>
45
44
<g id="edge2" class="edge"><title>calendarsubscription->calendar</title>
46
<path style="fill:none;stroke:black;" d="M1034,107C1005,151 951,226 916,272"/>
47
<polygon style="fill:black;stroke:black;" points="919,274 910,280 913,270 919,274"/>
45
<path style="fill:none;stroke:black;" d="M1772,1568C1746,1509 1701,1406 1675,1346"/>
46
<polygon style="fill:black;stroke:black;" points="1672,1348 1671,1337 1678,1345 1672,1348"/>
48
47
</g>
49
48
<g id="edge4" class="edge"><title>calendarsubscription->calendar</title>
50
<path style="fill:none;stroke:black;" d="M1022,107C987,152 934,226 904,272"/>
51
<polygon style="fill:black;stroke:black;" points="907,274 898,280 901,270 907,274"/>
49
<path style="fill:none;stroke:black;" d="M1772,1568C1746,1509 1701,1406 1675,1346"/>
50
<polygon style="fill:black;stroke:black;" points="1672,1348 1671,1337 1678,1345 1672,1348"/>
52
51
</g>
53
52
<g id="node3" class="node"><title>country</title>
54
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="318,1236 318,1146 450,1146 450,1236 318,1236"/>
55
<polygon style="fill:white;stroke:white;" points="321,1161 321,1149 447,1149 447,1161 321,1161"/>
56
<text text-anchor="middle" style="font-size:6.00;" x="384" y="1157">country</text>
57
<polygon style="fill:none;stroke:black;" points="321,1161 321,1149 447,1149 447,1161 321,1161"/>
58
<text text-anchor="middle" style="font-size:6.00;" x="326" y="1170">id</text>
59
<text text-anchor="middle" style="font-size:6.00;" x="371" y="1170">serial</text>
60
<text text-anchor="middle" style="font-size:6.00;" x="423" y="1170"> PRIMARY KEY </text>
61
<text text-anchor="middle" style="font-size:6.00;" x="341" y="1182">iso3166code2</text>
62
<text text-anchor="middle" style="font-size:6.00;" x="379" y="1182">character(2)</text>
63
<text text-anchor="middle" style="font-size:6.00;" x="414" y="1182"> UNIQUE </text>
64
<text text-anchor="middle" style="font-size:6.00;" x="341" y="1194">iso3166code3</text>
65
<text text-anchor="middle" style="font-size:6.00;" x="379" y="1194">character(3)</text>
66
<text text-anchor="middle" style="font-size:6.00;" x="414" y="1194"> UNIQUE </text>
67
<text text-anchor="middle" style="font-size:6.00;" x="331" y="1206">name</text>
68
<text text-anchor="middle" style="font-size:6.00;" x="370" y="1206">text</text>
69
<text text-anchor="middle" style="font-size:6.00;" x="414" y="1206"> UNIQUE </text>
70
<text text-anchor="middle" style="font-size:6.00;" x="329" y="1218">title</text>
71
<text text-anchor="middle" style="font-size:6.00;" x="370" y="1218">text</text>
72
<text text-anchor="middle" style="font-size:6.00;" x="338" y="1230">description</text>
73
<text text-anchor="middle" style="font-size:6.00;" x="370" y="1230">text</text>
74
<polygon style="fill:none;stroke:black;" points="318,1236 318,1146 450,1146 450,1236 318,1236"/>
53
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="1672,317 1672,199 1868,199 1868,317 1672,317"/>
54
<polygon style="fill:white;stroke:white;" points="1675,216 1675,202 1865,202 1865,216 1675,216"/>
55
<text text-anchor="middle" style="font-size:8.00;" x="1770" y="212">country</text>
56
<polygon style="fill:none;stroke:black;" points="1675,216 1675,202 1865,202 1865,216 1675,216"/>
57
<text text-anchor="middle" style="font-size:8.00;" x="1681" y="227">id</text>
58
<text text-anchor="middle" style="font-size:8.00;" x="1739" y="227">serial</text>
59
<text text-anchor="middle" style="font-size:8.00;" x="1806" y="227"> PRIMARY KEY </text>
60
<text text-anchor="middle" style="font-size:8.00;" x="1701" y="241">iso3166code2</text>
61
<text text-anchor="middle" style="font-size:8.00;" x="1750" y="241">character(2)</text>
62
<text text-anchor="middle" style="font-size:8.00;" x="1794" y="241"> UNIQUE </text>
63
<text text-anchor="middle" style="font-size:8.00;" x="1701" y="255">iso3166code3</text>
64
<text text-anchor="middle" style="font-size:8.00;" x="1750" y="255">character(3)</text>
65
<text text-anchor="middle" style="font-size:8.00;" x="1794" y="255"> UNIQUE </text>
66
<text text-anchor="middle" style="font-size:8.00;" x="1687" y="269">name</text>
67
<text text-anchor="middle" style="font-size:8.00;" x="1737" y="269">text</text>
68
<text text-anchor="middle" style="font-size:8.00;" x="1794" y="269"> UNIQUE </text>
69
<text text-anchor="middle" style="font-size:8.00;" x="1684" y="283">title</text>
70
<text text-anchor="middle" style="font-size:8.00;" x="1737" y="283">text</text>
71
<text text-anchor="middle" style="font-size:8.00;" x="1695" y="297">description</text>
72
<text text-anchor="middle" style="font-size:8.00;" x="1737" y="297">text</text>
73
<text text-anchor="middle" style="font-size:8.00;" x="1693" y="311">continent</text>
74
<text text-anchor="middle" style="font-size:8.00;" x="1742" y="311">integer</text>
75
<text text-anchor="middle" style="font-size:8.00;" x="1820" y="311"> REFERENCES continent </text>
76
<polygon style="fill:none;stroke:black;" points="1672,317 1672,199 1868,199 1868,317 1672,317"/>
77
</g>
78
<g id="node25" class="node"><title>fake_continent_92</title>
79
<ellipse cx="1935" cy="23" rx="27" ry="18" style="fill:none;stroke:red;"/>
80
<text text-anchor="middle" style="font-size:8.00;" x="1935" y="26">continent</text>
81
</g>
82
<g id="edge6" class="edge"><title>country->fake_continent_92</title>
83
<path style="fill:none;stroke:black;" d="M1814,195C1848,146 1893,83 1917,48"/>
84
<polygon style="fill:black;stroke:black;" points="1914,46 1923,40 1920,50 1914,46"/>
75
85
</g>
76
86
<g id="node4" class="node"><title>emailaddress</title>
77
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="500,387 500,321 618,321 618,387 500,387"/>
78
<polygon style="fill:white;stroke:white;" points="503,336 503,324 615,324 615,336 503,336"/>
79
<text text-anchor="middle" style="font-size:6.00;" x="559" y="332">emailaddress</text>
80
<polygon style="fill:none;stroke:black;" points="503,336 503,324 615,324 615,336 503,336"/>
81
<text text-anchor="middle" style="font-size:6.00;" x="508" y="345">id</text>
82
<text text-anchor="middle" style="font-size:6.00;" x="536" y="345">serial</text>
83
<text text-anchor="middle" style="font-size:6.00;" x="576" y="345"> PRIMARY KEY </text>
84
<text text-anchor="middle" style="font-size:6.00;" x="513" y="357">email</text>
85
<text text-anchor="middle" style="font-size:6.00;" x="535" y="357">text</text>
86
<text text-anchor="middle" style="font-size:6.00;" x="514" y="369">person</text>
87
<text text-anchor="middle" style="font-size:6.00;" x="538" y="369">integer</text>
88
<text text-anchor="middle" style="font-size:6.00;" x="583" y="369"> REFERENCES person </text>
89
<text text-anchor="middle" style="font-size:6.00;" x="513" y="381">status</text>
90
<text text-anchor="middle" style="font-size:6.00;" x="538" y="381">integer</text>
91
<polygon style="fill:none;stroke:black;" points="500,387 500,321 618,321 618,387 500,387"/>
92
</g>
93
<g id="node14" class="node"><title>person</title>
94
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="468,935 468,569 670,569 670,935 468,935"/>
95
<polygon style="fill:white;stroke:white;" points="471,584 471,572 667,572 667,584 471,584"/>
96
<text text-anchor="middle" style="font-size:6.00;" x="569" y="580">person</text>
97
<polygon style="fill:none;stroke:black;" points="471,584 471,572 667,572 667,584 471,584"/>
98
<text text-anchor="middle" style="font-size:6.00;" x="476" y="593">id</text>
99
<text text-anchor="middle" style="font-size:6.00;" x="551" y="593">serial</text>
100
<text text-anchor="middle" style="font-size:6.00;" x="600" y="593"> PRIMARY KEY </text>
101
<text text-anchor="middle" style="font-size:6.00;" x="489" y="605">displayname</text>
102
<text text-anchor="middle" style="font-size:6.00;" x="550" y="605">text</text>
103
<text text-anchor="middle" style="font-size:6.00;" x="487" y="617">givenname</text>
104
<text text-anchor="middle" style="font-size:6.00;" x="550" y="617">text</text>
105
<text text-anchor="middle" style="font-size:6.00;" x="488" y="629">familyname</text>
106
<text text-anchor="middle" style="font-size:6.00;" x="550" y="629">text</text>
107
<text text-anchor="middle" style="font-size:6.00;" x="485" y="641">password</text>
108
<text text-anchor="middle" style="font-size:6.00;" x="550" y="641">text</text>
109
<text text-anchor="middle" style="font-size:6.00;" x="487" y="653">teamowner</text>
110
<text text-anchor="middle" style="font-size:6.00;" x="553" y="653">integer</text>
111
<text text-anchor="middle" style="font-size:6.00;" x="607" y="653"> REFERENCES person </text>
112
<text text-anchor="middle" style="font-size:6.00;" x="494" y="665">teamdescription</text>
113
<text text-anchor="middle" style="font-size:6.00;" x="550" y="665">text</text>
114
<text text-anchor="middle" style="font-size:6.00;" x="481" y="677">name</text>
115
<text text-anchor="middle" style="font-size:6.00;" x="550" y="677">text</text>
116
<text text-anchor="middle" style="font-size:6.00;" x="485" y="689">language</text>
117
<text text-anchor="middle" style="font-size:6.00;" x="553" y="689">integer</text>
118
<text text-anchor="middle" style="font-size:6.00;" x="610" y="689"> REFERENCES language </text>
119
<text text-anchor="middle" style="font-size:6.00;" x="477" y="701">fti</text>
120
<text text-anchor="middle" style="font-size:6.00;" x="555" y="701">tsvector</text>
121
<text text-anchor="middle" style="font-size:6.00;" x="505" y="713">defaultmembershipperiod</text>
122
<text text-anchor="middle" style="font-size:6.00;" x="553" y="713">integer</text>
123
<text text-anchor="middle" style="font-size:6.00;" x="500" y="725">defaultrenewalperiod</text>
124
<text text-anchor="middle" style="font-size:6.00;" x="553" y="725">integer</text>
125
<text text-anchor="middle" style="font-size:6.00;" x="496" y="737">subscriptionpolicy</text>
126
<text text-anchor="middle" style="font-size:6.00;" x="553" y="737">integer</text>
127
<text text-anchor="middle" style="font-size:6.00;" x="483" y="749">merged</text>
128
<text text-anchor="middle" style="font-size:6.00;" x="553" y="749">integer</text>
129
<text text-anchor="middle" style="font-size:6.00;" x="607" y="749"> REFERENCES person </text>
130
<text text-anchor="middle" style="font-size:6.00;" x="488" y="761">datecreated</text>
131
<text text-anchor="middle" style="font-size:6.00;" x="558" y="761">timestamp</text>
132
<text text-anchor="middle" style="font-size:6.00;" x="484" y="773">calendar</text>
133
<text text-anchor="middle" style="font-size:6.00;" x="553" y="773">integer</text>
134
<text text-anchor="middle" style="font-size:6.00;" x="621" y="773"> REFERENCES calendar UNIQUE </text>
135
<text text-anchor="middle" style="font-size:6.00;" x="485" y="785">timezone</text>
136
<text text-anchor="middle" style="font-size:6.00;" x="550" y="785">text</text>
137
<text text-anchor="middle" style="font-size:6.00;" x="482" y="797">karma</text>
138
<text text-anchor="middle" style="font-size:6.00;" x="553" y="797">integer</text>
139
<text text-anchor="middle" style="font-size:6.00;" x="489" y="809">addressline1</text>
140
<text text-anchor="middle" style="font-size:6.00;" x="550" y="809">text</text>
141
<text text-anchor="middle" style="font-size:6.00;" x="489" y="821">addressline2</text>
142
<text text-anchor="middle" style="font-size:6.00;" x="550" y="821">text</text>
143
<text text-anchor="middle" style="font-size:6.00;" x="489" y="833">organization</text>
144
<text text-anchor="middle" style="font-size:6.00;" x="550" y="833">text</text>
145
<text text-anchor="middle" style="font-size:6.00;" x="479" y="845">city</text>
146
<text text-anchor="middle" style="font-size:6.00;" x="550" y="845">text</text>
147
<text text-anchor="middle" style="font-size:6.00;" x="485" y="857">province</text>
148
<text text-anchor="middle" style="font-size:6.00;" x="550" y="857">text</text>
149
<text text-anchor="middle" style="font-size:6.00;" x="484" y="869">country</text>
150
<text text-anchor="middle" style="font-size:6.00;" x="553" y="869">integer</text>
151
<text text-anchor="middle" style="font-size:6.00;" x="609" y="869"> REFERENCES country </text>
152
<text text-anchor="middle" style="font-size:6.00;" x="485" y="881">postcode</text>
153
<text text-anchor="middle" style="font-size:6.00;" x="550" y="881">text</text>
154
<text text-anchor="middle" style="font-size:6.00;" x="482" y="893">phone</text>
155
<text text-anchor="middle" style="font-size:6.00;" x="550" y="893">text</text>
156
<text text-anchor="middle" style="font-size:6.00;" x="497" y="905">homepage_content</text>
157
<text text-anchor="middle" style="font-size:6.00;" x="550" y="905">text</text>
158
<text text-anchor="middle" style="font-size:6.00;" x="484" y="917">emblem</text>
159
<text text-anchor="middle" style="font-size:6.00;" x="553" y="917">integer</text>
160
<text text-anchor="middle" style="font-size:6.00;" x="617" y="917"> REFERENCES libraryfilealias </text>
161
<text text-anchor="middle" style="font-size:6.00;" x="490" y="929">hackergotchi</text>
162
<text text-anchor="middle" style="font-size:6.00;" x="553" y="929">integer</text>
163
<text text-anchor="middle" style="font-size:6.00;" x="617" y="929"> REFERENCES libraryfilealias </text>
164
<polygon style="fill:none;stroke:black;" points="468,935 468,569 670,569 670,935 468,935"/>
165
</g>
166
<g id="edge6" class="edge"><title>emailaddress->person</title>
167
<path style="fill:none;stroke:black;" d="M560,391C561,429 562,492 564,555"/>
168
<polygon style="fill:black;stroke:black;" points="568,555 564,565 561,555 568,555"/>
87
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="1119,412 1119,336 1267,336 1267,412 1119,412"/>
88
<polygon style="fill:white;stroke:white;" points="1122,353 1122,339 1264,339 1264,353 1122,353"/>
89
<text text-anchor="middle" style="font-size:8.00;" x="1193" y="349">emailaddress</text>
90
<polygon style="fill:none;stroke:black;" points="1122,353 1122,339 1264,339 1264,353 1122,353"/>
91
<text text-anchor="middle" style="font-size:8.00;" x="1128" y="364">id</text>
92
<text text-anchor="middle" style="font-size:8.00;" x="1162" y="364">serial</text>
93
<text text-anchor="middle" style="font-size:8.00;" x="1213" y="364"> PRIMARY KEY </text>
94
<text text-anchor="middle" style="font-size:8.00;" x="1134" y="378">email</text>
95
<text text-anchor="middle" style="font-size:8.00;" x="1160" y="378">text</text>
96
<text text-anchor="middle" style="font-size:8.00;" x="1136" y="392">person</text>
97
<text text-anchor="middle" style="font-size:8.00;" x="1165" y="392">integer</text>
98
<text text-anchor="middle" style="font-size:8.00;" x="1223" y="392"> REFERENCES person </text>
99
<text text-anchor="middle" style="font-size:8.00;" x="1134" y="406">status</text>
100
<text text-anchor="middle" style="font-size:8.00;" x="1165" y="406">integer</text>
101
<polygon style="fill:none;stroke:black;" points="1119,412 1119,336 1267,336 1267,412 1119,412"/>
102
</g>
103
<g id="node15" class="node"><title>person</title>
104
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="1288,976 1288,578 1546,578 1546,976 1288,976"/>
105
<polygon style="fill:white;stroke:white;" points="1291,595 1291,581 1543,581 1543,595 1291,595"/>
106
<text text-anchor="middle" style="font-size:8.00;" x="1417" y="591">person</text>
107
<polygon style="fill:none;stroke:black;" points="1291,595 1291,581 1543,581 1543,595 1291,595"/>
108
<text text-anchor="middle" style="font-size:8.00;" x="1297" y="606">id</text>
109
<text text-anchor="middle" style="font-size:8.00;" x="1392" y="606">serial</text>
110
<text text-anchor="middle" style="font-size:8.00;" x="1454" y="606"> PRIMARY KEY </text>
111
<text text-anchor="middle" style="font-size:8.00;" x="1314" y="620">displayname</text>
112
<text text-anchor="middle" style="font-size:8.00;" x="1390" y="620">text</text>
113
<text text-anchor="middle" style="font-size:8.00;" x="1309" y="634">password</text>
114
<text text-anchor="middle" style="font-size:8.00;" x="1390" y="634">text</text>
115
<text text-anchor="middle" style="font-size:8.00;" x="1312" y="648">teamowner</text>
116
<text text-anchor="middle" style="font-size:8.00;" x="1395" y="648">integer</text>
117
<text text-anchor="middle" style="font-size:8.00;" x="1464" y="648"> REFERENCES person </text>
118
<text text-anchor="middle" style="font-size:8.00;" x="1320" y="662">teamdescription</text>
119
<text text-anchor="middle" style="font-size:8.00;" x="1390" y="662">text</text>
120
<text text-anchor="middle" style="font-size:8.00;" x="1303" y="676">name</text>
121
<text text-anchor="middle" style="font-size:8.00;" x="1390" y="676">text</text>
122
<text text-anchor="middle" style="font-size:8.00;" x="1309" y="690">language</text>
123
<text text-anchor="middle" style="font-size:8.00;" x="1395" y="690">integer</text>
124
<text text-anchor="middle" style="font-size:8.00;" x="1468" y="690"> REFERENCES language </text>
125
<text text-anchor="middle" style="font-size:8.00;" x="1298" y="704">fti</text>
126
<text text-anchor="middle" style="font-size:8.00;" x="1397" y="704">tsvector</text>
127
<text text-anchor="middle" style="font-size:8.00;" x="1335" y="718">defaultmembershipperiod</text>
128
<text text-anchor="middle" style="font-size:8.00;" x="1395" y="718">integer</text>
129
<text text-anchor="middle" style="font-size:8.00;" x="1328" y="732">defaultrenewalperiod</text>
130
<text text-anchor="middle" style="font-size:8.00;" x="1395" y="732">integer</text>
131
<text text-anchor="middle" style="font-size:8.00;" x="1323" y="746">subscriptionpolicy</text>
132
<text text-anchor="middle" style="font-size:8.00;" x="1395" y="746">integer</text>
133
<text text-anchor="middle" style="font-size:8.00;" x="1306" y="760">merged</text>
134
<text text-anchor="middle" style="font-size:8.00;" x="1395" y="760">integer</text>
135
<text text-anchor="middle" style="font-size:8.00;" x="1464" y="760"> REFERENCES person </text>
136
<text text-anchor="middle" style="font-size:8.00;" x="1312" y="774">datecreated</text>
137
<text text-anchor="middle" style="font-size:8.00;" x="1401" y="774">timestamp</text>
138
<text text-anchor="middle" style="font-size:8.00;" x="1307" y="788">calendar</text>
139
<text text-anchor="middle" style="font-size:8.00;" x="1395" y="788">integer</text>
140
<text text-anchor="middle" style="font-size:8.00;" x="1483" y="788"> REFERENCES calendar UNIQUE </text>
141
<text text-anchor="middle" style="font-size:8.00;" x="1309" y="802">timezone</text>
142
<text text-anchor="middle" style="font-size:8.00;" x="1390" y="802">text</text>
143
<text text-anchor="middle" style="font-size:8.00;" x="1314" y="816">addressline1</text>
144
<text text-anchor="middle" style="font-size:8.00;" x="1390" y="816">text</text>
145
<text text-anchor="middle" style="font-size:8.00;" x="1314" y="830">addressline2</text>
146
<text text-anchor="middle" style="font-size:8.00;" x="1390" y="830">text</text>
147
<text text-anchor="middle" style="font-size:8.00;" x="1314" y="844">organization</text>
148
<text text-anchor="middle" style="font-size:8.00;" x="1390" y="844">text</text>
149
<text text-anchor="middle" style="font-size:8.00;" x="1300" y="858">city</text>
150
<text text-anchor="middle" style="font-size:8.00;" x="1390" y="858">text</text>
151
<text text-anchor="middle" style="font-size:8.00;" x="1308" y="872">province</text>
152
<text text-anchor="middle" style="font-size:8.00;" x="1390" y="872">text</text>
153
<text text-anchor="middle" style="font-size:8.00;" x="1306" y="886">country</text>
154
<text text-anchor="middle" style="font-size:8.00;" x="1395" y="886">integer</text>
155
<text text-anchor="middle" style="font-size:8.00;" x="1465" y="886"> REFERENCES country </text>
156
<text text-anchor="middle" style="font-size:8.00;" x="1308" y="900">postcode</text>
157
<text text-anchor="middle" style="font-size:8.00;" x="1390" y="900">text</text>
158
<text text-anchor="middle" style="font-size:8.00;" x="1304" y="914">phone</text>
159
<text text-anchor="middle" style="font-size:8.00;" x="1390" y="914">text</text>
160
<text text-anchor="middle" style="font-size:8.00;" x="1325" y="928">homepage_content</text>
161
<text text-anchor="middle" style="font-size:8.00;" x="1390" y="928">text</text>
162
<text text-anchor="middle" style="font-size:8.00;" x="1307" y="942">emblem</text>
163
<text text-anchor="middle" style="font-size:8.00;" x="1395" y="942">integer</text>
164
<text text-anchor="middle" style="font-size:8.00;" x="1476" y="942"> REFERENCES libraryfilealias </text>
165
<text text-anchor="middle" style="font-size:8.00;" x="1315" y="956">hackergotchi</text>
166
<text text-anchor="middle" style="font-size:8.00;" x="1395" y="956">integer</text>
167
<text text-anchor="middle" style="font-size:8.00;" x="1476" y="956"> REFERENCES libraryfilealias </text>
168
<text text-anchor="middle" style="font-size:8.00;" x="1329" y="970">hide_email_addresses</text>
169
<text text-anchor="middle" style="font-size:8.00;" x="1397" y="970">boolean</text>
170
<polygon style="fill:none;stroke:black;" points="1288,976 1288,578 1546,578 1546,976 1288,976"/>
171
</g>
172
<g id="edge8" class="edge"><title>emailaddress->person</title>
173
<path style="fill:none;stroke:black;" d="M1217,416C1237,452 1268,508 1299,565"/>
174
<polygon style="fill:black;stroke:black;" points="1302,564 1304,574 1296,567 1302,564"/>
169
175
</g>
170
176
<g id="node5" class="node"><title>gpgkey</title>
171
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="987,896 987,782 1147,782 1147,896 987,896"/>
172
<polygon style="fill:white;stroke:white;" points="990,797 990,785 1144,785 1144,797 990,797"/>
173
<text text-anchor="middle" style="font-size:6.00;" x="1067" y="793">gpgkey</text>
174
<polygon style="fill:none;stroke:black;" points="990,797 990,785 1144,785 1144,797 990,797"/>
175
<text text-anchor="middle" style="font-size:6.00;" x="995" y="806">id</text>
176
<text text-anchor="middle" style="font-size:6.00;" x="1038" y="806">serial</text>
177
<text text-anchor="middle" style="font-size:6.00;" x="1093" y="806"> UNIQUE PRIMARY KEY </text>
178
<text text-anchor="middle" style="font-size:6.00;" x="1001" y="818">owner</text>
179
<text text-anchor="middle" style="font-size:6.00;" x="1040" y="818">integer</text>
180
<text text-anchor="middle" style="font-size:6.00;" x="1100" y="818"> REFERENCES person UNIQUE </text>
181
<text text-anchor="middle" style="font-size:6.00;" x="1000" y="830">keyid</text>
182
<text text-anchor="middle" style="font-size:6.00;" x="1037" y="830">text</text>
183
<text text-anchor="middle" style="font-size:6.00;" x="1006" y="842">fingerprint</text>
184
<text text-anchor="middle" style="font-size:6.00;" x="1037" y="842">text</text>
185
<text text-anchor="middle" style="font-size:6.00;" x="1072" y="842"> UNIQUE </text>
186
<text text-anchor="middle" style="font-size:6.00;" x="1000" y="854">active</text>
187
<text text-anchor="middle" style="font-size:6.00;" x="1042" y="854">boolean</text>
188
<text text-anchor="middle" style="font-size:6.00;" x="1005" y="866">algorithm</text>
189
<text text-anchor="middle" style="font-size:6.00;" x="1040" y="866">integer</text>
190
<text text-anchor="middle" style="font-size:6.00;" x="1002" y="878">keysize</text>
191
<text text-anchor="middle" style="font-size:6.00;" x="1040" y="878">integer</text>
192
<text text-anchor="middle" style="font-size:6.00;" x="1008" y="890">can_encrypt</text>
193
<text text-anchor="middle" style="font-size:6.00;" x="1042" y="890">boolean</text>
194
<polygon style="fill:none;stroke:black;" points="987,896 987,782 1147,782 1147,896 987,896"/>
177
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="1378,294 1378,162 1578,162 1578,294 1378,294"/>
178
<polygon style="fill:white;stroke:white;" points="1381,179 1381,165 1575,165 1575,179 1381,179"/>
179
<text text-anchor="middle" style="font-size:8.00;" x="1478" y="175">gpgkey</text>
180
<polygon style="fill:none;stroke:black;" points="1381,179 1381,165 1575,165 1575,179 1381,179"/>
181
<text text-anchor="middle" style="font-size:8.00;" x="1387" y="190">id</text>
182
<text text-anchor="middle" style="font-size:8.00;" x="1438" y="190">serial</text>
183
<text text-anchor="middle" style="font-size:8.00;" x="1509" y="190"> UNIQUE PRIMARY KEY </text>
184
<text text-anchor="middle" style="font-size:8.00;" x="1394" y="204">owner</text>
185
<text text-anchor="middle" style="font-size:8.00;" x="1441" y="204">integer</text>
186
<text text-anchor="middle" style="font-size:8.00;" x="1518" y="204"> REFERENCES person UNIQUE </text>
187
<text text-anchor="middle" style="font-size:8.00;" x="1393" y="218">keyid</text>
188
<text text-anchor="middle" style="font-size:8.00;" x="1436" y="218">text</text>
189
<text text-anchor="middle" style="font-size:8.00;" x="1401" y="232">fingerprint</text>
190
<text text-anchor="middle" style="font-size:8.00;" x="1436" y="232">text</text>
191
<text text-anchor="middle" style="font-size:8.00;" x="1480" y="232"> UNIQUE </text>
192
<text text-anchor="middle" style="font-size:8.00;" x="1393" y="246">active</text>
193
<text text-anchor="middle" style="font-size:8.00;" x="1443" y="246">boolean</text>
194
<text text-anchor="middle" style="font-size:8.00;" x="1399" y="260">algorithm</text>
195
<text text-anchor="middle" style="font-size:8.00;" x="1441" y="260">integer</text>
196
<text text-anchor="middle" style="font-size:8.00;" x="1396" y="274">keysize</text>
197
<text text-anchor="middle" style="font-size:8.00;" x="1441" y="274">integer</text>
198
<text text-anchor="middle" style="font-size:8.00;" x="1403" y="288">can_encrypt</text>
199
<text text-anchor="middle" style="font-size:8.00;" x="1443" y="288">boolean</text>
200
<polygon style="fill:none;stroke:black;" points="1378,294 1378,162 1578,162 1578,294 1378,294"/>
195
201
</g>
196
<g id="edge8" class="edge"><title>gpgkey->person</title>
197
<path style="fill:none;stroke:black;" d="M979,824C898,810 777,789 688,773"/>
198
<polygon style="fill:black;stroke:black;" points="687,776 678,771 688,770 687,776"/>
202
<g id="edge10" class="edge"><title>gpgkey->person</title>
203
<path style="fill:none;stroke:black;" d="M1470,298C1463,365 1451,470 1441,564"/>
204
<polygon style="fill:black;stroke:black;" points="1444,564 1440,574 1438,564 1444,564"/>
199
205
</g>
200
206
<g id="node6" class="node"><title>ircid</title>
201
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="37,703 37,637 163,637 163,703 37,703"/>
202
<polygon style="fill:white;stroke:white;" points="40,652 40,640 160,640 160,652 40,652"/>
203
<text text-anchor="middle" style="font-size:6.00;" x="100" y="648">ircid</text>
204
<polygon style="fill:none;stroke:black;" points="40,652 40,640 160,640 160,652 40,652"/>
205
<text text-anchor="middle" style="font-size:6.00;" x="45" y="661">id</text>
206
<text text-anchor="middle" style="font-size:6.00;" x="81" y="661">serial</text>
207
<text text-anchor="middle" style="font-size:6.00;" x="121" y="661"> PRIMARY KEY </text>
208
<text text-anchor="middle" style="font-size:6.00;" x="51" y="673">person</text>
209
<text text-anchor="middle" style="font-size:6.00;" x="83" y="673">integer</text>
210
<text text-anchor="middle" style="font-size:6.00;" x="128" y="673"> REFERENCES person </text>
211
<text text-anchor="middle" style="font-size:6.00;" x="53" y="685">network</text>
212
<text text-anchor="middle" style="font-size:6.00;" x="80" y="685">text</text>
213
<text text-anchor="middle" style="font-size:6.00;" x="55" y="697">nickname</text>
214
<text text-anchor="middle" style="font-size:6.00;" x="80" y="697">text</text>
215
<polygon style="fill:none;stroke:black;" points="37,703 37,637 163,637 163,703 37,703"/>
207
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="1046,1228 1046,1152 1204,1152 1204,1228 1046,1228"/>
208
<polygon style="fill:white;stroke:white;" points="1049,1169 1049,1155 1201,1155 1201,1169 1049,1169"/>
209
<text text-anchor="middle" style="font-size:8.00;" x="1125" y="1165">ircid</text>
210
<polygon style="fill:none;stroke:black;" points="1049,1169 1049,1155 1201,1155 1201,1169 1049,1169"/>
211
<text text-anchor="middle" style="font-size:8.00;" x="1055" y="1180">id</text>
212
<text text-anchor="middle" style="font-size:8.00;" x="1099" y="1180">serial</text>
213
<text text-anchor="middle" style="font-size:8.00;" x="1150" y="1180"> PRIMARY KEY </text>
214
<text text-anchor="middle" style="font-size:8.00;" x="1063" y="1194">person</text>
215
<text text-anchor="middle" style="font-size:8.00;" x="1102" y="1194">integer</text>
216
<text text-anchor="middle" style="font-size:8.00;" x="1160" y="1194"> REFERENCES person </text>
217
<text text-anchor="middle" style="font-size:8.00;" x="1065" y="1208">network</text>
218
<text text-anchor="middle" style="font-size:8.00;" x="1097" y="1208">text</text>
219
<text text-anchor="middle" style="font-size:8.00;" x="1068" y="1222">nickname</text>
220
<text text-anchor="middle" style="font-size:8.00;" x="1097" y="1222">text</text>
221
<polygon style="fill:none;stroke:black;" points="1046,1228 1046,1152 1204,1152 1204,1228 1046,1228"/>
216
222
</g>
217
<g id="edge10" class="edge"><title>ircid->person</title>
218
<path style="fill:none;stroke:black;" d="M171,682C245,695 362,715 450,731"/>
219
<polygon style="fill:black;stroke:black;" points="451,728 460,733 450,734 451,728"/>
223
<g id="edge12" class="edge"><title>ircid->person</title>
224
<path style="fill:none;stroke:black;" d="M1155,1148C1184,1107 1229,1043 1274,980"/>
225
<polygon style="fill:black;stroke:black;" points="1272,977 1280,971 1277,981 1272,977"/>
220
226
</g>
221
227
<g id="node7" class="node"><title>jabberid</title>
222
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="167,1101 167,1047 289,1047 289,1101 167,1101"/>
223
<polygon style="fill:white;stroke:white;" points="170,1062 170,1050 286,1050 286,1062 170,1062"/>
224
<text text-anchor="middle" style="font-size:6.00;" x="228" y="1058">jabberid</text>
225
<polygon style="fill:none;stroke:black;" points="170,1062 170,1050 286,1050 286,1062 170,1062"/>
226
<text text-anchor="middle" style="font-size:6.00;" x="175" y="1071">id</text>
227
<text text-anchor="middle" style="font-size:6.00;" x="207" y="1071">serial</text>
228
<text text-anchor="middle" style="font-size:6.00;" x="247" y="1071"> PRIMARY KEY </text>
229
<text text-anchor="middle" style="font-size:6.00;" x="181" y="1083">person</text>
230
<text text-anchor="middle" style="font-size:6.00;" x="209" y="1083">integer</text>
231
<text text-anchor="middle" style="font-size:6.00;" x="254" y="1083"> REFERENCES person </text>
232
<text text-anchor="middle" style="font-size:6.00;" x="183" y="1095">jabberid</text>
233
<text text-anchor="middle" style="font-size:6.00;" x="206" y="1095">text</text>
234
<text text-anchor="middle" style="font-size:6.00;" x="238" y="1095"> UNIQUE </text>
235
<polygon style="fill:none;stroke:black;" points="167,1101 167,1047 289,1047 289,1101 167,1101"/>
228
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="1387,1296 1387,1234 1541,1234 1541,1296 1387,1296"/>
229
<polygon style="fill:white;stroke:white;" points="1390,1251 1390,1237 1538,1237 1538,1251 1390,1251"/>
230
<text text-anchor="middle" style="font-size:8.00;" x="1464" y="1247">jabberid</text>
231
<polygon style="fill:none;stroke:black;" points="1390,1251 1390,1237 1538,1237 1538,1251 1390,1251"/>
232
<text text-anchor="middle" style="font-size:8.00;" x="1396" y="1262">id</text>
233
<text text-anchor="middle" style="font-size:8.00;" x="1436" y="1262">serial</text>
234
<text text-anchor="middle" style="font-size:8.00;" x="1487" y="1262"> PRIMARY KEY </text>
235
<text text-anchor="middle" style="font-size:8.00;" x="1404" y="1276">person</text>
236
<text text-anchor="middle" style="font-size:8.00;" x="1439" y="1276">integer</text>
237
<text text-anchor="middle" style="font-size:8.00;" x="1497" y="1276"> REFERENCES person </text>
238
<text text-anchor="middle" style="font-size:8.00;" x="1406" y="1290">jabberid</text>
239
<text text-anchor="middle" style="font-size:8.00;" x="1434" y="1290">text</text>
240
<text text-anchor="middle" style="font-size:8.00;" x="1475" y="1290"> UNIQUE </text>
241
<polygon style="fill:none;stroke:black;" points="1387,1296 1387,1234 1541,1234 1541,1296 1387,1296"/>
236
242
</g>
237
<g id="edge12" class="edge"><title>jabberid->person</title>
238
<path style="fill:none;stroke:black;" d="M261,1043C305,1002 385,926 453,862"/>
239
<polygon style="fill:black;stroke:black;" points="450,860 460,855 455,865 450,860"/>
243
<g id="edge14" class="edge"><title>jabberid->person</title>
244
<path style="fill:none;stroke:black;" d="M1461,1230C1456,1179 1447,1082 1438,990"/>
245
<polygon style="fill:black;stroke:black;" points="1435,990 1437,980 1441,990 1435,990"/>
240
246
</g>
241
247
<g id="node8" class="node"><title>karma</title>
242
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="620,1359 620,1293 772,1293 772,1359 620,1359"/>
243
<polygon style="fill:white;stroke:white;" points="623,1308 623,1296 769,1296 769,1308 623,1308"/>
244
<text text-anchor="middle" style="font-size:6.00;" x="696" y="1304">karma</text>
245
<polygon style="fill:none;stroke:black;" points="623,1308 623,1296 769,1296 769,1308 623,1308"/>
246
<text text-anchor="middle" style="font-size:6.00;" x="628" y="1317">id</text>
247
<text text-anchor="middle" style="font-size:6.00;" x="667" y="1317">serial</text>
248
<text text-anchor="middle" style="font-size:6.00;" x="716" y="1317"> PRIMARY KEY </text>
249
<text text-anchor="middle" style="font-size:6.00;" x="640" y="1329">datecreated</text>
250
<text text-anchor="middle" style="font-size:6.00;" x="674" y="1329">timestamp</text>
251
<text text-anchor="middle" style="font-size:6.00;" x="634" y="1341">person</text>
252
<text text-anchor="middle" style="font-size:6.00;" x="669" y="1341">integer</text>
253
<text text-anchor="middle" style="font-size:6.00;" x="723" y="1341"> REFERENCES person </text>
254
<text text-anchor="middle" style="font-size:6.00;" x="634" y="1353">action</text>
255
<text text-anchor="middle" style="font-size:6.00;" x="669" y="1353">integer</text>
256
<text text-anchor="middle" style="font-size:6.00;" x="730" y="1353"> REFERENCES karmaaction </text>
257
<polygon style="fill:none;stroke:black;" points="620,1359 620,1293 772,1293 772,1359 620,1359"/>
248
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="700,644 700,568 892,568 892,644 700,644"/>
249
<polygon style="fill:white;stroke:white;" points="703,585 703,571 889,571 889,585 703,585"/>
250
<text text-anchor="middle" style="font-size:8.00;" x="796" y="581">karma</text>
251
<polygon style="fill:none;stroke:black;" points="703,585 703,571 889,571 889,585 703,585"/>
252
<text text-anchor="middle" style="font-size:8.00;" x="709" y="596">id</text>
253
<text text-anchor="middle" style="font-size:8.00;" x="758" y="596">serial</text>
254
<text text-anchor="middle" style="font-size:8.00;" x="820" y="596"> PRIMARY KEY </text>
255
<text text-anchor="middle" style="font-size:8.00;" x="724" y="610">datecreated</text>
256
<text text-anchor="middle" style="font-size:8.00;" x="767" y="610">timestamp</text>
257
<text text-anchor="middle" style="font-size:8.00;" x="717" y="624">person</text>
258
<text text-anchor="middle" style="font-size:8.00;" x="761" y="624">integer</text>
259
<text text-anchor="middle" style="font-size:8.00;" x="830" y="624"> REFERENCES person </text>
260
<text text-anchor="middle" style="font-size:8.00;" x="715" y="638">action</text>
261
<text text-anchor="middle" style="font-size:8.00;" x="761" y="638">integer</text>
262
<text text-anchor="middle" style="font-size:8.00;" x="839" y="638"> REFERENCES karmaaction </text>
263
<polygon style="fill:none;stroke:black;" points="700,644 700,568 892,568 892,644 700,644"/>
258
264
</g>
259
265
<g id="node9" class="node"><title>karmaaction</title>
260
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="705,1742 705,1652 849,1652 849,1742 705,1742"/>
261
<polygon style="fill:white;stroke:white;" points="708,1667 708,1655 846,1655 846,1667 708,1667"/>
262
<text text-anchor="middle" style="font-size:6.00;" x="777" y="1663">karmaaction</text>
263
<polygon style="fill:none;stroke:black;" points="708,1667 708,1655 846,1655 846,1667 708,1667"/>
264
<text text-anchor="middle" style="font-size:6.00;" x="713" y="1676">id</text>
265
<text text-anchor="middle" style="font-size:6.00;" x="747" y="1676">serial</text>
266
<text text-anchor="middle" style="font-size:6.00;" x="787" y="1676"> PRIMARY KEY </text>
267
<text text-anchor="middle" style="font-size:6.00;" x="722" y="1688">category</text>
268
<text text-anchor="middle" style="font-size:6.00;" x="749" y="1688">integer</text>
269
<text text-anchor="middle" style="font-size:6.00;" x="804" y="1688"> REFERENCES karmacategory </text>
270
<text text-anchor="middle" style="font-size:6.00;" x="719" y="1700">points</text>
271
<text text-anchor="middle" style="font-size:6.00;" x="749" y="1700">integer</text>
272
<text text-anchor="middle" style="font-size:6.00;" x="718" y="1712">name</text>
273
<text text-anchor="middle" style="font-size:6.00;" x="746" y="1712">text</text>
274
<text text-anchor="middle" style="font-size:6.00;" x="778" y="1712"> UNIQUE </text>
275
<text text-anchor="middle" style="font-size:6.00;" x="716" y="1724">title</text>
276
<text text-anchor="middle" style="font-size:6.00;" x="746" y="1724">text</text>
277
<text text-anchor="middle" style="font-size:6.00;" x="722" y="1736">summary</text>
278
<text text-anchor="middle" style="font-size:6.00;" x="746" y="1736">text</text>
279
<polygon style="fill:none;stroke:black;" points="705,1742 705,1652 849,1652 849,1742 705,1742"/>
280
</g>
281
<g id="edge16" class="edge"><title>karma->karmaaction</title>
282
<path style="fill:none;stroke:black;" d="M704,1363C718,1427 747,1560 764,1638"/>
283
<polygon style="fill:black;stroke:black;" points="767,1638 766,1648 761,1639 767,1638"/>
284
</g>
285
<g id="edge14" class="edge"><title>karma->person</title>
286
<path style="fill:none;stroke:black;" d="M688,1289C673,1221 640,1073 613,949"/>
287
<polygon style="fill:black;stroke:black;" points="610,949 611,939 616,948 610,949"/>
266
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="307,556 307,452 489,452 489,556 307,556"/>
267
<polygon style="fill:white;stroke:white;" points="310,469 310,455 486,455 486,469 310,469"/>
268
<text text-anchor="middle" style="font-size:8.00;" x="398" y="465">karmaaction</text>
269
<polygon style="fill:none;stroke:black;" points="310,469 310,455 486,455 486,469 310,469"/>
270
<text text-anchor="middle" style="font-size:8.00;" x="316" y="480">id</text>
271
<text text-anchor="middle" style="font-size:8.00;" x="358" y="480">serial</text>
272
<text text-anchor="middle" style="font-size:8.00;" x="409" y="480"> PRIMARY KEY </text>
273
<text text-anchor="middle" style="font-size:8.00;" x="326" y="494">category</text>
274
<text text-anchor="middle" style="font-size:8.00;" x="361" y="494">integer</text>
275
<text text-anchor="middle" style="font-size:8.00;" x="432" y="494"> REFERENCES karmacategory </text>
276
<text text-anchor="middle" style="font-size:8.00;" x="323" y="508">points</text>
277
<text text-anchor="middle" style="font-size:8.00;" x="361" y="508">integer</text>
278
<text text-anchor="middle" style="font-size:8.00;" x="322" y="522">name</text>
279
<text text-anchor="middle" style="font-size:8.00;" x="356" y="522">text</text>
280
<text text-anchor="middle" style="font-size:8.00;" x="397" y="522"> UNIQUE </text>
281
<text text-anchor="middle" style="font-size:8.00;" x="319" y="536">title</text>
282
<text text-anchor="middle" style="font-size:8.00;" x="356" y="536">text</text>
283
<text text-anchor="middle" style="font-size:8.00;" x="328" y="550">summary</text>
284
<text text-anchor="middle" style="font-size:8.00;" x="356" y="550">text</text>
285
<polygon style="fill:none;stroke:black;" points="307,556 307,452 489,452 489,556 307,556"/>
286
</g>
287
<g id="edge18" class="edge"><title>karma->karmaaction</title>
288
<path style="fill:none;stroke:black;" d="M692,579C635,565 565,547 507,532"/>
289
<polygon style="fill:black;stroke:black;" points="506,535 497,529 508,529 506,535"/>
290
</g>
291
<g id="edge16" class="edge"><title>karma->person</title>
292
<path style="fill:none;stroke:black;" d="M900,635C1001,662 1156,705 1270,736"/>
293
<polygon style="fill:black;stroke:black;" points="1271,733 1280,739 1269,739 1271,733"/>
288
294
</g>
289
295
<g id="node11" class="node"><title>karmacategory</title>
290
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="787,2013 787,1947 891,1947 891,2013 787,2013"/>
291
<polygon style="fill:white;stroke:white;" points="790,1962 790,1950 888,1950 888,1962 790,1962"/>
292
<text text-anchor="middle" style="font-size:6.00;" x="839" y="1958">karmacategory</text>
293
<polygon style="fill:none;stroke:black;" points="790,1962 790,1950 888,1950 888,1962 790,1962"/>
294
<text text-anchor="middle" style="font-size:6.00;" x="795" y="1971">id</text>
295
<text text-anchor="middle" style="font-size:6.00;" x="828" y="1971">serial</text>
296
<text text-anchor="middle" style="font-size:6.00;" x="864" y="1971"> PRIMARY KEY </text>
297
<text text-anchor="middle" style="font-size:6.00;" x="800" y="1983">name</text>
298
<text text-anchor="middle" style="font-size:6.00;" x="827" y="1983">text</text>
299
<text text-anchor="middle" style="font-size:6.00;" x="798" y="1995">title</text>
300
<text text-anchor="middle" style="font-size:6.00;" x="827" y="1995">text</text>
301
<text text-anchor="middle" style="font-size:6.00;" x="804" y="2007">summary</text>
302
<text text-anchor="middle" style="font-size:6.00;" x="827" y="2007">text</text>
303
<polygon style="fill:none;stroke:black;" points="787,2013 787,1947 891,1947 891,2013 787,2013"/>
296
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="14,461 14,385 146,385 146,461 14,461"/>
297
<polygon style="fill:white;stroke:white;" points="17,402 17,388 143,388 143,402 17,402"/>
298
<text text-anchor="middle" style="font-size:8.00;" x="80" y="398">karmacategory</text>
299
<polygon style="fill:none;stroke:black;" points="17,402 17,388 143,388 143,402 17,402"/>
300
<text text-anchor="middle" style="font-size:8.00;" x="23" y="413">id</text>
301
<text text-anchor="middle" style="font-size:8.00;" x="66" y="413">serial</text>
302
<text text-anchor="middle" style="font-size:8.00;" x="111" y="413"> PRIMARY KEY </text>
303
<text text-anchor="middle" style="font-size:8.00;" x="29" y="427">name</text>
304
<text text-anchor="middle" style="font-size:8.00;" x="64" y="427">text</text>
305
<text text-anchor="middle" style="font-size:8.00;" x="26" y="441">title</text>
306
<text text-anchor="middle" style="font-size:8.00;" x="64" y="441">text</text>
307
<text text-anchor="middle" style="font-size:8.00;" x="35" y="455">summary</text>
308
<text text-anchor="middle" style="font-size:8.00;" x="64" y="455">text</text>
309
<polygon style="fill:none;stroke:black;" points="14,461 14,385 146,385 146,461 14,461"/>
304
310
</g>
305
<g id="edge18" class="edge"><title>karmaaction->karmacategory</title>
306
<path style="fill:none;stroke:black;" d="M788,1746C799,1798 818,1881 829,1933"/>
307
<polygon style="fill:black;stroke:black;" points="832,1933 831,1943 826,1934 832,1933"/>
311
<g id="edge20" class="edge"><title>karmaaction->karmacategory</title>
312
<path style="fill:none;stroke:black;" d="M299,479C255,468 205,455 164,444"/>
313
<polygon style="fill:black;stroke:black;" points="163,447 154,442 164,441 163,447"/>
308
314
</g>
309
315
<g id="node10" class="node"><title>karmacache</title>
310
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="798,1139 798,1073 952,1073 952,1139 798,1139"/>
311
<polygon style="fill:white;stroke:white;" points="801,1088 801,1076 949,1076 949,1088 801,1088"/>
312
<text text-anchor="middle" style="font-size:6.00;" x="875" y="1084">karmacache</text>
313
<polygon style="fill:none;stroke:black;" points="801,1088 801,1076 949,1076 949,1088 801,1088"/>
314
<text text-anchor="middle" style="font-size:6.00;" x="806" y="1097">id</text>
315
<text text-anchor="middle" style="font-size:6.00;" x="846" y="1097">serial</text>
316
<text text-anchor="middle" style="font-size:6.00;" x="886" y="1097"> PRIMARY KEY </text>
317
<text text-anchor="middle" style="font-size:6.00;" x="812" y="1109">person</text>
318
<text text-anchor="middle" style="font-size:6.00;" x="848" y="1109">integer</text>
319
<text text-anchor="middle" style="font-size:6.00;" x="905" y="1109"> UNIQUE REFERENCES person </text>
320
<text text-anchor="middle" style="font-size:6.00;" x="815" y="1121">category</text>
321
<text text-anchor="middle" style="font-size:6.00;" x="848" y="1121">integer</text>
322
<text text-anchor="middle" style="font-size:6.00;" x="877" y="1121"> UNIQUE </text>
323
<text text-anchor="middle" style="font-size:6.00;" x="818" y="1133">karmavalue</text>
324
<text text-anchor="middle" style="font-size:6.00;" x="848" y="1133">integer</text>
325
<polygon style="fill:none;stroke:black;" points="798,1139 798,1073 952,1073 952,1139 798,1139"/>
326
</g>
327
<g id="edge20" class="edge"><title>karmacache->person</title>
328
<path style="fill:none;stroke:black;" d="M843,1069C805,1026 741,952 684,886"/>
329
<polygon style="fill:black;stroke:black;" points="681,888 678,878 687,884 681,888"/>
330
</g>
331
<g id="node12" class="node"><title>language</title>
332
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="337,332 337,218 467,218 467,332 337,332"/>
333
<polygon style="fill:white;stroke:white;" points="340,233 340,221 464,221 464,233 340,233"/>
334
<text text-anchor="middle" style="font-size:6.00;" x="402" y="229">language</text>
335
<polygon style="fill:none;stroke:black;" points="340,233 340,221 464,221 464,233 340,233"/>
336
<text text-anchor="middle" style="font-size:6.00;" x="345" y="242">id</text>
337
<text text-anchor="middle" style="font-size:6.00;" x="397" y="242">serial</text>
338
<text text-anchor="middle" style="font-size:6.00;" x="440" y="242"> PRIMARY KEY </text>
339
<text text-anchor="middle" style="font-size:6.00;" x="349" y="254">code</text>
340
<text text-anchor="middle" style="font-size:6.00;" x="396" y="254">text</text>
341
<text text-anchor="middle" style="font-size:6.00;" x="431" y="254"> UNIQUE </text>
342
<text text-anchor="middle" style="font-size:6.00;" x="358" y="266">englishname</text>
343
<text text-anchor="middle" style="font-size:6.00;" x="396" y="266">text</text>
344
<text text-anchor="middle" style="font-size:6.00;" x="357" y="278">nativename</text>
345
<text text-anchor="middle" style="font-size:6.00;" x="396" y="278">text</text>
346
<text text-anchor="middle" style="font-size:6.00;" x="357" y="290">pluralforms</text>
347
<text text-anchor="middle" style="font-size:6.00;" x="399" y="290">integer</text>
348
<text text-anchor="middle" style="font-size:6.00;" x="363" y="302">pluralexpression</text>
349
<text text-anchor="middle" style="font-size:6.00;" x="396" y="302">text</text>
350
<text text-anchor="middle" style="font-size:6.00;" x="351" y="314">visible</text>
351
<text text-anchor="middle" style="font-size:6.00;" x="401" y="314">boolean</text>
352
<text text-anchor="middle" style="font-size:6.00;" x="354" y="326">direction</text>
353
<text text-anchor="middle" style="font-size:6.00;" x="399" y="326">integer</text>
354
<polygon style="fill:none;stroke:black;" points="337,332 337,218 467,218 467,332 337,332"/>
355
</g>
356
<g id="node13" class="node"><title>logintoken</title>
357
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="921,544 921,430 1067,430 1067,544 921,544"/>
358
<polygon style="fill:white;stroke:white;" points="924,445 924,433 1064,433 1064,445 924,445"/>
359
<text text-anchor="middle" style="font-size:6.00;" x="994" y="441">logintoken</text>
360
<polygon style="fill:none;stroke:black;" points="924,445 924,433 1064,433 1064,445 924,445"/>
361
<text text-anchor="middle" style="font-size:6.00;" x="929" y="454">id</text>
362
<text text-anchor="middle" style="font-size:6.00;" x="976" y="454">serial</text>
363
<text text-anchor="middle" style="font-size:6.00;" x="938" y="466">requester</text>
364
<text text-anchor="middle" style="font-size:6.00;" x="978" y="466">integer</text>
365
<text text-anchor="middle" style="font-size:6.00;" x="1032" y="466"> REFERENCES person </text>
366
<text text-anchor="middle" style="font-size:6.00;" x="945" y="478">requesteremail</text>
367
<text text-anchor="middle" style="font-size:6.00;" x="975" y="478">text</text>
368
<text text-anchor="middle" style="font-size:6.00;" x="934" y="490">email</text>
369
<text text-anchor="middle" style="font-size:6.00;" x="975" y="490">text</text>
370
<text text-anchor="middle" style="font-size:6.00;" x="936" y="502">created</text>
371
<text text-anchor="middle" style="font-size:6.00;" x="983" y="502">timestamp</text>
372
<text text-anchor="middle" style="font-size:6.00;" x="939" y="514">tokentype</text>
373
<text text-anchor="middle" style="font-size:6.00;" x="978" y="514">integer</text>
374
<text text-anchor="middle" style="font-size:6.00;" x="934" y="526">token</text>
375
<text text-anchor="middle" style="font-size:6.00;" x="975" y="526">text</text>
376
<text text-anchor="middle" style="font-size:6.00;" x="1016" y="526"> UNIQUE </text>
377
<text text-anchor="middle" style="font-size:6.00;" x="940" y="538">fingerprint</text>
378
<text text-anchor="middle" style="font-size:6.00;" x="975" y="538">text</text>
379
<polygon style="fill:none;stroke:black;" points="921,544 921,430 1067,430 1067,544 921,544"/>
380
</g>
381
<g id="edge22" class="edge"><title>logintoken->person</title>
382
<path style="fill:none;stroke:black;" d="M913,538C849,578 758,633 687,679"/>
383
<polygon style="fill:black;stroke:black;" points="688,682 678,684 685,676 688,682"/>
384
</g>
385
<g id="edge30" class="edge"><title>person->calendar</title>
386
<path style="fill:none;stroke:black;" d="M678,598C741,510 814,406 853,351"/>
387
<polygon style="fill:black;stroke:black;" points="851,348 859,342 856,352 851,348"/>
388
</g>
389
<g id="edge32" class="edge"><title>person->country</title>
390
<path style="fill:none;stroke:black;" d="M490,939C461,1009 430,1083 409,1133"/>
391
<polygon style="fill:black;stroke:black;" points="412,1134 405,1142 406,1131 412,1134"/>
392
</g>
393
<g id="edge26" class="edge"><title>person->language</title>
394
<path style="fill:none;stroke:black;" d="M503,565C476,487 447,403 426,345"/>
395
<polygon style="fill:black;stroke:black;" points="423,347 423,336 429,344 423,347"/>
396
</g>
397
<g id="edge24" class="edge"><title>person->person</title>
398
<path style="fill:none;stroke:black;" d="M678,809C689,797 696,779 696,752 696,730 692,715 684,703"/>
399
<polygon style="fill:black;stroke:black;" points="681,705 678,695 687,701 681,705"/>
316
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="818,800 818,724 1014,724 1014,800 818,800"/>
317
<polygon style="fill:white;stroke:white;" points="821,741 821,727 1011,727 1011,741 821,741"/>
318
<text text-anchor="middle" style="font-size:8.00;" x="916" y="737">karmacache</text>
319
<polygon style="fill:none;stroke:black;" points="821,741 821,727 1011,727 1011,741 821,741"/>
320
<text text-anchor="middle" style="font-size:8.00;" x="827" y="752">id</text>
321
<text text-anchor="middle" style="font-size:8.00;" x="877" y="752">serial</text>
322
<text text-anchor="middle" style="font-size:8.00;" x="928" y="752"> PRIMARY KEY </text>
323
<text text-anchor="middle" style="font-size:8.00;" x="835" y="766">person</text>
324
<text text-anchor="middle" style="font-size:8.00;" x="880" y="766">integer</text>
325
<text text-anchor="middle" style="font-size:8.00;" x="954" y="766"> UNIQUE REFERENCES person </text>
326
<text text-anchor="middle" style="font-size:8.00;" x="837" y="780">category</text>
327
<text text-anchor="middle" style="font-size:8.00;" x="880" y="780">integer</text>
328
<text text-anchor="middle" style="font-size:8.00;" x="916" y="780"> UNIQUE </text>
329
<text text-anchor="middle" style="font-size:8.00;" x="843" y="794">karmavalue</text>
330
<text text-anchor="middle" style="font-size:8.00;" x="880" y="794">integer</text>
331
<polygon style="fill:none;stroke:black;" points="818,800 818,724 1014,724 1014,800 818,800"/>
332
</g>
333
<g id="edge22" class="edge"><title>karmacache->person</title>
334
<path style="fill:none;stroke:black;" d="M1022,765C1094,768 1191,771 1270,773"/>
335
<polygon style="fill:black;stroke:black;" points="1270,769 1280,773 1270,776 1270,769"/>
336
</g>
337
<g id="node12" class="node"><title>karmatotalcache</title>
338
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="1742,509 1742,447 1940,447 1940,509 1742,509"/>
339
<polygon style="fill:white;stroke:white;" points="1745,464 1745,450 1937,450 1937,464 1745,464"/>
340
<text text-anchor="middle" style="font-size:8.00;" x="1841" y="460">karmatotalcache</text>
341
<polygon style="fill:none;stroke:black;" points="1745,464 1745,450 1937,450 1937,464 1745,464"/>
342
<text text-anchor="middle" style="font-size:8.00;" x="1751" y="475">id</text>
343
<text text-anchor="middle" style="font-size:8.00;" x="1803" y="475">serial</text>
344
<text text-anchor="middle" style="font-size:8.00;" x="1854" y="475"> PRIMARY KEY </text>
345
<text text-anchor="middle" style="font-size:8.00;" x="1759" y="489">person</text>
346
<text text-anchor="middle" style="font-size:8.00;" x="1806" y="489">integer</text>
347
<text text-anchor="middle" style="font-size:8.00;" x="1880" y="489"> REFERENCES person UNIQUE </text>
348
<text text-anchor="middle" style="font-size:8.00;" x="1767" y="503">karma_total</text>
349
<text text-anchor="middle" style="font-size:8.00;" x="1806" y="503">integer</text>
350
<polygon style="fill:none;stroke:black;" points="1742,509 1742,447 1940,447 1940,509 1742,509"/>
351
</g>
352
<g id="edge24" class="edge"><title>karmatotalcache->person</title>
353
<path style="fill:none;stroke:black;" d="M1791,513C1735,553 1642,618 1563,674"/>
354
<polygon style="fill:black;stroke:black;" points="1564,677 1554,680 1560,672 1564,677"/>
355
</g>
356
<g id="node13" class="node"><title>language</title>
357
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="1861,838 1861,706 2025,706 2025,838 1861,838"/>
358
<polygon style="fill:white;stroke:white;" points="1864,723 1864,709 2022,709 2022,723 1864,723"/>
359
<text text-anchor="middle" style="font-size:8.00;" x="1943" y="719">language</text>
360
<polygon style="fill:none;stroke:black;" points="1864,723 1864,709 2022,709 2022,723 1864,723"/>
361
<text text-anchor="middle" style="font-size:8.00;" x="1870" y="734">id</text>
362
<text text-anchor="middle" style="font-size:8.00;" x="1936" y="734">serial</text>
363
<text text-anchor="middle" style="font-size:8.00;" x="1990" y="734"> PRIMARY KEY </text>
364
<text text-anchor="middle" style="font-size:8.00;" x="1874" y="748">code</text>
365
<text text-anchor="middle" style="font-size:8.00;" x="1934" y="748">text</text>
366
<text text-anchor="middle" style="font-size:8.00;" x="1978" y="748"> UNIQUE </text>
367
<text text-anchor="middle" style="font-size:8.00;" x="1887" y="762">englishname</text>
368
<text text-anchor="middle" style="font-size:8.00;" x="1934" y="762">text</text>
369
<text text-anchor="middle" style="font-size:8.00;" x="1886" y="776">nativename</text>
370
<text text-anchor="middle" style="font-size:8.00;" x="1934" y="776">text</text>
371
<text text-anchor="middle" style="font-size:8.00;" x="1886" y="790">pluralforms</text>
372
<text text-anchor="middle" style="font-size:8.00;" x="1939" y="790">integer</text>
373
<text text-anchor="middle" style="font-size:8.00;" x="1894" y="804">pluralexpression</text>
374
<text text-anchor="middle" style="font-size:8.00;" x="1934" y="804">text</text>
375
<text text-anchor="middle" style="font-size:8.00;" x="1878" y="818">visible</text>
376
<text text-anchor="middle" style="font-size:8.00;" x="1941" y="818">boolean</text>
377
<text text-anchor="middle" style="font-size:8.00;" x="1881" y="832">direction</text>
378
<text text-anchor="middle" style="font-size:8.00;" x="1939" y="832">integer</text>
379
<polygon style="fill:none;stroke:black;" points="1861,838 1861,706 2025,706 2025,838 1861,838"/>
380
</g>
381
<g id="node14" class="node"><title>logintoken</title>
382
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="901,521 901,375 1087,375 1087,521 901,521"/>
383
<polygon style="fill:white;stroke:white;" points="904,392 904,378 1084,378 1084,392 904,392"/>
384
<text text-anchor="middle" style="font-size:8.00;" x="994" y="388">logintoken</text>
385
<polygon style="fill:none;stroke:black;" points="904,392 904,378 1084,378 1084,392 904,392"/>
386
<text text-anchor="middle" style="font-size:8.00;" x="910" y="403">id</text>
387
<text text-anchor="middle" style="font-size:8.00;" x="971" y="403">serial</text>
388
<text text-anchor="middle" style="font-size:8.00;" x="922" y="417">requester</text>
389
<text text-anchor="middle" style="font-size:8.00;" x="974" y="417">integer</text>
390
<text text-anchor="middle" style="font-size:8.00;" x="1043" y="417"> REFERENCES person </text>
391
<text text-anchor="middle" style="font-size:8.00;" x="931" y="431">requesteremail</text>
392
<text text-anchor="middle" style="font-size:8.00;" x="969" y="431">text</text>
393
<text text-anchor="middle" style="font-size:8.00;" x="916" y="445">email</text>
394
<text text-anchor="middle" style="font-size:8.00;" x="969" y="445">text</text>
395
<text text-anchor="middle" style="font-size:8.00;" x="918" y="459">created</text>
396
<text text-anchor="middle" style="font-size:8.00;" x="980" y="459">timestamp</text>
397
<text text-anchor="middle" style="font-size:8.00;" x="923" y="473">tokentype</text>
398
<text text-anchor="middle" style="font-size:8.00;" x="974" y="473">integer</text>
399
<text text-anchor="middle" style="font-size:8.00;" x="916" y="487">token</text>
400
<text text-anchor="middle" style="font-size:8.00;" x="969" y="487">text</text>
401
<text text-anchor="middle" style="font-size:8.00;" x="1021" y="487"> UNIQUE </text>
402
<text text-anchor="middle" style="font-size:8.00;" x="924" y="501">fingerprint</text>
403
<text text-anchor="middle" style="font-size:8.00;" x="969" y="501">text</text>
404
<text text-anchor="middle" style="font-size:8.00;" x="931" y="515">redirection_url</text>
405
<text text-anchor="middle" style="font-size:8.00;" x="969" y="515">text</text>
406
<polygon style="fill:none;stroke:black;" points="901,521 901,375 1087,375 1087,521 901,521"/>
407
</g>
408
<g id="edge26" class="edge"><title>logintoken->person</title>
409
<path style="fill:none;stroke:black;" d="M1093,525C1146,566 1213,618 1272,664"/>
410
<polygon style="fill:black;stroke:black;" points="1274,661 1280,670 1270,667 1274,661"/>
411
</g>
412
<g id="edge34" class="edge"><title>person->calendar</title>
413
<path style="fill:none;stroke:black;" d="M1509,980C1556,1082 1607,1196 1635,1258"/>
414
<polygon style="fill:black;stroke:black;" points="1638,1256 1639,1267 1632,1259 1638,1256"/>
415
</g>
416
<g id="edge36" class="edge"><title>person->country</title>
417
<path style="fill:none;stroke:black;" d="M1554,575C1612,488 1678,393 1721,329"/>
418
<polygon style="fill:black;stroke:black;" points="1718,327 1727,321 1724,331 1718,327"/>
419
</g>
420
<g id="edge30" class="edge"><title>person->language</title>
421
<path style="fill:none;stroke:black;" d="M1554,776C1644,775 1761,774 1843,773"/>
422
<polygon style="fill:black;stroke:black;" points="1843,769 1853,773 1843,776 1843,769"/>
400
423
</g>
401
424
<g id="edge28" class="edge"><title>person->person</title>
402
<path style="fill:none;stroke:black;" d="M678,885C699,869 714,825 714,752 714,688 702,646 685,626"/>
403
<polygon style="fill:black;stroke:black;" points="683,629 678,619 688,624 683,629"/>
404
</g>
405
<g id="node37" class="node"><title>fake_libraryfilealias_177</title>
406
<ellipse cx="604" cy="1109" rx="29" ry="18" style="fill:none;stroke:red;"/>
407
<text text-anchor="middle" style="font-size:6.00;" x="604" y="1111">libraryfilealias</text>
408
</g>
409
<g id="edge34" class="edge"><title>person->fake_libraryfilealias_177</title>
410
<path style="fill:none;stroke:black;" d="M587,939C592,994 598,1049 601,1081"/>
411
<polygon style="fill:black;stroke:black;" points="604,1081 602,1091 598,1081 604,1081"/>
412
</g>
413
<g id="node39" class="node"><title>fake_libraryfilealias_179</title>
414
<ellipse cx="244" cy="897" rx="29" ry="18" style="fill:none;stroke:red;"/>
415
<text text-anchor="middle" style="font-size:6.00;" x="244" y="899">libraryfilealias</text>
416
</g>
417
<g id="edge36" class="edge"><title>person->fake_libraryfilealias_179</title>
418
<path style="fill:none;stroke:black;" d="M460,801C396,830 320,864 277,882"/>
419
<polygon style="fill:black;stroke:black;" points="279,885 268,886 276,879 279,885"/>
420
</g>
421
<g id="node15" class="node"><title>personlanguage</title>
422
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="556,273 556,219 710,219 710,273 556,273"/>
423
<polygon style="fill:white;stroke:white;" points="559,234 559,222 707,222 707,234 559,234"/>
424
<text text-anchor="middle" style="font-size:6.00;" x="633" y="230">personlanguage</text>
425
<polygon style="fill:none;stroke:black;" points="559,234 559,222 707,222 707,234 559,234"/>
426
<text text-anchor="middle" style="font-size:6.00;" x="564" y="243">id</text>
427
<text text-anchor="middle" style="font-size:6.00;" x="598" y="243">serial</text>
428
<text text-anchor="middle" style="font-size:6.00;" x="638" y="243"> PRIMARY KEY </text>
429
<text text-anchor="middle" style="font-size:6.00;" x="570" y="255">person</text>
430
<text text-anchor="middle" style="font-size:6.00;" x="600" y="255">integer</text>
431
<text text-anchor="middle" style="font-size:6.00;" x="657" y="255"> REFERENCES person UNIQUE </text>
432
<text text-anchor="middle" style="font-size:6.00;" x="573" y="267">language</text>
433
<text text-anchor="middle" style="font-size:6.00;" x="600" y="267">integer</text>
434
<text text-anchor="middle" style="font-size:6.00;" x="660" y="267"> REFERENCES language UNIQUE </text>
435
<polygon style="fill:none;stroke:black;" points="556,273 556,219 710,219 710,273 556,273"/>
436
</g>
437
<g id="edge40" class="edge"><title>personlanguage->language</title>
438
<path style="fill:none;stroke:black;" d="M548,257C527,260 505,262 485,265"/>
439
<polygon style="fill:black;stroke:black;" points="485,268 475,266 485,262 485,268"/>
440
</g>
441
<g id="edge38" class="edge"><title>personlanguage->person</title>
442
<path style="fill:none;stroke:black;" d="M629,277C622,332 607,450 594,555"/>
443
<polygon style="fill:black;stroke:black;" points="597,555 593,565 591,555 597,555"/>
444
</g>
445
<g id="node16" class="node"><title>signedcodeofconduct</title>
446
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="950,1047 950,933 1158,933 1158,1047 950,1047"/>
447
<polygon style="fill:white;stroke:white;" points="953,948 953,936 1155,936 1155,948 953,948"/>
448
<text text-anchor="middle" style="font-size:6.00;" x="1054" y="944">signedcodeofconduct</text>
449
<polygon style="fill:none;stroke:black;" points="953,948 953,936 1155,936 1155,948 953,948"/>
450
<text text-anchor="middle" style="font-size:6.00;" x="958" y="957">id</text>
451
<text text-anchor="middle" style="font-size:6.00;" x="1008" y="957">serial</text>
452
<text text-anchor="middle" style="font-size:6.00;" x="964" y="969">owner</text>
453
<text text-anchor="middle" style="font-size:6.00;" x="1010" y="969">integer</text>
454
<text text-anchor="middle" style="font-size:6.00;" x="1094" y="969"> REFERENCES person REFERENCES gpgkey </text>
455
<text text-anchor="middle" style="font-size:6.00;" x="969" y="981">signingkey</text>
456
<text text-anchor="middle" style="font-size:6.00;" x="1010" y="981">integer</text>
457
<text text-anchor="middle" style="font-size:6.00;" x="1065" y="981"> REFERENCES gpgkey </text>
458
<text text-anchor="middle" style="font-size:6.00;" x="970" y="993">datecreated</text>
459
<text text-anchor="middle" style="font-size:6.00;" x="1015" y="993">timestamp</text>
460
<text text-anchor="middle" style="font-size:6.00;" x="969" y="1005">signedcode</text>
461
<text text-anchor="middle" style="font-size:6.00;" x="1007" y="1005">text</text>
462
<text text-anchor="middle" style="font-size:6.00;" x="967" y="1017">recipient</text>
463
<text text-anchor="middle" style="font-size:6.00;" x="1010" y="1017">integer</text>
464
<text text-anchor="middle" style="font-size:6.00;" x="963" y="1029">active</text>
465
<text text-anchor="middle" style="font-size:6.00;" x="1012" y="1029">boolean</text>
466
<text text-anchor="middle" style="font-size:6.00;" x="975" y="1041">admincomment</text>
467
<text text-anchor="middle" style="font-size:6.00;" x="1007" y="1041">text</text>
468
<polygon style="fill:none;stroke:black;" points="950,1047 950,933 1158,933 1158,1047 950,1047"/>
469
</g>
470
<g id="edge44" class="edge"><title>signedcodeofconduct->gpgkey</title>
471
<path style="fill:none;stroke:black;" d="M1059,929C1060,922 1060,916 1061,910"/>
472
<polygon style="fill:black;stroke:black;" points="1058,910 1062,900 1064,910 1058,910"/>
473
</g>
474
<g id="edge42" class="edge"><title>signedcodeofconduct->person</title>
475
<path style="fill:none;stroke:black;" d="M942,935C866,898 765,848 687,811"/>
476
<polygon style="fill:black;stroke:black;" points="685,814 678,806 688,808 685,814"/>
477
</g>
478
<g id="node17" class="node"><title>sshkey</title>
479
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="962,700 962,622 1086,622 1086,700 962,700"/>
480
<polygon style="fill:white;stroke:white;" points="965,637 965,625 1083,625 1083,637 965,637"/>
481
<text text-anchor="middle" style="font-size:6.00;" x="1024" y="633">sshkey</text>
482
<polygon style="fill:none;stroke:black;" points="965,637 965,625 1083,625 1083,637 965,637"/>
483
<text text-anchor="middle" style="font-size:6.00;" x="970" y="646">id</text>
484
<text text-anchor="middle" style="font-size:6.00;" x="1004" y="646">serial</text>
485
<text text-anchor="middle" style="font-size:6.00;" x="1044" y="646"> PRIMARY KEY </text>
486
<text text-anchor="middle" style="font-size:6.00;" x="976" y="658">person</text>
487
<text text-anchor="middle" style="font-size:6.00;" x="1006" y="658">integer</text>
488
<text text-anchor="middle" style="font-size:6.00;" x="1051" y="658"> REFERENCES person </text>
489
<text text-anchor="middle" style="font-size:6.00;" x="978" y="670">keytype</text>
490
<text text-anchor="middle" style="font-size:6.00;" x="1006" y="670">integer</text>
491
<text text-anchor="middle" style="font-size:6.00;" x="977" y="682">keytext</text>
492
<text text-anchor="middle" style="font-size:6.00;" x="1003" y="682">text</text>
493
<text text-anchor="middle" style="font-size:6.00;" x="979" y="694">comment</text>
494
<text text-anchor="middle" style="font-size:6.00;" x="1003" y="694">text</text>
495
<polygon style="fill:none;stroke:black;" points="962,700 962,622 1086,622 1086,700 962,700"/>
496
</g>
497
<g id="edge46" class="edge"><title>sshkey->person</title>
498
<path style="fill:none;stroke:black;" d="M954,675C883,689 773,711 688,728"/>
499
<polygon style="fill:black;stroke:black;" points="688,731 678,730 687,725 688,731"/>
500
</g>
501
<g id="node18" class="node"><title>teammembership</title>
502
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="118,411 118,297 296,297 296,411 118,411"/>
503
<polygon style="fill:white;stroke:white;" points="121,312 121,300 293,300 293,312 121,312"/>
504
<text text-anchor="middle" style="font-size:6.00;" x="207" y="308">teammembership</text>
505
<polygon style="fill:none;stroke:black;" points="121,312 121,300 293,300 293,312 121,312"/>
506
<text text-anchor="middle" style="font-size:6.00;" x="126" y="321">id</text>
507
<text text-anchor="middle" style="font-size:6.00;" x="181" y="321">serial</text>
508
<text text-anchor="middle" style="font-size:6.00;" x="230" y="321"> PRIMARY KEY </text>
509
<text text-anchor="middle" style="font-size:6.00;" x="132" y="333">person</text>
510
<text text-anchor="middle" style="font-size:6.00;" x="183" y="333">integer</text>
511
<text text-anchor="middle" style="font-size:6.00;" x="249" y="333"> REFERENCES person UNIQUE </text>
512
<text text-anchor="middle" style="font-size:6.00;" x="130" y="345">team</text>
513
<text text-anchor="middle" style="font-size:6.00;" x="183" y="345">integer</text>
514
<text text-anchor="middle" style="font-size:6.00;" x="249" y="345"> REFERENCES person UNIQUE </text>
515
<text text-anchor="middle" style="font-size:6.00;" x="131" y="357">status</text>
516
<text text-anchor="middle" style="font-size:6.00;" x="183" y="357">integer</text>
517
<text text-anchor="middle" style="font-size:6.00;" x="137" y="369">datejoined</text>
518
<text text-anchor="middle" style="font-size:6.00;" x="188" y="369">timestamp</text>
519
<text text-anchor="middle" style="font-size:6.00;" x="138" y="381">dateexpires</text>
520
<text text-anchor="middle" style="font-size:6.00;" x="188" y="381">timestamp</text>
521
<text text-anchor="middle" style="font-size:6.00;" x="134" y="393">reviewer</text>
522
<text text-anchor="middle" style="font-size:6.00;" x="183" y="393">integer</text>
523
<text text-anchor="middle" style="font-size:6.00;" x="237" y="393"> REFERENCES person </text>
524
<text text-anchor="middle" style="font-size:6.00;" x="145" y="405">reviewercomment</text>
525
<text text-anchor="middle" style="font-size:6.00;" x="180" y="405">text</text>
526
<polygon style="fill:none;stroke:black;" points="118,411 118,297 296,297 296,411 118,411"/>
527
</g>
528
<g id="edge48" class="edge"><title>teammembership->person</title>
529
<path style="fill:none;stroke:black;" d="M277,415C327,466 395,539 453,605"/>
530
<polygon style="fill:black;stroke:black;" points="456,603 460,613 451,608 456,603"/>
531
</g>
532
<g id="edge50" class="edge"><title>teammembership->person</title>
533
<path style="fill:none;stroke:black;" d="M250,415C299,475 383,569 453,642"/>
534
<polygon style="fill:black;stroke:black;" points="456,640 460,650 451,645 456,640"/>
425
<path style="fill:none;stroke:black;" d="M1554,835C1565,822 1572,803 1572,777 1572,756 1567,740 1560,727"/>
426
<polygon style="fill:black;stroke:black;" points="1557,729 1554,719 1563,725 1557,729"/>
427
</g>
428
<g id="edge32" class="edge"><title>person->person</title>
429
<path style="fill:none;stroke:black;" d="M1554,915C1576,895 1590,848 1590,777 1590,714 1579,670 1561,647"/>
430
<polygon style="fill:black;stroke:black;" points="1558,649 1554,639 1563,644 1558,649"/>
431
</g>
432
<g id="node42" class="node"><title>fake_libraryfilealias_192</title>
433
<ellipse cx="1560" cy="421" rx="35" ry="18" style="fill:none;stroke:red;"/>
434
<text text-anchor="middle" style="font-size:8.00;" x="1560" y="424">libraryfilealias</text>
435
</g>
436
<g id="edge38" class="edge"><title>person->fake_libraryfilealias_192</title>
437
<path style="fill:none;stroke:black;" d="M1499,574C1519,524 1538,477 1549,448"/>
438
<polygon style="fill:black;stroke:black;" points="1546,447 1553,439 1552,450 1546,447"/>
439
</g>
440
<g id="node44" class="node"><title>fake_libraryfilealias_194</title>
441
<ellipse cx="1637" cy="1083" rx="35" ry="18" style="fill:none;stroke:red;"/>
442
<text text-anchor="middle" style="font-size:8.00;" x="1637" y="1086">libraryfilealias</text>
443
</g>
444
<g id="edge40" class="edge"><title>person->fake_libraryfilealias_194</title>
445
<path style="fill:none;stroke:black;" d="M1554,968C1580,1004 1604,1036 1619,1058"/>
446
<polygon style="fill:black;stroke:black;" points="1622,1056 1625,1066 1616,1060 1622,1056"/>
447
</g>
448
<g id="node16" class="node"><title>personlanguage</title>
449
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="1828,679 1828,617 2024,617 2024,679 1828,679"/>
450
<polygon style="fill:white;stroke:white;" points="1831,634 1831,620 2021,620 2021,634 1831,634"/>
451
<text text-anchor="middle" style="font-size:8.00;" x="1926" y="630">personlanguage</text>
452
<polygon style="fill:none;stroke:black;" points="1831,634 1831,620 2021,620 2021,634 1831,634"/>
453
<text text-anchor="middle" style="font-size:8.00;" x="1837" y="645">id</text>
454
<text text-anchor="middle" style="font-size:8.00;" x="1879" y="645">serial</text>
455
<text text-anchor="middle" style="font-size:8.00;" x="1930" y="645"> PRIMARY KEY </text>
456
<text text-anchor="middle" style="font-size:8.00;" x="1845" y="659">person</text>
457
<text text-anchor="middle" style="font-size:8.00;" x="1882" y="659">integer</text>
458
<text text-anchor="middle" style="font-size:8.00;" x="1956" y="659"> REFERENCES person UNIQUE </text>
459
<text text-anchor="middle" style="font-size:8.00;" x="1849" y="673">language</text>
460
<text text-anchor="middle" style="font-size:8.00;" x="1882" y="673">integer</text>
461
<text text-anchor="middle" style="font-size:8.00;" x="1960" y="673"> REFERENCES language UNIQUE </text>
462
<polygon style="fill:none;stroke:black;" points="1828,679 1828,617 2024,617 2024,679 1828,679"/>
463
</g>
464
<g id="edge44" class="edge"><title>personlanguage->language</title>
465
<path style="fill:none;stroke:black;" d="M1931,683C1931,686 1932,689 1932,692"/>
466
<polygon style="fill:black;stroke:black;" points="1935,692 1934,702 1929,693 1935,692"/>
467
</g>
468
<g id="edge42" class="edge"><title>personlanguage->person</title>
469
<path style="fill:none;stroke:black;" d="M1820,675C1746,694 1646,719 1564,740"/>
470
<polygon style="fill:black;stroke:black;" points="1564,743 1554,742 1563,737 1564,743"/>
471
</g>
472
<g id="node17" class="node"><title>signedcodeofconduct</title>
473
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="1080,273 1080,141 1346,141 1346,273 1080,273"/>
474
<polygon style="fill:white;stroke:white;" points="1083,158 1083,144 1343,144 1343,158 1083,158"/>
475
<text text-anchor="middle" style="font-size:8.00;" x="1213" y="154">signedcodeofconduct</text>
476
<polygon style="fill:none;stroke:black;" points="1083,158 1083,144 1343,144 1343,158 1083,158"/>
477
<text text-anchor="middle" style="font-size:8.00;" x="1089" y="169">id</text>
478
<text text-anchor="middle" style="font-size:8.00;" x="1152" y="169">serial</text>
479
<text text-anchor="middle" style="font-size:8.00;" x="1096" y="183">owner</text>
480
<text text-anchor="middle" style="font-size:8.00;" x="1155" y="183">integer</text>
481
<text text-anchor="middle" style="font-size:8.00;" x="1263" y="183"> REFERENCES person REFERENCES gpgkey </text>
482
<text text-anchor="middle" style="font-size:8.00;" x="1103" y="197">signingkey</text>
483
<text text-anchor="middle" style="font-size:8.00;" x="1155" y="197">integer</text>
484
<text text-anchor="middle" style="font-size:8.00;" x="1225" y="197"> REFERENCES gpgkey </text>
485
<text text-anchor="middle" style="font-size:8.00;" x="1104" y="211">datecreated</text>
486
<text text-anchor="middle" style="font-size:8.00;" x="1161" y="211">timestamp</text>
487
<text text-anchor="middle" style="font-size:8.00;" x="1104" y="225">signedcode</text>
488
<text text-anchor="middle" style="font-size:8.00;" x="1150" y="225">text</text>
489
<text text-anchor="middle" style="font-size:8.00;" x="1100" y="239">recipient</text>
490
<text text-anchor="middle" style="font-size:8.00;" x="1155" y="239">integer</text>
491
<text text-anchor="middle" style="font-size:8.00;" x="1095" y="253">active</text>
492
<text text-anchor="middle" style="font-size:8.00;" x="1157" y="253">boolean</text>
493
<text text-anchor="middle" style="font-size:8.00;" x="1111" y="267">admincomment</text>
494
<text text-anchor="middle" style="font-size:8.00;" x="1150" y="267">text</text>
495
<polygon style="fill:none;stroke:black;" points="1080,273 1080,141 1346,141 1346,273 1080,273"/>
496
</g>
497
<g id="edge48" class="edge"><title>signedcodeofconduct->gpgkey</title>
498
<path style="fill:none;stroke:black;" d="M1354,218C1356,218 1358,218 1360,218"/>
499
<polygon style="fill:black;stroke:black;" points="1360,215 1370,219 1360,221 1360,215"/>
500
</g>
501
<g id="edge46" class="edge"><title>signedcodeofconduct->person</title>
502
<path style="fill:none;stroke:black;" d="M1254,277C1263,294 1272,313 1279,330 1311,405 1338,489 1360,564"/>
503
<polygon style="fill:black;stroke:black;" points="1363,563 1363,574 1357,565 1363,563"/>
504
</g>
505
<g id="node18" class="node"><title>sshkey</title>
506
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="864,987 864,897 1020,897 1020,987 864,987"/>
507
<polygon style="fill:white;stroke:white;" points="867,914 867,900 1017,900 1017,914 867,914"/>
508
<text text-anchor="middle" style="font-size:8.00;" x="942" y="910">sshkey</text>
509
<polygon style="fill:none;stroke:black;" points="867,914 867,900 1017,900 1017,914 867,914"/>
510
<text text-anchor="middle" style="font-size:8.00;" x="873" y="925">id</text>
511
<text text-anchor="middle" style="font-size:8.00;" x="915" y="925">serial</text>
512
<text text-anchor="middle" style="font-size:8.00;" x="966" y="925"> PRIMARY KEY </text>
513
<text text-anchor="middle" style="font-size:8.00;" x="881" y="939">person</text>
514
<text text-anchor="middle" style="font-size:8.00;" x="918" y="939">integer</text>
515
<text text-anchor="middle" style="font-size:8.00;" x="976" y="939"> REFERENCES person </text>
516
<text text-anchor="middle" style="font-size:8.00;" x="883" y="953">keytype</text>
517
<text text-anchor="middle" style="font-size:8.00;" x="918" y="953">integer</text>
518
<text text-anchor="middle" style="font-size:8.00;" x="882" y="967">keytext</text>
519
<text text-anchor="middle" style="font-size:8.00;" x="913" y="967">text</text>
520
<text text-anchor="middle" style="font-size:8.00;" x="885" y="981">comment</text>
521
<text text-anchor="middle" style="font-size:8.00;" x="913" y="981">text</text>
522
<polygon style="fill:none;stroke:black;" points="864,987 864,897 1020,897 1020,987 864,987"/>
523
</g>
524
<g id="edge50" class="edge"><title>sshkey->person</title>
525
<path style="fill:none;stroke:black;" d="M1028,912C1095,889 1191,856 1270,828"/>
526
<polygon style="fill:black;stroke:black;" points="1269,825 1280,825 1271,831 1269,825"/>
527
</g>
528
<g id="node19" class="node"><title>teammembership</title>
529
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="1852,1027 1852,895 2080,895 2080,1027 1852,1027"/>
530
<polygon style="fill:white;stroke:white;" points="1855,912 1855,898 2077,898 2077,912 1855,912"/>
531
<text text-anchor="middle" style="font-size:8.00;" x="1966" y="908">teammembership</text>
532
<polygon style="fill:none;stroke:black;" points="1855,912 1855,898 2077,898 2077,912 1855,912"/>
533
<text text-anchor="middle" style="font-size:8.00;" x="1861" y="923">id</text>
534
<text text-anchor="middle" style="font-size:8.00;" x="1932" y="923">serial</text>
535
<text text-anchor="middle" style="font-size:8.00;" x="1994" y="923"> PRIMARY KEY </text>
536
<text text-anchor="middle" style="font-size:8.00;" x="1869" y="937">person</text>
537
<text text-anchor="middle" style="font-size:8.00;" x="1935" y="937">integer</text>
538
<text text-anchor="middle" style="font-size:8.00;" x="2020" y="937"> UNIQUE REFERENCES person </text>
539
<text text-anchor="middle" style="font-size:8.00;" x="1866" y="951">team</text>
540
<text text-anchor="middle" style="font-size:8.00;" x="1935" y="951">integer</text>
541
<text text-anchor="middle" style="font-size:8.00;" x="2020" y="951"> UNIQUE REFERENCES person </text>
542
<text text-anchor="middle" style="font-size:8.00;" x="1867" y="965">status</text>
543
<text text-anchor="middle" style="font-size:8.00;" x="1935" y="965">integer</text>
544
<text text-anchor="middle" style="font-size:8.00;" x="1874" y="979">datejoined</text>
545
<text text-anchor="middle" style="font-size:8.00;" x="1941" y="979">timestamp</text>
546
<text text-anchor="middle" style="font-size:8.00;" x="1876" y="993">dateexpires</text>
547
<text text-anchor="middle" style="font-size:8.00;" x="1941" y="993">timestamp</text>
548
<text text-anchor="middle" style="font-size:8.00;" x="1872" y="1007">reviewer</text>
549
<text text-anchor="middle" style="font-size:8.00;" x="1935" y="1007">integer</text>
550
<text text-anchor="middle" style="font-size:8.00;" x="2004" y="1007"> REFERENCES person </text>
551
<text text-anchor="middle" style="font-size:8.00;" x="1887" y="1021">reviewercomment</text>
552
<text text-anchor="middle" style="font-size:8.00;" x="1930" y="1021">text</text>
553
<polygon style="fill:none;stroke:black;" points="1852,1027 1852,895 2080,895 2080,1027 1852,1027"/>
535
554
</g>
536
555
<g id="edge52" class="edge"><title>teammembership->person</title>
537
<path style="fill:none;stroke:black;" d="M263,415C313,471 389,555 453,624"/>
538
<polygon style="fill:black;stroke:black;" points="456,622 460,632 451,627 456,622"/>
539
</g>
540
<g id="node19" class="node"><title>teamparticipation</title>
541
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="14,883 14,829 156,829 156,883 14,883"/>
542
<polygon style="fill:white;stroke:white;" points="17,844 17,832 153,832 153,844 17,844"/>
543
<text text-anchor="middle" style="font-size:6.00;" x="85" y="840">teamparticipation</text>
544
<polygon style="fill:none;stroke:black;" points="17,844 17,832 153,832 153,844 17,844"/>
545
<text text-anchor="middle" style="font-size:6.00;" x="22" y="853">id</text>
546
<text text-anchor="middle" style="font-size:6.00;" x="50" y="853">serial</text>
547
<text text-anchor="middle" style="font-size:6.00;" x="90" y="853"> PRIMARY KEY </text>
548
<text text-anchor="middle" style="font-size:6.00;" x="26" y="865">team</text>
549
<text text-anchor="middle" style="font-size:6.00;" x="52" y="865">integer</text>
550
<text text-anchor="middle" style="font-size:6.00;" x="109" y="865"> REFERENCES person UNIQUE </text>
551
<text text-anchor="middle" style="font-size:6.00;" x="28" y="877">person</text>
552
<text text-anchor="middle" style="font-size:6.00;" x="52" y="877">integer</text>
553
<text text-anchor="middle" style="font-size:6.00;" x="109" y="877"> REFERENCES person UNIQUE </text>
554
<polygon style="fill:none;stroke:black;" points="14,883 14,829 156,829 156,883 14,883"/>
555
</g>
556
<g id="edge54" class="edge"><title>teamparticipation->person</title>
557
<path style="fill:none;stroke:black;" d="M164,834C242,816 361,790 450,772"/>
558
<polygon style="fill:black;stroke:black;" points="450,769 460,770 451,775 450,769"/>
559
</g>
560
<g id="edge56" class="edge"><title>teamparticipation->person</title>
561
<path style="fill:none;stroke:black;" d="M164,844C242,830 361,804 450,784"/>
562
<polygon style="fill:black;stroke:black;" points="450,781 460,782 451,787 450,781"/>
563
</g>
564
<g id="node20" class="node"><title>wikiname</title>
565
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="106,552 106,486 232,486 232,552 106,552"/>
566
<polygon style="fill:white;stroke:white;" points="109,501 109,489 229,489 229,501 109,501"/>
567
<text text-anchor="middle" style="font-size:6.00;" x="169" y="497">wikiname</text>
568
<polygon style="fill:none;stroke:black;" points="109,501 109,489 229,489 229,501 109,501"/>
569
<text text-anchor="middle" style="font-size:6.00;" x="114" y="510">id</text>
570
<text text-anchor="middle" style="font-size:6.00;" x="150" y="510">serial</text>
571
<text text-anchor="middle" style="font-size:6.00;" x="190" y="510"> PRIMARY KEY </text>
572
<text text-anchor="middle" style="font-size:6.00;" x="120" y="522">person</text>
573
<text text-anchor="middle" style="font-size:6.00;" x="152" y="522">integer</text>
574
<text text-anchor="middle" style="font-size:6.00;" x="197" y="522"> REFERENCES person </text>
575
<text text-anchor="middle" style="font-size:6.00;" x="117" y="534">wiki</text>
576
<text text-anchor="middle" style="font-size:6.00;" x="149" y="534">text</text>
577
<text text-anchor="middle" style="font-size:6.00;" x="181" y="534"> UNIQUE </text>
578
<text text-anchor="middle" style="font-size:6.00;" x="124" y="546">wikiname</text>
579
<text text-anchor="middle" style="font-size:6.00;" x="149" y="546">text</text>
580
<text text-anchor="middle" style="font-size:6.00;" x="181" y="546"> UNIQUE </text>
581
<polygon style="fill:none;stroke:black;" points="106,552 106,486 232,486 232,552 106,552"/>
582
</g>
583
<g id="edge58" class="edge"><title>wikiname->person</title>
584
<path style="fill:none;stroke:black;" d="M233,556C291,591 379,642 451,683"/>
585
<polygon style="fill:black;stroke:black;" points="453,680 460,688 450,686 453,680"/>
556
<path style="fill:none;stroke:black;" d="M1844,920C1761,892 1651,856 1563,826"/>
557
<polygon style="fill:black;stroke:black;" points="1562,829 1554,823 1565,823 1562,829"/>
558
</g>
559
<g id="edge54" class="edge"><title>teammembership->person</title>
560
<path style="fill:none;stroke:black;" d="M1844,920C1761,892 1651,856 1563,826"/>
561
<polygon style="fill:black;stroke:black;" points="1562,829 1554,823 1565,823 1562,829"/>
562
</g>
563
<g id="edge56" class="edge"><title>teammembership->person</title>
564
<path style="fill:none;stroke:black;" d="M1844,920C1761,892 1651,856 1563,826"/>
565
<polygon style="fill:black;stroke:black;" points="1562,829 1554,823 1565,823 1562,829"/>
566
</g>
567
<g id="node20" class="node"><title>teamparticipation</title>
568
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="1175,1315 1175,1253 1355,1253 1355,1315 1175,1315"/>
569
<polygon style="fill:white;stroke:white;" points="1178,1270 1178,1256 1352,1256 1352,1270 1178,1270"/>
570
<text text-anchor="middle" style="font-size:8.00;" x="1265" y="1266">teamparticipation</text>
571
<polygon style="fill:none;stroke:black;" points="1178,1270 1178,1256 1352,1256 1352,1270 1178,1270"/>
572
<text text-anchor="middle" style="font-size:8.00;" x="1184" y="1281">id</text>
573
<text text-anchor="middle" style="font-size:8.00;" x="1218" y="1281">serial</text>
574
<text text-anchor="middle" style="font-size:8.00;" x="1269" y="1281"> PRIMARY KEY </text>
575
<text text-anchor="middle" style="font-size:8.00;" x="1189" y="1295">team</text>
576
<text text-anchor="middle" style="font-size:8.00;" x="1221" y="1295">integer</text>
577
<text text-anchor="middle" style="font-size:8.00;" x="1295" y="1295"> REFERENCES person UNIQUE </text>
578
<text text-anchor="middle" style="font-size:8.00;" x="1192" y="1309">person</text>
579
<text text-anchor="middle" style="font-size:8.00;" x="1221" y="1309">integer</text>
580
<text text-anchor="middle" style="font-size:8.00;" x="1295" y="1309"> REFERENCES person UNIQUE </text>
581
<polygon style="fill:none;stroke:black;" points="1175,1315 1175,1253 1355,1253 1355,1315 1175,1315"/>
582
</g>
583
<g id="edge58" class="edge"><title>teamparticipation->person</title>
584
<path style="fill:none;stroke:black;" d="M1276,1249C1291,1195 1324,1088 1353,990"/>
585
<polygon style="fill:black;stroke:black;" points="1350,989 1356,980 1356,991 1350,989"/>
586
</g>
587
<g id="edge60" class="edge"><title>teamparticipation->person</title>
588
<path style="fill:none;stroke:black;" d="M1276,1249C1291,1195 1324,1088 1353,990"/>
589
<polygon style="fill:black;stroke:black;" points="1350,989 1356,980 1356,991 1350,989"/>
590
</g>
591
<g id="node21" class="node"><title>validpersonorteamcache</title>
592
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="1736,1108 1736,1074 1926,1074 1926,1108 1736,1108"/>
593
<polygon style="fill:white;stroke:white;" points="1739,1091 1739,1077 1923,1077 1923,1091 1739,1091"/>
594
<text text-anchor="middle" style="font-size:8.00;" x="1831" y="1087">validpersonorteamcache</text>
595
<polygon style="fill:none;stroke:black;" points="1739,1091 1739,1077 1923,1077 1923,1091 1739,1091"/>
596
<text text-anchor="middle" style="font-size:8.00;" x="1745" y="1102">id</text>
597
<text text-anchor="middle" style="font-size:8.00;" x="1767" y="1102">integer</text>
598
<text text-anchor="middle" style="font-size:8.00;" x="1853" y="1102"> REFERENCES person PRIMARY KEY </text>
599
<polygon style="fill:none;stroke:black;" points="1736,1108 1736,1074 1926,1074 1926,1108 1736,1108"/>
600
</g>
601
<g id="edge62" class="edge"><title>validpersonorteamcache->person</title>
602
<path style="fill:none;stroke:black;" d="M1803,1070C1755,1033 1650,954 1562,887"/>
603
<polygon style="fill:black;stroke:black;" points="1560,890 1554,881 1564,884 1560,890"/>
604
</g>
605
<g id="node22" class="node"><title>wikiname</title>
606
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="937,1124 937,1048 1095,1048 1095,1124 937,1124"/>
607
<polygon style="fill:white;stroke:white;" points="940,1065 940,1051 1092,1051 1092,1065 940,1065"/>
608
<text text-anchor="middle" style="font-size:8.00;" x="1016" y="1061">wikiname</text>
609
<polygon style="fill:none;stroke:black;" points="940,1065 940,1051 1092,1051 1092,1065 940,1065"/>
610
<text text-anchor="middle" style="font-size:8.00;" x="946" y="1076">id</text>
611
<text text-anchor="middle" style="font-size:8.00;" x="990" y="1076">serial</text>
612
<text text-anchor="middle" style="font-size:8.00;" x="1041" y="1076"> PRIMARY KEY </text>
613
<text text-anchor="middle" style="font-size:8.00;" x="954" y="1090">person</text>
614
<text text-anchor="middle" style="font-size:8.00;" x="993" y="1090">integer</text>
615
<text text-anchor="middle" style="font-size:8.00;" x="1051" y="1090"> REFERENCES person </text>
616
<text text-anchor="middle" style="font-size:8.00;" x="950" y="1104">wiki</text>
617
<text text-anchor="middle" style="font-size:8.00;" x="988" y="1104">text</text>
618
<text text-anchor="middle" style="font-size:8.00;" x="1029" y="1104"> UNIQUE </text>
619
<text text-anchor="middle" style="font-size:8.00;" x="959" y="1118">wikiname</text>
620
<text text-anchor="middle" style="font-size:8.00;" x="988" y="1118">text</text>
621
<text text-anchor="middle" style="font-size:8.00;" x="1029" y="1118"> UNIQUE </text>
622
<polygon style="fill:none;stroke:black;" points="937,1124 937,1048 1095,1048 1095,1124 937,1124"/>
623
</g>
624
<g id="edge64" class="edge"><title>wikiname->person</title>
625
<path style="fill:none;stroke:black;" d="M1071,1044C1123,1005 1202,943 1272,889"/>
626
<polygon style="fill:black;stroke:black;" points="1270,886 1280,883 1274,892 1270,886"/>
586
627
</g>
587
628
</g>
588
629
</svg>
Loggerhead is a web-based interface for Breezy
Version: 2.0.1