// 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]; "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]; "attach":"hash":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "attach":"hash":w -> "hubloc":"hubloc_hash.type":e [arrowhead=none dir=back arrowtail=crowodot]; "attach":"hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "attach":"id":w -> "verify":"elipses":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "channel":"channel_hash":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]; "dreport":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "event":"event_hash":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "event":"event_hash":w -> "hubloc":"hubloc_hash.type":e [arrowhead=none dir=back arrowtail=crowodot]; "event":"event_hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "event":"event_xchan":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "event":"id":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]; "group_member":"elipses":w -> "verify":"elipses":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "group_member":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "groups":"hash":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "groups":"hash":w -> "hubloc":"hubloc_hash.type":e [arrowhead=none dir=back arrowtail=crowodot]; "groups":"hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "groups":"id":w -> "verify":"elipses":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "hook":"elipses":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "hubloc":"hubloc_hash":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "hubloc":"hubloc_hash":w -> "hubloc":"hubloc_hash.type":e [arrowhead=none dir=back arrowtail=crowodot]; "hubloc":"hubloc_hash":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":"elipses":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]; "likes":"elipses":w -> "channel":"channel_id":e [arrowhead=none dir=back arrowtail=crowodot style=dashed]; "likes":"elipses":w -> "verify":"elipses":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "mail":"elipses":w -> "channel":"channel_id":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":"elipses":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":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "manage":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "notify":"hash":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "notify":"hash":w -> "hubloc":"hubloc_hash.type":e [arrowhead=none dir=back arrowtail=crowodot]; "notify":"hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "outq":"outq_hash":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=teeodot]; "outq":"outq_hash":w -> "hubloc":"hubloc_hash.type":e [arrowhead=none dir=back arrowtail=teeodot]; "outq":"outq_hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=teeodot]; "pconfig":"elipses":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "pconfig":"elipses":w -> "cache":"elipses":e [arrowhead=none dir=back arrowtail=crowodot style=dashed]; "photo":"elipses":w -> "verify":"elipses":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "photo":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "profext":"channel_id":w -> "channel":"channel_id":e [arrowhead=none dir=back arrowtail=crowodot style=dashed]; "profext":"hash":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "profext":"hash":w -> "hubloc":"hubloc_hash.type":e [arrowhead=none dir=back arrowtail=crowodot]; "profext":"hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "profext":"id":w -> "verify":"elipses":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "profext":"k":w -> "cache":"elipses":e [arrowhead=none dir=back arrowtail=crowodot style=dashed]; "profile":"elipses":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "register":"hash":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "register":"hash":w -> "hubloc":"hubloc_hash.type":e [arrowhead=none dir=back arrowtail=crowodot]; "register":"hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "register":"id":w -> "verify":"elipses":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "shares":"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]; "source":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "spam":"elipses":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "term":"parent_hash":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "term":"parent_hash":w -> "hubloc":"hubloc_hash.type":e [arrowhead=none dir=back arrowtail=crowodot]; "term":"parent_hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "term":"term_hash":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "term":"term_hash":w -> "hubloc":"hubloc_hash.type":e [arrowhead=none dir=back arrowtail=crowodot]; "term":"term_hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "updates":"ud_hash":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "updates":"ud_hash":w -> "hubloc":"hubloc_hash.type":e [arrowhead=none dir=back arrowtail=crowodot]; "updates":"ud_hash":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":"channel_hash":e [arrowhead=none dir=back arrowtail=teeodot]; "xchan":"xchan_hash":w -> "hubloc":"hubloc_hash.type":e [arrowhead=none dir=back arrowtail=teeodot]; "xchat":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "xconfig":"elipses":w -> "verify":"elipses":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "xconfig":"elipses":w -> "cache":"elipses":e [arrowhead=none dir=back arrowtail=crowodot style=dashed]; "xconfig":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "xign":"elipses":w -> "verify":"elipses":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":"xprof_hash":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=teeodot]; "xprof":"xprof_hash":w -> "hubloc":"hubloc_hash.type":e [arrowhead=none dir=back arrowtail=teeodot]; "xprof":"xprof_hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=teeodot]; "xtag":"xtag_hash":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "xtag":"xtag_hash":w -> "hubloc":"hubloc_hash.type":e [arrowhead=none dir=back arrowtail=crowodot]; "xtag":"xtag_hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "abook" [ label=<
abook
...
< 1685 rows
> URL="abook.html" tooltip="abook" ]; "addon" [ label=<
addon
...
< 120 rows
> URL="addon.html" tooltip="addon" ]; "app" [ label=<
app
...
< 14 rows
> URL="app.html" tooltip="app" ]; "attach" [ label=<
attach
id
aid
uid
hash
creator
filename
filetype
filesize
revision
folder
flags
is_dir
is_photo
os_storage
os_path
display_path
data
created
edited
allow_cid
allow_gid
deny_cid
deny_gid
< 4105 rows
> URL="attach.html" tooltip="attach" ]; "cache" [ label=<
cache
...
334 rows5 >
> URL="cache.html" tooltip="cache" ]; "channel" [ label=<
channel
channel_id
channel_account_id
channel_primary
channel_name
channel_address
channel_guid
channel_guid_sig
channel_hash
channel_timezone
channel_location
channel_theme
channel_startpage
channel_pubkey
channel_prvkey
channel_notifyflags
channel_pageflags
channel_dirdate
channel_lastpost
channel_deleted
channel_max_anon_mail
channel_max_friend_req
channel_expire_days
channel_passwd_reset
channel_default_group
channel_allow_cid
channel_allow_gid
channel_deny_cid
channel_deny_gid
channel_r_stream
channel_r_profile
channel_r_photos
channel_r_abook
channel_w_stream
channel_w_wall
channel_w_tagwall
channel_w_comment
channel_w_mail
channel_w_photos
channel_w_chat
channel_a_delegate
channel_r_storage
channel_w_storage
channel_r_pages
channel_w_pages
channel_a_republish
channel_w_like
channel_removed
channel_system
< 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" ]; "dreport" [ label=<
dreport
...
< 18 579 rows
> URL="dreport.html" tooltip="dreport" ]; "event" [ label=<
event
id
aid
uid
event_xchan
event_hash
created
edited
start
finish
summary
description
location
type
nofinish
adjust
ignore
allow_cid
allow_gid
deny_cid
deny_gid
event_status
event_status_date
event_percent
event_repeat
event_sequence
event_priority
event_vdata
< 512 rows
> URL="event.html" tooltip="event" ]; "fserver" [ label=<
fserver
...
< 10 rows
> URL="fserver.html" tooltip="fserver" ]; "fsuggest" [ label=<
fsuggest
...
< 10 rows
> URL="fsuggest.html" tooltip="fsuggest" ]; "group_member" [ label=<
group_member
...
< 242 rows
> URL="group_member.html" tooltip="group_member" ]; "groups" [ label=<
groups
id
hash
uid
visible
deleted
name
< 410 rows
> URL="groups.html" tooltip="groups" ]; "hook" [ label=<
hook
...
< 141 rows
> URL="hook.html" tooltip="hook" ]; "hubloc" [ label=<
hubloc
hubloc_idint unsigned[10]
hubloc_guidchar[255]
hubloc_guid_sigtext[65535]
hubloc_hashchar[255]
hubloc_addrchar[255]
hubloc_networkchar[32]
hubloc_flagsint unsigned[10]
hubloc_statusint unsigned[10]
hubloc_urlchar[255]
hubloc_url_sigtext[65535]
hubloc_hostchar[255]
hubloc_callbackchar[255]
hubloc_connectchar[255]
hubloc_sitekeytext[65535]
hubloc_updateddatetime[19]
hubloc_connecteddatetime[19]
hubloc_primarybit[0]
hubloc_orphancheckbit[0]
hubloc_errorbit[0]
hubloc_deletedbit[0]
< 32 658 rows14 >
> URL="hubloc.html" tooltip="hubloc" ]; "item" [ label=<
item
...
< 437 583 rows
> URL="item.html" tooltip="item" ]; "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
id
hash
name
url
photo
date
msg
aid
uid
link
parent
seen
type
verb
otype
< 3528 rows10 >
> URL="notify.html" tooltip="notify" ]; "outq" [ label=<
outq
outq_hash
outq_account
outq_channel
outq_driver
outq_posturl
outq_async
outq_delivered
outq_created
outq_updated
outq_notify
outq_msg
outq_priority
< 3660 rows
> URL="outq.html" tooltip="outq" ]; "pconfig" [ label=<
pconfig
...
< 2719 rows
> URL="pconfig.html" tooltip="pconfig" ]; "photo" [ label=<
photo
...
< 25 888 rows
> URL="photo.html" tooltip="photo" ]; "profext" [ label=<
profext
id
channel_id
hash
k
v
< 60 rows
> URL="profext.html" tooltip="profext" ]; "profile" [ label=<
profile
...
< 111 rows
> URL="profile.html" tooltip="profile" ]; "register" [ label=<
register
id
hash
created
uid
password
language
< 40 rows
> URL="register.html" tooltip="register" ]; "shares" [ label=<
shares
...
< 10 rows
> URL="shares.html" tooltip="shares" ]; "source" [ label=<
source
...
< 20 rows
> URL="source.html" tooltip="source" ]; "spam" [ label=<
spam
...
< 10 rows
> URL="spam.html" tooltip="spam" ]; "term" [ label=<
term
tid
aid
uid
oid
otype
type
term
url
imgurl
term_hash
parent_hash
< 68 980 rows
> URL="term.html" tooltip="term" ]; "updates" [ label=<
updates
ud_id
ud_hash
ud_guid
ud_date
ud_last
ud_flags
ud_addr
< 30 rows
> URL="updates.html" tooltip="updates" ]; "verify" [ label=<
verify
...
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
xprof_hash
xprof_age
xprof_desc
xprof_dob
xprof_gender
xprof_marital
xprof_sexual
xprof_locale
xprof_region
xprof_postcode
xprof_country
xprof_keywords
xprof_about
xprof_homepage
xprof_hometown
< 30 rows
> URL="xprof.html" tooltip="xprof" ]; "xtag" [ label=<
xtag
xtag_id
xtag_hash
xtag_term
xtag_flags
< 30 rows
> URL="xtag.html" tooltip="xtag" ]; }