← 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: 2006-03-25 14:00:52 UTC
  • mto: This revision was merged to the branch mainline in revision 3346.
  • Revision ID: stuart.bishop@canonical.com-20060325140052-d15df1a961ff920b
Update database diagrams

Show diffs side-by-side

added added

removed removed

Lines of Context:
database/schema/diagrams/misc.svg
3
3
 "http://www.w3.org/TR/2001/REC-SVG-20010904/DTD/svg10.dtd">
4
4
<!-- Generated by fdp version 2.2.1 (Tue Oct 11 01:38:21 UTC 2005)
5
5
     For user: (stub) Stuart Bishop,,,   Title: g    Pages: 1 -->
6
 
<svg width="756px" height="535px"
7
 
 viewBox = "-1 -1 755 534"
 
6
<svg width="1077px" height="713px"
 
7
 viewBox = "-1 -1 1076 712"
8
8
 xmlns="http://www.w3.org/2000/svg">
9
 
<g id="graph0" class="graph" transform = "scale(0.767988)"
10
 
 style="font-family:Times-Roman;font-size:14.00;">
 
9
<g id="graph0" class="graph" style="font-family:Times-Roman;font-size:14.00;">
11
10
<title>g</title>
12
 
<text text-anchor="middle" style="font-size:22.00;" x="489" y="678">Misc</text>
13
 
<g id="node1" class="node"><title>label</title>
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"/>
 
11
<text text-anchor="middle" style="font-size:22.00;" x="537" y="695">Misc</text>
 
12
<g id="node1" class="node"><title>fticache</title>
 
13
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="364,106 364,44 500,44 500,106 364,106"/>
 
14
<polygon style="fill:white;stroke:white;" points="367,61 367,47 497,47 497,61 367,61"/>
 
15
<text text-anchor="middle" style="font-size:8.00;" x="432" y="57">fticache</text>
 
16
<polygon style="fill:none;stroke:black;" points="367,61 367,47 497,47 497,61 367,61"/>
 
17
<text text-anchor="middle" style="font-size:8.00;" x="373" y="72">id</text>
 
18
<text text-anchor="middle" style="font-size:8.00;" x="420" y="72">serial</text>
 
19
<text text-anchor="middle" style="font-size:8.00;" x="465" y="72"> PRIMARY KEY </text>
 
20
<text text-anchor="middle" style="font-size:8.00;" x="387" y="86">tablename</text>
 
21
<text text-anchor="middle" style="font-size:8.00;" x="418" y="86">text</text>
 
22
<text text-anchor="middle" style="font-size:8.00;" x="453" y="86"> UNIQUE </text>
 
23
<text text-anchor="middle" style="font-size:8.00;" x="383" y="100">columns</text>
 
24
<text text-anchor="middle" style="font-size:8.00;" x="418" y="100">text</text>
 
25
<polygon style="fill:none;stroke:black;" points="364,106 364,44 500,44 500,106 364,106"/>
 
26
</g>
 
27
<g id="node2" class="node"><title>label</title>
 
28
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="14,560 14,470 210,470 210,560 14,560"/>
 
29
<polygon style="fill:white;stroke:white;" points="17,487 17,473 207,473 207,487 17,487"/>
 
30
<text text-anchor="middle" style="font-size:8.00;" x="112" y="483">label</text>
 
31
<polygon style="fill:none;stroke:black;" points="17,487 17,473 207,473 207,487 17,487"/>
 
32
<text text-anchor="middle" style="font-size:8.00;" x="23" y="498">id</text>
 
33
<text text-anchor="middle" style="font-size:8.00;" x="70" y="498">serial</text>
 
34
<text text-anchor="middle" style="font-size:8.00;" x="121" y="498"> PRIMARY KEY </text>
 
35
<text text-anchor="middle" style="font-size:8.00;" x="32" y="512">schema</text>
 
36
<text text-anchor="middle" style="font-size:8.00;" x="73" y="512">integer</text>
 
37
<text text-anchor="middle" style="font-size:8.00;" x="148" y="512"> REFERENCES schema UNIQUE </text>
 
38
<text text-anchor="middle" style="font-size:8.00;" x="29" y="526">name</text>
 
39
<text text-anchor="middle" style="font-size:8.00;" x="68" y="526">text</text>
 
40
<text text-anchor="middle" style="font-size:8.00;" x="109" y="526"> UNIQUE </text>
 
41
<text text-anchor="middle" style="font-size:8.00;" x="26" y="540">title</text>
 
42
<text text-anchor="middle" style="font-size:8.00;" x="68" y="540">text</text>
 
43
<text text-anchor="middle" style="font-size:8.00;" x="37" y="554">description</text>
 
44
<text text-anchor="middle" style="font-size:8.00;" x="68" y="554">text</text>
 
45
<polygon style="fill:none;stroke:black;" points="14,560 14,470 210,470 210,560 14,560"/>
 
46
</g>
 
47
<g id="node11" class="node"><title>schema</title>
 
48
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="108,445 108,341 272,341 272,445 108,445"/>
 
49
<polygon style="fill:white;stroke:white;" points="111,358 111,344 269,344 269,358 111,358"/>
 
50
<text text-anchor="middle" style="font-size:8.00;" x="190" y="354">schema</text>
 
51
<polygon style="fill:none;stroke:black;" points="111,358 111,344 269,344 269,358 111,358"/>
 
52
<text text-anchor="middle" style="font-size:8.00;" x="117" y="369">id</text>
 
53
<text text-anchor="middle" style="font-size:8.00;" x="164" y="369">serial</text>
 
54
<text text-anchor="middle" style="font-size:8.00;" x="218" y="369"> PRIMARY KEY </text>
 
55
<text text-anchor="middle" style="font-size:8.00;" x="123" y="383">name</text>
 
56
<text text-anchor="middle" style="font-size:8.00;" x="162" y="383">text</text>
 
57
<text text-anchor="middle" style="font-size:8.00;" x="120" y="397">title</text>
 
58
<text text-anchor="middle" style="font-size:8.00;" x="162" y="397">text</text>
 
59
<text text-anchor="middle" style="font-size:8.00;" x="131" y="411">description</text>
 
60
<text text-anchor="middle" style="font-size:8.00;" x="162" y="411">text</text>
 
61
<text text-anchor="middle" style="font-size:8.00;" x="124" y="425">owner</text>
 
62
<text text-anchor="middle" style="font-size:8.00;" x="167" y="425">integer</text>
 
63
<text text-anchor="middle" style="font-size:8.00;" x="228" y="425"> REFERENCES person </text>
 
64
<text text-anchor="middle" style="font-size:8.00;" x="130" y="439">extensible</text>
 
65
<text text-anchor="middle" style="font-size:8.00;" x="169" y="439">boolean</text>
 
66
<polygon style="fill:none;stroke:black;" points="108,445 108,341 272,341 272,445 108,445"/>
53
67
</g>
54
68
<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"/>
57
 
</g>
58
 
<g id="node2" class="node"><title>launchpaddatabaserevision</title>
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"/>
73
 
</g>
74
 
<g id="node3" class="node"><title>launchpadstatistic</title>
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"/>
90
 
</g>
91
 
<g id="node4" class="node"><title>libraryfilealias</title>
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"/>
111
 
</g>
112
 
<g id="node5" class="node"><title>libraryfilecontent</title>
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"/>
 
69
<path style="fill:none;stroke:black;" d="M144,466C146,463 147,460 149,457"/>
 
70
<polygon style="fill:black;stroke:black;" points="146,455 155,449 152,459 146,455"/>
 
71
</g>
 
72
<g id="node3" class="node"><title>launchpaddatabaserevision</title>
 
73
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="679,71 679,9 807,9 807,71 679,71"/>
 
74
<polygon style="fill:white;stroke:white;" points="682,26 682,12 804,12 804,26 682,26"/>
 
75
<text text-anchor="middle" style="font-size:8.00;" x="743" y="22">launchpaddatabaserevision</text>
 
76
<polygon style="fill:none;stroke:black;" points="682,26 682,12 804,12 804,26 682,26"/>
 
77
<text text-anchor="middle" style="font-size:8.00;" x="694" y="37">major</text>
 
78
<text text-anchor="middle" style="font-size:8.00;" x="724" y="37">integer</text>
 
79
<text text-anchor="middle" style="font-size:8.00;" x="772" y="37"> PRIMARY KEY </text>
 
80
<text text-anchor="middle" style="font-size:8.00;" x="695" y="51">minor</text>
 
81
<text text-anchor="middle" style="font-size:8.00;" x="724" y="51">integer</text>
 
82
<text text-anchor="middle" style="font-size:8.00;" x="772" y="51"> PRIMARY KEY </text>
 
83
<text text-anchor="middle" style="font-size:8.00;" x="694" y="65">patch</text>
 
84
<text text-anchor="middle" style="font-size:8.00;" x="724" y="65">integer</text>
 
85
<text text-anchor="middle" style="font-size:8.00;" x="772" y="65"> PRIMARY KEY </text>
 
86
<polygon style="fill:none;stroke:black;" points="679,71 679,9 807,9 807,71 679,71"/>
 
87
</g>
 
88
<g id="node4" class="node"><title>launchpadstatistic</title>
 
89
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="609,631 609,555 767,555 767,631 609,631"/>
 
90
<polygon style="fill:white;stroke:white;" points="612,572 612,558 764,558 764,572 612,572"/>
 
91
<text text-anchor="middle" style="font-size:8.00;" x="688" y="568">launchpadstatistic</text>
 
92
<polygon style="fill:none;stroke:black;" points="612,572 612,558 764,558 764,572 612,572"/>
 
93
<text text-anchor="middle" style="font-size:8.00;" x="618" y="583">id</text>
 
94
<text text-anchor="middle" style="font-size:8.00;" x="670" y="583">serial</text>
 
95
<text text-anchor="middle" style="font-size:8.00;" x="732" y="583"> PRIMARY KEY </text>
 
96
<text text-anchor="middle" style="font-size:8.00;" x="624" y="597">name</text>
 
97
<text text-anchor="middle" style="font-size:8.00;" x="668" y="597">text</text>
 
98
<text text-anchor="middle" style="font-size:8.00;" x="720" y="597"> UNIQUE </text>
 
99
<text text-anchor="middle" style="font-size:8.00;" x="624" y="611">value</text>
 
100
<text text-anchor="middle" style="font-size:8.00;" x="673" y="611">integer</text>
 
101
<text text-anchor="middle" style="font-size:8.00;" x="634" y="625">dateupdated</text>
 
102
<text text-anchor="middle" style="font-size:8.00;" x="679" y="625">timestamp</text>
 
103
<polygon style="fill:none;stroke:black;" points="609,631 609,555 767,555 767,631 609,631"/>
 
104
</g>
 
105
<g id="node5" class="node"><title>libraryfilealias</title>
 
106
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="644,213 644,109 860,109 860,213 644,213"/>
 
107
<polygon style="fill:white;stroke:white;" points="647,126 647,112 857,112 857,126 647,126"/>
 
108
<text text-anchor="middle" style="font-size:8.00;" x="752" y="122">libraryfilealias</text>
 
109
<polygon style="fill:none;stroke:black;" points="647,126 647,112 857,112 857,126 647,126"/>
 
110
<text text-anchor="middle" style="font-size:8.00;" x="653" y="137">id</text>
 
111
<text text-anchor="middle" style="font-size:8.00;" x="710" y="137">serial</text>
 
112
<text text-anchor="middle" style="font-size:8.00;" x="772" y="137"> PRIMARY KEY </text>
 
113
<text text-anchor="middle" style="font-size:8.00;" x="661" y="151">content</text>
 
114
<text text-anchor="middle" style="font-size:8.00;" x="713" y="151">integer</text>
 
115
<text text-anchor="middle" style="font-size:8.00;" x="799" y="151"> REFERENCES libraryfilecontent </text>
 
116
<text text-anchor="middle" style="font-size:8.00;" x="664" y="165">filename</text>
 
117
<text text-anchor="middle" style="font-size:8.00;" x="708" y="165">text</text>
 
118
<text text-anchor="middle" style="font-size:8.00;" x="666" y="179">mimetype</text>
 
119
<text text-anchor="middle" style="font-size:8.00;" x="708" y="179">text</text>
 
120
<text text-anchor="middle" style="font-size:8.00;" x="662" y="193">expires</text>
 
121
<text text-anchor="middle" style="font-size:8.00;" x="719" y="193">timestamp</text>
 
122
<text text-anchor="middle" style="font-size:8.00;" x="672" y="207">last_accessed</text>
 
123
<text text-anchor="middle" style="font-size:8.00;" x="719" y="207">timestamp</text>
 
124
<polygon style="fill:none;stroke:black;" points="644,213 644,109 860,109 860,213 644,213"/>
 
125
</g>
 
126
<g id="node6" class="node"><title>libraryfilecontent</title>
 
127
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="893,246 893,142 1061,142 1061,246 893,246"/>
 
128
<polygon style="fill:white;stroke:white;" points="896,159 896,145 1058,145 1058,159 896,159"/>
 
129
<text text-anchor="middle" style="font-size:8.00;" x="977" y="155">libraryfilecontent</text>
 
130
<polygon style="fill:none;stroke:black;" points="896,159 896,145 1058,145 1058,159 896,159"/>
 
131
<text text-anchor="middle" style="font-size:8.00;" x="902" y="170">id</text>
 
132
<text text-anchor="middle" style="font-size:8.00;" x="955" y="170">serial</text>
 
133
<text text-anchor="middle" style="font-size:8.00;" x="1026" y="170"> PRIMARY KEY </text>
 
134
<text text-anchor="middle" style="font-size:8.00;" x="917" y="184">datecreated</text>
 
135
<text text-anchor="middle" style="font-size:8.00;" x="964" y="184">timestamp</text>
 
136
<text text-anchor="middle" style="font-size:8.00;" x="919" y="198">datemirrored</text>
 
137
<text text-anchor="middle" style="font-size:8.00;" x="964" y="198">timestamp</text>
 
138
<text text-anchor="middle" style="font-size:8.00;" x="911" y="212">filesize</text>
 
139
<text text-anchor="middle" style="font-size:8.00;" x="958" y="212">integer</text>
 
140
<text text-anchor="middle" style="font-size:8.00;" x="906" y="226">sha1</text>
 
141
<text text-anchor="middle" style="font-size:8.00;" x="968" y="226">character(40)</text>
 
142
<text text-anchor="middle" style="font-size:8.00;" x="910" y="240">deleted</text>
 
143
<text text-anchor="middle" style="font-size:8.00;" x="960" y="240">boolean</text>
 
144
<polygon style="fill:none;stroke:black;" points="893,246 893,142 1061,142 1061,246 893,246"/>
131
145
</g>
132
146
<g id="edge4" class="edge"><title>libraryfilealias&#45;&gt;libraryfilecontent</title>
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"/>
 
147
<path style="fill:none;stroke:black;" d="M868,178C870,178 873,179 875,179"/>
 
148
<polygon style="fill:black;stroke:black;" points="875,176 885,180 875,182 875,176"/>
135
149
</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"/>
 
150
<g id="node7" class="node"><title>person</title>
 
151
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="305,550 305,152 563,152 563,550 305,550"/>
 
152
<polygon style="fill:white;stroke:white;" points="308,169 308,155 560,155 560,169 308,169"/>
 
153
<text text-anchor="middle" style="font-size:8.00;" x="434" y="165">person</text>
 
154
<polygon style="fill:none;stroke:black;" points="308,169 308,155 560,155 560,169 308,169"/>
 
155
<text text-anchor="middle" style="font-size:8.00;" x="314" y="180">id</text>
 
156
<text text-anchor="middle" style="font-size:8.00;" x="409" y="180">serial</text>
 
157
<text text-anchor="middle" style="font-size:8.00;" x="471" y="180"> PRIMARY KEY </text>
 
158
<text text-anchor="middle" style="font-size:8.00;" x="331" y="194">displayname</text>
 
159
<text text-anchor="middle" style="font-size:8.00;" x="407" y="194">text</text>
 
160
<text text-anchor="middle" style="font-size:8.00;" x="326" y="208">password</text>
 
161
<text text-anchor="middle" style="font-size:8.00;" x="407" y="208">text</text>
 
162
<text text-anchor="middle" style="font-size:8.00;" x="329" y="222">teamowner</text>
 
163
<text text-anchor="middle" style="font-size:8.00;" x="412" y="222">integer</text>
 
164
<text text-anchor="middle" style="font-size:8.00;" x="481" y="222"> REFERENCES person </text>
 
165
<text text-anchor="middle" style="font-size:8.00;" x="337" y="236">teamdescription</text>
 
166
<text text-anchor="middle" style="font-size:8.00;" x="407" y="236">text</text>
 
167
<text text-anchor="middle" style="font-size:8.00;" x="320" y="250">name</text>
 
168
<text text-anchor="middle" style="font-size:8.00;" x="407" y="250">text</text>
 
169
<text text-anchor="middle" style="font-size:8.00;" x="326" y="264">language</text>
 
170
<text text-anchor="middle" style="font-size:8.00;" x="412" y="264">integer</text>
 
171
<text text-anchor="middle" style="font-size:8.00;" x="485" y="264"> REFERENCES language </text>
 
172
<text text-anchor="middle" style="font-size:8.00;" x="315" y="278">fti</text>
 
173
<text text-anchor="middle" style="font-size:8.00;" x="414" y="278">tsvector</text>
 
174
<text text-anchor="middle" style="font-size:8.00;" x="352" y="292">defaultmembershipperiod</text>
 
175
<text text-anchor="middle" style="font-size:8.00;" x="412" y="292">integer</text>
 
176
<text text-anchor="middle" style="font-size:8.00;" x="345" y="306">defaultrenewalperiod</text>
 
177
<text text-anchor="middle" style="font-size:8.00;" x="412" y="306">integer</text>
 
178
<text text-anchor="middle" style="font-size:8.00;" x="340" y="320">subscriptionpolicy</text>
 
179
<text text-anchor="middle" style="font-size:8.00;" x="412" y="320">integer</text>
 
180
<text text-anchor="middle" style="font-size:8.00;" x="323" y="334">merged</text>
 
181
<text text-anchor="middle" style="font-size:8.00;" x="412" y="334">integer</text>
 
182
<text text-anchor="middle" style="font-size:8.00;" x="481" y="334"> REFERENCES person </text>
 
183
<text text-anchor="middle" style="font-size:8.00;" x="329" y="348">datecreated</text>
 
184
<text text-anchor="middle" style="font-size:8.00;" x="418" y="348">timestamp</text>
 
185
<text text-anchor="middle" style="font-size:8.00;" x="324" y="362">calendar</text>
 
186
<text text-anchor="middle" style="font-size:8.00;" x="412" y="362">integer</text>
 
187
<text text-anchor="middle" style="font-size:8.00;" x="500" y="362"> REFERENCES calendar UNIQUE </text>
 
188
<text text-anchor="middle" style="font-size:8.00;" x="326" y="376">timezone</text>
 
189
<text text-anchor="middle" style="font-size:8.00;" x="407" y="376">text</text>
 
190
<text text-anchor="middle" style="font-size:8.00;" x="331" y="390">addressline1</text>
 
191
<text text-anchor="middle" style="font-size:8.00;" x="407" y="390">text</text>
 
192
<text text-anchor="middle" style="font-size:8.00;" x="331" y="404">addressline2</text>
 
193
<text text-anchor="middle" style="font-size:8.00;" x="407" y="404">text</text>
 
194
<text text-anchor="middle" style="font-size:8.00;" x="331" y="418">organization</text>
 
195
<text text-anchor="middle" style="font-size:8.00;" x="407" y="418">text</text>
 
196
<text text-anchor="middle" style="font-size:8.00;" x="317" y="432">city</text>
 
197
<text text-anchor="middle" style="font-size:8.00;" x="407" y="432">text</text>
 
198
<text text-anchor="middle" style="font-size:8.00;" x="325" y="446">province</text>
 
199
<text text-anchor="middle" style="font-size:8.00;" x="407" y="446">text</text>
 
200
<text text-anchor="middle" style="font-size:8.00;" x="323" y="460">country</text>
 
201
<text text-anchor="middle" style="font-size:8.00;" x="412" y="460">integer</text>
 
202
<text text-anchor="middle" style="font-size:8.00;" x="482" y="460"> REFERENCES country </text>
 
203
<text text-anchor="middle" style="font-size:8.00;" x="325" y="474">postcode</text>
 
204
<text text-anchor="middle" style="font-size:8.00;" x="407" y="474">text</text>
 
205
<text text-anchor="middle" style="font-size:8.00;" x="321" y="488">phone</text>
 
206
<text text-anchor="middle" style="font-size:8.00;" x="407" y="488">text</text>
 
207
<text text-anchor="middle" style="font-size:8.00;" x="342" y="502">homepage_content</text>
 
208
<text text-anchor="middle" style="font-size:8.00;" x="407" y="502">text</text>
 
209
<text text-anchor="middle" style="font-size:8.00;" x="324" y="516">emblem</text>
 
210
<text text-anchor="middle" style="font-size:8.00;" x="412" y="516">integer</text>
 
211
<text text-anchor="middle" style="font-size:8.00;" x="493" y="516"> REFERENCES libraryfilealias </text>
 
212
<text text-anchor="middle" style="font-size:8.00;" x="332" y="530">hackergotchi</text>
 
213
<text text-anchor="middle" style="font-size:8.00;" x="412" y="530">integer</text>
 
214
<text text-anchor="middle" style="font-size:8.00;" x="493" y="530"> REFERENCES libraryfilealias </text>
 
215
<text text-anchor="middle" style="font-size:8.00;" x="346" y="544">hide_email_addresses</text>
 
216
<text text-anchor="middle" style="font-size:8.00;" x="414" y="544">boolean</text>
 
217
<polygon style="fill:none;stroke:black;" points="305,550 305,152 563,152 563,550 305,550"/>
208
218
</g>
209
219
<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"/>
 
220
<path style="fill:none;stroke:black;" d="M571,409C582,396 589,377 589,351 589,330 584,314 577,301"/>
 
221
<polygon style="fill:black;stroke:black;" points="574,303 571,293 580,299 574,303"/>
212
222
</g>
213
223
<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"/>
 
224
<path style="fill:none;stroke:black;" d="M571,489C593,469 607,422 607,351 607,288 596,244 578,221"/>
 
225
<polygon style="fill:black;stroke:black;" points="575,223 571,213 580,218 575,223"/>
 
226
</g>
 
227
<g id="node15" class="node"><title>fake_language_187</title>
 
228
<ellipse cx="615" cy="296" rx="27" ry="18" style="fill:none;stroke:red;"/>
 
229
<text text-anchor="middle" style="font-size:8.00;" x="615" y="299">language</text>
 
230
</g>
 
231
<g id="edge8" class="edge"><title>person&#45;&gt;fake_language_187</title>
 
232
<path style="fill:none;stroke:black;" d="M571,309C574,308 577,307 580,306"/>
 
233
<polygon style="fill:black;stroke:black;" points="579,303 590,303 581,309 579,303"/>
 
234
</g>
 
235
<g id="node18" class="node"><title>fake_calendar_190</title>
 
236
<ellipse cx="580" cy="79" rx="27" ry="18" style="fill:none;stroke:red;"/>
 
237
<text text-anchor="middle" style="font-size:8.00;" x="580" y="82">calendar</text>
 
238
</g>
 
239
<g id="edge12" class="edge"><title>person&#45;&gt;fake_calendar_190</title>
 
240
<path style="fill:none;stroke:black;" d="M543,148C552,132 560,116 566,105"/>
 
241
<polygon style="fill:black;stroke:black;" points="563,103 571,96 569,106 563,103"/>
 
242
</g>
 
243
<g id="node20" class="node"><title>fake_country_192</title>
 
244
<ellipse cx="488" cy="652" rx="27" ry="18" style="fill:none;stroke:red;"/>
 
245
<text text-anchor="middle" style="font-size:8.00;" x="488" y="655">country</text>
 
246
</g>
 
247
<g id="edge14" class="edge"><title>person&#45;&gt;fake_country_192</title>
 
248
<path style="fill:none;stroke:black;" d="M470,554C475,581 479,606 483,624"/>
 
249
<polygon style="fill:black;stroke:black;" points="486,624 485,634 480,625 486,624"/>
 
250
</g>
 
251
<g id="node22" class="node"><title>fake_libraryfilealias_194</title>
 
252
<ellipse cx="709" cy="504" rx="35" ry="18" style="fill:none;stroke:red;"/>
 
253
<text text-anchor="middle" style="font-size:8.00;" x="709" y="507">libraryfilealias</text>
 
254
</g>
 
255
<g id="edge16" class="edge"><title>person&#45;&gt;fake_libraryfilealias_194</title>
 
256
<path style="fill:none;stroke:black;" d="M571,427C610,449 650,471 676,486"/>
 
257
<polygon style="fill:black;stroke:black;" points="678,483 685,491 675,489 678,483"/>
 
258
</g>
 
259
<g id="node24" class="node"><title>fake_libraryfilealias_196</title>
 
260
<ellipse cx="300" cy="65" rx="35" ry="18" style="fill:none;stroke:red;"/>
 
261
<text text-anchor="middle" style="font-size:8.00;" x="300" y="68">libraryfilealias</text>
 
262
</g>
 
263
<g id="edge18" class="edge"><title>person&#45;&gt;fake_libraryfilealias_196</title>
 
264
<path style="fill:none;stroke:black;" d="M339,148C328,126 319,107 312,92"/>
 
265
<polygon style="fill:black;stroke:black;" points="309,94 308,83 315,91 309,94"/>
 
266
</g>
 
267
<g id="node8" class="node"><title>personlabel</title>
 
268
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="99,632 99,584 247,584 247,632 99,632"/>
 
269
<polygon style="fill:white;stroke:white;" points="102,601 102,587 244,587 244,601 102,601"/>
 
270
<text text-anchor="middle" style="font-size:8.00;" x="173" y="597">personlabel</text>
 
271
<polygon style="fill:none;stroke:black;" points="102,601 102,587 244,587 244,601 102,601"/>
 
272
<text text-anchor="middle" style="font-size:8.00;" x="116" y="612">person</text>
 
273
<text text-anchor="middle" style="font-size:8.00;" x="145" y="612">integer</text>
 
274
<text text-anchor="middle" style="font-size:8.00;" x="203" y="612"> REFERENCES person </text>
 
275
<text text-anchor="middle" style="font-size:8.00;" x="113" y="626">label</text>
 
276
<text text-anchor="middle" style="font-size:8.00;" x="145" y="626">integer</text>
 
277
<text text-anchor="middle" style="font-size:8.00;" x="200" y="626"> REFERENCES label </text>
 
278
<polygon style="fill:none;stroke:black;" points="99,632 99,584 247,584 247,632 99,632"/>
269
279
</g>
270
280
<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"/>
 
281
<path style="fill:none;stroke:black;" d="M155,580C154,578 152,575 150,573"/>
 
282
<polygon style="fill:black;stroke:black;" points="147,574 145,564 153,571 147,574"/>
273
283
</g>
274
284
<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"/>
 
285
<path style="fill:none;stroke:black;" d="M208,580C213,575 218,571 223,566 245,546 268,524 290,502"/>
 
286
<polygon style="fill:black;stroke:black;" points="287,500 297,495 292,505 287,500"/>
 
287
</g>
 
288
<g id="node9" class="node"><title>processor</title>
 
289
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="644,434 644,344 836,344 836,434 644,434"/>
 
290
<polygon style="fill:white;stroke:white;" points="647,361 647,347 833,347 833,361 647,361"/>
 
291
<text text-anchor="middle" style="font-size:8.00;" x="740" y="357">processor</text>
 
292
<polygon style="fill:none;stroke:black;" points="647,361 647,347 833,347 833,361 647,361"/>
 
293
<text text-anchor="middle" style="font-size:8.00;" x="653" y="372">id</text>
 
294
<text text-anchor="middle" style="font-size:8.00;" x="701" y="372">serial</text>
 
295
<text text-anchor="middle" style="font-size:8.00;" x="752" y="372"> PRIMARY KEY </text>
 
296
<text text-anchor="middle" style="font-size:8.00;" x="661" y="386">family</text>
 
297
<text text-anchor="middle" style="font-size:8.00;" x="704" y="386">integer</text>
 
298
<text text-anchor="middle" style="font-size:8.00;" x="777" y="386"> REFERENCES processorfamily </text>
 
299
<text text-anchor="middle" style="font-size:8.00;" x="659" y="400">name</text>
 
300
<text text-anchor="middle" style="font-size:8.00;" x="699" y="400">text</text>
 
301
<text text-anchor="middle" style="font-size:8.00;" x="740" y="400"> UNIQUE </text>
 
302
<text text-anchor="middle" style="font-size:8.00;" x="656" y="414">title</text>
 
303
<text text-anchor="middle" style="font-size:8.00;" x="699" y="414">text</text>
 
304
<text text-anchor="middle" style="font-size:8.00;" x="667" y="428">description</text>
 
305
<text text-anchor="middle" style="font-size:8.00;" x="699" y="428">text</text>
 
306
<polygon style="fill:none;stroke:black;" points="644,434 644,344 836,344 836,434 644,434"/>
 
307
</g>
 
308
<g id="node10" class="node"><title>processorfamily</title>
 
309
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="868,456 868,380 1004,380 1004,456 868,456"/>
 
310
<polygon style="fill:white;stroke:white;" points="871,397 871,383 1001,383 1001,397 871,397"/>
 
311
<text text-anchor="middle" style="font-size:8.00;" x="936" y="393">processorfamily</text>
 
312
<polygon style="fill:none;stroke:black;" points="871,397 871,383 1001,383 1001,397 871,397"/>
 
313
<text text-anchor="middle" style="font-size:8.00;" x="877" y="408">id</text>
 
314
<text text-anchor="middle" style="font-size:8.00;" x="924" y="408">serial</text>
 
315
<text text-anchor="middle" style="font-size:8.00;" x="969" y="408"> PRIMARY KEY </text>
 
316
<text text-anchor="middle" style="font-size:8.00;" x="883" y="422">name</text>
 
317
<text text-anchor="middle" style="font-size:8.00;" x="922" y="422">text</text>
 
318
<text text-anchor="middle" style="font-size:8.00;" x="957" y="422"> UNIQUE </text>
 
319
<text text-anchor="middle" style="font-size:8.00;" x="880" y="436">title</text>
 
320
<text text-anchor="middle" style="font-size:8.00;" x="922" y="436">text</text>
 
321
<text text-anchor="middle" style="font-size:8.00;" x="891" y="450">description</text>
 
322
<text text-anchor="middle" style="font-size:8.00;" x="922" y="450">text</text>
 
323
<polygon style="fill:none;stroke:black;" points="868,456 868,380 1004,380 1004,456 868,456"/>
314
324
</g>
315
325
<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"/>
 
326
<path style="fill:none;stroke:black;" d="M844,404C846,404 848,405 850,405"/>
 
327
<polygon style="fill:black;stroke:black;" points="850,402 860,406 850,408 850,402"/>
318
328
</g>
319
329
<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"/>
 
330
<path style="fill:none;stroke:black;" d="M280,377C282,377 285,376 287,376"/>
 
331
<polygon style="fill:black;stroke:black;" points="287,373 297,374 288,379 287,373"/>
322
332
</g>
323
333
</g>
324
334
</svg>