← Back to branch summary

~launchpad-pqm/launchpad/devel

« back to all changes in this revision

Viewing changes to database/schema/diagrams/calendar.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/calendar.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="535px" height="535px"
7
 
 viewBox = "-1 -1 534 534"
 
6
<svg width="537px" height="535px"
 
7
 viewBox = "-1 -1 536 534"
8
8
 xmlns="http://www.w3.org/2000/svg">
9
 
<g id="graph0" class="graph" transform = "scale(0.484708)"
 
9
<g id="graph0" class="graph" transform = "scale(0.478500)"
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="545" y="1083">Calendar</text>
 
12
<text text-anchor="middle" style="font-size:22.00;" x="554" y="1097">Calendar</text>
13
13
<g id="node1" class="node"><title>calendar</title>
14
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="487,361 487,307 593,307 593,361 487,361"/>
15
 
<polygon style="fill:white;stroke:white;" points="490,322 490,310 590,310 590,322 490,322"/>
16
 
<text text-anchor="middle" style="font-size:6.00;" x="540" y="318">calendar</text>
17
 
<polygon style="fill:none;stroke:black;" points="490,322 490,310 590,310 590,322 490,322"/>
18
 
<text text-anchor="middle" style="font-size:6.00;" x="495" y="331">id</text>
19
 
<text text-anchor="middle" style="font-size:6.00;" x="526" y="331">serial</text>
20
 
<text text-anchor="middle" style="font-size:6.00;" x="566" y="331"> PRIMARY KEY </text>
21
 
<text text-anchor="middle" style="font-size:6.00;" x="498" y="343">title</text>
22
 
<text text-anchor="middle" style="font-size:6.00;" x="525" y="343">text</text>
23
 
<text text-anchor="middle" style="font-size:6.00;" x="503" y="355">revision</text>
24
 
<text text-anchor="middle" style="font-size:6.00;" x="528" y="355">integer</text>
25
 
<polygon style="fill:none;stroke:black;" points="487,361 487,307 593,307 593,361 487,361"/>
 
14
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="500,360 500,306 606,306 606,360 500,360"/>
 
15
<polygon style="fill:white;stroke:white;" points="503,321 503,309 603,309 603,321 503,321"/>
 
16
<text text-anchor="middle" style="font-size:6.00;" x="553" y="317">calendar</text>
 
17
<polygon style="fill:none;stroke:black;" points="503,321 503,309 603,309 603,321 503,321"/>
 
18
<text text-anchor="middle" style="font-size:6.00;" x="508" y="330">id</text>
 
19
<text text-anchor="middle" style="font-size:6.00;" x="539" y="330">serial</text>
 
20
<text text-anchor="middle" style="font-size:6.00;" x="579" y="330"> PRIMARY KEY </text>
 
21
<text text-anchor="middle" style="font-size:6.00;" x="511" y="342">title</text>
 
22
<text text-anchor="middle" style="font-size:6.00;" x="538" y="342">text</text>
 
23
<text text-anchor="middle" style="font-size:6.00;" x="516" y="354">revision</text>
 
24
<text text-anchor="middle" style="font-size:6.00;" x="541" y="354">integer</text>
 
25
<polygon style="fill:none;stroke:black;" points="500,360 500,306 606,306 606,360 500,360"/>
26
26
</g>
27
27
<g id="node2" class="node"><title>calendarevent</title>
28
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="447,133 447,19 619,19 619,133 447,133"/>
29
 
<polygon style="fill:white;stroke:white;" points="450,34 450,22 616,22 616,34 450,34"/>
30
 
<text text-anchor="middle" style="font-size:6.00;" x="533" y="30">calendarevent</text>
31
 
<polygon style="fill:none;stroke:black;" points="450,34 450,22 616,22 616,34 450,34"/>
32
 
<text text-anchor="middle" style="font-size:6.00;" x="455" y="43">id</text>
33
 
<text text-anchor="middle" style="font-size:6.00;" x="494" y="43">serial</text>
34
 
<text text-anchor="middle" style="font-size:6.00;" x="573" y="43"> PRIMARY KEY </text>
35
 
<text text-anchor="middle" style="font-size:6.00;" x="457" y="55">uid</text>
36
 
<text text-anchor="middle" style="font-size:6.00;" x="516" y="55">character varying(255)</text>
37
 
<text text-anchor="middle" style="font-size:6.00;" x="564" y="55"> UNIQUE </text>
38
 
<text text-anchor="middle" style="font-size:6.00;" x="463" y="67">calendar</text>
39
 
<text text-anchor="middle" style="font-size:6.00;" x="496" y="67">integer</text>
40
 
<text text-anchor="middle" style="font-size:6.00;" x="582" y="67"> REFERENCES calendar </text>
41
 
<text text-anchor="middle" style="font-size:6.00;" x="461" y="79">dtstart</text>
42
 
<text text-anchor="middle" style="font-size:6.00;" x="501" y="79">timestamp</text>
43
 
<text text-anchor="middle" style="font-size:6.00;" x="463" y="91">duration</text>
44
 
<text text-anchor="middle" style="font-size:6.00;" x="497" y="91">interval</text>
45
 
<text text-anchor="middle" style="font-size:6.00;" x="458" y="103">title</text>
46
 
<text text-anchor="middle" style="font-size:6.00;" x="493" y="103">text</text>
47
 
<text text-anchor="middle" style="font-size:6.00;" x="467" y="115">description</text>
48
 
<text text-anchor="middle" style="font-size:6.00;" x="493" y="115">text</text>
49
 
<text text-anchor="middle" style="font-size:6.00;" x="463" y="127">location</text>
50
 
<text text-anchor="middle" style="font-size:6.00;" x="493" y="127">text</text>
51
 
<polygon style="fill:none;stroke:black;" points="447,133 447,19 619,19 619,133 447,133"/>
 
28
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="456,133 456,19 628,19 628,133 456,133"/>
 
29
<polygon style="fill:white;stroke:white;" points="459,34 459,22 625,22 625,34 459,34"/>
 
30
<text text-anchor="middle" style="font-size:6.00;" x="542" y="30">calendarevent</text>
 
31
<polygon style="fill:none;stroke:black;" points="459,34 459,22 625,22 625,34 459,34"/>
 
32
<text text-anchor="middle" style="font-size:6.00;" x="464" y="43">id</text>
 
33
<text text-anchor="middle" style="font-size:6.00;" x="503" y="43">serial</text>
 
34
<text text-anchor="middle" style="font-size:6.00;" x="582" y="43"> PRIMARY KEY </text>
 
35
<text text-anchor="middle" style="font-size:6.00;" x="466" y="55">uid</text>
 
36
<text text-anchor="middle" style="font-size:6.00;" x="525" y="55">character varying(255)</text>
 
37
<text text-anchor="middle" style="font-size:6.00;" x="573" y="55"> UNIQUE </text>
 
38
<text text-anchor="middle" style="font-size:6.00;" x="472" y="67">calendar</text>
 
39
<text text-anchor="middle" style="font-size:6.00;" x="505" y="67">integer</text>
 
40
<text text-anchor="middle" style="font-size:6.00;" x="591" y="67"> REFERENCES calendar </text>
 
41
<text text-anchor="middle" style="font-size:6.00;" x="470" y="79">dtstart</text>
 
42
<text text-anchor="middle" style="font-size:6.00;" x="510" y="79">timestamp</text>
 
43
<text text-anchor="middle" style="font-size:6.00;" x="472" y="91">duration</text>
 
44
<text text-anchor="middle" style="font-size:6.00;" x="506" y="91">interval</text>
 
45
<text text-anchor="middle" style="font-size:6.00;" x="467" y="103">title</text>
 
46
<text text-anchor="middle" style="font-size:6.00;" x="502" y="103">text</text>
 
47
<text text-anchor="middle" style="font-size:6.00;" x="476" y="115">description</text>
 
48
<text text-anchor="middle" style="font-size:6.00;" x="502" y="115">text</text>
 
49
<text text-anchor="middle" style="font-size:6.00;" x="472" y="127">location</text>
 
50
<text text-anchor="middle" style="font-size:6.00;" x="502" y="127">text</text>
 
51
<polygon style="fill:none;stroke:black;" points="456,133 456,19 628,19 628,133 456,133"/>
52
52
</g>
53
53
<g id="edge2" class="edge"><title>calendarevent&#45;&gt;calendar</title>
54
 
<path style="fill:none;stroke:black;" d="M535,137C536,185 538,251 539,293"/>
55
 
<polygon style="fill:black;stroke:black;" points="543,293 539,303 536,293 543,293"/>
 
54
<path style="fill:none;stroke:black;" d="M545,137C547,185 550,250 552,292"/>
 
55
<polygon style="fill:black;stroke:black;" points="556,292 552,302 549,292 556,292"/>
56
56
</g>
57
57
<g id="node3" class="node"><title>calendarsubscription</title>
58
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="302,507 302,441 448,441 448,507 302,507"/>
59
 
<polygon style="fill:white;stroke:white;" points="305,456 305,444 445,444 445,456 305,456"/>
60
 
<text text-anchor="middle" style="font-size:6.00;" x="375" y="452">calendarsubscription</text>
61
 
<polygon style="fill:none;stroke:black;" points="305,456 305,444 445,444 445,456 305,456"/>
62
 
<text text-anchor="middle" style="font-size:6.00;" x="310" y="465">id</text>
63
 
<text text-anchor="middle" style="font-size:6.00;" x="338" y="465">serial</text>
64
 
<text text-anchor="middle" style="font-size:6.00;" x="378" y="465"> PRIMARY KEY </text>
65
 
<text text-anchor="middle" style="font-size:6.00;" x="316" y="477">subject</text>
66
 
<text text-anchor="middle" style="font-size:6.00;" x="340" y="477">integer</text>
67
 
<text text-anchor="middle" style="font-size:6.00;" x="399" y="477"> REFERENCES calendar UNIQUE </text>
68
 
<text text-anchor="middle" style="font-size:6.00;" x="316" y="489">object</text>
69
 
<text text-anchor="middle" style="font-size:6.00;" x="340" y="489">integer</text>
70
 
<text text-anchor="middle" style="font-size:6.00;" x="399" y="489"> REFERENCES calendar UNIQUE </text>
71
 
<text text-anchor="middle" style="font-size:6.00;" x="316" y="501">colour</text>
72
 
<text text-anchor="middle" style="font-size:6.00;" x="337" y="501">text</text>
73
 
<polygon style="fill:none;stroke:black;" points="302,507 302,441 448,441 448,507 302,507"/>
 
58
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="328,517 328,451 474,451 474,517 328,517"/>
 
59
<polygon style="fill:white;stroke:white;" points="331,466 331,454 471,454 471,466 331,466"/>
 
60
<text text-anchor="middle" style="font-size:6.00;" x="401" y="462">calendarsubscription</text>
 
61
<polygon style="fill:none;stroke:black;" points="331,466 331,454 471,454 471,466 331,466"/>
 
62
<text text-anchor="middle" style="font-size:6.00;" x="336" y="475">id</text>
 
63
<text text-anchor="middle" style="font-size:6.00;" x="364" y="475">serial</text>
 
64
<text text-anchor="middle" style="font-size:6.00;" x="404" y="475"> PRIMARY KEY </text>
 
65
<text text-anchor="middle" style="font-size:6.00;" x="342" y="487">subject</text>
 
66
<text text-anchor="middle" style="font-size:6.00;" x="366" y="487">integer</text>
 
67
<text text-anchor="middle" style="font-size:6.00;" x="425" y="487"> REFERENCES calendar UNIQUE </text>
 
68
<text text-anchor="middle" style="font-size:6.00;" x="342" y="499">object</text>
 
69
<text text-anchor="middle" style="font-size:6.00;" x="366" y="499">integer</text>
 
70
<text text-anchor="middle" style="font-size:6.00;" x="425" y="499"> REFERENCES calendar UNIQUE </text>
 
71
<text text-anchor="middle" style="font-size:6.00;" x="342" y="511">colour</text>
 
72
<text text-anchor="middle" style="font-size:6.00;" x="363" y="511">text</text>
 
73
<polygon style="fill:none;stroke:black;" points="328,517 328,451 474,451 474,517 328,517"/>
74
74
</g>
75
75
<g id="edge4" class="edge"><title>calendarsubscription&#45;&gt;calendar</title>
76
 
<path style="fill:none;stroke:black;" d="M410,437C433,417 462,392 486,371"/>
77
 
<polygon style="fill:black;stroke:black;" points="484,368 494,365 488,374 484,368"/>
 
76
<path style="fill:none;stroke:black;" d="M430,447C452,424 481,394 506,371"/>
 
77
<polygon style="fill:black;stroke:black;" points="503,369 513,364 508,374 503,369"/>
78
78
</g>
79
79
<g id="edge6" class="edge"><title>calendarsubscription&#45;&gt;calendar</title>
80
 
<path style="fill:none;stroke:black;" d="M428,437C452,417 481,392 503,372"/>
81
 
<polygon style="fill:black;stroke:black;" points="501,369 511,365 506,374 501,369"/>
 
80
<path style="fill:none;stroke:black;" d="M446,447C470,424 499,395 521,372"/>
 
81
<polygon style="fill:black;stroke:black;" points="519,369 528,364 524,374 519,369"/>
82
82
</g>
83
83
<g id="node4" class="node"><title>person</title>
84
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="475,903 475,537 677,537 677,903 475,903"/>
85
 
<polygon style="fill:white;stroke:white;" points="478,552 478,540 674,540 674,552 478,552"/>
86
 
<text text-anchor="middle" style="font-size:6.00;" x="576" y="548">person</text>
87
 
<polygon style="fill:none;stroke:black;" points="478,552 478,540 674,540 674,552 478,552"/>
88
 
<text text-anchor="middle" style="font-size:6.00;" x="483" y="561">id</text>
89
 
<text text-anchor="middle" style="font-size:6.00;" x="558" y="561">serial</text>
90
 
<text text-anchor="middle" style="font-size:6.00;" x="607" y="561"> PRIMARY KEY </text>
91
 
<text text-anchor="middle" style="font-size:6.00;" x="496" y="573">displayname</text>
92
 
<text text-anchor="middle" style="font-size:6.00;" x="557" y="573">text</text>
93
 
<text text-anchor="middle" style="font-size:6.00;" x="494" y="585">givenname</text>
94
 
<text text-anchor="middle" style="font-size:6.00;" x="557" y="585">text</text>
95
 
<text text-anchor="middle" style="font-size:6.00;" x="495" y="597">familyname</text>
96
 
<text text-anchor="middle" style="font-size:6.00;" x="557" y="597">text</text>
97
 
<text text-anchor="middle" style="font-size:6.00;" x="492" y="609">password</text>
98
 
<text text-anchor="middle" style="font-size:6.00;" x="557" y="609">text</text>
99
 
<text text-anchor="middle" style="font-size:6.00;" x="494" y="621">teamowner</text>
100
 
<text text-anchor="middle" style="font-size:6.00;" x="560" y="621">integer</text>
101
 
<text text-anchor="middle" style="font-size:6.00;" x="614" y="621"> REFERENCES person </text>
102
 
<text text-anchor="middle" style="font-size:6.00;" x="501" y="633">teamdescription</text>
103
 
<text text-anchor="middle" style="font-size:6.00;" x="557" y="633">text</text>
104
 
<text text-anchor="middle" style="font-size:6.00;" x="488" y="645">name</text>
105
 
<text text-anchor="middle" style="font-size:6.00;" x="557" y="645">text</text>
106
 
<text text-anchor="middle" style="font-size:6.00;" x="492" y="657">language</text>
107
 
<text text-anchor="middle" style="font-size:6.00;" x="560" y="657">integer</text>
108
 
<text text-anchor="middle" style="font-size:6.00;" x="617" y="657"> REFERENCES language </text>
109
 
<text text-anchor="middle" style="font-size:6.00;" x="484" y="669">fti</text>
110
 
<text text-anchor="middle" style="font-size:6.00;" x="562" y="669">tsvector</text>
111
 
<text text-anchor="middle" style="font-size:6.00;" x="512" y="681">defaultmembershipperiod</text>
112
 
<text text-anchor="middle" style="font-size:6.00;" x="560" y="681">integer</text>
113
 
<text text-anchor="middle" style="font-size:6.00;" x="507" y="693">defaultrenewalperiod</text>
114
 
<text text-anchor="middle" style="font-size:6.00;" x="560" y="693">integer</text>
115
 
<text text-anchor="middle" style="font-size:6.00;" x="503" y="705">subscriptionpolicy</text>
116
 
<text text-anchor="middle" style="font-size:6.00;" x="560" y="705">integer</text>
117
 
<text text-anchor="middle" style="font-size:6.00;" x="490" y="717">merged</text>
118
 
<text text-anchor="middle" style="font-size:6.00;" x="560" y="717">integer</text>
119
 
<text text-anchor="middle" style="font-size:6.00;" x="614" y="717"> REFERENCES person </text>
120
 
<text text-anchor="middle" style="font-size:6.00;" x="495" y="729">datecreated</text>
121
 
<text text-anchor="middle" style="font-size:6.00;" x="565" y="729">timestamp</text>
122
 
<text text-anchor="middle" style="font-size:6.00;" x="491" y="741">calendar</text>
123
 
<text text-anchor="middle" style="font-size:6.00;" x="560" y="741">integer</text>
124
 
<text text-anchor="middle" style="font-size:6.00;" x="628" y="741"> REFERENCES calendar UNIQUE </text>
125
 
<text text-anchor="middle" style="font-size:6.00;" x="492" y="753">timezone</text>
126
 
<text text-anchor="middle" style="font-size:6.00;" x="557" y="753">text</text>
127
 
<text text-anchor="middle" style="font-size:6.00;" x="489" y="765">karma</text>
128
 
<text text-anchor="middle" style="font-size:6.00;" x="560" y="765">integer</text>
129
 
<text text-anchor="middle" style="font-size:6.00;" x="496" y="777">addressline1</text>
130
 
<text text-anchor="middle" style="font-size:6.00;" x="557" y="777">text</text>
131
 
<text text-anchor="middle" style="font-size:6.00;" x="496" y="789">addressline2</text>
132
 
<text text-anchor="middle" style="font-size:6.00;" x="557" y="789">text</text>
133
 
<text text-anchor="middle" style="font-size:6.00;" x="496" y="801">organization</text>
134
 
<text text-anchor="middle" style="font-size:6.00;" x="557" y="801">text</text>
135
 
<text text-anchor="middle" style="font-size:6.00;" x="486" y="813">city</text>
136
 
<text text-anchor="middle" style="font-size:6.00;" x="557" y="813">text</text>
137
 
<text text-anchor="middle" style="font-size:6.00;" x="492" y="825">province</text>
138
 
<text text-anchor="middle" style="font-size:6.00;" x="557" y="825">text</text>
139
 
<text text-anchor="middle" style="font-size:6.00;" x="491" y="837">country</text>
140
 
<text text-anchor="middle" style="font-size:6.00;" x="560" y="837">integer</text>
141
 
<text text-anchor="middle" style="font-size:6.00;" x="616" y="837"> REFERENCES country </text>
142
 
<text text-anchor="middle" style="font-size:6.00;" x="492" y="849">postcode</text>
143
 
<text text-anchor="middle" style="font-size:6.00;" x="557" y="849">text</text>
144
 
<text text-anchor="middle" style="font-size:6.00;" x="489" y="861">phone</text>
145
 
<text text-anchor="middle" style="font-size:6.00;" x="557" y="861">text</text>
146
 
<text text-anchor="middle" style="font-size:6.00;" x="504" y="873">homepage_content</text>
147
 
<text text-anchor="middle" style="font-size:6.00;" x="557" y="873">text</text>
148
 
<text text-anchor="middle" style="font-size:6.00;" x="491" y="885">emblem</text>
149
 
<text text-anchor="middle" style="font-size:6.00;" x="560" y="885">integer</text>
150
 
<text text-anchor="middle" style="font-size:6.00;" x="624" y="885"> REFERENCES libraryfilealias </text>
151
 
<text text-anchor="middle" style="font-size:6.00;" x="497" y="897">hackergotchi</text>
152
 
<text text-anchor="middle" style="font-size:6.00;" x="560" y="897">integer</text>
153
 
<text text-anchor="middle" style="font-size:6.00;" x="624" y="897"> REFERENCES libraryfilealias </text>
154
 
<polygon style="fill:none;stroke:black;" points="475,903 475,537 677,537 677,903 475,903"/>
 
84
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="479,913 479,547 681,547 681,913 479,913"/>
 
85
<polygon style="fill:white;stroke:white;" points="482,562 482,550 678,550 678,562 482,562"/>
 
86
<text text-anchor="middle" style="font-size:6.00;" x="580" y="558">person</text>
 
87
<polygon style="fill:none;stroke:black;" points="482,562 482,550 678,550 678,562 482,562"/>
 
88
<text text-anchor="middle" style="font-size:6.00;" x="487" y="571">id</text>
 
89
<text text-anchor="middle" style="font-size:6.00;" x="562" y="571">serial</text>
 
90
<text text-anchor="middle" style="font-size:6.00;" x="611" y="571"> PRIMARY KEY </text>
 
91
<text text-anchor="middle" style="font-size:6.00;" x="500" y="583">displayname</text>
 
92
<text text-anchor="middle" style="font-size:6.00;" x="561" y="583">text</text>
 
93
<text text-anchor="middle" style="font-size:6.00;" x="498" y="595">givenname</text>
 
94
<text text-anchor="middle" style="font-size:6.00;" x="561" y="595">text</text>
 
95
<text text-anchor="middle" style="font-size:6.00;" x="499" y="607">familyname</text>
 
96
<text text-anchor="middle" style="font-size:6.00;" x="561" y="607">text</text>
 
97
<text text-anchor="middle" style="font-size:6.00;" x="496" y="619">password</text>
 
98
<text text-anchor="middle" style="font-size:6.00;" x="561" y="619">text</text>
 
99
<text text-anchor="middle" style="font-size:6.00;" x="498" y="631">teamowner</text>
 
100
<text text-anchor="middle" style="font-size:6.00;" x="564" y="631">integer</text>
 
101
<text text-anchor="middle" style="font-size:6.00;" x="618" y="631"> REFERENCES person </text>
 
102
<text text-anchor="middle" style="font-size:6.00;" x="505" y="643">teamdescription</text>
 
103
<text text-anchor="middle" style="font-size:6.00;" x="561" y="643">text</text>
 
104
<text text-anchor="middle" style="font-size:6.00;" x="492" y="655">name</text>
 
105
<text text-anchor="middle" style="font-size:6.00;" x="561" y="655">text</text>
 
106
<text text-anchor="middle" style="font-size:6.00;" x="496" y="667">language</text>
 
107
<text text-anchor="middle" style="font-size:6.00;" x="564" y="667">integer</text>
 
108
<text text-anchor="middle" style="font-size:6.00;" x="621" y="667"> REFERENCES language </text>
 
109
<text text-anchor="middle" style="font-size:6.00;" x="488" y="679">fti</text>
 
110
<text text-anchor="middle" style="font-size:6.00;" x="566" y="679">tsvector</text>
 
111
<text text-anchor="middle" style="font-size:6.00;" x="516" y="691">defaultmembershipperiod</text>
 
112
<text text-anchor="middle" style="font-size:6.00;" x="564" y="691">integer</text>
 
113
<text text-anchor="middle" style="font-size:6.00;" x="511" y="703">defaultrenewalperiod</text>
 
114
<text text-anchor="middle" style="font-size:6.00;" x="564" y="703">integer</text>
 
115
<text text-anchor="middle" style="font-size:6.00;" x="507" y="715">subscriptionpolicy</text>
 
116
<text text-anchor="middle" style="font-size:6.00;" x="564" y="715">integer</text>
 
117
<text text-anchor="middle" style="font-size:6.00;" x="494" y="727">merged</text>
 
118
<text text-anchor="middle" style="font-size:6.00;" x="564" y="727">integer</text>
 
119
<text text-anchor="middle" style="font-size:6.00;" x="618" y="727"> REFERENCES person </text>
 
120
<text text-anchor="middle" style="font-size:6.00;" x="499" y="739">datecreated</text>
 
121
<text text-anchor="middle" style="font-size:6.00;" x="569" y="739">timestamp</text>
 
122
<text text-anchor="middle" style="font-size:6.00;" x="495" y="751">calendar</text>
 
123
<text text-anchor="middle" style="font-size:6.00;" x="564" y="751">integer</text>
 
124
<text text-anchor="middle" style="font-size:6.00;" x="632" y="751"> REFERENCES calendar UNIQUE </text>
 
125
<text text-anchor="middle" style="font-size:6.00;" x="496" y="763">timezone</text>
 
126
<text text-anchor="middle" style="font-size:6.00;" x="561" y="763">text</text>
 
127
<text text-anchor="middle" style="font-size:6.00;" x="493" y="775">karma</text>
 
128
<text text-anchor="middle" style="font-size:6.00;" x="564" y="775">integer</text>
 
129
<text text-anchor="middle" style="font-size:6.00;" x="500" y="787">addressline1</text>
 
130
<text text-anchor="middle" style="font-size:6.00;" x="561" y="787">text</text>
 
131
<text text-anchor="middle" style="font-size:6.00;" x="500" y="799">addressline2</text>
 
132
<text text-anchor="middle" style="font-size:6.00;" x="561" y="799">text</text>
 
133
<text text-anchor="middle" style="font-size:6.00;" x="500" y="811">organization</text>
 
134
<text text-anchor="middle" style="font-size:6.00;" x="561" y="811">text</text>
 
135
<text text-anchor="middle" style="font-size:6.00;" x="490" y="823">city</text>
 
136
<text text-anchor="middle" style="font-size:6.00;" x="561" y="823">text</text>
 
137
<text text-anchor="middle" style="font-size:6.00;" x="496" y="835">province</text>
 
138
<text text-anchor="middle" style="font-size:6.00;" x="561" y="835">text</text>
 
139
<text text-anchor="middle" style="font-size:6.00;" x="495" y="847">country</text>
 
140
<text text-anchor="middle" style="font-size:6.00;" x="564" y="847">integer</text>
 
141
<text text-anchor="middle" style="font-size:6.00;" x="620" y="847"> REFERENCES country </text>
 
142
<text text-anchor="middle" style="font-size:6.00;" x="496" y="859">postcode</text>
 
143
<text text-anchor="middle" style="font-size:6.00;" x="561" y="859">text</text>
 
144
<text text-anchor="middle" style="font-size:6.00;" x="493" y="871">phone</text>
 
145
<text text-anchor="middle" style="font-size:6.00;" x="561" y="871">text</text>
 
146
<text text-anchor="middle" style="font-size:6.00;" x="508" y="883">homepage_content</text>
 
147
<text text-anchor="middle" style="font-size:6.00;" x="561" y="883">text</text>
 
148
<text text-anchor="middle" style="font-size:6.00;" x="495" y="895">emblem</text>
 
149
<text text-anchor="middle" style="font-size:6.00;" x="564" y="895">integer</text>
 
150
<text text-anchor="middle" style="font-size:6.00;" x="628" y="895"> REFERENCES libraryfilealias </text>
 
151
<text text-anchor="middle" style="font-size:6.00;" x="501" y="907">hackergotchi</text>
 
152
<text text-anchor="middle" style="font-size:6.00;" x="564" y="907">integer</text>
 
153
<text text-anchor="middle" style="font-size:6.00;" x="628" y="907"> REFERENCES libraryfilealias </text>
 
154
<polygon style="fill:none;stroke:black;" points="479,913 479,547 681,547 681,913 479,913"/>
155
155
</g>
156
156
<g id="edge14" class="edge"><title>person&#45;&gt;calendar</title>
157
 
<path style="fill:none;stroke:black;" d="M559,533C553,474 547,413 544,375"/>
158
 
<polygon style="fill:black;stroke:black;" points="541,375 543,365 547,375 541,375"/>
 
157
<path style="fill:none;stroke:black;" d="M567,543C562,480 559,415 556,374"/>
 
158
<polygon style="fill:black;stroke:black;" points="553,374 555,364 559,374 553,374"/>
159
159
</g>
160
160
<g id="edge8" class="edge"><title>person&#45;&gt;person</title>
161
 
<path style="fill:none;stroke:black;" d="M685,777C696,765 703,747 703,720 703,698 699,683 691,671"/>
162
 
<polygon style="fill:black;stroke:black;" points="688,673 685,663 694,669 688,673"/>
 
161
<path style="fill:none;stroke:black;" d="M689,787C700,775 707,757 707,730 707,708 703,693 695,681"/>
 
162
<polygon style="fill:black;stroke:black;" points="692,683 689,673 698,679 692,683"/>
163
163
</g>
164
164
<g id="edge12" class="edge"><title>person&#45;&gt;person</title>
165
 
<path style="fill:none;stroke:black;" d="M685,853C706,837 721,793 721,720 721,656 709,614 692,594"/>
166
 
<polygon style="fill:black;stroke:black;" points="690,597 685,587 695,592 690,597"/>
167
 
</g>
168
 
<g id="node11" class="node"><title>fake_language_168</title>
169
 
<ellipse cx="316" cy="857" rx="27" ry="18" style="fill:none;stroke:red;"/>
170
 
<text text-anchor="middle" style="font-size:6.00;" x="316" y="859">language</text>
171
 
</g>
172
 
<g id="edge10" class="edge"><title>person&#45;&gt;fake_language_168</title>
173
 
<path style="fill:none;stroke:black;" d="M467,778C424,801 376,826 347,841"/>
174
 
<polygon style="fill:black;stroke:black;" points="348,844 338,846 345,838 348,844"/>
175
 
</g>
176
 
<g id="node15" class="node"><title>fake_country_172</title>
177
 
<ellipse cx="890" cy="826" rx="27" ry="18" style="fill:none;stroke:red;"/>
178
 
<text text-anchor="middle" style="font-size:6.00;" x="890" y="828">country</text>
179
 
</g>
180
 
<g id="edge16" class="edge"><title>person&#45;&gt;fake_country_172</title>
181
 
<path style="fill:none;stroke:black;" d="M685,757C745,777 815,801 856,815"/>
182
 
<polygon style="fill:black;stroke:black;" points="857,812 866,818 855,818 857,812"/>
183
 
</g>
184
 
<g id="node17" class="node"><title>fake_libraryfilealias_174</title>
185
 
<ellipse cx="452" cy="1040" rx="29" ry="18" style="fill:none;stroke:red;"/>
186
 
<text text-anchor="middle" style="font-size:6.00;" x="452" y="1042">libraryfilealias</text>
187
 
</g>
188
 
<g id="edge18" class="edge"><title>person&#45;&gt;fake_libraryfilealias_174</title>
189
 
<path style="fill:none;stroke:black;" d="M504,907C487,949 472,988 463,1012"/>
190
 
<polygon style="fill:black;stroke:black;" points="466,1014 459,1022 459,1011 466,1014"/>
191
 
</g>
192
 
<g id="node19" class="node"><title>fake_libraryfilealias_176</title>
193
 
<ellipse cx="711" cy="1029" rx="29" ry="18" style="fill:none;stroke:red;"/>
194
 
<text text-anchor="middle" style="font-size:6.00;" x="711" y="1031">libraryfilealias</text>
195
 
</g>
196
 
<g id="edge20" class="edge"><title>person&#45;&gt;fake_libraryfilealias_176</title>
197
 
<path style="fill:none;stroke:black;" d="M658,907C675,944 690,980 699,1003"/>
198
 
<polygon style="fill:black;stroke:black;" points="702,1001 703,1012 696,1004 702,1001"/>
 
165
<path style="fill:none;stroke:black;" d="M689,863C710,847 725,803 725,730 725,666 713,624 696,604"/>
 
166
<polygon style="fill:black;stroke:black;" points="694,607 689,597 699,602 694,607"/>
 
167
</g>
 
168
<g id="node11" class="node"><title>fake_language_173</title>
 
169
<ellipse cx="293" cy="899" rx="27" ry="18" style="fill:none;stroke:red;"/>
 
170
<text text-anchor="middle" style="font-size:6.00;" x="293" y="901">language</text>
 
171
</g>
 
172
<g id="edge10" class="edge"><title>person&#45;&gt;fake_language_173</title>
 
173
<path style="fill:none;stroke:black;" d="M471,794C418,825 357,861 323,882"/>
 
174
<polygon style="fill:black;stroke:black;" points="324,885 314,887 321,879 324,885"/>
 
175
</g>
 
176
<g id="node15" class="node"><title>fake_country_177</title>
 
177
<ellipse cx="899" cy="833" rx="27" ry="18" style="fill:none;stroke:red;"/>
 
178
<text text-anchor="middle" style="font-size:6.00;" x="899" y="835">country</text>
 
179
</g>
 
180
<g id="edge16" class="edge"><title>person&#45;&gt;fake_country_177</title>
 
181
<path style="fill:none;stroke:black;" d="M689,765C751,785 824,808 865,822"/>
 
182
<polygon style="fill:black;stroke:black;" points="866,819 875,825 864,825 866,819"/>
 
183
</g>
 
184
<g id="node17" class="node"><title>fake_libraryfilealias_179</title>
 
185
<ellipse cx="486" cy="1054" rx="29" ry="18" style="fill:none;stroke:red;"/>
 
186
<text text-anchor="middle" style="font-size:6.00;" x="486" y="1056">libraryfilealias</text>
 
187
</g>
 
188
<g id="edge18" class="edge"><title>person&#45;&gt;fake_libraryfilealias_179</title>
 
189
<path style="fill:none;stroke:black;" d="M526,917C514,960 501,1001 494,1026"/>
 
190
<polygon style="fill:black;stroke:black;" points="497,1027 491,1036 491,1025 497,1027"/>
 
191
</g>
 
192
<g id="node19" class="node"><title>fake_libraryfilealias_181</title>
 
193
<ellipse cx="734" cy="1031" rx="29" ry="18" style="fill:none;stroke:red;"/>
 
194
<text text-anchor="middle" style="font-size:6.00;" x="734" y="1033">libraryfilealias</text>
 
195
</g>
 
196
<g id="edge20" class="edge"><title>person&#45;&gt;fake_libraryfilealias_181</title>
 
197
<path style="fill:none;stroke:black;" d="M676,917C693,952 710,983 721,1005"/>
 
198
<polygon style="fill:black;stroke:black;" points="724,1003 725,1014 718,1006 724,1003"/>
199
199
</g>
200
200
<g id="node5" class="node"><title>product</title>
201
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="664,423 664,69 856,69 856,423 664,423"/>
202
 
<polygon style="fill:white;stroke:white;" points="667,84 667,72 853,72 853,84 667,84"/>
203
 
<text text-anchor="middle" style="font-size:6.00;" x="760" y="80">product</text>
204
 
<polygon style="fill:none;stroke:black;" points="667,84 667,72 853,72 853,84 667,84"/>
205
 
<text text-anchor="middle" style="font-size:6.00;" x="672" y="93">id</text>
206
 
<text text-anchor="middle" style="font-size:6.00;" x="737" y="93">serial</text>
207
 
<text text-anchor="middle" style="font-size:6.00;" x="786" y="93"> PRIMARY KEY </text>
208
 
<text text-anchor="middle" style="font-size:6.00;" x="678" y="105">project</text>
209
 
<text text-anchor="middle" style="font-size:6.00;" x="739" y="105">integer</text>
210
 
<text text-anchor="middle" style="font-size:6.00;" x="793" y="105"> REFERENCES project </text>
211
 
<text text-anchor="middle" style="font-size:6.00;" x="678" y="117">owner</text>
212
 
<text text-anchor="middle" style="font-size:6.00;" x="739" y="117">integer</text>
213
 
<text text-anchor="middle" style="font-size:6.00;" x="793" y="117"> REFERENCES person </text>
214
 
<text text-anchor="middle" style="font-size:6.00;" x="677" y="129">name</text>
215
 
<text text-anchor="middle" style="font-size:6.00;" x="736" y="129">text</text>
216
 
<text text-anchor="middle" style="font-size:6.00;" x="777" y="129"> UNIQUE </text>
217
 
<text text-anchor="middle" style="font-size:6.00;" x="685" y="141">displayname</text>
218
 
<text text-anchor="middle" style="font-size:6.00;" x="736" y="141">text</text>
219
 
<text text-anchor="middle" style="font-size:6.00;" x="675" y="153">title</text>
220
 
<text text-anchor="middle" style="font-size:6.00;" x="736" y="153">text</text>
221
 
<text text-anchor="middle" style="font-size:6.00;" x="681" y="165">summary</text>
222
 
<text text-anchor="middle" style="font-size:6.00;" x="736" y="165">text</text>
223
 
<text text-anchor="middle" style="font-size:6.00;" x="684" y="177">description</text>
224
 
<text text-anchor="middle" style="font-size:6.00;" x="736" y="177">text</text>
225
 
<text text-anchor="middle" style="font-size:6.00;" x="684" y="189">datecreated</text>
226
 
<text text-anchor="middle" style="font-size:6.00;" x="744" y="189">timestamp</text>
227
 
<text text-anchor="middle" style="font-size:6.00;" x="686" y="201">homepageurl</text>
228
 
<text text-anchor="middle" style="font-size:6.00;" x="736" y="201">text</text>
229
 
<text text-anchor="middle" style="font-size:6.00;" x="687" y="213">screenshotsurl</text>
230
 
<text text-anchor="middle" style="font-size:6.00;" x="736" y="213">text</text>
231
 
<text text-anchor="middle" style="font-size:6.00;" x="679" y="225">wikiurl</text>
232
 
<text text-anchor="middle" style="font-size:6.00;" x="736" y="225">text</text>
233
 
<text text-anchor="middle" style="font-size:6.00;" x="677" y="237">listurl</text>
234
 
<text text-anchor="middle" style="font-size:6.00;" x="736" y="237">text</text>
235
 
<text text-anchor="middle" style="font-size:6.00;" x="692" y="249">programminglang</text>
236
 
<text text-anchor="middle" style="font-size:6.00;" x="736" y="249">text</text>
237
 
<text text-anchor="middle" style="font-size:6.00;" x="685" y="261">downloadurl</text>
238
 
<text text-anchor="middle" style="font-size:6.00;" x="736" y="261">text</text>
239
 
<text text-anchor="middle" style="font-size:6.00;" x="680" y="273">lastdoap</text>
240
 
<text text-anchor="middle" style="font-size:6.00;" x="736" y="273">text</text>
241
 
<text text-anchor="middle" style="font-size:6.00;" x="692" y="285">sourceforgeproject</text>
242
 
<text text-anchor="middle" style="font-size:6.00;" x="736" y="285">text</text>
243
 
<text text-anchor="middle" style="font-size:6.00;" x="690" y="297">freshmeatproject</text>
244
 
<text text-anchor="middle" style="font-size:6.00;" x="736" y="297">text</text>
245
 
<text text-anchor="middle" style="font-size:6.00;" x="681" y="309">reviewed</text>
246
 
<text text-anchor="middle" style="font-size:6.00;" x="741" y="309">boolean</text>
247
 
<text text-anchor="middle" style="font-size:6.00;" x="677" y="321">active</text>
248
 
<text text-anchor="middle" style="font-size:6.00;" x="741" y="321">boolean</text>
249
 
<text text-anchor="middle" style="font-size:6.00;" x="673" y="333">fti</text>
250
 
<text text-anchor="middle" style="font-size:6.00;" x="741" y="333">tsvector</text>
251
 
<text text-anchor="middle" style="font-size:6.00;" x="684" y="345">autoupdate</text>
252
 
<text text-anchor="middle" style="font-size:6.00;" x="741" y="345">boolean</text>
253
 
<text text-anchor="middle" style="font-size:6.00;" x="690" y="357">translationgroup</text>
254
 
<text text-anchor="middle" style="font-size:6.00;" x="739" y="357">integer</text>
255
 
<text text-anchor="middle" style="font-size:6.00;" x="805" y="357"> REFERENCES translationgroup </text>
256
 
<text text-anchor="middle" style="font-size:6.00;" x="696" y="369">translationpermission</text>
257
 
<text text-anchor="middle" style="font-size:6.00;" x="739" y="369">integer</text>
258
 
<text text-anchor="middle" style="font-size:6.00;" x="683" y="381">releaseroot</text>
259
 
<text text-anchor="middle" style="font-size:6.00;" x="736" y="381">text</text>
260
 
<text text-anchor="middle" style="font-size:6.00;" x="680" y="393">calendar</text>
261
 
<text text-anchor="middle" style="font-size:6.00;" x="739" y="393">integer</text>
262
 
<text text-anchor="middle" style="font-size:6.00;" x="807" y="393"> REFERENCES calendar UNIQUE </text>
263
 
<text text-anchor="middle" style="font-size:6.00;" x="688" y="405">official_rosetta</text>
264
 
<text text-anchor="middle" style="font-size:6.00;" x="741" y="405">boolean</text>
265
 
<text text-anchor="middle" style="font-size:6.00;" x="689" y="417">official_malone</text>
266
 
<text text-anchor="middle" style="font-size:6.00;" x="741" y="417">boolean</text>
267
 
<polygon style="fill:none;stroke:black;" points="664,423 664,69 856,69 856,423 664,423"/>
 
201
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="680,423 680,57 872,57 872,423 680,423"/>
 
202
<polygon style="fill:white;stroke:white;" points="683,72 683,60 869,60 869,72 683,72"/>
 
203
<text text-anchor="middle" style="font-size:6.00;" x="776" y="68">product</text>
 
204
<polygon style="fill:none;stroke:black;" points="683,72 683,60 869,60 869,72 683,72"/>
 
205
<text text-anchor="middle" style="font-size:6.00;" x="688" y="81">id</text>
 
206
<text text-anchor="middle" style="font-size:6.00;" x="753" y="81">serial</text>
 
207
<text text-anchor="middle" style="font-size:6.00;" x="802" y="81"> PRIMARY KEY </text>
 
208
<text text-anchor="middle" style="font-size:6.00;" x="694" y="93">project</text>
 
209
<text text-anchor="middle" style="font-size:6.00;" x="755" y="93">integer</text>
 
210
<text text-anchor="middle" style="font-size:6.00;" x="809" y="93"> REFERENCES project </text>
 
211
<text text-anchor="middle" style="font-size:6.00;" x="694" y="105">owner</text>
 
212
<text text-anchor="middle" style="font-size:6.00;" x="755" y="105">integer</text>
 
213
<text text-anchor="middle" style="font-size:6.00;" x="809" y="105"> REFERENCES person </text>
 
214
<text text-anchor="middle" style="font-size:6.00;" x="693" y="117">name</text>
 
215
<text text-anchor="middle" style="font-size:6.00;" x="752" y="117">text</text>
 
216
<text text-anchor="middle" style="font-size:6.00;" x="793" y="117"> UNIQUE </text>
 
217
<text text-anchor="middle" style="font-size:6.00;" x="701" y="129">displayname</text>
 
218
<text text-anchor="middle" style="font-size:6.00;" x="752" y="129">text</text>
 
219
<text text-anchor="middle" style="font-size:6.00;" x="691" y="141">title</text>
 
220
<text text-anchor="middle" style="font-size:6.00;" x="752" y="141">text</text>
 
221
<text text-anchor="middle" style="font-size:6.00;" x="697" y="153">summary</text>
 
222
<text text-anchor="middle" style="font-size:6.00;" x="752" y="153">text</text>
 
223
<text text-anchor="middle" style="font-size:6.00;" x="700" y="165">description</text>
 
224
<text text-anchor="middle" style="font-size:6.00;" x="752" y="165">text</text>
 
225
<text text-anchor="middle" style="font-size:6.00;" x="700" y="177">datecreated</text>
 
226
<text text-anchor="middle" style="font-size:6.00;" x="760" y="177">timestamp</text>
 
227
<text text-anchor="middle" style="font-size:6.00;" x="702" y="189">homepageurl</text>
 
228
<text text-anchor="middle" style="font-size:6.00;" x="752" y="189">text</text>
 
229
<text text-anchor="middle" style="font-size:6.00;" x="703" y="201">screenshotsurl</text>
 
230
<text text-anchor="middle" style="font-size:6.00;" x="752" y="201">text</text>
 
231
<text text-anchor="middle" style="font-size:6.00;" x="695" y="213">wikiurl</text>
 
232
<text text-anchor="middle" style="font-size:6.00;" x="752" y="213">text</text>
 
233
<text text-anchor="middle" style="font-size:6.00;" x="693" y="225">listurl</text>
 
234
<text text-anchor="middle" style="font-size:6.00;" x="752" y="225">text</text>
 
235
<text text-anchor="middle" style="font-size:6.00;" x="708" y="237">programminglang</text>
 
236
<text text-anchor="middle" style="font-size:6.00;" x="752" y="237">text</text>
 
237
<text text-anchor="middle" style="font-size:6.00;" x="701" y="249">downloadurl</text>
 
238
<text text-anchor="middle" style="font-size:6.00;" x="752" y="249">text</text>
 
239
<text text-anchor="middle" style="font-size:6.00;" x="696" y="261">lastdoap</text>
 
240
<text text-anchor="middle" style="font-size:6.00;" x="752" y="261">text</text>
 
241
<text text-anchor="middle" style="font-size:6.00;" x="708" y="273">sourceforgeproject</text>
 
242
<text text-anchor="middle" style="font-size:6.00;" x="752" y="273">text</text>
 
243
<text text-anchor="middle" style="font-size:6.00;" x="706" y="285">freshmeatproject</text>
 
244
<text text-anchor="middle" style="font-size:6.00;" x="752" y="285">text</text>
 
245
<text text-anchor="middle" style="font-size:6.00;" x="697" y="297">reviewed</text>
 
246
<text text-anchor="middle" style="font-size:6.00;" x="757" y="297">boolean</text>
 
247
<text text-anchor="middle" style="font-size:6.00;" x="693" y="309">active</text>
 
248
<text text-anchor="middle" style="font-size:6.00;" x="757" y="309">boolean</text>
 
249
<text text-anchor="middle" style="font-size:6.00;" x="689" y="321">fti</text>
 
250
<text text-anchor="middle" style="font-size:6.00;" x="757" y="321">tsvector</text>
 
251
<text text-anchor="middle" style="font-size:6.00;" x="700" y="333">autoupdate</text>
 
252
<text text-anchor="middle" style="font-size:6.00;" x="757" y="333">boolean</text>
 
253
<text text-anchor="middle" style="font-size:6.00;" x="706" y="345">translationgroup</text>
 
254
<text text-anchor="middle" style="font-size:6.00;" x="755" y="345">integer</text>
 
255
<text text-anchor="middle" style="font-size:6.00;" x="821" y="345"> REFERENCES translationgroup </text>
 
256
<text text-anchor="middle" style="font-size:6.00;" x="712" y="357">translationpermission</text>
 
257
<text text-anchor="middle" style="font-size:6.00;" x="755" y="357">integer</text>
 
258
<text text-anchor="middle" style="font-size:6.00;" x="699" y="369">releaseroot</text>
 
259
<text text-anchor="middle" style="font-size:6.00;" x="752" y="369">text</text>
 
260
<text text-anchor="middle" style="font-size:6.00;" x="696" y="381">calendar</text>
 
261
<text text-anchor="middle" style="font-size:6.00;" x="755" y="381">integer</text>
 
262
<text text-anchor="middle" style="font-size:6.00;" x="823" y="381"> REFERENCES calendar UNIQUE </text>
 
263
<text text-anchor="middle" style="font-size:6.00;" x="704" y="393">official_rosetta</text>
 
264
<text text-anchor="middle" style="font-size:6.00;" x="757" y="393">boolean</text>
 
265
<text text-anchor="middle" style="font-size:6.00;" x="705" y="405">official_malone</text>
 
266
<text text-anchor="middle" style="font-size:6.00;" x="757" y="405">boolean</text>
 
267
<text text-anchor="middle" style="font-size:6.00;" x="700" y="417">bugcontact</text>
 
268
<text text-anchor="middle" style="font-size:6.00;" x="755" y="417">integer</text>
 
269
<text text-anchor="middle" style="font-size:6.00;" x="809" y="417"> REFERENCES person </text>
 
270
<polygon style="fill:none;stroke:black;" points="680,423 680,57 872,57 872,423 680,423"/>
268
271
</g>
269
272
<g id="edge28" class="edge"><title>product&#45;&gt;calendar</title>
270
 
<path style="fill:none;stroke:black;" d="M656,288C640,294 625,300 610,306"/>
271
 
<polygon style="fill:black;stroke:black;" points="612,309 601,310 609,303 612,309"/>
 
273
<path style="fill:none;stroke:black;" d="M672,284C655,291 639,298 623,304"/>
 
274
<polygon style="fill:black;stroke:black;" points="625,307 614,308 622,301 625,307"/>
272
275
</g>
273
276
<g id="edge24" class="edge"><title>product&#45;&gt;person</title>
274
 
<path style="fill:none;stroke:black;" d="M690,427C678,459 665,492 653,524"/>
275
 
<polygon style="fill:black;stroke:black;" points="656,525 649,533 650,522 656,525"/>
 
277
<path style="fill:none;stroke:black;" d="M708,427C694,462 680,498 666,534"/>
 
278
<polygon style="fill:black;stroke:black;" points="669,535 662,543 663,532 669,535"/>
 
279
</g>
 
280
<g id="edge30" class="edge"><title>product&#45;&gt;person</title>
 
281
<path style="fill:none;stroke:black;" d="M695,427C681,462 667,498 653,534"/>
 
282
<polygon style="fill:black;stroke:black;" points="656,535 649,543 650,532 656,535"/>
276
283
</g>
277
284
<g id="node6" class="node"><title>project</title>
278
 
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="186,417 186,171 378,171 378,417 186,417"/>
279
 
<polygon style="fill:white;stroke:white;" points="189,186 189,174 375,174 375,186 189,186"/>
280
 
<text text-anchor="middle" style="font-size:6.00;" x="282" y="182">project</text>
281
 
<polygon style="fill:none;stroke:black;" points="189,186 189,174 375,174 375,186 189,186"/>
282
 
<text text-anchor="middle" style="font-size:6.00;" x="194" y="195">id</text>
283
 
<text text-anchor="middle" style="font-size:6.00;" x="259" y="195">serial</text>
284
 
<text text-anchor="middle" style="font-size:6.00;" x="308" y="195"> PRIMARY KEY </text>
285
 
<text text-anchor="middle" style="font-size:6.00;" x="200" y="207">owner</text>
286
 
<text text-anchor="middle" style="font-size:6.00;" x="261" y="207">integer</text>
287
 
<text text-anchor="middle" style="font-size:6.00;" x="315" y="207"> REFERENCES person </text>
288
 
<text text-anchor="middle" style="font-size:6.00;" x="199" y="219">name</text>
289
 
<text text-anchor="middle" style="font-size:6.00;" x="258" y="219">text</text>
290
 
<text text-anchor="middle" style="font-size:6.00;" x="299" y="219"> UNIQUE </text>
291
 
<text text-anchor="middle" style="font-size:6.00;" x="207" y="231">displayname</text>
292
 
<text text-anchor="middle" style="font-size:6.00;" x="258" y="231">text</text>
293
 
<text text-anchor="middle" style="font-size:6.00;" x="197" y="243">title</text>
294
 
<text text-anchor="middle" style="font-size:6.00;" x="258" y="243">text</text>
295
 
<text text-anchor="middle" style="font-size:6.00;" x="203" y="255">summary</text>
296
 
<text text-anchor="middle" style="font-size:6.00;" x="258" y="255">text</text>
297
 
<text text-anchor="middle" style="font-size:6.00;" x="206" y="267">description</text>
298
 
<text text-anchor="middle" style="font-size:6.00;" x="258" y="267">text</text>
299
 
<text text-anchor="middle" style="font-size:6.00;" x="206" y="279">datecreated</text>
300
 
<text text-anchor="middle" style="font-size:6.00;" x="266" y="279">timestamp</text>
301
 
<text text-anchor="middle" style="font-size:6.00;" x="208" y="291">homepageurl</text>
302
 
<text text-anchor="middle" style="font-size:6.00;" x="258" y="291">text</text>
303
 
<text text-anchor="middle" style="font-size:6.00;" x="201" y="303">wikiurl</text>
304
 
<text text-anchor="middle" style="font-size:6.00;" x="258" y="303">text</text>
305
 
<text text-anchor="middle" style="font-size:6.00;" x="202" y="315">lastdoap</text>
306
 
<text text-anchor="middle" style="font-size:6.00;" x="258" y="315">text</text>
307
 
<text text-anchor="middle" style="font-size:6.00;" x="214" y="327">sourceforgeproject</text>
308
 
<text text-anchor="middle" style="font-size:6.00;" x="258" y="327">text</text>
309
 
<text text-anchor="middle" style="font-size:6.00;" x="212" y="339">freshmeatproject</text>
310
 
<text text-anchor="middle" style="font-size:6.00;" x="258" y="339">text</text>
311
 
<text text-anchor="middle" style="font-size:6.00;" x="203" y="351">reviewed</text>
312
 
<text text-anchor="middle" style="font-size:6.00;" x="263" y="351">boolean</text>
313
 
<text text-anchor="middle" style="font-size:6.00;" x="199" y="363">active</text>
314
 
<text text-anchor="middle" style="font-size:6.00;" x="263" y="363">boolean</text>
315
 
<text text-anchor="middle" style="font-size:6.00;" x="195" y="375">fti</text>
316
 
<text text-anchor="middle" style="font-size:6.00;" x="263" y="375">tsvector</text>
317
 
<text text-anchor="middle" style="font-size:6.00;" x="212" y="387">translationgroup</text>
318
 
<text text-anchor="middle" style="font-size:6.00;" x="261" y="387">integer</text>
319
 
<text text-anchor="middle" style="font-size:6.00;" x="327" y="387"> REFERENCES translationgroup </text>
320
 
<text text-anchor="middle" style="font-size:6.00;" x="218" y="399">translationpermission</text>
321
 
<text text-anchor="middle" style="font-size:6.00;" x="261" y="399">integer</text>
322
 
<text text-anchor="middle" style="font-size:6.00;" x="202" y="411">calendar</text>
323
 
<text text-anchor="middle" style="font-size:6.00;" x="261" y="411">integer</text>
324
 
<text text-anchor="middle" style="font-size:6.00;" x="329" y="411"> REFERENCES calendar UNIQUE </text>
325
 
<polygon style="fill:none;stroke:black;" points="186,417 186,171 378,171 378,417 186,417"/>
 
285
<polygon style="fill:#c1cdcc;stroke:#c1cdcc;" points="192,426 192,180 384,180 384,426 192,426"/>
 
286
<polygon style="fill:white;stroke:white;" points="195,195 195,183 381,183 381,195 195,195"/>
 
287
<text text-anchor="middle" style="font-size:6.00;" x="288" y="191">project</text>
 
288
<polygon style="fill:none;stroke:black;" points="195,195 195,183 381,183 381,195 195,195"/>
 
289
<text text-anchor="middle" style="font-size:6.00;" x="200" y="204">id</text>
 
290
<text text-anchor="middle" style="font-size:6.00;" x="265" y="204">serial</text>
 
291
<text text-anchor="middle" style="font-size:6.00;" x="314" y="204"> PRIMARY KEY </text>
 
292
<text text-anchor="middle" style="font-size:6.00;" x="206" y="216">owner</text>
 
293
<text text-anchor="middle" style="font-size:6.00;" x="267" y="216">integer</text>
 
294
<text text-anchor="middle" style="font-size:6.00;" x="321" y="216"> REFERENCES person </text>
 
295
<text text-anchor="middle" style="font-size:6.00;" x="205" y="228">name</text>
 
296
<text text-anchor="middle" style="font-size:6.00;" x="264" y="228">text</text>
 
297
<text text-anchor="middle" style="font-size:6.00;" x="305" y="228"> UNIQUE </text>
 
298
<text text-anchor="middle" style="font-size:6.00;" x="213" y="240">displayname</text>
 
299
<text text-anchor="middle" style="font-size:6.00;" x="264" y="240">text</text>
 
300
<text text-anchor="middle" style="font-size:6.00;" x="203" y="252">title</text>
 
301
<text text-anchor="middle" style="font-size:6.00;" x="264" y="252">text</text>
 
302
<text text-anchor="middle" style="font-size:6.00;" x="209" y="264">summary</text>
 
303
<text text-anchor="middle" style="font-size:6.00;" x="264" y="264">text</text>
 
304
<text text-anchor="middle" style="font-size:6.00;" x="212" y="276">description</text>
 
305
<text text-anchor="middle" style="font-size:6.00;" x="264" y="276">text</text>
 
306
<text text-anchor="middle" style="font-size:6.00;" x="212" y="288">datecreated</text>
 
307
<text text-anchor="middle" style="font-size:6.00;" x="272" y="288">timestamp</text>
 
308
<text text-anchor="middle" style="font-size:6.00;" x="214" y="300">homepageurl</text>
 
309
<text text-anchor="middle" style="font-size:6.00;" x="264" y="300">text</text>
 
310
<text text-anchor="middle" style="font-size:6.00;" x="207" y="312">wikiurl</text>
 
311
<text text-anchor="middle" style="font-size:6.00;" x="264" y="312">text</text>
 
312
<text text-anchor="middle" style="font-size:6.00;" x="208" y="324">lastdoap</text>
 
313
<text text-anchor="middle" style="font-size:6.00;" x="264" y="324">text</text>
 
314
<text text-anchor="middle" style="font-size:6.00;" x="220" y="336">sourceforgeproject</text>
 
315
<text text-anchor="middle" style="font-size:6.00;" x="264" y="336">text</text>
 
316
<text text-anchor="middle" style="font-size:6.00;" x="218" y="348">freshmeatproject</text>
 
317
<text text-anchor="middle" style="font-size:6.00;" x="264" y="348">text</text>
 
318
<text text-anchor="middle" style="font-size:6.00;" x="209" y="360">reviewed</text>
 
319
<text text-anchor="middle" style="font-size:6.00;" x="269" y="360">boolean</text>
 
320
<text text-anchor="middle" style="font-size:6.00;" x="205" y="372">active</text>
 
321
<text text-anchor="middle" style="font-size:6.00;" x="269" y="372">boolean</text>
 
322
<text text-anchor="middle" style="font-size:6.00;" x="201" y="384">fti</text>
 
323
<text text-anchor="middle" style="font-size:6.00;" x="269" y="384">tsvector</text>
 
324
<text text-anchor="middle" style="font-size:6.00;" x="218" y="396">translationgroup</text>
 
325
<text text-anchor="middle" style="font-size:6.00;" x="267" y="396">integer</text>
 
326
<text text-anchor="middle" style="font-size:6.00;" x="333" y="396"> REFERENCES translationgroup </text>
 
327
<text text-anchor="middle" style="font-size:6.00;" x="224" y="408">translationpermission</text>
 
328
<text text-anchor="middle" style="font-size:6.00;" x="267" y="408">integer</text>
 
329
<text text-anchor="middle" style="font-size:6.00;" x="208" y="420">calendar</text>
 
330
<text text-anchor="middle" style="font-size:6.00;" x="267" y="420">integer</text>
 
331
<text text-anchor="middle" style="font-size:6.00;" x="335" y="420"> REFERENCES calendar UNIQUE </text>
 
332
<polygon style="fill:none;stroke:black;" points="192,426 192,180 384,180 384,426 192,426"/>
326
333
</g>
327
334
<g id="edge22" class="edge"><title>product&#45;&gt;project</title>
328
 
<path style="fill:none;stroke:black;" d="M656,256C579,265 475,275 396,283"/>
329
 
<polygon style="fill:black;stroke:black;" points="396,286 386,284 396,280 396,286"/>
330
 
</g>
331
 
<g id="node23" class="node"><title>fake_translationgroup_230</title>
332
 
<ellipse cx="1053" cy="110" rx="32" ry="18" style="fill:none;stroke:red;"/>
333
 
<text text-anchor="middle" style="font-size:6.00;" x="1053" y="112">translationgroup</text>
334
 
</g>
335
 
<g id="edge26" class="edge"><title>product&#45;&gt;fake_translationgroup_230</title>
336
 
<path style="fill:none;stroke:black;" d="M864,198C918,173 981,143 1018,126"/>
337
 
<polygon style="fill:black;stroke:black;" points="1017,122 1028,122 1020,129 1017,122"/>
338
 
</g>
339
 
<g id="edge34" class="edge"><title>project&#45;&gt;calendar</title>
340
 
<path style="fill:none;stroke:black;" d="M386,310C414,314 443,319 469,323"/>
341
 
<polygon style="fill:black;stroke:black;" points="469,320 479,324 469,326 469,320"/>
342
 
</g>
343
 
<g id="edge30" class="edge"><title>project&#45;&gt;person</title>
344
 
<path style="fill:none;stroke:black;" d="M370,421C398,462 431,510 461,554"/>
345
 
<polygon style="fill:black;stroke:black;" points="464,552 467,562 458,556 464,552"/>
346
 
</g>
347
 
<g id="node27" class="node"><title>fake_translationgroup_250</title>
348
 
<ellipse cx="38" cy="154" rx="32" ry="18" style="fill:none;stroke:red;"/>
349
 
<text text-anchor="middle" style="font-size:6.00;" x="38" y="156">translationgroup</text>
350
 
</g>
351
 
<g id="edge32" class="edge"><title>project&#45;&gt;fake_translationgroup_250</title>
352
 
<path style="fill:none;stroke:black;" d="M178,234C139,212 97,188 70,172"/>
353
 
<polygon style="fill:black;stroke:black;" points="68,175 61,167 71,169 68,175"/>
 
335
<path style="fill:none;stroke:black;" d="M672,253C593,264 484,278 402,289"/>
 
336
<polygon style="fill:black;stroke:black;" points="402,292 392,290 402,286 402,292"/>
 
337
</g>
 
338
<g id="node23" class="node"><title>fake_translationgroup_235</title>
 
339
<ellipse cx="1070" cy="86" rx="32" ry="18" style="fill:none;stroke:red;"/>
 
340
<text text-anchor="middle" style="font-size:6.00;" x="1070" y="88">translationgroup</text>
 
341
</g>
 
342
<g id="edge26" class="edge"><title>product&#45;&gt;fake_translationgroup_235</title>
 
343
<path style="fill:none;stroke:black;" d="M880,185C935,156 1000,123 1037,103"/>
 
344
<polygon style="fill:black;stroke:black;" points="1036,100 1046,98 1039,106 1036,100"/>
 
345
</g>
 
346
<g id="edge36" class="edge"><title>project&#45;&gt;calendar</title>
 
347
<path style="fill:none;stroke:black;" d="M392,315C422,319 454,322 482,325"/>
 
348
<polygon style="fill:black;stroke:black;" points="482,322 492,326 482,328 482,322"/>
 
349
</g>
 
350
<g id="edge32" class="edge"><title>project&#45;&gt;person</title>
 
351
<path style="fill:none;stroke:black;" d="M375,430C403,471 435,518 465,562"/>
 
352
<polygon style="fill:black;stroke:black;" points="468,560 471,570 462,564 468,560"/>
 
353
</g>
 
354
<g id="node28" class="node"><title>fake_translationgroup_255</title>
 
355
<ellipse cx="38" cy="178" rx="32" ry="18" style="fill:none;stroke:red;"/>
 
356
<text text-anchor="middle" style="font-size:6.00;" x="38" y="180">translationgroup</text>
 
357
</g>
 
358
<g id="edge34" class="edge"><title>project&#45;&gt;fake_translationgroup_255</title>
 
359
<path style="fill:none;stroke:black;" d="M184,251C144,231 100,209 71,195"/>
 
360
<polygon style="fill:black;stroke:black;" points="69,198 62,190 72,192 69,198"/>
354
361
</g>
355
362
</g>
356
363
</svg>