aboutsummaryrefslogblamecommitdiffstats
path: root/hubzilla_er/diagrams/profile.implied2degrees.dot
blob: 6dd37a33a4208e7dc2f3cf81c48bd9c55e22fcd1 (plain) (tree) 
c40f6060d







































































































































































































1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199







































































































































































































                                                                                                                                                           
// dot 2.26.3 on Linux 3.2.0-4-686-pae
// SchemaSpy rev 590
digraph "impliedTwoDegreesRelationshipsDiagram" {
  graph [
    rankdir="RL"
    bgcolor="#f7f7f7"
    label="\nGenerated by SchemaSpy"
    labeljust="l"
    nodesep="0.18"
    ranksep="0.46"
    fontname="Helvetica"
    fontsize="11"
  ];
  node [
    fontname="Helvetica"
    fontsize="11"
    shape="plaintext"
  ];
  edge [
    arrowsize="0.8"
  ];
  "addon":"elipses":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
  "app":"elipses":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
  "event":"elipses":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
  "fserver":"elipses":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
  "fsuggest":"elipses":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
  "hook":"elipses":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
  "manage":"elipses":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
  "pconfig":"elipses":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
  "profile":"id":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
  "spam":"elipses":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
  "addon" [
    label=<
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">addon</TD></TR>
      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
    </TABLE>>
    URL="addon.html"
    tooltip="addon"
  ];
  "app" [
    label=<
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">app</TD></TR>
      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
    </TABLE>>
    URL="app.html"
    tooltip="app"
  ];
  "event" [
    label=<
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">event</TD></TR>
      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
    </TABLE>>
    URL="event.html"
    tooltip="event"
  ];
  "fserver" [
    label=<
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">fserver</TD></TR>
      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
    </TABLE>>
    URL="fserver.html"
    tooltip="fserver"
  ];
  "fsuggest" [
    label=<
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">fsuggest</TD></TR>
      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
    </TABLE>>
    URL="fsuggest.html"
    tooltip="fsuggest"
  ];
  "hook" [
    label=<
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">hook</TD></TR>
      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
    </TABLE>>
    URL="hook.html"
    tooltip="hook"
  ];
  "manage" [
    label=<
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">manage</TD></TR>
      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
    </TABLE>>
    URL="manage.html"
    tooltip="manage"
  ];
  "notify" [
    label=<
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">notify</TD></TR>
      <TR><TD PORT="id" COLSPAN="3" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD></TR>
      <TR><TD PORT="hash" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">hash</TD></TR>
      <TR><TD PORT="name" COLSPAN="3" ALIGN="LEFT">name</TD></TR>
      <TR><TD PORT="url" COLSPAN="3" ALIGN="LEFT">url</TD></TR>
      <TR><TD PORT="photo" COLSPAN="3" ALIGN="LEFT">photo</TD></TR>
      <TR><TD PORT="date" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">date</TD></TR>
      <TR><TD PORT="msg" COLSPAN="3" ALIGN="LEFT">msg</TD></TR>
      <TR><TD PORT="aid" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">aid</TD></TR>
      <TR><TD PORT="uid" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">uid</TD></TR>
      <TR><TD PORT="link" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">link</TD></TR>
      <TR><TD PORT="parent" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">parent</TD></TR>
      <TR><TD PORT="seen" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">seen</TD></TR>
      <TR><TD PORT="type" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">type</TD></TR>
      <TR><TD PORT="verb" COLSPAN="3" ALIGN="LEFT">verb</TD></TR>
      <TR><TD PORT="otype" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">otype</TD></TR>
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">59 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">10 &gt;</TD></TR>
    </TABLE>>
    URL="notify.html"
    tooltip="notify"
  ];
  "pconfig" [
    label=<
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">pconfig</TD></TR>
      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">232 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
    </TABLE>>
    URL="pconfig.html"
    tooltip="pconfig"
  ];
  "profile" [
    label=<
    <TABLE BORDER="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">profile</TD></TR>
      <TR><TD PORT="id" COLSPAN="2" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD><TD PORT="id.type" ALIGN="LEFT">int[10]</TD></TR>
      <TR><TD PORT="profile_guid" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">profile_guid</TD><TD PORT="profile_guid.type" ALIGN="LEFT">char[64]</TD></TR>
      <TR><TD PORT="aid" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">aid</TD><TD PORT="aid.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
      <TR><TD PORT="uid" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">uid</TD><TD PORT="uid.type" ALIGN="LEFT">int[10]</TD></TR>
      <TR><TD PORT="profile_name" COLSPAN="2" ALIGN="LEFT">profile_name</TD><TD PORT="profile_name.type" ALIGN="LEFT">char[255]</TD></TR>
      <TR><TD PORT="is_default" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">is_default</TD><TD PORT="is_default.type" ALIGN="LEFT">bit[0]</TD></TR>
      <TR><TD PORT="hide_friends" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">hide_friends</TD><TD PORT="hide_friends.type" ALIGN="LEFT">bit[0]</TD></TR>
      <TR><TD PORT="name" COLSPAN="2" ALIGN="LEFT">name</TD><TD PORT="name.type" ALIGN="LEFT">char[255]</TD></TR>
      <TR><TD PORT="pdesc" COLSPAN="2" ALIGN="LEFT">pdesc</TD><TD PORT="pdesc.type" ALIGN="LEFT">char[255]</TD></TR>
      <TR><TD PORT="chandesc" COLSPAN="2" ALIGN="LEFT">chandesc</TD><TD PORT="chandesc.type" ALIGN="LEFT">text[65535]</TD></TR>
      <TR><TD PORT="dob" COLSPAN="2" ALIGN="LEFT">dob</TD><TD PORT="dob.type" ALIGN="LEFT">char[32]</TD></TR>
      <TR><TD PORT="dob_tz" COLSPAN="2" ALIGN="LEFT">dob_tz</TD><TD PORT="dob_tz.type" ALIGN="LEFT">char[255]</TD></TR>
      <TR><TD PORT="address" COLSPAN="2" ALIGN="LEFT">address</TD><TD PORT="address.type" ALIGN="LEFT">char[255]</TD></TR>
      <TR><TD PORT="locality" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">locality</TD><TD PORT="locality.type" ALIGN="LEFT">char[255]</TD></TR>
      <TR><TD PORT="region" COLSPAN="2" ALIGN="LEFT">region</TD><TD PORT="region.type" ALIGN="LEFT">char[255]</TD></TR>
      <TR><TD PORT="postal_code" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">postal_code</TD><TD PORT="postal_code.type" ALIGN="LEFT">char[32]</TD></TR>
      <TR><TD PORT="country_name" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">country_name</TD><TD PORT="country_name.type" ALIGN="LEFT">char[255]</TD></TR>
      <TR><TD PORT="hometown" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">hometown</TD><TD PORT="hometown.type" ALIGN="LEFT">char[255]</TD></TR>
      <TR><TD PORT="gender" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">gender</TD><TD PORT="gender.type" ALIGN="LEFT">char[32]</TD></TR>
      <TR><TD PORT="marital" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">marital</TD><TD PORT="marital.type" ALIGN="LEFT">char[255]</TD></TR>
      <TR><TD PORT="with" COLSPAN="2" ALIGN="LEFT">with</TD><TD PORT="with.type" ALIGN="LEFT">text[65535]</TD></TR>
      <TR><TD PORT="howlong" COLSPAN="2" ALIGN="LEFT">howlong</TD><TD PORT="howlong.type" ALIGN="LEFT">datetime[19]</TD></TR>
      <TR><TD PORT="sexual" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">sexual</TD><TD PORT="sexual.type" ALIGN="LEFT">char[255]</TD></TR>
      <TR><TD PORT="politic" COLSPAN="2" ALIGN="LEFT">politic</TD><TD PORT="politic.type" ALIGN="LEFT">char[255]</TD></TR>
      <TR><TD PORT="religion" COLSPAN="2" ALIGN="LEFT">religion</TD><TD PORT="religion.type" ALIGN="LEFT">char[255]</TD></TR>
      <TR><TD PORT="keywords" COLSPAN="2" ALIGN="LEFT">keywords</TD><TD PORT="keywords.type" ALIGN="LEFT">text[65535]</TD></TR>
      <TR><TD PORT="likes" COLSPAN="2" ALIGN="LEFT">likes</TD><TD PORT="likes.type" ALIGN="LEFT">text[65535]</TD></TR>
      <TR><TD PORT="dislikes" COLSPAN="2" ALIGN="LEFT">dislikes</TD><TD PORT="dislikes.type" ALIGN="LEFT">text[65535]</TD></TR>
      <TR><TD PORT="about" COLSPAN="2" ALIGN="LEFT">about</TD><TD PORT="about.type" ALIGN="LEFT">text[65535]</TD></TR>
      <TR><TD PORT="summary" COLSPAN="2" ALIGN="LEFT">summary</TD><TD PORT="summary.type" ALIGN="LEFT">char[255]</TD></TR>
      <TR><TD PORT="music" COLSPAN="2" ALIGN="LEFT">music</TD><TD PORT="music.type" ALIGN="LEFT">text[65535]</TD></TR>
      <TR><TD PORT="book" COLSPAN="2" ALIGN="LEFT">book</TD><TD PORT="book.type" ALIGN="LEFT">text[65535]</TD></TR>
      <TR><TD PORT="tv" COLSPAN="2" ALIGN="LEFT">tv</TD><TD PORT="tv.type" ALIGN="LEFT">text[65535]</TD></TR>
      <TR><TD PORT="film" COLSPAN="2" ALIGN="LEFT">film</TD><TD PORT="film.type" ALIGN="LEFT">text[65535]</TD></TR>
      <TR><TD PORT="interest" COLSPAN="2" ALIGN="LEFT">interest</TD><TD PORT="interest.type" ALIGN="LEFT">text[65535]</TD></TR>
      <TR><TD PORT="romance" COLSPAN="2" ALIGN="LEFT">romance</TD><TD PORT="romance.type" ALIGN="LEFT">text[65535]</TD></TR>
      <TR><TD PORT="work" COLSPAN="2" ALIGN="LEFT">work</TD><TD PORT="work.type" ALIGN="LEFT">text[65535]</TD></TR>
      <TR><TD PORT="education" COLSPAN="2" ALIGN="LEFT">education</TD><TD PORT="education.type" ALIGN="LEFT">text[65535]</TD></TR>
      <TR><TD PORT="contact" COLSPAN="2" ALIGN="LEFT">contact</TD><TD PORT="contact.type" ALIGN="LEFT">text[65535]</TD></TR>
      <TR><TD PORT="channels" COLSPAN="2" ALIGN="LEFT">channels</TD><TD PORT="channels.type" ALIGN="LEFT">text[65535]</TD></TR>
      <TR><TD PORT="homepage" COLSPAN="2" ALIGN="LEFT">homepage</TD><TD PORT="homepage.type" ALIGN="LEFT">char[255]</TD></TR>
      <TR><TD PORT="photo" COLSPAN="2" ALIGN="LEFT">photo</TD><TD PORT="photo.type" ALIGN="LEFT">char[255]</TD></TR>
      <TR><TD PORT="thumb" COLSPAN="2" ALIGN="LEFT">thumb</TD><TD PORT="thumb.type" ALIGN="LEFT">char[255]</TD></TR>
      <TR><TD PORT="publish" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">publish</TD><TD PORT="publish.type" ALIGN="LEFT">bit[0]</TD></TR>
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">4 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 &gt;</TD></TR>
    </TABLE>>
    URL="profile.html"
    tooltip="profile"
  ];
  "spam" [
    label=<
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">spam</TD></TR>
      <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR>
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
    </TABLE>>
    URL="spam.html"
    tooltip="spam"
  ];
}
generated by cgit v1.2.3 (git 2.25.1) at 2024-11-06 23:34:21 +0000