// 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" ]; "abook":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "attach":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot]; "attach":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot]; "attach":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "attach":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "channel":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "chat":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "chatpresence":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "config":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "conv":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "dreport":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "event":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot]; "event":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot]; "event":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "event":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "event":"elipses":w -> "notify":"elipses":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "fcontact":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "ffinder":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "group_member":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "group_member":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "groups":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot]; "groups":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot]; "groups":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "groups":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "hubloc":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot]; "hubloc":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "item":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "item":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "item":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "item":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "item_id":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "likes":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot style=dashed]; "likes":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "mail":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot style=dashed]; "mail":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "mail":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "mail":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "manage":"elipses":w -> "notify":"elipses":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "manage":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "notify":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot]; "notify":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot]; "notify":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "outq":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=teeodot]; "outq":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=teeodot]; "outq":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=teeodot]; "photo":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "photo":"xchan":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "profdef":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "profext":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot style=dashed]; "profext":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot]; "profext":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot]; "profext":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "profext":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "profile_check":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "register":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot]; "register":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot]; "register":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "register":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "shares":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "sign":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "source":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "source":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "sys_perms":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "term":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot]; "term":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot]; "term":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "term":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot]; "term":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot]; "term":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "updates":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot]; "updates":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot]; "updates":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "vote":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "xchan":"xchan_hash":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=teeodot]; "xchan":"xchan_hash":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=teeodot]; "xchat":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "xconfig":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "xconfig":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "xign":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "xign":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "xlink":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "xprof":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=teeodot]; "xprof":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=teeodot]; "xprof":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=teeodot]; "xtag":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot]; "xtag":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot]; "xtag":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "abook" [ label=<
abook
...
< 1685 rows
> URL="abook.html" tooltip="abook" ]; "attach" [ label=<
attach
...
< 4105 rows
> URL="attach.html" tooltip="attach" ]; "channel" [ label=<
channel
...
< 112 rows17 >
> URL="channel.html" tooltip="channel" ]; "chat" [ label=<
chat
...
< 10 rows
> URL="chat.html" tooltip="chat" ]; "chatpresence" [ label=<
chatpresence
...
< 11 row
> URL="chatpresence.html" tooltip="chatpresence" ]; "config" [ label=<
config
...
< 283 rows
> URL="config.html" tooltip="config" ]; "conv" [ label=<
conv
...
< 115 rows
> URL="conv.html" tooltip="conv" ]; "dreport" [ label=<
dreport
...
< 18 579 rows
> URL="dreport.html" tooltip="dreport" ]; "event" [ label=<
event
...
< 512 rows
> URL="event.html" tooltip="event" ]; "fcontact" [ label=<
fcontact
...
< 10 rows
> URL="fcontact.html" tooltip="fcontact" ]; "ffinder" [ label=<
ffinder
...
< 10 rows
> URL="ffinder.html" tooltip="ffinder" ]; "group_member" [ label=<
group_member
...
< 242 rows
> URL="group_member.html" tooltip="group_member" ]; "groups" [ label=<
groups
...
< 410 rows
> URL="groups.html" tooltip="groups" ]; "hubloc" [ label=<
hubloc
...
< 32 658 rows14 >
> URL="hubloc.html" tooltip="hubloc" ]; "item" [ label=<
item
...
< 437 583 rows
> URL="item.html" tooltip="item" ]; "item_id" [ label=<
item_id
...
< 1194 rows
> URL="item_id.html" tooltip="item_id" ]; "likes" [ label=<
likes
...
< 20 rows
> URL="likes.html" tooltip="likes" ]; "mail" [ label=<
mail
...
< 539 rows
> URL="mail.html" tooltip="mail" ]; "manage" [ label=<
manage
...
< 20 rows
> URL="manage.html" tooltip="manage" ]; "notify" [ label=<
notify
...
< 3528 rows10 >
> URL="notify.html" tooltip="notify" ]; "outq" [ label=<
outq
...
< 3660 rows
> URL="outq.html" tooltip="outq" ]; "photo" [ label=<
photo
idint unsigned[10]
aidint unsigned[10]
uidint unsigned[10]
xchanchar[255]
resource_idchar[255]
createddatetime[19]
editeddatetime[19]
titlechar[255]
descriptiontext[65535]
albumchar[255]
filenamechar[255]
typechar[128]
heightsmallint[5]
widthsmallint[5]
sizeint unsigned[10]
datamediumblob[16777215]
scaletinyint[3]
photo_usagesmallint[5]
profilebit[0]
is_nsfwbit[0]
os_storagebit[0]
os_pathmediumtext[16777215]
display_pathmediumtext[16777215]
photo_flagsint unsigned[10]
allow_cidmediumtext[16777215]
allow_gidmediumtext[16777215]
deny_cidmediumtext[16777215]
deny_gidmediumtext[16777215]
< 25 888 rows0 >
> URL="photo.html" tooltip="photo" ]; "profdef" [ label=<
profdef
...
< 10 rows
> URL="profdef.html" tooltip="profdef" ]; "profext" [ label=<
profext
...
< 60 rows
> URL="profext.html" tooltip="profext" ]; "profile_check" [ label=<
profile_check
...
< 10 rows
> URL="profile_check.html" tooltip="profile_check" ]; "register" [ label=<
register
...
< 40 rows
> URL="register.html" tooltip="register" ]; "shares" [ label=<
shares
...
< 10 rows
> URL="shares.html" tooltip="shares" ]; "sign" [ label=<
sign
...
< 10 rows
> URL="sign.html" tooltip="sign" ]; "source" [ label=<
source
...
< 20 rows
> URL="source.html" tooltip="source" ]; "sys_perms" [ label=<
sys_perms
...
< 20 rows
> URL="sys_perms.html" tooltip="sys_perms" ]; "term" [ label=<
term
...
< 68 980 rows
> URL="term.html" tooltip="term" ]; "updates" [ label=<
updates
...
< 30 rows
> URL="updates.html" tooltip="updates" ]; "verify" [ label=<
verify
id
channel
type
token
meta
created
0 rows20 >
> URL="verify.html" tooltip="verify" ]; "vote" [ label=<
vote
...
< 10 rows
> URL="vote.html" tooltip="vote" ]; "xchan" [ label=<
xchan
xchan_hash
xchan_guid
xchan_guid_sig
xchan_pubkey
xchan_photo_mimetype
xchan_photo_l
xchan_photo_m
xchan_photo_s
xchan_addr
xchan_url
xchan_connurl
xchan_follow
xchan_connpage
xchan_name
xchan_network
xchan_instance_url
xchan_flags
xchan_photo_date
xchan_name_date
xchan_hidden
xchan_orphan
xchan_censored
xchan_selfcensored
xchan_system
xchan_pubforum
xchan_deleted
< 22 301 rows35 >
> URL="xchan.html" tooltip="xchan" ]; "xchat" [ label=<
xchat
...
< 19 rows
> URL="xchat.html" tooltip="xchat" ]; "xconfig" [ label=<
xconfig
...
< 38 rows
> URL="xconfig.html" tooltip="xconfig" ]; "xign" [ label=<
xign
...
< 20 rows
> URL="xign.html" tooltip="xign" ]; "xlink" [ label=<
xlink
...
< 14 105 rows
> URL="xlink.html" tooltip="xlink" ]; "xprof" [ label=<
xprof
...
< 30 rows
> URL="xprof.html" tooltip="xprof" ]; "xtag" [ label=<
xtag
...
< 30 rows
> URL="xtag.html" tooltip="xtag" ]; }