← Back to branch summary

~launchpad-pqm/launchpad/devel

« back to all changes in this revision

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

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

Show diffs side-by-side

added added

removed removed

Lines of Context:
database/schema/diagrams/misc.svg
1
1
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
2
2
<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.0//EN"
3
3
 "http://www.w3.org/TR/2001/REC-SVG-20010904/DTD/svg10.dtd">
4
 
<!-- Generated by fdp version 2.2.1 (Thu Apr 14 05:40:09 UTC 2005)
 
4
<!-- Generated by fdp version 2.2.1 (Tue Oct 11 01:38:21 UTC 2005)
5
5
     For user: (stub) Stuart Bishop,,,   Title: g    Pages: 1 -->
6
 
<svg width="667px" height="535px"
7
 
 viewBox = "-1 -1 666 534"
 
6
<svg width="756px" height="535px"
 
7
 viewBox = "-1 -1 755 534"
8
8
 xmlns="http://www.w3.org/2000/svg">
9
 
<g id="graph0" class="graph" transform = "scale(0.689065)"
 
9
<g id="graph0" class="graph" transform = "scale(0.767988)"
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="480" y="757">Misc</text>
 
12
<text text-anchor="middle" style="font-size:22.00;" x="489" y="678">Misc</text>
13
13
<g id="node1" class="node"><title>label</title>
14
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="14,475 14,397 170,397 170,475 14,475"/>
15
 
<polygon style="fill:white;stroke:white;" points="17,412 17,400 167,400 167,412 17,412"/>
16
 
<text text-anchor="middle" style="font-size:6.00;" x="92" y="408">label</text>
17
 
<polygon style="fill:none;stroke:black;" points="17,412 17,400 167,400 167,412 17,412"/>
18
 
<text text-anchor="middle" style="font-size:6.00;" x="22" y="421">id</text>
19
 
<text text-anchor="middle" style="font-size:6.00;" x="62" y="421">serial</text>
20
 
<text text-anchor="middle" style="font-size:6.00;" x="102" y="421"> PRIMARY KEY </text>
21
 
<text text-anchor="middle" style="font-size:6.00;" x="29" y="433">schema</text>
22
 
<text text-anchor="middle" style="font-size:6.00;" x="64" y="433">integer</text>
23
 
<text text-anchor="middle" style="font-size:6.00;" x="122" y="433"> REFERENCES schema UNIQUE </text>
24
 
<text text-anchor="middle" style="font-size:6.00;" x="27" y="445">name</text>
25
 
<text text-anchor="middle" style="font-size:6.00;" x="61" y="445">text</text>
26
 
<text text-anchor="middle" style="font-size:6.00;" x="93" y="445"> UNIQUE </text>
27
 
<text text-anchor="middle" style="font-size:6.00;" x="25" y="457">title</text>
28
 
<text text-anchor="middle" style="font-size:6.00;" x="61" y="457">text</text>
29
 
<text text-anchor="middle" style="font-size:6.00;" x="34" y="469">description</text>
30
 
<text text-anchor="middle" style="font-size:6.00;" x="61" y="469">text</text>
31
 
<polygon style="fill:none;stroke:black;" points="14,475 14,397 170,397 170,475 14,475"/>
32
 
</g>
33
 
<g id="node12" class="node"><title>fake_schema_130</title>
34
 
<ellipse cx="72" cy="349" rx="27" ry="18" style="fill:none;stroke:red;"/>
35
 
<text text-anchor="middle" style="font-size:6.00;" x="72" y="351">schema</text>
36
 
</g>
37
 
<g id="edge2" class="edge"><title>label&#45;&gt;fake_schema_130</title>
38
 
<path style="fill:none;stroke:black;" d="M82,393C81,388 80,382 78,377"/>
39
 
<polygon style="fill:black;stroke:black;" points="75,377 76,367 81,376 75,377"/>
 
14
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="14,498 14,420 170,420 170,498 14,498"/>
 
15
<polygon style="fill:white;stroke:white;" points="17,435 17,423 167,423 167,435 17,435"/>
 
16
<text text-anchor="middle" style="font-size:6.00;" x="92" y="431">label</text>
 
17
<polygon style="fill:none;stroke:black;" points="17,435 17,423 167,423 167,435 17,435"/>
 
18
<text text-anchor="middle" style="font-size:6.00;" x="22" y="444">id</text>
 
19
<text text-anchor="middle" style="font-size:6.00;" x="62" y="444">serial</text>
 
20
<text text-anchor="middle" style="font-size:6.00;" x="102" y="444"> PRIMARY KEY </text>
 
21
<text text-anchor="middle" style="font-size:6.00;" x="29" y="456">schema</text>
 
22
<text text-anchor="middle" style="font-size:6.00;" x="64" y="456">integer</text>
 
23
<text text-anchor="middle" style="font-size:6.00;" x="122" y="456"> REFERENCES schema UNIQUE </text>
 
24
<text text-anchor="middle" style="font-size:6.00;" x="27" y="468">name</text>
 
25
<text text-anchor="middle" style="font-size:6.00;" x="61" y="468">text</text>
 
26
<text text-anchor="middle" style="font-size:6.00;" x="93" y="468"> UNIQUE </text>
 
27
<text text-anchor="middle" style="font-size:6.00;" x="25" y="480">title</text>
 
28
<text text-anchor="middle" style="font-size:6.00;" x="61" y="480">text</text>
 
29
<text text-anchor="middle" style="font-size:6.00;" x="34" y="492">description</text>
 
30
<text text-anchor="middle" style="font-size:6.00;" x="61" y="492">text</text>
 
31
<polygon style="fill:none;stroke:black;" points="14,498 14,420 170,420 170,498 14,498"/>
 
32
</g>
 
33
<g id="node10" class="node"><title>schema</title>
 
34
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="211,393 211,303 343,303 343,393 211,393"/>
 
35
<polygon style="fill:white;stroke:white;" points="214,318 214,306 340,306 340,318 214,318"/>
 
36
<text text-anchor="middle" style="font-size:6.00;" x="277" y="314">schema</text>
 
37
<polygon style="fill:none;stroke:black;" points="214,318 214,306 340,306 340,318 214,318"/>
 
38
<text text-anchor="middle" style="font-size:6.00;" x="219" y="327">id</text>
 
39
<text text-anchor="middle" style="font-size:6.00;" x="258" y="327">serial</text>
 
40
<text text-anchor="middle" style="font-size:6.00;" x="301" y="327"> PRIMARY KEY </text>
 
41
<text text-anchor="middle" style="font-size:6.00;" x="224" y="339">name</text>
 
42
<text text-anchor="middle" style="font-size:6.00;" x="257" y="339">text</text>
 
43
<text text-anchor="middle" style="font-size:6.00;" x="222" y="351">title</text>
 
44
<text text-anchor="middle" style="font-size:6.00;" x="257" y="351">text</text>
 
45
<text text-anchor="middle" style="font-size:6.00;" x="231" y="363">description</text>
 
46
<text text-anchor="middle" style="font-size:6.00;" x="257" y="363">text</text>
 
47
<text text-anchor="middle" style="font-size:6.00;" x="225" y="375">owner</text>
 
48
<text text-anchor="middle" style="font-size:6.00;" x="260" y="375">integer</text>
 
49
<text text-anchor="middle" style="font-size:6.00;" x="308" y="375"> REFERENCES person </text>
 
50
<text text-anchor="middle" style="font-size:6.00;" x="229" y="387">extensible</text>
 
51
<text text-anchor="middle" style="font-size:6.00;" x="262" y="387">boolean</text>
 
52
<polygon style="fill:none;stroke:black;" points="211,393 211,303 343,303 343,393 211,393"/>
 
53
</g>
 
54
<g id="edge2" class="edge"><title>label&#45;&gt;schema</title>
 
55
<path style="fill:none;stroke:black;" d="M164,416C174,410 184,404 194,398"/>
 
56
<polygon style="fill:black;stroke:black;" points="193,395 203,393 196,401 193,395"/>
40
57
</g>
41
58
<g id="node2" class="node"><title>launchpaddatabaserevision</title>
42
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="194,440 194,386 296,386 296,440 194,440"/>
43
 
<polygon style="fill:white;stroke:white;" points="197,401 197,389 293,389 293,401 197,401"/>
44
 
<text text-anchor="middle" style="font-size:6.00;" x="245" y="397">launchpaddatabaserevision</text>
45
 
<polygon style="fill:none;stroke:black;" points="197,401 197,389 293,389 293,401 197,401"/>
46
 
<text text-anchor="middle" style="font-size:6.00;" x="207" y="410">major</text>
47
 
<text text-anchor="middle" style="font-size:6.00;" x="231" y="410">integer</text>
48
 
<text text-anchor="middle" style="font-size:6.00;" x="269" y="410"> PRIMARY KEY </text>
49
 
<text text-anchor="middle" style="font-size:6.00;" x="207" y="422">minor</text>
50
 
<text text-anchor="middle" style="font-size:6.00;" x="231" y="422">integer</text>
51
 
<text text-anchor="middle" style="font-size:6.00;" x="269" y="422"> PRIMARY KEY </text>
52
 
<text text-anchor="middle" style="font-size:6.00;" x="207" y="434">patch</text>
53
 
<text text-anchor="middle" style="font-size:6.00;" x="231" y="434">integer</text>
54
 
<text text-anchor="middle" style="font-size:6.00;" x="269" y="434"> PRIMARY KEY </text>
55
 
<polygon style="fill:none;stroke:black;" points="194,440 194,386 296,386 296,440 194,440"/>
 
59
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="374,145 374,91 476,91 476,145 374,145"/>
 
60
<polygon style="fill:white;stroke:white;" points="377,106 377,94 473,94 473,106 377,106"/>
 
61
<text text-anchor="middle" style="font-size:6.00;" x="425" y="102">launchpaddatabaserevision</text>
 
62
<polygon style="fill:none;stroke:black;" points="377,106 377,94 473,94 473,106 377,106"/>
 
63
<text text-anchor="middle" style="font-size:6.00;" x="387" y="115">major</text>
 
64
<text text-anchor="middle" style="font-size:6.00;" x="411" y="115">integer</text>
 
65
<text text-anchor="middle" style="font-size:6.00;" x="449" y="115"> PRIMARY KEY </text>
 
66
<text text-anchor="middle" style="font-size:6.00;" x="387" y="127">minor</text>
 
67
<text text-anchor="middle" style="font-size:6.00;" x="411" y="127">integer</text>
 
68
<text text-anchor="middle" style="font-size:6.00;" x="449" y="127"> PRIMARY KEY </text>
 
69
<text text-anchor="middle" style="font-size:6.00;" x="387" y="139">patch</text>
 
70
<text text-anchor="middle" style="font-size:6.00;" x="411" y="139">integer</text>
 
71
<text text-anchor="middle" style="font-size:6.00;" x="449" y="139"> PRIMARY KEY </text>
 
72
<polygon style="fill:none;stroke:black;" points="374,145 374,91 476,91 476,145 374,145"/>
56
73
</g>
57
74
<g id="node3" class="node"><title>launchpadstatistic</title>
58
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="158,368 158,302 284,302 284,368 158,368"/>
59
 
<polygon style="fill:white;stroke:white;" points="161,317 161,305 281,305 281,317 161,317"/>
60
 
<text text-anchor="middle" style="font-size:6.00;" x="221" y="313">launchpadstatistic</text>
61
 
<polygon style="fill:none;stroke:black;" points="161,317 161,305 281,305 281,317 161,317"/>
62
 
<text text-anchor="middle" style="font-size:6.00;" x="166" y="326">id</text>
63
 
<text text-anchor="middle" style="font-size:6.00;" x="208" y="326">serial</text>
64
 
<text text-anchor="middle" style="font-size:6.00;" x="257" y="326"> PRIMARY KEY </text>
65
 
<text text-anchor="middle" style="font-size:6.00;" x="171" y="338">name</text>
66
 
<text text-anchor="middle" style="font-size:6.00;" x="207" y="338">text</text>
67
 
<text text-anchor="middle" style="font-size:6.00;" x="248" y="338"> UNIQUE </text>
68
 
<text text-anchor="middle" style="font-size:6.00;" x="171" y="350">value</text>
69
 
<text text-anchor="middle" style="font-size:6.00;" x="210" y="350">integer</text>
70
 
<text text-anchor="middle" style="font-size:6.00;" x="179" y="362">dateupdated</text>
71
 
<text text-anchor="middle" style="font-size:6.00;" x="215" y="362">timestamp</text>
72
 
<polygon style="fill:none;stroke:black;" points="158,368 158,302 284,302 284,368 158,368"/>
 
75
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="194,289 194,223 320,223 320,289 194,289"/>
 
76
<polygon style="fill:white;stroke:white;" points="197,238 197,226 317,226 317,238 197,238"/>
 
77
<text text-anchor="middle" style="font-size:6.00;" x="257" y="234">launchpadstatistic</text>
 
78
<polygon style="fill:none;stroke:black;" points="197,238 197,226 317,226 317,238 197,238"/>
 
79
<text text-anchor="middle" style="font-size:6.00;" x="202" y="247">id</text>
 
80
<text text-anchor="middle" style="font-size:6.00;" x="244" y="247">serial</text>
 
81
<text text-anchor="middle" style="font-size:6.00;" x="293" y="247"> PRIMARY KEY </text>
 
82
<text text-anchor="middle" style="font-size:6.00;" x="207" y="259">name</text>
 
83
<text text-anchor="middle" style="font-size:6.00;" x="243" y="259">text</text>
 
84
<text text-anchor="middle" style="font-size:6.00;" x="284" y="259"> UNIQUE </text>
 
85
<text text-anchor="middle" style="font-size:6.00;" x="207" y="271">value</text>
 
86
<text text-anchor="middle" style="font-size:6.00;" x="246" y="271">integer</text>
 
87
<text text-anchor="middle" style="font-size:6.00;" x="215" y="283">dateupdated</text>
 
88
<text text-anchor="middle" style="font-size:6.00;" x="251" y="283">timestamp</text>
 
89
<polygon style="fill:none;stroke:black;" points="194,289 194,223 320,223 320,289 194,289"/>
73
90
</g>
74
91
<g id="node4" class="node"><title>libraryfilealias</title>
75
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="590,557 590,479 752,479 752,557 590,557"/>
76
 
<polygon style="fill:white;stroke:white;" points="593,494 593,482 749,482 749,494 593,494"/>
77
 
<text text-anchor="middle" style="font-size:6.00;" x="671" y="490">libraryfilealias</text>
78
 
<polygon style="fill:none;stroke:black;" points="593,494 593,482 749,482 749,494 593,494"/>
79
 
<text text-anchor="middle" style="font-size:6.00;" x="598" y="503">id</text>
80
 
<text text-anchor="middle" style="font-size:6.00;" x="635" y="503">serial</text>
81
 
<text text-anchor="middle" style="font-size:6.00;" x="684" y="503"> PRIMARY KEY </text>
82
 
<text text-anchor="middle" style="font-size:6.00;" x="605" y="515">content</text>
83
 
<text text-anchor="middle" style="font-size:6.00;" x="637" y="515">integer</text>
84
 
<text text-anchor="middle" style="font-size:6.00;" x="704" y="515"> REFERENCES libraryfilecontent </text>
85
 
<text text-anchor="middle" style="font-size:6.00;" x="607" y="527">filename</text>
86
 
<text text-anchor="middle" style="font-size:6.00;" x="634" y="527">text</text>
87
 
<text text-anchor="middle" style="font-size:6.00;" x="608" y="539">mimetype</text>
88
 
<text text-anchor="middle" style="font-size:6.00;" x="634" y="539">text</text>
89
 
<text text-anchor="middle" style="font-size:6.00;" x="605" y="551">expires</text>
90
 
<text text-anchor="middle" style="font-size:6.00;" x="642" y="551">timestamp</text>
91
 
<polygon style="fill:none;stroke:black;" points="590,557 590,479 752,479 752,557 590,557"/>
 
92
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="626,225 626,135 796,135 796,225 626,225"/>
 
93
<polygon style="fill:white;stroke:white;" points="629,150 629,138 793,138 793,150 629,150"/>
 
94
<text text-anchor="middle" style="font-size:6.00;" x="711" y="146">libraryfilealias</text>
 
95
<polygon style="fill:none;stroke:black;" points="629,150 629,138 793,138 793,150 629,150"/>
 
96
<text text-anchor="middle" style="font-size:6.00;" x="634" y="159">id</text>
 
97
<text text-anchor="middle" style="font-size:6.00;" x="679" y="159">serial</text>
 
98
<text text-anchor="middle" style="font-size:6.00;" x="728" y="159"> PRIMARY KEY </text>
 
99
<text text-anchor="middle" style="font-size:6.00;" x="641" y="171">content</text>
 
100
<text text-anchor="middle" style="font-size:6.00;" x="681" y="171">integer</text>
 
101
<text text-anchor="middle" style="font-size:6.00;" x="748" y="171"> REFERENCES libraryfilecontent </text>
 
102
<text text-anchor="middle" style="font-size:6.00;" x="643" y="183">filename</text>
 
103
<text text-anchor="middle" style="font-size:6.00;" x="678" y="183">text</text>
 
104
<text text-anchor="middle" style="font-size:6.00;" x="644" y="195">mimetype</text>
 
105
<text text-anchor="middle" style="font-size:6.00;" x="678" y="195">text</text>
 
106
<text text-anchor="middle" style="font-size:6.00;" x="641" y="207">expires</text>
 
107
<text text-anchor="middle" style="font-size:6.00;" x="686" y="207">timestamp</text>
 
108
<text text-anchor="middle" style="font-size:6.00;" x="648" y="219">last_accessed</text>
 
109
<text text-anchor="middle" style="font-size:6.00;" x="686" y="219">timestamp</text>
 
110
<polygon style="fill:none;stroke:black;" points="626,225 626,135 796,135 796,225 626,225"/>
92
111
</g>
93
112
<g id="node5" class="node"><title>libraryfilecontent</title>
94
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="786,584 786,506 920,506 920,584 786,584"/>
95
 
<polygon style="fill:white;stroke:white;" points="789,521 789,509 917,509 917,521 789,521"/>
96
 
<text text-anchor="middle" style="font-size:6.00;" x="853" y="517">libraryfilecontent</text>
97
 
<polygon style="fill:none;stroke:black;" points="789,521 789,509 917,509 917,521 789,521"/>
98
 
<text text-anchor="middle" style="font-size:6.00;" x="794" y="530">id</text>
99
 
<text text-anchor="middle" style="font-size:6.00;" x="837" y="530">serial</text>
100
 
<text text-anchor="middle" style="font-size:6.00;" x="893" y="530"> PRIMARY KEY </text>
101
 
<text text-anchor="middle" style="font-size:6.00;" x="806" y="542">datecreated</text>
102
 
<text text-anchor="middle" style="font-size:6.00;" x="844" y="542">timestamp</text>
103
 
<text text-anchor="middle" style="font-size:6.00;" x="808" y="554">datemirrored</text>
104
 
<text text-anchor="middle" style="font-size:6.00;" x="844" y="554">timestamp</text>
105
 
<text text-anchor="middle" style="font-size:6.00;" x="801" y="566">filesize</text>
106
 
<text text-anchor="middle" style="font-size:6.00;" x="839" y="566">integer</text>
107
 
<text text-anchor="middle" style="font-size:6.00;" x="797" y="578">sha1</text>
108
 
<text text-anchor="middle" style="font-size:6.00;" x="847" y="578">character(40)</text>
109
 
<polygon style="fill:none;stroke:black;" points="786,584 786,506 920,506 920,584 786,584"/>
 
113
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="831,253 831,163 965,163 965,253 831,253"/>
 
114
<polygon style="fill:white;stroke:white;" points="834,178 834,166 962,166 962,178 834,178"/>
 
115
<text text-anchor="middle" style="font-size:6.00;" x="898" y="174">libraryfilecontent</text>
 
116
<polygon style="fill:none;stroke:black;" points="834,178 834,166 962,166 962,178 834,178"/>
 
117
<text text-anchor="middle" style="font-size:6.00;" x="839" y="187">id</text>
 
118
<text text-anchor="middle" style="font-size:6.00;" x="882" y="187">serial</text>
 
119
<text text-anchor="middle" style="font-size:6.00;" x="938" y="187"> PRIMARY KEY </text>
 
120
<text text-anchor="middle" style="font-size:6.00;" x="851" y="199">datecreated</text>
 
121
<text text-anchor="middle" style="font-size:6.00;" x="889" y="199">timestamp</text>
 
122
<text text-anchor="middle" style="font-size:6.00;" x="853" y="211">datemirrored</text>
 
123
<text text-anchor="middle" style="font-size:6.00;" x="889" y="211">timestamp</text>
 
124
<text text-anchor="middle" style="font-size:6.00;" x="846" y="223">filesize</text>
 
125
<text text-anchor="middle" style="font-size:6.00;" x="884" y="223">integer</text>
 
126
<text text-anchor="middle" style="font-size:6.00;" x="842" y="235">sha1</text>
 
127
<text text-anchor="middle" style="font-size:6.00;" x="892" y="235">character(40)</text>
 
128
<text text-anchor="middle" style="font-size:6.00;" x="846" y="247">deleted</text>
 
129
<text text-anchor="middle" style="font-size:6.00;" x="886" y="247">boolean</text>
 
130
<polygon style="fill:none;stroke:black;" points="831,253 831,163 965,163 965,253 831,253"/>
110
131
</g>
111
132
<g id="edge4" class="edge"><title>libraryfilealias&#45;&gt;libraryfilecontent</title>
112
 
<path style="fill:none;stroke:black;" d="M760,531C763,531 765,532 768,532"/>
113
 
<polygon style="fill:black;stroke:black;" points="769,529 778,534 768,535 769,529"/>
114
 
</g>
115
 
<g id="node6" class="node"><title>message</title>
116
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="597,211 597,85 757,85 757,211 597,211"/>
117
 
<polygon style="fill:white;stroke:white;" points="600,100 600,88 754,88 754,100 600,100"/>
118
 
<text text-anchor="middle" style="font-size:6.00;" x="677" y="96">message</text>
119
 
<polygon style="fill:none;stroke:black;" points="600,100 600,88 754,88 754,100 600,100"/>
120
 
<text text-anchor="middle" style="font-size:6.00;" x="605" y="109">id</text>
121
 
<text text-anchor="middle" style="font-size:6.00;" x="647" y="109">serial</text>
122
 
<text text-anchor="middle" style="font-size:6.00;" x="696" y="109"> PRIMARY KEY </text>
123
 
<text text-anchor="middle" style="font-size:6.00;" x="617" y="121">datecreated</text>
124
 
<text text-anchor="middle" style="font-size:6.00;" x="654" y="121">timestamp</text>
125
 
<text text-anchor="middle" style="font-size:6.00;" x="611" y="133">subject</text>
126
 
<text text-anchor="middle" style="font-size:6.00;" x="646" y="133">text</text>
127
 
<text text-anchor="middle" style="font-size:6.00;" x="611" y="145">owner</text>
128
 
<text text-anchor="middle" style="font-size:6.00;" x="649" y="145">integer</text>
129
 
<text text-anchor="middle" style="font-size:6.00;" x="703" y="145"> REFERENCES person </text>
130
 
<text text-anchor="middle" style="font-size:6.00;" x="611" y="157">parent</text>
131
 
<text text-anchor="middle" style="font-size:6.00;" x="649" y="157">integer</text>
132
 
<text text-anchor="middle" style="font-size:6.00;" x="705" y="157"> REFERENCES message </text>
133
 
<text text-anchor="middle" style="font-size:6.00;" x="617" y="169">distribution</text>
134
 
<text text-anchor="middle" style="font-size:6.00;" x="649" y="169">integer</text>
135
 
<text text-anchor="middle" style="font-size:6.00;" x="709" y="169"> REFERENCES distribution </text>
136
 
<text text-anchor="middle" style="font-size:6.00;" x="618" y="181">rfc822msgid</text>
137
 
<text text-anchor="middle" style="font-size:6.00;" x="646" y="181">text</text>
138
 
<text text-anchor="middle" style="font-size:6.00;" x="606" y="193">fti</text>
139
 
<text text-anchor="middle" style="font-size:6.00;" x="651" y="193">tsvector</text>
140
 
<text text-anchor="middle" style="font-size:6.00;" x="607" y="205">raw</text>
141
 
<text text-anchor="middle" style="font-size:6.00;" x="649" y="205">integer</text>
142
 
<text text-anchor="middle" style="font-size:6.00;" x="713" y="205"> REFERENCES libraryfilealias </text>
143
 
<polygon style="fill:none;stroke:black;" points="597,211 597,85 757,85 757,211 597,211"/>
144
 
</g>
145
 
<g id="edge8" class="edge"><title>message&#45;&gt;message</title>
146
 
<path style="fill:none;stroke:black;" d="M765,191C776,184 783,169 783,148 783,132 779,120 772,112"/>
147
 
<polygon style="fill:black;stroke:black;" points="770,115 765,105 775,110 770,115"/>
148
 
</g>
149
 
<g id="node15" class="node"><title>fake_person_143</title>
150
 
<ellipse cx="537" cy="184" rx="27" ry="18" style="fill:none;stroke:red;"/>
151
 
<text text-anchor="middle" style="font-size:6.00;" x="537" y="186">person</text>
152
 
</g>
153
 
<g id="edge6" class="edge"><title>message&#45;&gt;fake_person_143</title>
154
 
<path style="fill:none;stroke:black;" d="M589,171C583,172 577,174 572,175"/>
155
 
<polygon style="fill:black;stroke:black;" points="573,178 562,178 571,172 573,178"/>
156
 
</g>
157
 
<g id="node18" class="node"><title>fake_distribution_146</title>
158
 
<ellipse cx="649" cy="27" rx="27" ry="18" style="fill:none;stroke:red;"/>
159
 
<text text-anchor="middle" style="font-size:6.00;" x="649" y="29">distribution</text>
160
 
</g>
161
 
<g id="edge10" class="edge"><title>message&#45;&gt;fake_distribution_146</title>
162
 
<path style="fill:none;stroke:black;" d="M661,81C659,72 657,63 655,55"/>
163
 
<polygon style="fill:black;stroke:black;" points="652,55 653,45 658,54 652,55"/>
164
 
</g>
165
 
<g id="node20" class="node"><title>fake_libraryfilealias_148</title>
166
 
<ellipse cx="725" cy="318" rx="29" ry="18" style="fill:none;stroke:red;"/>
167
 
<text text-anchor="middle" style="font-size:6.00;" x="725" y="320">libraryfilealias</text>
168
 
</g>
169
 
<g id="edge12" class="edge"><title>message&#45;&gt;fake_libraryfilealias_148</title>
170
 
<path style="fill:none;stroke:black;" d="M696,215C703,241 711,270 717,290"/>
171
 
<polygon style="fill:black;stroke:black;" points="720,289 720,300 714,291 720,289"/>
172
 
</g>
173
 
<g id="node7" class="node"><title>messagechunk</title>
174
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="793,208 793,118 947,118 947,208 793,208"/>
175
 
<polygon style="fill:white;stroke:white;" points="796,133 796,121 944,121 944,133 796,133"/>
176
 
<text text-anchor="middle" style="font-size:6.00;" x="870" y="129">messagechunk</text>
177
 
<polygon style="fill:none;stroke:black;" points="796,133 796,121 944,121 944,133 796,133"/>
178
 
<text text-anchor="middle" style="font-size:6.00;" x="801" y="142">id</text>
179
 
<text text-anchor="middle" style="font-size:6.00;" x="834" y="142">serial</text>
180
 
<text text-anchor="middle" style="font-size:6.00;" x="877" y="142"> PRIMARY KEY </text>
181
 
<text text-anchor="middle" style="font-size:6.00;" x="809" y="154">message</text>
182
 
<text text-anchor="middle" style="font-size:6.00;" x="836" y="154">integer</text>
183
 
<text text-anchor="middle" style="font-size:6.00;" x="898" y="154"> REFERENCES message UNIQUE </text>
184
 
<text text-anchor="middle" style="font-size:6.00;" x="810" y="166">sequence</text>
185
 
<text text-anchor="middle" style="font-size:6.00;" x="836" y="166">integer</text>
186
 
<text text-anchor="middle" style="font-size:6.00;" x="868" y="166"> UNIQUE </text>
187
 
<text text-anchor="middle" style="font-size:6.00;" x="808" y="178">content</text>
188
 
<text text-anchor="middle" style="font-size:6.00;" x="833" y="178">text</text>
189
 
<text text-anchor="middle" style="font-size:6.00;" x="805" y="190">blob</text>
190
 
<text text-anchor="middle" style="font-size:6.00;" x="836" y="190">integer</text>
191
 
<text text-anchor="middle" style="font-size:6.00;" x="894" y="190"> REFERENCES libraryfilealias </text>
192
 
<text text-anchor="middle" style="font-size:6.00;" x="802" y="202">fti</text>
193
 
<text text-anchor="middle" style="font-size:6.00;" x="838" y="202">tsvector</text>
194
 
<polygon style="fill:none;stroke:black;" points="793,208 793,118 947,118 947,208 793,208"/>
195
 
</g>
196
 
<g id="edge14" class="edge"><title>messagechunk&#45;&gt;message</title>
197
 
<path style="fill:none;stroke:black;" d="M785,156C782,155 778,155 775,155"/>
198
 
<polygon style="fill:black;stroke:black;" points="775,158 765,154 775,152 775,158"/>
199
 
</g>
200
 
<g id="node23" class="node"><title>fake_libraryfilealias_151</title>
201
 
<ellipse cx="870" cy="75" rx="29" ry="18" style="fill:none;stroke:red;"/>
202
 
<text text-anchor="middle" style="font-size:6.00;" x="870" y="77">libraryfilealias</text>
203
 
</g>
204
 
<g id="edge16" class="edge"><title>messagechunk&#45;&gt;fake_libraryfilealias_151</title>
205
 
<path style="fill:none;stroke:black;" d="M870,114C870,110 870,107 870,103"/>
206
 
<polygon style="fill:black;stroke:black;" points="867,103 870,93 874,103 867,103"/>
207
 
</g>
208
 
<g id="node8" class="node"><title>person</title>
209
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="344,604 344,238 546,238 546,604 344,604"/>
210
 
<polygon style="fill:white;stroke:white;" points="347,253 347,241 543,241 543,253 347,253"/>
211
 
<text text-anchor="middle" style="font-size:6.00;" x="445" y="249">person</text>
212
 
<polygon style="fill:none;stroke:black;" points="347,253 347,241 543,241 543,253 347,253"/>
213
 
<text text-anchor="middle" style="font-size:6.00;" x="352" y="262">id</text>
214
 
<text text-anchor="middle" style="font-size:6.00;" x="427" y="262">serial</text>
215
 
<text text-anchor="middle" style="font-size:6.00;" x="476" y="262"> PRIMARY KEY </text>
216
 
<text text-anchor="middle" style="font-size:6.00;" x="365" y="274">displayname</text>
217
 
<text text-anchor="middle" style="font-size:6.00;" x="426" y="274">text</text>
218
 
<text text-anchor="middle" style="font-size:6.00;" x="363" y="286">givenname</text>
219
 
<text text-anchor="middle" style="font-size:6.00;" x="426" y="286">text</text>
220
 
<text text-anchor="middle" style="font-size:6.00;" x="364" y="298">familyname</text>
221
 
<text text-anchor="middle" style="font-size:6.00;" x="426" y="298">text</text>
222
 
<text text-anchor="middle" style="font-size:6.00;" x="361" y="310">password</text>
223
 
<text text-anchor="middle" style="font-size:6.00;" x="426" y="310">text</text>
224
 
<text text-anchor="middle" style="font-size:6.00;" x="363" y="322">teamowner</text>
225
 
<text text-anchor="middle" style="font-size:6.00;" x="429" y="322">integer</text>
226
 
<text text-anchor="middle" style="font-size:6.00;" x="483" y="322"> REFERENCES person </text>
227
 
<text text-anchor="middle" style="font-size:6.00;" x="370" y="334">teamdescription</text>
228
 
<text text-anchor="middle" style="font-size:6.00;" x="426" y="334">text</text>
229
 
<text text-anchor="middle" style="font-size:6.00;" x="357" y="346">name</text>
230
 
<text text-anchor="middle" style="font-size:6.00;" x="426" y="346">text</text>
231
 
<text text-anchor="middle" style="font-size:6.00;" x="361" y="358">language</text>
232
 
<text text-anchor="middle" style="font-size:6.00;" x="429" y="358">integer</text>
233
 
<text text-anchor="middle" style="font-size:6.00;" x="486" y="358"> REFERENCES language </text>
234
 
<text text-anchor="middle" style="font-size:6.00;" x="353" y="370">fti</text>
235
 
<text text-anchor="middle" style="font-size:6.00;" x="431" y="370">tsvector</text>
236
 
<text text-anchor="middle" style="font-size:6.00;" x="381" y="382">defaultmembershipperiod</text>
237
 
<text text-anchor="middle" style="font-size:6.00;" x="429" y="382">integer</text>
238
 
<text text-anchor="middle" style="font-size:6.00;" x="376" y="394">defaultrenewalperiod</text>
239
 
<text text-anchor="middle" style="font-size:6.00;" x="429" y="394">integer</text>
240
 
<text text-anchor="middle" style="font-size:6.00;" x="372" y="406">subscriptionpolicy</text>
241
 
<text text-anchor="middle" style="font-size:6.00;" x="429" y="406">integer</text>
242
 
<text text-anchor="middle" style="font-size:6.00;" x="359" y="418">merged</text>
243
 
<text text-anchor="middle" style="font-size:6.00;" x="429" y="418">integer</text>
244
 
<text text-anchor="middle" style="font-size:6.00;" x="483" y="418"> REFERENCES person </text>
245
 
<text text-anchor="middle" style="font-size:6.00;" x="364" y="430">datecreated</text>
246
 
<text text-anchor="middle" style="font-size:6.00;" x="434" y="430">timestamp</text>
247
 
<text text-anchor="middle" style="font-size:6.00;" x="360" y="442">calendar</text>
248
 
<text text-anchor="middle" style="font-size:6.00;" x="429" y="442">integer</text>
249
 
<text text-anchor="middle" style="font-size:6.00;" x="497" y="442"> REFERENCES calendar UNIQUE </text>
250
 
<text text-anchor="middle" style="font-size:6.00;" x="361" y="454">timezone</text>
251
 
<text text-anchor="middle" style="font-size:6.00;" x="426" y="454">text</text>
252
 
<text text-anchor="middle" style="font-size:6.00;" x="358" y="466">karma</text>
253
 
<text text-anchor="middle" style="font-size:6.00;" x="429" y="466">integer</text>
254
 
<text text-anchor="middle" style="font-size:6.00;" x="365" y="478">addressline1</text>
255
 
<text text-anchor="middle" style="font-size:6.00;" x="426" y="478">text</text>
256
 
<text text-anchor="middle" style="font-size:6.00;" x="365" y="490">addressline2</text>
257
 
<text text-anchor="middle" style="font-size:6.00;" x="426" y="490">text</text>
258
 
<text text-anchor="middle" style="font-size:6.00;" x="365" y="502">organization</text>
259
 
<text text-anchor="middle" style="font-size:6.00;" x="426" y="502">text</text>
260
 
<text text-anchor="middle" style="font-size:6.00;" x="355" y="514">city</text>
261
 
<text text-anchor="middle" style="font-size:6.00;" x="426" y="514">text</text>
262
 
<text text-anchor="middle" style="font-size:6.00;" x="361" y="526">province</text>
263
 
<text text-anchor="middle" style="font-size:6.00;" x="426" y="526">text</text>
264
 
<text text-anchor="middle" style="font-size:6.00;" x="360" y="538">country</text>
265
 
<text text-anchor="middle" style="font-size:6.00;" x="429" y="538">integer</text>
266
 
<text text-anchor="middle" style="font-size:6.00;" x="485" y="538"> REFERENCES country </text>
267
 
<text text-anchor="middle" style="font-size:6.00;" x="361" y="550">postcode</text>
268
 
<text text-anchor="middle" style="font-size:6.00;" x="426" y="550">text</text>
269
 
<text text-anchor="middle" style="font-size:6.00;" x="358" y="562">phone</text>
270
 
<text text-anchor="middle" style="font-size:6.00;" x="426" y="562">text</text>
271
 
<text text-anchor="middle" style="font-size:6.00;" x="373" y="574">homepage_content</text>
272
 
<text text-anchor="middle" style="font-size:6.00;" x="426" y="574">text</text>
273
 
<text text-anchor="middle" style="font-size:6.00;" x="360" y="586">emblem</text>
274
 
<text text-anchor="middle" style="font-size:6.00;" x="429" y="586">integer</text>
275
 
<text text-anchor="middle" style="font-size:6.00;" x="493" y="586"> REFERENCES libraryfilealias </text>
276
 
<text text-anchor="middle" style="font-size:6.00;" x="366" y="598">hackergotchi</text>
277
 
<text text-anchor="middle" style="font-size:6.00;" x="429" y="598">integer</text>
278
 
<text text-anchor="middle" style="font-size:6.00;" x="493" y="598"> REFERENCES libraryfilealias </text>
279
 
<polygon style="fill:none;stroke:black;" points="344,604 344,238 546,238 546,604 344,604"/>
280
 
</g>
281
 
<g id="edge22" class="edge"><title>person&#45;&gt;person</title>
282
 
<path style="fill:none;stroke:black;" d="M554,478C565,466 572,448 572,421 572,399 568,384 560,372"/>
283
 
<polygon style="fill:black;stroke:black;" points="557,374 554,364 563,370 557,374"/>
284
 
</g>
285
 
<g id="edge18" class="edge"><title>person&#45;&gt;person</title>
286
 
<path style="fill:none;stroke:black;" d="M554,554C575,538 590,494 590,421 590,357 578,315 561,295"/>
287
 
<polygon style="fill:black;stroke:black;" points="559,298 554,288 564,293 559,298"/>
288
 
</g>
289
 
<g id="node26" class="node"><title>fake_language_173</title>
290
 
<ellipse cx="638" cy="627" rx="27" ry="18" style="fill:none;stroke:red;"/>
291
 
<text text-anchor="middle" style="font-size:6.00;" x="638" y="629">language</text>
292
 
</g>
293
 
<g id="edge20" class="edge"><title>person&#45;&gt;fake_language_173</title>
294
 
<path style="fill:none;stroke:black;" d="M554,538C578,563 601,588 617,605"/>
295
 
<polygon style="fill:black;stroke:black;" points="619,602 624,612 614,607 619,602"/>
296
 
</g>
297
 
<g id="node29" class="node"><title>fake_calendar_176</title>
298
 
<ellipse cx="597" cy="355" rx="27" ry="18" style="fill:none;stroke:red;"/>
299
 
<text text-anchor="middle" style="font-size:6.00;" x="597" y="357">calendar</text>
300
 
</g>
301
 
<g id="edge24" class="edge"><title>person&#45;&gt;fake_calendar_176</title>
302
 
<path style="fill:none;stroke:black;" d="M554,374C558,372 561,371 565,369"/>
303
 
<polygon style="fill:black;stroke:black;" points="563,366 574,365 566,372 563,366"/>
304
 
</g>
305
 
<g id="node31" class="node"><title>fake_country_178</title>
306
 
<ellipse cx="287" cy="175" rx="27" ry="18" style="fill:none;stroke:red;"/>
307
 
<text text-anchor="middle" style="font-size:6.00;" x="287" y="177">country</text>
308
 
</g>
309
 
<g id="edge26" class="edge"><title>person&#45;&gt;fake_country_178</title>
310
 
<path style="fill:none;stroke:black;" d="M336,251C324,231 312,214 304,201"/>
311
 
<polygon style="fill:black;stroke:black;" points="301,202 298,192 306,198 301,202"/>
312
 
</g>
313
 
<g id="node33" class="node"><title>fake_libraryfilealias_180</title>
314
 
<ellipse cx="385" cy="714" rx="29" ry="18" style="fill:none;stroke:red;"/>
315
 
<text text-anchor="middle" style="font-size:6.00;" x="385" y="716">libraryfilealias</text>
316
 
</g>
317
 
<g id="edge28" class="edge"><title>person&#45;&gt;fake_libraryfilealias_180</title>
318
 
<path style="fill:none;stroke:black;" d="M407,608C400,638 395,667 391,686"/>
319
 
<polygon style="fill:black;stroke:black;" points="394,687 389,696 388,686 394,687"/>
320
 
</g>
321
 
<g id="node35" class="node"><title>fake_libraryfilealias_182</title>
322
 
<ellipse cx="496" cy="133" rx="29" ry="18" style="fill:none;stroke:red;"/>
323
 
<text text-anchor="middle" style="font-size:6.00;" x="496" y="135">libraryfilealias</text>
324
 
</g>
325
 
<g id="edge30" class="edge"><title>person&#45;&gt;fake_libraryfilealias_182</title>
326
 
<path style="fill:none;stroke:black;" d="M478,234C483,205 488,180 491,161"/>
327
 
<polygon style="fill:black;stroke:black;" points="488,160 493,151 494,161 488,160"/>
328
 
</g>
329
 
<g id="node9" class="node"><title>personlabel</title>
330
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="193,561 193,519 311,519 311,561 193,561"/>
331
 
<polygon style="fill:white;stroke:white;" points="196,534 196,522 308,522 308,534 196,534"/>
332
 
<text text-anchor="middle" style="font-size:6.00;" x="252" y="530">personlabel</text>
333
 
<polygon style="fill:none;stroke:black;" points="196,534 196,522 308,522 308,534 196,534"/>
334
 
<text text-anchor="middle" style="font-size:6.00;" x="207" y="543">person</text>
335
 
<text text-anchor="middle" style="font-size:6.00;" x="231" y="543">integer</text>
336
 
<text text-anchor="middle" style="font-size:6.00;" x="276" y="543"> REFERENCES person </text>
337
 
<text text-anchor="middle" style="font-size:6.00;" x="205" y="555">label</text>
338
 
<text text-anchor="middle" style="font-size:6.00;" x="231" y="555">integer</text>
339
 
<text text-anchor="middle" style="font-size:6.00;" x="274" y="555"> REFERENCES label </text>
340
 
<polygon style="fill:none;stroke:black;" points="193,561 193,519 311,519 311,561 193,561"/>
341
 
</g>
342
 
<g id="edge34" class="edge"><title>personlabel&#45;&gt;label</title>
343
 
<path style="fill:none;stroke:black;" d="M213,515C199,506 183,495 167,484"/>
344
 
<polygon style="fill:black;stroke:black;" points="165,487 158,479 168,481 165,487"/>
345
 
</g>
346
 
<g id="edge32" class="edge"><title>personlabel&#45;&gt;person</title>
347
 
<path style="fill:none;stroke:black;" d="M293,515C303,509 315,501 327,494"/>
348
 
<polygon style="fill:black;stroke:black;" points="326,491 336,489 329,497 326,491"/>
349
 
</g>
350
 
<g id="node10" class="node"><title>processor</title>
351
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="122,97 122,19 274,19 274,97 122,97"/>
352
 
<polygon style="fill:white;stroke:white;" points="125,34 125,22 271,22 271,34 125,34"/>
353
 
<text text-anchor="middle" style="font-size:6.00;" x="198" y="30">processor</text>
354
 
<polygon style="fill:none;stroke:black;" points="125,34 125,22 271,22 271,34 125,34"/>
355
 
<text text-anchor="middle" style="font-size:6.00;" x="130" y="43">id</text>
356
 
<text text-anchor="middle" style="font-size:6.00;" x="170" y="43">serial</text>
357
 
<text text-anchor="middle" style="font-size:6.00;" x="210" y="43"> PRIMARY KEY </text>
358
 
<text text-anchor="middle" style="font-size:6.00;" x="136" y="55">family</text>
359
 
<text text-anchor="middle" style="font-size:6.00;" x="172" y="55">integer</text>
360
 
<text text-anchor="middle" style="font-size:6.00;" x="228" y="55"> REFERENCES processorfamily </text>
361
 
<text text-anchor="middle" style="font-size:6.00;" x="135" y="67">name</text>
362
 
<text text-anchor="middle" style="font-size:6.00;" x="169" y="67">text</text>
363
 
<text text-anchor="middle" style="font-size:6.00;" x="201" y="67"> UNIQUE </text>
364
 
<text text-anchor="middle" style="font-size:6.00;" x="133" y="79">title</text>
365
 
<text text-anchor="middle" style="font-size:6.00;" x="169" y="79">text</text>
366
 
<text text-anchor="middle" style="font-size:6.00;" x="142" y="91">description</text>
367
 
<text text-anchor="middle" style="font-size:6.00;" x="169" y="91">text</text>
368
 
<polygon style="fill:none;stroke:black;" points="122,97 122,19 274,19 274,97 122,97"/>
369
 
</g>
370
 
<g id="node11" class="node"><title>processorfamily</title>
371
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="308,116 308,50 418,50 418,116 308,116"/>
372
 
<polygon style="fill:white;stroke:white;" points="311,65 311,53 415,53 415,65 311,65"/>
373
 
<text text-anchor="middle" style="font-size:6.00;" x="363" y="61">processorfamily</text>
374
 
<polygon style="fill:none;stroke:black;" points="311,65 311,53 415,53 415,65 311,65"/>
375
 
<text text-anchor="middle" style="font-size:6.00;" x="316" y="74">id</text>
376
 
<text text-anchor="middle" style="font-size:6.00;" x="355" y="74">serial</text>
377
 
<text text-anchor="middle" style="font-size:6.00;" x="391" y="74"> PRIMARY KEY </text>
378
 
<text text-anchor="middle" style="font-size:6.00;" x="321" y="86">name</text>
379
 
<text text-anchor="middle" style="font-size:6.00;" x="354" y="86">text</text>
380
 
<text text-anchor="middle" style="font-size:6.00;" x="382" y="86"> UNIQUE </text>
381
 
<text text-anchor="middle" style="font-size:6.00;" x="319" y="98">title</text>
382
 
<text text-anchor="middle" style="font-size:6.00;" x="354" y="98">text</text>
383
 
<text text-anchor="middle" style="font-size:6.00;" x="328" y="110">description</text>
384
 
<text text-anchor="middle" style="font-size:6.00;" x="354" y="110">text</text>
385
 
<polygon style="fill:none;stroke:black;" points="308,116 308,50 418,50 418,116 308,116"/>
386
 
</g>
387
 
<g id="edge36" class="edge"><title>processor&#45;&gt;processorfamily</title>
388
 
<path style="fill:none;stroke:black;" d="M282,71C285,71 287,72 290,72"/>
389
 
<polygon style="fill:black;stroke:black;" points="291,69 300,74 290,75 291,69"/>
 
133
<path style="fill:none;stroke:black;" d="M804,194C807,194 810,195 813,195"/>
 
134
<polygon style="fill:black;stroke:black;" points="814,192 823,197 813,198 814,192"/>
 
135
</g>
 
136
<g id="node6" class="node"><title>person</title>
 
137
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="379,531 379,165 581,165 581,531 379,531"/>
 
138
<polygon style="fill:white;stroke:white;" points="382,180 382,168 578,168 578,180 382,180"/>
 
139
<text text-anchor="middle" style="font-size:6.00;" x="480" y="176">person</text>
 
140
<polygon style="fill:none;stroke:black;" points="382,180 382,168 578,168 578,180 382,180"/>
 
141
<text text-anchor="middle" style="font-size:6.00;" x="387" y="189">id</text>
 
142
<text text-anchor="middle" style="font-size:6.00;" x="462" y="189">serial</text>
 
143
<text text-anchor="middle" style="font-size:6.00;" x="511" y="189"> PRIMARY KEY </text>
 
144
<text text-anchor="middle" style="font-size:6.00;" x="400" y="201">displayname</text>
 
145
<text text-anchor="middle" style="font-size:6.00;" x="461" y="201">text</text>
 
146
<text text-anchor="middle" style="font-size:6.00;" x="398" y="213">givenname</text>
 
147
<text text-anchor="middle" style="font-size:6.00;" x="461" y="213">text</text>
 
148
<text text-anchor="middle" style="font-size:6.00;" x="399" y="225">familyname</text>
 
149
<text text-anchor="middle" style="font-size:6.00;" x="461" y="225">text</text>
 
150
<text text-anchor="middle" style="font-size:6.00;" x="396" y="237">password</text>
 
151
<text text-anchor="middle" style="font-size:6.00;" x="461" y="237">text</text>
 
152
<text text-anchor="middle" style="font-size:6.00;" x="398" y="249">teamowner</text>
 
153
<text text-anchor="middle" style="font-size:6.00;" x="464" y="249">integer</text>
 
154
<text text-anchor="middle" style="font-size:6.00;" x="518" y="249"> REFERENCES person </text>
 
155
<text text-anchor="middle" style="font-size:6.00;" x="405" y="261">teamdescription</text>
 
156
<text text-anchor="middle" style="font-size:6.00;" x="461" y="261">text</text>
 
157
<text text-anchor="middle" style="font-size:6.00;" x="392" y="273">name</text>
 
158
<text text-anchor="middle" style="font-size:6.00;" x="461" y="273">text</text>
 
159
<text text-anchor="middle" style="font-size:6.00;" x="396" y="285">language</text>
 
160
<text text-anchor="middle" style="font-size:6.00;" x="464" y="285">integer</text>
 
161
<text text-anchor="middle" style="font-size:6.00;" x="521" y="285"> REFERENCES language </text>
 
162
<text text-anchor="middle" style="font-size:6.00;" x="388" y="297">fti</text>
 
163
<text text-anchor="middle" style="font-size:6.00;" x="466" y="297">tsvector</text>
 
164
<text text-anchor="middle" style="font-size:6.00;" x="416" y="309">defaultmembershipperiod</text>
 
165
<text text-anchor="middle" style="font-size:6.00;" x="464" y="309">integer</text>
 
166
<text text-anchor="middle" style="font-size:6.00;" x="411" y="321">defaultrenewalperiod</text>
 
167
<text text-anchor="middle" style="font-size:6.00;" x="464" y="321">integer</text>
 
168
<text text-anchor="middle" style="font-size:6.00;" x="407" y="333">subscriptionpolicy</text>
 
169
<text text-anchor="middle" style="font-size:6.00;" x="464" y="333">integer</text>
 
170
<text text-anchor="middle" style="font-size:6.00;" x="394" y="345">merged</text>
 
171
<text text-anchor="middle" style="font-size:6.00;" x="464" y="345">integer</text>
 
172
<text text-anchor="middle" style="font-size:6.00;" x="518" y="345"> REFERENCES person </text>
 
173
<text text-anchor="middle" style="font-size:6.00;" x="399" y="357">datecreated</text>
 
174
<text text-anchor="middle" style="font-size:6.00;" x="469" y="357">timestamp</text>
 
175
<text text-anchor="middle" style="font-size:6.00;" x="395" y="369">calendar</text>
 
176
<text text-anchor="middle" style="font-size:6.00;" x="464" y="369">integer</text>
 
177
<text text-anchor="middle" style="font-size:6.00;" x="532" y="369"> REFERENCES calendar UNIQUE </text>
 
178
<text text-anchor="middle" style="font-size:6.00;" x="396" y="381">timezone</text>
 
179
<text text-anchor="middle" style="font-size:6.00;" x="461" y="381">text</text>
 
180
<text text-anchor="middle" style="font-size:6.00;" x="393" y="393">karma</text>
 
181
<text text-anchor="middle" style="font-size:6.00;" x="464" y="393">integer</text>
 
182
<text text-anchor="middle" style="font-size:6.00;" x="400" y="405">addressline1</text>
 
183
<text text-anchor="middle" style="font-size:6.00;" x="461" y="405">text</text>
 
184
<text text-anchor="middle" style="font-size:6.00;" x="400" y="417">addressline2</text>
 
185
<text text-anchor="middle" style="font-size:6.00;" x="461" y="417">text</text>
 
186
<text text-anchor="middle" style="font-size:6.00;" x="400" y="429">organization</text>
 
187
<text text-anchor="middle" style="font-size:6.00;" x="461" y="429">text</text>
 
188
<text text-anchor="middle" style="font-size:6.00;" x="390" y="441">city</text>
 
189
<text text-anchor="middle" style="font-size:6.00;" x="461" y="441">text</text>
 
190
<text text-anchor="middle" style="font-size:6.00;" x="396" y="453">province</text>
 
191
<text text-anchor="middle" style="font-size:6.00;" x="461" y="453">text</text>
 
192
<text text-anchor="middle" style="font-size:6.00;" x="395" y="465">country</text>
 
193
<text text-anchor="middle" style="font-size:6.00;" x="464" y="465">integer</text>
 
194
<text text-anchor="middle" style="font-size:6.00;" x="520" y="465"> REFERENCES country </text>
 
195
<text text-anchor="middle" style="font-size:6.00;" x="396" y="477">postcode</text>
 
196
<text text-anchor="middle" style="font-size:6.00;" x="461" y="477">text</text>
 
197
<text text-anchor="middle" style="font-size:6.00;" x="393" y="489">phone</text>
 
198
<text text-anchor="middle" style="font-size:6.00;" x="461" y="489">text</text>
 
199
<text text-anchor="middle" style="font-size:6.00;" x="408" y="501">homepage_content</text>
 
200
<text text-anchor="middle" style="font-size:6.00;" x="461" y="501">text</text>
 
201
<text text-anchor="middle" style="font-size:6.00;" x="395" y="513">emblem</text>
 
202
<text text-anchor="middle" style="font-size:6.00;" x="464" y="513">integer</text>
 
203
<text text-anchor="middle" style="font-size:6.00;" x="528" y="513"> REFERENCES libraryfilealias </text>
 
204
<text text-anchor="middle" style="font-size:6.00;" x="401" y="525">hackergotchi</text>
 
205
<text text-anchor="middle" style="font-size:6.00;" x="464" y="525">integer</text>
 
206
<text text-anchor="middle" style="font-size:6.00;" x="528" y="525"> REFERENCES libraryfilealias </text>
 
207
<polygon style="fill:none;stroke:black;" points="379,531 379,165 581,165 581,531 379,531"/>
 
208
</g>
 
209
<g id="edge6" class="edge"><title>person&#45;&gt;person</title>
 
210
<path style="fill:none;stroke:black;" d="M589,405C600,393 607,375 607,348 607,326 603,311 595,299"/>
 
211
<polygon style="fill:black;stroke:black;" points="592,301 589,291 598,297 592,301"/>
 
212
</g>
 
213
<g id="edge10" class="edge"><title>person&#45;&gt;person</title>
 
214
<path style="fill:none;stroke:black;" d="M589,481C610,465 625,421 625,348 625,284 613,242 596,222"/>
 
215
<polygon style="fill:black;stroke:black;" points="594,225 589,215 599,220 594,225"/>
 
216
</g>
 
217
<g id="node14" class="node"><title>fake_language_173</title>
 
218
<ellipse cx="635" cy="308" rx="27" ry="18" style="fill:none;stroke:red;"/>
 
219
<text text-anchor="middle" style="font-size:6.00;" x="635" y="310">language</text>
 
220
</g>
 
221
<g id="edge8" class="edge"><title>person&#45;&gt;fake_language_173</title>
 
222
<path style="fill:none;stroke:black;" d="M589,320C593,319 597,318 600,317"/>
 
223
<polygon style="fill:black;stroke:black;" points="600,314 610,315 601,320 600,314"/>
 
224
</g>
 
225
<g id="node17" class="node"><title>fake_calendar_176</title>
 
226
<ellipse cx="551" cy="59" rx="27" ry="18" style="fill:none;stroke:red;"/>
 
227
<text text-anchor="middle" style="font-size:6.00;" x="551" y="61">calendar</text>
 
228
</g>
 
229
<g id="edge12" class="edge"><title>person&#45;&gt;fake_calendar_176</title>
 
230
<path style="fill:none;stroke:black;" d="M526,161C534,132 540,105 544,87"/>
 
231
<polygon style="fill:black;stroke:black;" points="541,86 547,77 547,88 541,86"/>
 
232
</g>
 
233
<g id="node19" class="node"><title>fake_country_178</title>
 
234
<ellipse cx="520" cy="635" rx="27" ry="18" style="fill:none;stroke:red;"/>
 
235
<text text-anchor="middle" style="font-size:6.00;" x="520" y="637">country</text>
 
236
</g>
 
237
<g id="edge14" class="edge"><title>person&#45;&gt;fake_country_178</title>
 
238
<path style="fill:none;stroke:black;" d="M506,535C510,563 514,589 516,607"/>
 
239
<polygon style="fill:black;stroke:black;" points="519,607 518,617 513,608 519,607"/>
 
240
</g>
 
241
<g id="node21" class="node"><title>fake_libraryfilealias_180</title>
 
242
<ellipse cx="720" cy="520" rx="29" ry="18" style="fill:none;stroke:red;"/>
 
243
<text text-anchor="middle" style="font-size:6.00;" x="720" y="522">libraryfilealias</text>
 
244
</g>
 
245
<g id="edge16" class="edge"><title>person&#45;&gt;fake_libraryfilealias_180</title>
 
246
<path style="fill:none;stroke:black;" d="M589,426C627,454 667,482 692,500"/>
 
247
<polygon style="fill:black;stroke:black;" points="695,498 701,506 691,503 695,498"/>
 
248
</g>
 
249
<g id="node23" class="node"><title>fake_libraryfilealias_182</title>
 
250
<ellipse cx="310" cy="101" rx="29" ry="18" style="fill:none;stroke:red;"/>
 
251
<text text-anchor="middle" style="font-size:6.00;" x="310" y="103">libraryfilealias</text>
 
252
</g>
 
253
<g id="edge18" class="edge"><title>person&#45;&gt;fake_libraryfilealias_182</title>
 
254
<path style="fill:none;stroke:black;" d="M371,189C354,165 339,143 328,127"/>
 
255
<polygon style="fill:black;stroke:black;" points="325,128 322,118 330,124 325,128"/>
 
256
</g>
 
257
<g id="node7" class="node"><title>personlabel</title>
 
258
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="182,601 182,559 300,559 300,601 182,601"/>
 
259
<polygon style="fill:white;stroke:white;" points="185,574 185,562 297,562 297,574 185,574"/>
 
260
<text text-anchor="middle" style="font-size:6.00;" x="241" y="570">personlabel</text>
 
261
<polygon style="fill:none;stroke:black;" points="185,574 185,562 297,562 297,574 185,574"/>
 
262
<text text-anchor="middle" style="font-size:6.00;" x="196" y="583">person</text>
 
263
<text text-anchor="middle" style="font-size:6.00;" x="220" y="583">integer</text>
 
264
<text text-anchor="middle" style="font-size:6.00;" x="265" y="583"> REFERENCES person </text>
 
265
<text text-anchor="middle" style="font-size:6.00;" x="194" y="595">label</text>
 
266
<text text-anchor="middle" style="font-size:6.00;" x="220" y="595">integer</text>
 
267
<text text-anchor="middle" style="font-size:6.00;" x="263" y="595"> REFERENCES label </text>
 
268
<polygon style="fill:none;stroke:black;" points="182,601 182,559 300,559 300,601 182,601"/>
 
269
</g>
 
270
<g id="edge22" class="edge"><title>personlabel&#45;&gt;label</title>
 
271
<path style="fill:none;stroke:black;" d="M210,555C193,542 173,525 153,508"/>
 
272
<polygon style="fill:black;stroke:black;" points="151,511 145,502 155,505 151,511"/>
 
273
</g>
 
274
<g id="edge20" class="edge"><title>personlabel&#45;&gt;person</title>
 
275
<path style="fill:none;stroke:black;" d="M267,555C290,532 327,497 364,461"/>
 
276
<polygon style="fill:black;stroke:black;" points="361,459 371,454 366,464 361,459"/>
 
277
</g>
 
278
<g id="node8" class="node"><title>processor</title>
 
279
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="626,90 626,12 778,12 778,90 626,90"/>
 
280
<polygon style="fill:white;stroke:white;" points="629,27 629,15 775,15 775,27 629,27"/>
 
281
<text text-anchor="middle" style="font-size:6.00;" x="702" y="23">processor</text>
 
282
<polygon style="fill:none;stroke:black;" points="629,27 629,15 775,15 775,27 629,27"/>
 
283
<text text-anchor="middle" style="font-size:6.00;" x="634" y="36">id</text>
 
284
<text text-anchor="middle" style="font-size:6.00;" x="674" y="36">serial</text>
 
285
<text text-anchor="middle" style="font-size:6.00;" x="714" y="36"> PRIMARY KEY </text>
 
286
<text text-anchor="middle" style="font-size:6.00;" x="640" y="48">family</text>
 
287
<text text-anchor="middle" style="font-size:6.00;" x="676" y="48">integer</text>
 
288
<text text-anchor="middle" style="font-size:6.00;" x="732" y="48"> REFERENCES processorfamily </text>
 
289
<text text-anchor="middle" style="font-size:6.00;" x="639" y="60">name</text>
 
290
<text text-anchor="middle" style="font-size:6.00;" x="673" y="60">text</text>
 
291
<text text-anchor="middle" style="font-size:6.00;" x="705" y="60"> UNIQUE </text>
 
292
<text text-anchor="middle" style="font-size:6.00;" x="637" y="72">title</text>
 
293
<text text-anchor="middle" style="font-size:6.00;" x="673" y="72">text</text>
 
294
<text text-anchor="middle" style="font-size:6.00;" x="646" y="84">description</text>
 
295
<text text-anchor="middle" style="font-size:6.00;" x="673" y="84">text</text>
 
296
<polygon style="fill:none;stroke:black;" points="626,90 626,12 778,12 778,90 626,90"/>
 
297
</g>
 
298
<g id="node9" class="node"><title>processorfamily</title>
 
299
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="812,109 812,43 922,43 922,109 812,109"/>
 
300
<polygon style="fill:white;stroke:white;" points="815,58 815,46 919,46 919,58 815,58"/>
 
301
<text text-anchor="middle" style="font-size:6.00;" x="867" y="54">processorfamily</text>
 
302
<polygon style="fill:none;stroke:black;" points="815,58 815,46 919,46 919,58 815,58"/>
 
303
<text text-anchor="middle" style="font-size:6.00;" x="820" y="67">id</text>
 
304
<text text-anchor="middle" style="font-size:6.00;" x="859" y="67">serial</text>
 
305
<text text-anchor="middle" style="font-size:6.00;" x="895" y="67"> PRIMARY KEY </text>
 
306
<text text-anchor="middle" style="font-size:6.00;" x="825" y="79">name</text>
 
307
<text text-anchor="middle" style="font-size:6.00;" x="858" y="79">text</text>
 
308
<text text-anchor="middle" style="font-size:6.00;" x="886" y="79"> UNIQUE </text>
 
309
<text text-anchor="middle" style="font-size:6.00;" x="823" y="91">title</text>
 
310
<text text-anchor="middle" style="font-size:6.00;" x="858" y="91">text</text>
 
311
<text text-anchor="middle" style="font-size:6.00;" x="832" y="103">description</text>
 
312
<text text-anchor="middle" style="font-size:6.00;" x="858" y="103">text</text>
 
313
<polygon style="fill:none;stroke:black;" points="812,109 812,43 922,43 922,109 812,109"/>
 
314
</g>
 
315
<g id="edge24" class="edge"><title>processor&#45;&gt;processorfamily</title>
 
316
<path style="fill:none;stroke:black;" d="M786,64C789,64 791,65 794,65"/>
 
317
<polygon style="fill:black;stroke:black;" points="795,62 804,67 794,68 795,62"/>
 
318
</g>
 
319
<g id="edge26" class="edge"><title>schema&#45;&gt;person</title>
 
320
<path style="fill:none;stroke:black;" d="M351,348C354,348 357,348 361,348"/>
 
321
<polygon style="fill:black;stroke:black;" points="361,344 371,348 361,351 361,344"/>
390
322
</g>
391
323
</g>
392
324
</svg>