~launchpad-pqm/launchpad/devel

« back to all changes in this revision

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

  • Committer: Stuart Bishop
  • Date: 2005-11-24 07:47:19 UTC
  • mto: This revision was merged to the branch mainline in revision 2851.
  • Revision ID: stuart.bishop@canonical.com-20051124074719-1f14a54a1d23e0ff
Update database diagrams and documentation

Show diffs side-by-side

added added

removed removed

Lines of Context:
1
1
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
2
2
<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.0//EN"
3
3
 "http://www.w3.org/TR/2001/REC-SVG-20010904/DTD/svg10.dtd">
4
 
<!-- Generated by fdp version 2.2.1 (Thu Apr 14 05:40:09 UTC 2005)
 
4
<!-- Generated by fdp version 2.2.1 (Tue Oct 11 01:38:21 UTC 2005)
5
5
     For user: (stub) Stuart Bishop,,,   Title: g    Pages: 1 -->
6
 
<svg width="534px" height="535px"
7
 
 viewBox = "-1 -1 533 534"
 
6
<svg width="312px" height="535px"
 
7
 viewBox = "-1 -1 311 534"
8
8
 xmlns="http://www.w3.org/2000/svg">
9
 
<g id="graph0" class="graph" transform = "scale(0.384559)"
 
9
<g id="graph0" class="graph" transform = "scale(0.258911)"
10
10
 style="font-family:Times-Roman;font-size:14.00;">
11
11
<title>g</title>
12
 
<text text-anchor="middle" style="font-size:22.00;" x="684" y="1370">Foaf</text>
 
12
<text text-anchor="middle" style="font-size:22.00;" x="586" y="2042">Foaf</text>
13
13
<g id="node1" class="node"><title>calendar</title>
14
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="967,696 967,642 1073,642 1073,696 967,696"/>
15
 
<polygon style="fill:white;stroke:white;" points="970,657 970,645 1070,645 1070,657 970,657"/>
16
 
<text text-anchor="middle" style="font-size:6.00;" x="1020" y="653">calendar</text>
17
 
<polygon style="fill:none;stroke:black;" points="970,657 970,645 1070,645 1070,657 970,657"/>
18
 
<text text-anchor="middle" style="font-size:6.00;" x="975" y="666">id</text>
19
 
<text text-anchor="middle" style="font-size:6.00;" x="1006" y="666">serial</text>
20
 
<text text-anchor="middle" style="font-size:6.00;" x="1046" y="666"> PRIMARY KEY </text>
21
 
<text text-anchor="middle" style="font-size:6.00;" x="978" y="678">title</text>
22
 
<text text-anchor="middle" style="font-size:6.00;" x="1005" y="678">text</text>
23
 
<text text-anchor="middle" style="font-size:6.00;" x="983" y="690">revision</text>
24
 
<text text-anchor="middle" style="font-size:6.00;" x="1008" y="690">integer</text>
25
 
<polygon style="fill:none;stroke:black;" points="967,696 967,642 1073,642 1073,696 967,696"/>
 
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"/>
26
26
</g>
27
27
<g id="node2" class="node"><title>calendarsubscription</title>
28
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="1208,748 1208,682 1354,682 1354,748 1208,748"/>
29
 
<polygon style="fill:white;stroke:white;" points="1211,697 1211,685 1351,685 1351,697 1211,697"/>
30
 
<text text-anchor="middle" style="font-size:6.00;" x="1281" y="693">calendarsubscription</text>
31
 
<polygon style="fill:none;stroke:black;" points="1211,697 1211,685 1351,685 1351,697 1211,697"/>
32
 
<text text-anchor="middle" style="font-size:6.00;" x="1216" y="706">id</text>
33
 
<text text-anchor="middle" style="font-size:6.00;" x="1244" y="706">serial</text>
34
 
<text text-anchor="middle" style="font-size:6.00;" x="1284" y="706"> PRIMARY KEY </text>
35
 
<text text-anchor="middle" style="font-size:6.00;" x="1222" y="718">subject</text>
36
 
<text text-anchor="middle" style="font-size:6.00;" x="1246" y="718">integer</text>
37
 
<text text-anchor="middle" style="font-size:6.00;" x="1305" y="718"> REFERENCES calendar UNIQUE </text>
38
 
<text text-anchor="middle" style="font-size:6.00;" x="1222" y="730">object</text>
39
 
<text text-anchor="middle" style="font-size:6.00;" x="1246" y="730">integer</text>
40
 
<text text-anchor="middle" style="font-size:6.00;" x="1305" y="730"> REFERENCES calendar UNIQUE </text>
41
 
<text text-anchor="middle" style="font-size:6.00;" x="1222" y="742">colour</text>
42
 
<text text-anchor="middle" style="font-size:6.00;" x="1243" y="742">text</text>
43
 
<polygon style="fill:none;stroke:black;" points="1208,748 1208,682 1354,682 1354,748 1208,748"/>
 
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"/>
44
44
</g>
45
45
<g id="edge2" class="edge"><title>calendarsubscription&#45;&gt;calendar</title>
46
 
<path style="fill:none;stroke:black;" d="M1200,707C1165,702 1125,694 1091,688"/>
47
 
<polygon style="fill:black;stroke:black;" points="1090,691 1081,686 1091,685 1090,691"/>
 
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"/>
48
48
</g>
49
49
<g id="edge4" class="edge"><title>calendarsubscription&#45;&gt;calendar</title>
50
 
<path style="fill:none;stroke:black;" d="M1200,695C1165,688 1124,681 1091,676"/>
51
 
<polygon style="fill:black;stroke:black;" points="1090,679 1081,674 1091,673 1090,679"/>
 
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"/>
52
52
</g>
53
53
<g id="node3" class="node"><title>country</title>
54
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="137,950 137,860 269,860 269,950 137,950"/>
55
 
<polygon style="fill:white;stroke:white;" points="140,875 140,863 266,863 266,875 140,875"/>
56
 
<text text-anchor="middle" style="font-size:6.00;" x="203" y="871">country</text>
57
 
<polygon style="fill:none;stroke:black;" points="140,875 140,863 266,863 266,875 140,875"/>
58
 
<text text-anchor="middle" style="font-size:6.00;" x="145" y="884">id</text>
59
 
<text text-anchor="middle" style="font-size:6.00;" x="190" y="884">serial</text>
60
 
<text text-anchor="middle" style="font-size:6.00;" x="242" y="884"> PRIMARY KEY </text>
61
 
<text text-anchor="middle" style="font-size:6.00;" x="160" y="896">iso3166code2</text>
62
 
<text text-anchor="middle" style="font-size:6.00;" x="198" y="896">character(2)</text>
63
 
<text text-anchor="middle" style="font-size:6.00;" x="233" y="896"> UNIQUE </text>
64
 
<text text-anchor="middle" style="font-size:6.00;" x="160" y="908">iso3166code3</text>
65
 
<text text-anchor="middle" style="font-size:6.00;" x="198" y="908">character(3)</text>
66
 
<text text-anchor="middle" style="font-size:6.00;" x="233" y="908"> UNIQUE </text>
67
 
<text text-anchor="middle" style="font-size:6.00;" x="150" y="920">name</text>
68
 
<text text-anchor="middle" style="font-size:6.00;" x="189" y="920">text</text>
69
 
<text text-anchor="middle" style="font-size:6.00;" x="233" y="920"> UNIQUE </text>
70
 
<text text-anchor="middle" style="font-size:6.00;" x="148" y="932">title</text>
71
 
<text text-anchor="middle" style="font-size:6.00;" x="189" y="932">text</text>
72
 
<text text-anchor="middle" style="font-size:6.00;" x="157" y="944">description</text>
73
 
<text text-anchor="middle" style="font-size:6.00;" x="189" y="944">text</text>
74
 
<polygon style="fill:none;stroke:black;" points="137,950 137,860 269,860 269,950 137,950"/>
 
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"/>
75
75
</g>
76
76
<g id="node4" class="node"><title>emailaddress</title>
77
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="412,129 412,63 530,63 530,129 412,129"/>
78
 
<polygon style="fill:white;stroke:white;" points="415,78 415,66 527,66 527,78 415,78"/>
79
 
<text text-anchor="middle" style="font-size:6.00;" x="471" y="74">emailaddress</text>
80
 
<polygon style="fill:none;stroke:black;" points="415,78 415,66 527,66 527,78 415,78"/>
81
 
<text text-anchor="middle" style="font-size:6.00;" x="420" y="87">id</text>
82
 
<text text-anchor="middle" style="font-size:6.00;" x="448" y="87">serial</text>
83
 
<text text-anchor="middle" style="font-size:6.00;" x="488" y="87"> PRIMARY KEY </text>
84
 
<text text-anchor="middle" style="font-size:6.00;" x="425" y="99">email</text>
85
 
<text text-anchor="middle" style="font-size:6.00;" x="447" y="99">text</text>
86
 
<text text-anchor="middle" style="font-size:6.00;" x="426" y="111">person</text>
87
 
<text text-anchor="middle" style="font-size:6.00;" x="450" y="111">integer</text>
88
 
<text text-anchor="middle" style="font-size:6.00;" x="495" y="111"> REFERENCES person </text>
89
 
<text text-anchor="middle" style="font-size:6.00;" x="425" y="123">status</text>
90
 
<text text-anchor="middle" style="font-size:6.00;" x="450" y="123">integer</text>
91
 
<polygon style="fill:none;stroke:black;" points="412,129 412,63 530,63 530,129 412,129"/>
 
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
92
</g>
93
 
<g id="node13" class="node"><title>person</title>
94
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="424,743 424,377 626,377 626,743 424,743"/>
95
 
<polygon style="fill:white;stroke:white;" points="427,392 427,380 623,380 623,392 427,392"/>
96
 
<text text-anchor="middle" style="font-size:6.00;" x="525" y="388">person</text>
97
 
<polygon style="fill:none;stroke:black;" points="427,392 427,380 623,380 623,392 427,392"/>
98
 
<text text-anchor="middle" style="font-size:6.00;" x="432" y="401">id</text>
99
 
<text text-anchor="middle" style="font-size:6.00;" x="507" y="401">serial</text>
100
 
<text text-anchor="middle" style="font-size:6.00;" x="556" y="401"> PRIMARY KEY </text>
101
 
<text text-anchor="middle" style="font-size:6.00;" x="445" y="413">displayname</text>
102
 
<text text-anchor="middle" style="font-size:6.00;" x="506" y="413">text</text>
103
 
<text text-anchor="middle" style="font-size:6.00;" x="443" y="425">givenname</text>
104
 
<text text-anchor="middle" style="font-size:6.00;" x="506" y="425">text</text>
105
 
<text text-anchor="middle" style="font-size:6.00;" x="444" y="437">familyname</text>
106
 
<text text-anchor="middle" style="font-size:6.00;" x="506" y="437">text</text>
107
 
<text text-anchor="middle" style="font-size:6.00;" x="441" y="449">password</text>
108
 
<text text-anchor="middle" style="font-size:6.00;" x="506" y="449">text</text>
109
 
<text text-anchor="middle" style="font-size:6.00;" x="443" y="461">teamowner</text>
110
 
<text text-anchor="middle" style="font-size:6.00;" x="509" y="461">integer</text>
111
 
<text text-anchor="middle" style="font-size:6.00;" x="563" y="461"> REFERENCES person </text>
112
 
<text text-anchor="middle" style="font-size:6.00;" x="450" y="473">teamdescription</text>
113
 
<text text-anchor="middle" style="font-size:6.00;" x="506" y="473">text</text>
114
 
<text text-anchor="middle" style="font-size:6.00;" x="437" y="485">name</text>
115
 
<text text-anchor="middle" style="font-size:6.00;" x="506" y="485">text</text>
116
 
<text text-anchor="middle" style="font-size:6.00;" x="441" y="497">language</text>
117
 
<text text-anchor="middle" style="font-size:6.00;" x="509" y="497">integer</text>
118
 
<text text-anchor="middle" style="font-size:6.00;" x="566" y="497"> REFERENCES language </text>
119
 
<text text-anchor="middle" style="font-size:6.00;" x="433" y="509">fti</text>
120
 
<text text-anchor="middle" style="font-size:6.00;" x="511" y="509">tsvector</text>
121
 
<text text-anchor="middle" style="font-size:6.00;" x="461" y="521">defaultmembershipperiod</text>
122
 
<text text-anchor="middle" style="font-size:6.00;" x="509" y="521">integer</text>
123
 
<text text-anchor="middle" style="font-size:6.00;" x="456" y="533">defaultrenewalperiod</text>
124
 
<text text-anchor="middle" style="font-size:6.00;" x="509" y="533">integer</text>
125
 
<text text-anchor="middle" style="font-size:6.00;" x="452" y="545">subscriptionpolicy</text>
126
 
<text text-anchor="middle" style="font-size:6.00;" x="509" y="545">integer</text>
127
 
<text text-anchor="middle" style="font-size:6.00;" x="439" y="557">merged</text>
128
 
<text text-anchor="middle" style="font-size:6.00;" x="509" y="557">integer</text>
129
 
<text text-anchor="middle" style="font-size:6.00;" x="563" y="557"> REFERENCES person </text>
130
 
<text text-anchor="middle" style="font-size:6.00;" x="444" y="569">datecreated</text>
131
 
<text text-anchor="middle" style="font-size:6.00;" x="514" y="569">timestamp</text>
132
 
<text text-anchor="middle" style="font-size:6.00;" x="440" y="581">calendar</text>
133
 
<text text-anchor="middle" style="font-size:6.00;" x="509" y="581">integer</text>
134
 
<text text-anchor="middle" style="font-size:6.00;" x="577" y="581"> REFERENCES calendar UNIQUE </text>
135
 
<text text-anchor="middle" style="font-size:6.00;" x="441" y="593">timezone</text>
136
 
<text text-anchor="middle" style="font-size:6.00;" x="506" y="593">text</text>
137
 
<text text-anchor="middle" style="font-size:6.00;" x="438" y="605">karma</text>
138
 
<text text-anchor="middle" style="font-size:6.00;" x="509" y="605">integer</text>
139
 
<text text-anchor="middle" style="font-size:6.00;" x="445" y="617">addressline1</text>
140
 
<text text-anchor="middle" style="font-size:6.00;" x="506" y="617">text</text>
141
 
<text text-anchor="middle" style="font-size:6.00;" x="445" y="629">addressline2</text>
142
 
<text text-anchor="middle" style="font-size:6.00;" x="506" y="629">text</text>
143
 
<text text-anchor="middle" style="font-size:6.00;" x="445" y="641">organization</text>
144
 
<text text-anchor="middle" style="font-size:6.00;" x="506" y="641">text</text>
145
 
<text text-anchor="middle" style="font-size:6.00;" x="435" y="653">city</text>
146
 
<text text-anchor="middle" style="font-size:6.00;" x="506" y="653">text</text>
147
 
<text text-anchor="middle" style="font-size:6.00;" x="441" y="665">province</text>
148
 
<text text-anchor="middle" style="font-size:6.00;" x="506" y="665">text</text>
149
 
<text text-anchor="middle" style="font-size:6.00;" x="440" y="677">country</text>
150
 
<text text-anchor="middle" style="font-size:6.00;" x="509" y="677">integer</text>
151
 
<text text-anchor="middle" style="font-size:6.00;" x="565" y="677"> REFERENCES country </text>
152
 
<text text-anchor="middle" style="font-size:6.00;" x="441" y="689">postcode</text>
153
 
<text text-anchor="middle" style="font-size:6.00;" x="506" y="689">text</text>
154
 
<text text-anchor="middle" style="font-size:6.00;" x="438" y="701">phone</text>
155
 
<text text-anchor="middle" style="font-size:6.00;" x="506" y="701">text</text>
156
 
<text text-anchor="middle" style="font-size:6.00;" x="453" y="713">homepage_content</text>
157
 
<text text-anchor="middle" style="font-size:6.00;" x="506" y="713">text</text>
158
 
<text text-anchor="middle" style="font-size:6.00;" x="440" y="725">emblem</text>
159
 
<text text-anchor="middle" style="font-size:6.00;" x="509" y="725">integer</text>
160
 
<text text-anchor="middle" style="font-size:6.00;" x="573" y="725"> REFERENCES libraryfilealias </text>
161
 
<text text-anchor="middle" style="font-size:6.00;" x="446" y="737">hackergotchi</text>
162
 
<text text-anchor="middle" style="font-size:6.00;" x="509" y="737">integer</text>
163
 
<text text-anchor="middle" style="font-size:6.00;" x="573" y="737"> REFERENCES libraryfilealias </text>
164
 
<polygon style="fill:none;stroke:black;" points="424,743 424,377 626,377 626,743 424,743"/>
 
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
165
</g>
166
166
<g id="edge6" class="edge"><title>emailaddress&#45;&gt;person</title>
167
 
<path style="fill:none;stroke:black;" d="M475,133C481,183 492,277 502,363"/>
168
 
<polygon style="fill:black;stroke:black;" points="505,363 503,373 499,363 505,363"/>
 
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"/>
169
169
</g>
170
170
<g id="node5" class="node"><title>gpgkey</title>
171
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="566,127 566,25 722,25 722,127 566,127"/>
172
 
<polygon style="fill:white;stroke:white;" points="569,40 569,28 719,28 719,40 569,40"/>
173
 
<text text-anchor="middle" style="font-size:6.00;" x="644" y="36">gpgkey</text>
174
 
<polygon style="fill:none;stroke:black;" points="569,40 569,28 719,28 719,40 569,40"/>
175
 
<text text-anchor="middle" style="font-size:6.00;" x="574" y="49">id</text>
176
 
<text text-anchor="middle" style="font-size:6.00;" x="613" y="49">serial</text>
177
 
<text text-anchor="middle" style="font-size:6.00;" x="668" y="49"> UNIQUE PRIMARY KEY </text>
178
 
<text text-anchor="middle" style="font-size:6.00;" x="580" y="61">owner</text>
179
 
<text text-anchor="middle" style="font-size:6.00;" x="615" y="61">integer</text>
180
 
<text text-anchor="middle" style="font-size:6.00;" x="675" y="61"> REFERENCES person UNIQUE </text>
181
 
<text text-anchor="middle" style="font-size:6.00;" x="579" y="73">keyid</text>
182
 
<text text-anchor="middle" style="font-size:6.00;" x="612" y="73">text</text>
183
 
<text text-anchor="middle" style="font-size:6.00;" x="585" y="85">fingerprint</text>
184
 
<text text-anchor="middle" style="font-size:6.00;" x="612" y="85">text</text>
185
 
<text text-anchor="middle" style="font-size:6.00;" x="647" y="85"> UNIQUE </text>
186
 
<text text-anchor="middle" style="font-size:6.00;" x="579" y="97">active</text>
187
 
<text text-anchor="middle" style="font-size:6.00;" x="617" y="97">boolean</text>
188
 
<text text-anchor="middle" style="font-size:6.00;" x="584" y="109">algorithm</text>
189
 
<text text-anchor="middle" style="font-size:6.00;" x="615" y="109">integer</text>
190
 
<text text-anchor="middle" style="font-size:6.00;" x="581" y="121">keysize</text>
191
 
<text text-anchor="middle" style="font-size:6.00;" x="615" y="121">integer</text>
192
 
<polygon style="fill:none;stroke:black;" points="566,127 566,25 722,25 722,127 566,127"/>
 
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"/>
193
195
</g>
194
196
<g id="edge8" class="edge"><title>gpgkey&#45;&gt;person</title>
195
 
<path style="fill:none;stroke:black;" d="M630,131C617,188 594,279 573,363"/>
196
 
<polygon style="fill:black;stroke:black;" points="576,364 571,373 570,363 576,364"/>
 
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"/>
197
199
</g>
198
200
<g id="node6" class="node"><title>ircid</title>
199
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="14,499 14,433 140,433 140,499 14,499"/>
200
 
<polygon style="fill:white;stroke:white;" points="17,448 17,436 137,436 137,448 17,448"/>
201
 
<text text-anchor="middle" style="font-size:6.00;" x="77" y="444">ircid</text>
202
 
<polygon style="fill:none;stroke:black;" points="17,448 17,436 137,436 137,448 17,448"/>
203
 
<text text-anchor="middle" style="font-size:6.00;" x="22" y="457">id</text>
204
 
<text text-anchor="middle" style="font-size:6.00;" x="58" y="457">serial</text>
205
 
<text text-anchor="middle" style="font-size:6.00;" x="98" y="457"> PRIMARY KEY </text>
206
 
<text text-anchor="middle" style="font-size:6.00;" x="28" y="469">person</text>
207
 
<text text-anchor="middle" style="font-size:6.00;" x="60" y="469">integer</text>
208
 
<text text-anchor="middle" style="font-size:6.00;" x="105" y="469"> REFERENCES person </text>
209
 
<text text-anchor="middle" style="font-size:6.00;" x="30" y="481">network</text>
210
 
<text text-anchor="middle" style="font-size:6.00;" x="57" y="481">text</text>
211
 
<text text-anchor="middle" style="font-size:6.00;" x="32" y="493">nickname</text>
212
 
<text text-anchor="middle" style="font-size:6.00;" x="57" y="493">text</text>
213
 
<polygon style="fill:none;stroke:black;" points="14,499 14,433 140,433 140,499 14,499"/>
 
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"/>
214
216
</g>
215
217
<g id="edge10" class="edge"><title>ircid&#45;&gt;person</title>
216
 
<path style="fill:none;stroke:black;" d="M148,481C217,495 323,518 406,535"/>
217
 
<polygon style="fill:black;stroke:black;" points="407,532 416,537 406,538 407,532"/>
 
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"/>
218
220
</g>
219
221
<g id="node7" class="node"><title>jabberid</title>
220
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="15,650 15,596 137,596 137,650 15,650"/>
221
 
<polygon style="fill:white;stroke:white;" points="18,611 18,599 134,599 134,611 18,611"/>
222
 
<text text-anchor="middle" style="font-size:6.00;" x="76" y="607">jabberid</text>
223
 
<polygon style="fill:none;stroke:black;" points="18,611 18,599 134,599 134,611 18,611"/>
224
 
<text text-anchor="middle" style="font-size:6.00;" x="23" y="620">id</text>
225
 
<text text-anchor="middle" style="font-size:6.00;" x="55" y="620">serial</text>
226
 
<text text-anchor="middle" style="font-size:6.00;" x="95" y="620"> PRIMARY KEY </text>
227
 
<text text-anchor="middle" style="font-size:6.00;" x="29" y="632">person</text>
228
 
<text text-anchor="middle" style="font-size:6.00;" x="57" y="632">integer</text>
229
 
<text text-anchor="middle" style="font-size:6.00;" x="102" y="632"> REFERENCES person </text>
230
 
<text text-anchor="middle" style="font-size:6.00;" x="31" y="644">jabberid</text>
231
 
<text text-anchor="middle" style="font-size:6.00;" x="54" y="644">text</text>
232
 
<text text-anchor="middle" style="font-size:6.00;" x="86" y="644"> UNIQUE </text>
233
 
<polygon style="fill:none;stroke:black;" points="15,650 15,596 137,596 137,650 15,650"/>
 
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"/>
234
236
</g>
235
237
<g id="edge12" class="edge"><title>jabberid&#45;&gt;person</title>
236
 
<path style="fill:none;stroke:black;" d="M145,613C214,603 323,588 406,576"/>
237
 
<polygon style="fill:black;stroke:black;" points="406,573 416,575 406,579 406,573"/>
 
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"/>
238
240
</g>
239
241
<g id="node8" class="node"><title>karma</title>
240
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="656,1089 656,1023 808,1023 808,1089 656,1089"/>
241
 
<polygon style="fill:white;stroke:white;" points="659,1038 659,1026 805,1026 805,1038 659,1038"/>
242
 
<text text-anchor="middle" style="font-size:6.00;" x="732" y="1034">karma</text>
243
 
<polygon style="fill:none;stroke:black;" points="659,1038 659,1026 805,1026 805,1038 659,1038"/>
244
 
<text text-anchor="middle" style="font-size:6.00;" x="664" y="1047">id</text>
245
 
<text text-anchor="middle" style="font-size:6.00;" x="703" y="1047">serial</text>
246
 
<text text-anchor="middle" style="font-size:6.00;" x="752" y="1047"> PRIMARY KEY </text>
247
 
<text text-anchor="middle" style="font-size:6.00;" x="676" y="1059">datecreated</text>
248
 
<text text-anchor="middle" style="font-size:6.00;" x="710" y="1059">timestamp</text>
249
 
<text text-anchor="middle" style="font-size:6.00;" x="670" y="1071">person</text>
250
 
<text text-anchor="middle" style="font-size:6.00;" x="705" y="1071">integer</text>
251
 
<text text-anchor="middle" style="font-size:6.00;" x="759" y="1071"> REFERENCES person </text>
252
 
<text text-anchor="middle" style="font-size:6.00;" x="670" y="1083">action</text>
253
 
<text text-anchor="middle" style="font-size:6.00;" x="705" y="1083">integer</text>
254
 
<text text-anchor="middle" style="font-size:6.00;" x="766" y="1083"> REFERENCES karmaaction </text>
255
 
<polygon style="fill:none;stroke:black;" points="656,1089 656,1023 808,1023 808,1089 656,1089"/>
 
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"/>
256
258
</g>
257
259
<g id="node9" class="node"><title>karmaaction</title>
258
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="773,1341 773,1275 881,1275 881,1341 773,1341"/>
259
 
<polygon style="fill:white;stroke:white;" points="776,1290 776,1278 878,1278 878,1290 776,1290"/>
260
 
<text text-anchor="middle" style="font-size:6.00;" x="827" y="1286">karmaaction</text>
261
 
<polygon style="fill:none;stroke:black;" points="776,1290 776,1278 878,1278 878,1290 776,1290"/>
262
 
<text text-anchor="middle" style="font-size:6.00;" x="781" y="1299">id</text>
263
 
<text text-anchor="middle" style="font-size:6.00;" x="814" y="1299">serial</text>
264
 
<text text-anchor="middle" style="font-size:6.00;" x="854" y="1299"> PRIMARY KEY </text>
265
 
<text text-anchor="middle" style="font-size:6.00;" x="786" y="1311">name</text>
266
 
<text text-anchor="middle" style="font-size:6.00;" x="816" y="1311">integer</text>
267
 
<text text-anchor="middle" style="font-size:6.00;" x="845" y="1311"> UNIQUE </text>
268
 
<text text-anchor="middle" style="font-size:6.00;" x="790" y="1323">category</text>
269
 
<text text-anchor="middle" style="font-size:6.00;" x="816" y="1323">integer</text>
270
 
<text text-anchor="middle" style="font-size:6.00;" x="787" y="1335">points</text>
271
 
<text text-anchor="middle" style="font-size:6.00;" x="816" y="1335">integer</text>
272
 
<polygon style="fill:none;stroke:black;" points="773,1341 773,1275 881,1275 881,1341 773,1341"/>
 
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"/>
273
280
</g>
274
281
<g id="edge16" class="edge"><title>karma&#45;&gt;karmaaction</title>
275
 
<path style="fill:none;stroke:black;" d="M746,1093C763,1138 791,1213 809,1262"/>
276
 
<polygon style="fill:black;stroke:black;" points="812,1260 813,1271 806,1263 812,1260"/>
 
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"/>
277
284
</g>
278
285
<g id="edge14" class="edge"><title>karma&#45;&gt;person</title>
279
 
<path style="fill:none;stroke:black;" d="M716,1019C693,963 648,854 607,756"/>
280
 
<polygon style="fill:black;stroke:black;" points="604,758 603,747 610,755 604,758"/>
 
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"/>
 
288
</g>
 
289
<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"/>
 
304
</g>
 
305
<g id="edge18" class="edge"><title>karmaaction&#45;&gt;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"/>
281
308
</g>
282
309
<g id="node10" class="node"><title>karmacache</title>
283
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="446,1064 446,998 600,998 600,1064 446,1064"/>
284
 
<polygon style="fill:white;stroke:white;" points="449,1013 449,1001 597,1001 597,1013 449,1013"/>
285
 
<text text-anchor="middle" style="font-size:6.00;" x="523" y="1009">karmacache</text>
286
 
<polygon style="fill:none;stroke:black;" points="449,1013 449,1001 597,1001 597,1013 449,1013"/>
287
 
<text text-anchor="middle" style="font-size:6.00;" x="454" y="1022">id</text>
288
 
<text text-anchor="middle" style="font-size:6.00;" x="494" y="1022">serial</text>
289
 
<text text-anchor="middle" style="font-size:6.00;" x="534" y="1022"> PRIMARY KEY </text>
290
 
<text text-anchor="middle" style="font-size:6.00;" x="460" y="1034">person</text>
291
 
<text text-anchor="middle" style="font-size:6.00;" x="496" y="1034">integer</text>
292
 
<text text-anchor="middle" style="font-size:6.00;" x="553" y="1034"> UNIQUE REFERENCES person </text>
293
 
<text text-anchor="middle" style="font-size:6.00;" x="463" y="1046">category</text>
294
 
<text text-anchor="middle" style="font-size:6.00;" x="496" y="1046">integer</text>
295
 
<text text-anchor="middle" style="font-size:6.00;" x="525" y="1046"> UNIQUE </text>
296
 
<text text-anchor="middle" style="font-size:6.00;" x="466" y="1058">karmavalue</text>
297
 
<text text-anchor="middle" style="font-size:6.00;" x="496" y="1058">integer</text>
298
 
<polygon style="fill:none;stroke:black;" points="446,1064 446,998 600,998 600,1064 446,1064"/>
299
 
</g>
300
 
<g id="edge18" class="edge"><title>karmacache&#45;&gt;person</title>
301
 
<path style="fill:none;stroke:black;" d="M523,994C523,942 524,846 524,757"/>
302
 
<polygon style="fill:black;stroke:black;" points="521,757 524,747 528,757 521,757"/>
303
 
</g>
304
 
<g id="node11" class="node"><title>language</title>
305
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="862,355 862,253 992,253 992,355 862,355"/>
306
 
<polygon style="fill:white;stroke:white;" points="865,268 865,256 989,256 989,268 865,268"/>
307
 
<text text-anchor="middle" style="font-size:6.00;" x="927" y="264">language</text>
308
 
<polygon style="fill:none;stroke:black;" points="865,268 865,256 989,256 989,268 865,268"/>
309
 
<text text-anchor="middle" style="font-size:6.00;" x="870" y="277">id</text>
310
 
<text text-anchor="middle" style="font-size:6.00;" x="922" y="277">serial</text>
311
 
<text text-anchor="middle" style="font-size:6.00;" x="965" y="277"> PRIMARY KEY </text>
312
 
<text text-anchor="middle" style="font-size:6.00;" x="874" y="289">code</text>
313
 
<text text-anchor="middle" style="font-size:6.00;" x="921" y="289">text</text>
314
 
<text text-anchor="middle" style="font-size:6.00;" x="956" y="289"> UNIQUE </text>
315
 
<text text-anchor="middle" style="font-size:6.00;" x="883" y="301">englishname</text>
316
 
<text text-anchor="middle" style="font-size:6.00;" x="921" y="301">text</text>
317
 
<text text-anchor="middle" style="font-size:6.00;" x="882" y="313">nativename</text>
318
 
<text text-anchor="middle" style="font-size:6.00;" x="921" y="313">text</text>
319
 
<text text-anchor="middle" style="font-size:6.00;" x="882" y="325">pluralforms</text>
320
 
<text text-anchor="middle" style="font-size:6.00;" x="924" y="325">integer</text>
321
 
<text text-anchor="middle" style="font-size:6.00;" x="888" y="337">pluralexpression</text>
322
 
<text text-anchor="middle" style="font-size:6.00;" x="921" y="337">text</text>
323
 
<text text-anchor="middle" style="font-size:6.00;" x="876" y="349">visible</text>
324
 
<text text-anchor="middle" style="font-size:6.00;" x="926" y="349">boolean</text>
325
 
<polygon style="fill:none;stroke:black;" points="862,355 862,253 992,253 992,355 862,355"/>
326
 
</g>
327
 
<g id="node12" class="node"><title>logintoken</title>
328
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="30,360 30,246 176,246 176,360 30,360"/>
329
 
<polygon style="fill:white;stroke:white;" points="33,261 33,249 173,249 173,261 33,261"/>
330
 
<text text-anchor="middle" style="font-size:6.00;" x="103" y="257">logintoken</text>
331
 
<polygon style="fill:none;stroke:black;" points="33,261 33,249 173,249 173,261 33,261"/>
332
 
<text text-anchor="middle" style="font-size:6.00;" x="38" y="270">id</text>
333
 
<text text-anchor="middle" style="font-size:6.00;" x="85" y="270">serial</text>
334
 
<text text-anchor="middle" style="font-size:6.00;" x="47" y="282">requester</text>
335
 
<text text-anchor="middle" style="font-size:6.00;" x="87" y="282">integer</text>
336
 
<text text-anchor="middle" style="font-size:6.00;" x="141" y="282"> REFERENCES person </text>
337
 
<text text-anchor="middle" style="font-size:6.00;" x="54" y="294">requesteremail</text>
338
 
<text text-anchor="middle" style="font-size:6.00;" x="84" y="294">text</text>
339
 
<text text-anchor="middle" style="font-size:6.00;" x="43" y="306">email</text>
340
 
<text text-anchor="middle" style="font-size:6.00;" x="84" y="306">text</text>
341
 
<text text-anchor="middle" style="font-size:6.00;" x="45" y="318">created</text>
342
 
<text text-anchor="middle" style="font-size:6.00;" x="92" y="318">timestamp</text>
343
 
<text text-anchor="middle" style="font-size:6.00;" x="48" y="330">tokentype</text>
344
 
<text text-anchor="middle" style="font-size:6.00;" x="87" y="330">integer</text>
345
 
<text text-anchor="middle" style="font-size:6.00;" x="43" y="342">token</text>
346
 
<text text-anchor="middle" style="font-size:6.00;" x="84" y="342">text</text>
347
 
<text text-anchor="middle" style="font-size:6.00;" x="125" y="342"> UNIQUE </text>
348
 
<text text-anchor="middle" style="font-size:6.00;" x="49" y="354">fingerprint</text>
349
 
<text text-anchor="middle" style="font-size:6.00;" x="84" y="354">text</text>
350
 
<polygon style="fill:none;stroke:black;" points="30,360 30,246 176,246 176,360 30,360"/>
351
 
</g>
352
 
<g id="edge20" class="edge"><title>logintoken&#45;&gt;person</title>
353
 
<path style="fill:none;stroke:black;" d="M184,353C247,391 337,446 407,489"/>
354
 
<polygon style="fill:black;stroke:black;" points="409,486 416,494 406,492 409,486"/>
355
 
</g>
356
 
<g id="edge28" class="edge"><title>person&#45;&gt;calendar</title>
357
 
<path style="fill:none;stroke:black;" d="M634,584C730,605 867,636 949,654"/>
358
 
<polygon style="fill:black;stroke:black;" points="950,651 959,656 949,657 950,651"/>
359
 
</g>
360
 
<g id="edge30" class="edge"><title>person&#45;&gt;country</title>
361
 
<path style="fill:none;stroke:black;" d="M416,677C362,735 300,802 256,849"/>
362
 
<polygon style="fill:black;stroke:black;" points="259,851 249,856 254,846 259,851"/>
363
 
</g>
364
 
<g id="edge24" class="edge"><title>person&#45;&gt;language</title>
365
 
<path style="fill:none;stroke:black;" d="M634,491C701,448 784,395 845,356"/>
366
 
<polygon style="fill:black;stroke:black;" points="844,353 854,351 847,359 844,353"/>
367
 
</g>
368
 
<g id="edge22" class="edge"><title>person&#45;&gt;person</title>
369
 
<path style="fill:none;stroke:black;" d="M634,617C645,605 652,587 652,560 652,538 648,523 640,511"/>
370
 
<polygon style="fill:black;stroke:black;" points="637,513 634,503 643,509 637,513"/>
371
 
</g>
372
 
<g id="edge26" class="edge"><title>person&#45;&gt;person</title>
373
 
<path style="fill:none;stroke:black;" d="M634,693C655,677 670,633 670,560 670,496 658,454 641,434"/>
374
 
<polygon style="fill:black;stroke:black;" points="639,437 634,427 644,432 639,437"/>
375
 
</g>
376
 
<g id="node35" class="node"><title>fake_libraryfilealias_172</title>
377
 
<ellipse cx="388" cy="230" rx="29" ry="18" style="fill:none;stroke:red;"/>
378
 
<text text-anchor="middle" style="font-size:6.00;" x="388" y="232">libraryfilealias</text>
379
 
</g>
380
 
<g id="edge32" class="edge"><title>person&#45;&gt;fake_libraryfilealias_172</title>
381
 
<path style="fill:none;stroke:black;" d="M447,373C428,327 411,284 399,257"/>
382
 
<polygon style="fill:black;stroke:black;" points="396,259 395,248 402,256 396,259"/>
383
 
</g>
384
 
<g id="node37" class="node"><title>fake_libraryfilealias_174</title>
385
 
<ellipse cx="733" cy="632" rx="29" ry="18" style="fill:none;stroke:red;"/>
386
 
<text text-anchor="middle" style="font-size:6.00;" x="733" y="634">libraryfilealias</text>
387
 
</g>
388
 
<g id="edge34" class="edge"><title>person&#45;&gt;fake_libraryfilealias_174</title>
389
 
<path style="fill:none;stroke:black;" d="M634,598C657,606 679,614 697,620"/>
390
 
<polygon style="fill:black;stroke:black;" points="698,617 707,623 696,623 698,617"/>
391
 
</g>
392
 
<g id="node14" class="node"><title>personlanguage</title>
393
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="912,464 912,410 1066,410 1066,464 912,464"/>
394
 
<polygon style="fill:white;stroke:white;" points="915,425 915,413 1063,413 1063,425 915,425"/>
395
 
<text text-anchor="middle" style="font-size:6.00;" x="989" y="421">personlanguage</text>
396
 
<polygon style="fill:none;stroke:black;" points="915,425 915,413 1063,413 1063,425 915,425"/>
397
 
<text text-anchor="middle" style="font-size:6.00;" x="920" y="434">id</text>
398
 
<text text-anchor="middle" style="font-size:6.00;" x="954" y="434">serial</text>
399
 
<text text-anchor="middle" style="font-size:6.00;" x="994" y="434"> PRIMARY KEY </text>
400
 
<text text-anchor="middle" style="font-size:6.00;" x="926" y="446">person</text>
401
 
<text text-anchor="middle" style="font-size:6.00;" x="956" y="446">integer</text>
402
 
<text text-anchor="middle" style="font-size:6.00;" x="1013" y="446"> REFERENCES person UNIQUE </text>
403
 
<text text-anchor="middle" style="font-size:6.00;" x="929" y="458">language</text>
404
 
<text text-anchor="middle" style="font-size:6.00;" x="956" y="458">integer</text>
405
 
<text text-anchor="middle" style="font-size:6.00;" x="1016" y="458"> REFERENCES language UNIQUE </text>
406
 
<polygon style="fill:none;stroke:black;" points="912,464 912,410 1066,410 1066,464 912,464"/>
407
 
</g>
408
 
<g id="edge38" class="edge"><title>personlanguage&#45;&gt;language</title>
409
 
<path style="fill:none;stroke:black;" d="M974,406C969,395 963,381 956,368"/>
410
 
<polygon style="fill:black;stroke:black;" points="953,370 952,359 959,367 953,370"/>
411
 
</g>
412
 
<g id="edge36" class="edge"><title>personlanguage&#45;&gt;person</title>
413
 
<path style="fill:none;stroke:black;" d="M904,460C831,479 726,507 644,528"/>
414
 
<polygon style="fill:black;stroke:black;" points="645,531 634,531 643,525 645,531"/>
415
 
</g>
416
 
<g id="node15" class="node"><title>signedcodeofconduct</title>
417
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="757,197 757,83 965,83 965,197 757,197"/>
418
 
<polygon style="fill:white;stroke:white;" points="760,98 760,86 962,86 962,98 760,98"/>
419
 
<text text-anchor="middle" style="font-size:6.00;" x="861" y="94">signedcodeofconduct</text>
420
 
<polygon style="fill:none;stroke:black;" points="760,98 760,86 962,86 962,98 760,98"/>
421
 
<text text-anchor="middle" style="font-size:6.00;" x="765" y="107">id</text>
422
 
<text text-anchor="middle" style="font-size:6.00;" x="815" y="107">serial</text>
423
 
<text text-anchor="middle" style="font-size:6.00;" x="771" y="119">owner</text>
424
 
<text text-anchor="middle" style="font-size:6.00;" x="817" y="119">integer</text>
425
 
<text text-anchor="middle" style="font-size:6.00;" x="901" y="119"> REFERENCES person REFERENCES gpgkey </text>
426
 
<text text-anchor="middle" style="font-size:6.00;" x="776" y="131">signingkey</text>
427
 
<text text-anchor="middle" style="font-size:6.00;" x="817" y="131">integer</text>
428
 
<text text-anchor="middle" style="font-size:6.00;" x="872" y="131"> REFERENCES gpgkey </text>
429
 
<text text-anchor="middle" style="font-size:6.00;" x="777" y="143">datecreated</text>
430
 
<text text-anchor="middle" style="font-size:6.00;" x="822" y="143">timestamp</text>
431
 
<text text-anchor="middle" style="font-size:6.00;" x="776" y="155">signedcode</text>
432
 
<text text-anchor="middle" style="font-size:6.00;" x="814" y="155">text</text>
433
 
<text text-anchor="middle" style="font-size:6.00;" x="774" y="167">recipient</text>
434
 
<text text-anchor="middle" style="font-size:6.00;" x="817" y="167">integer</text>
435
 
<text text-anchor="middle" style="font-size:6.00;" x="770" y="179">active</text>
436
 
<text text-anchor="middle" style="font-size:6.00;" x="819" y="179">boolean</text>
437
 
<text text-anchor="middle" style="font-size:6.00;" x="782" y="191">admincomment</text>
438
 
<text text-anchor="middle" style="font-size:6.00;" x="814" y="191">text</text>
439
 
<polygon style="fill:none;stroke:black;" points="757,197 757,83 965,83 965,197 757,197"/>
440
 
</g>
441
 
<g id="edge42" class="edge"><title>signedcodeofconduct&#45;&gt;gpgkey</title>
442
 
<path style="fill:none;stroke:black;" d="M749,107C746,106 743,105 740,104"/>
443
 
<polygon style="fill:black;stroke:black;" points="739,107 730,101 741,101 739,107"/>
444
 
</g>
445
 
<g id="edge40" class="edge"><title>signedcodeofconduct&#45;&gt;person</title>
446
 
<path style="fill:none;stroke:black;" d="M812,201C768,257 699,343 640,415"/>
447
 
<polygon style="fill:black;stroke:black;" points="643,417 634,423 637,413 643,417"/>
448
 
</g>
449
 
<g id="node16" class="node"><title>sshkey</title>
450
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="813,910 813,832 937,832 937,910 813,910"/>
451
 
<polygon style="fill:white;stroke:white;" points="816,847 816,835 934,835 934,847 816,847"/>
452
 
<text text-anchor="middle" style="font-size:6.00;" x="875" y="843">sshkey</text>
453
 
<polygon style="fill:none;stroke:black;" points="816,847 816,835 934,835 934,847 816,847"/>
454
 
<text text-anchor="middle" style="font-size:6.00;" x="821" y="856">id</text>
455
 
<text text-anchor="middle" style="font-size:6.00;" x="855" y="856">serial</text>
456
 
<text text-anchor="middle" style="font-size:6.00;" x="895" y="856"> PRIMARY KEY </text>
457
 
<text text-anchor="middle" style="font-size:6.00;" x="827" y="868">person</text>
458
 
<text text-anchor="middle" style="font-size:6.00;" x="857" y="868">integer</text>
459
 
<text text-anchor="middle" style="font-size:6.00;" x="902" y="868"> REFERENCES person </text>
460
 
<text text-anchor="middle" style="font-size:6.00;" x="829" y="880">keytype</text>
461
 
<text text-anchor="middle" style="font-size:6.00;" x="857" y="880">integer</text>
462
 
<text text-anchor="middle" style="font-size:6.00;" x="828" y="892">keytext</text>
463
 
<text text-anchor="middle" style="font-size:6.00;" x="854" y="892">text</text>
464
 
<text text-anchor="middle" style="font-size:6.00;" x="830" y="904">comment</text>
465
 
<text text-anchor="middle" style="font-size:6.00;" x="854" y="904">text</text>
466
 
<polygon style="fill:none;stroke:black;" points="813,910 813,832 937,832 937,910 813,910"/>
467
 
</g>
468
 
<g id="edge44" class="edge"><title>sshkey&#45;&gt;person</title>
469
 
<path style="fill:none;stroke:black;" d="M826,828C779,786 705,719 642,664"/>
470
 
<polygon style="fill:black;stroke:black;" points="639,666 634,657 644,661 639,666"/>
471
 
</g>
472
 
<g id="node17" class="node"><title>teammembership</title>
473
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="231,1095 231,981 409,981 409,1095 231,1095"/>
474
 
<polygon style="fill:white;stroke:white;" points="234,996 234,984 406,984 406,996 234,996"/>
475
 
<text text-anchor="middle" style="font-size:6.00;" x="320" y="992">teammembership</text>
476
 
<polygon style="fill:none;stroke:black;" points="234,996 234,984 406,984 406,996 234,996"/>
477
 
<text text-anchor="middle" style="font-size:6.00;" x="239" y="1005">id</text>
478
 
<text text-anchor="middle" style="font-size:6.00;" x="294" y="1005">serial</text>
479
 
<text text-anchor="middle" style="font-size:6.00;" x="343" y="1005"> PRIMARY KEY </text>
480
 
<text text-anchor="middle" style="font-size:6.00;" x="245" y="1017">person</text>
481
 
<text text-anchor="middle" style="font-size:6.00;" x="296" y="1017">integer</text>
482
 
<text text-anchor="middle" style="font-size:6.00;" x="362" y="1017"> REFERENCES person UNIQUE </text>
483
 
<text text-anchor="middle" style="font-size:6.00;" x="243" y="1029">team</text>
484
 
<text text-anchor="middle" style="font-size:6.00;" x="296" y="1029">integer</text>
485
 
<text text-anchor="middle" style="font-size:6.00;" x="362" y="1029"> REFERENCES person UNIQUE </text>
486
 
<text text-anchor="middle" style="font-size:6.00;" x="244" y="1041">status</text>
487
 
<text text-anchor="middle" style="font-size:6.00;" x="296" y="1041">integer</text>
488
 
<text text-anchor="middle" style="font-size:6.00;" x="250" y="1053">datejoined</text>
489
 
<text text-anchor="middle" style="font-size:6.00;" x="301" y="1053">timestamp</text>
490
 
<text text-anchor="middle" style="font-size:6.00;" x="251" y="1065">dateexpires</text>
491
 
<text text-anchor="middle" style="font-size:6.00;" x="301" y="1065">timestamp</text>
492
 
<text text-anchor="middle" style="font-size:6.00;" x="247" y="1077">reviewer</text>
493
 
<text text-anchor="middle" style="font-size:6.00;" x="296" y="1077">integer</text>
494
 
<text text-anchor="middle" style="font-size:6.00;" x="350" y="1077"> REFERENCES person </text>
495
 
<text text-anchor="middle" style="font-size:6.00;" x="258" y="1089">reviewercomment</text>
496
 
<text text-anchor="middle" style="font-size:6.00;" x="293" y="1089">text</text>
497
 
<polygon style="fill:none;stroke:black;" points="231,1095 231,981 409,981 409,1095 231,1095"/>
498
 
</g>
499
 
<g id="edge46" class="edge"><title>teammembership&#45;&gt;person</title>
500
 
<path style="fill:none;stroke:black;" d="M336,977C356,921 391,836 426,757"/>
501
 
<polygon style="fill:black;stroke:black;" points="423,755 430,747 430,758 423,755"/>
 
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&#45;&gt;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&#45;&gt;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&#45;&gt;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&#45;&gt;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&#45;&gt;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&#45;&gt;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"/>
 
400
</g>
 
401
<g id="edge28" class="edge"><title>person&#45;&gt;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&#45;&gt;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&#45;&gt;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&#45;&gt;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&#45;&gt;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&#45;&gt;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&#45;&gt;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&#45;&gt;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"/>
502
527
</g>
503
528
<g id="edge48" class="edge"><title>teammembership&#45;&gt;person</title>
504
 
<path style="fill:none;stroke:black;" d="M356,977C383,921 421,836 454,757"/>
505
 
<polygon style="fill:black;stroke:black;" points="451,755 458,747 458,758 451,755"/>
 
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"/>
506
531
</g>
507
532
<g id="edge50" class="edge"><title>teammembership&#45;&gt;person</title>
508
 
<path style="fill:none;stroke:black;" d="M346,977C369,921 406,836 440,757"/>
509
 
<polygon style="fill:black;stroke:black;" points="437,755 444,747 444,758 437,755"/>
510
 
</g>
511
 
<g id="node18" class="node"><title>teamparticipation</title>
512
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="164,209 164,155 306,155 306,209 164,209"/>
513
 
<polygon style="fill:white;stroke:white;" points="167,170 167,158 303,158 303,170 167,170"/>
514
 
<text text-anchor="middle" style="font-size:6.00;" x="235" y="166">teamparticipation</text>
515
 
<polygon style="fill:none;stroke:black;" points="167,170 167,158 303,158 303,170 167,170"/>
516
 
<text text-anchor="middle" style="font-size:6.00;" x="172" y="179">id</text>
517
 
<text text-anchor="middle" style="font-size:6.00;" x="200" y="179">serial</text>
518
 
<text text-anchor="middle" style="font-size:6.00;" x="240" y="179"> PRIMARY KEY </text>
519
 
<text text-anchor="middle" style="font-size:6.00;" x="176" y="191">team</text>
520
 
<text text-anchor="middle" style="font-size:6.00;" x="202" y="191">integer</text>
521
 
<text text-anchor="middle" style="font-size:6.00;" x="259" y="191"> REFERENCES person UNIQUE </text>
522
 
<text text-anchor="middle" style="font-size:6.00;" x="178" y="203">person</text>
523
 
<text text-anchor="middle" style="font-size:6.00;" x="202" y="203">integer</text>
524
 
<text text-anchor="middle" style="font-size:6.00;" x="259" y="203"> REFERENCES person UNIQUE </text>
525
 
<polygon style="fill:none;stroke:black;" points="164,209 164,155 306,155 306,209 164,209"/>
526
 
</g>
527
 
<g id="edge52" class="edge"><title>teamparticipation&#45;&gt;person</title>
528
 
<path style="fill:none;stroke:black;" d="M264,213C298,254 356,329 410,399"/>
529
 
<polygon style="fill:black;stroke:black;" points="413,397 416,407 407,401 413,397"/>
 
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"/>
 
535
</g>
 
536
<g id="edge52" class="edge"><title>teammembership&#45;&gt;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"/>
530
555
</g>
531
556
<g id="edge54" class="edge"><title>teamparticipation&#45;&gt;person</title>
532
 
<path style="fill:none;stroke:black;" d="M254,213C286,258 351,345 410,420"/>
533
 
<polygon style="fill:black;stroke:black;" points="413,418 416,428 407,422 413,418"/>
534
 
</g>
535
 
<g id="node19" class="node"><title>wikiname</title>
536
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="52,806 52,740 178,740 178,806 52,806"/>
537
 
<polygon style="fill:white;stroke:white;" points="55,755 55,743 175,743 175,755 55,755"/>
538
 
<text text-anchor="middle" style="font-size:6.00;" x="115" y="751">wikiname</text>
539
 
<polygon style="fill:none;stroke:black;" points="55,755 55,743 175,743 175,755 55,755"/>
540
 
<text text-anchor="middle" style="font-size:6.00;" x="60" y="764">id</text>
541
 
<text text-anchor="middle" style="font-size:6.00;" x="96" y="764">serial</text>
542
 
<text text-anchor="middle" style="font-size:6.00;" x="136" y="764"> PRIMARY KEY </text>
543
 
<text text-anchor="middle" style="font-size:6.00;" x="66" y="776">person</text>
544
 
<text text-anchor="middle" style="font-size:6.00;" x="98" y="776">integer</text>
545
 
<text text-anchor="middle" style="font-size:6.00;" x="143" y="776"> REFERENCES person </text>
546
 
<text text-anchor="middle" style="font-size:6.00;" x="63" y="788">wiki</text>
547
 
<text text-anchor="middle" style="font-size:6.00;" x="95" y="788">text</text>
548
 
<text text-anchor="middle" style="font-size:6.00;" x="127" y="788"> UNIQUE </text>
549
 
<text text-anchor="middle" style="font-size:6.00;" x="70" y="800">wikiname</text>
550
 
<text text-anchor="middle" style="font-size:6.00;" x="95" y="800">text</text>
551
 
<text text-anchor="middle" style="font-size:6.00;" x="127" y="800"> UNIQUE </text>
552
 
<polygon style="fill:none;stroke:black;" points="52,806 52,740 178,740 178,806 52,806"/>
553
 
</g>
554
 
<g id="edge56" class="edge"><title>wikiname&#45;&gt;person</title>
555
 
<path style="fill:none;stroke:black;" d="M186,736C247,704 335,659 407,622"/>
556
 
<polygon style="fill:black;stroke:black;" points="406,619 416,617 409,625 406,619"/>
 
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&#45;&gt;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&#45;&gt;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"/>
557
586
</g>
558
587
</g>
559
588
</svg>