// dot 2.26.3 on Linux 3.2.0-4-686-pae // SchemaSpy rev 590 digraph "compactRelationshipsDiagram" { 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" [ label=<
abook
abook_id
abook_account
abook_channel
abook_xchan
abook_my_perms
abook_their_perms
abook_closeness
abook_created
abook_updated
abook_connected
abook_dob
abook_flags
abook_blocked
abook_ignored
abook_hidden
abook_archived
abook_pending
abook_unconnected
abook_self
abook_feed
abook_profile
...
< 1685 rows
> URL="tables/abook.html" tooltip="abook" ]; "attach" [ label=<
attach
id
aid
uid
hash
creator
filename
filetype
filesize
revision
folder
flags
is_dir
is_photo
os_storage
created
edited
...
< 3105 rows
> URL="tables/attach.html" tooltip="attach" ]; "channel" [ label=<
channel
channel_id
channel_account_id
channel_primary
channel_name
channel_address
channel_guid
channel_hash
channel_timezone
channel_location
channel_theme
channel_notifyflags
channel_pageflags
channel_dirdate
channel_lastpost
channel_deleted
channel_max_anon_mail
channel_max_friend_req
channel_expire_days
channel_default_group
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 rows14 >
> URL="tables/channel.html" tooltip="channel" ]; "chat" [ label=<
chat
chat_id
chat_room
chat_xchan
created
...
< 10 rows
> URL="tables/chat.html" tooltip="chat" ]; "chatpresence" [ label=<
chatpresence
cp_id
cp_room
cp_xchan
cp_last
cp_status
...
< 11 row
> URL="tables/chatpresence.html" tooltip="chatpresence" ]; "dreport" [ label=<
dreport
dreport_id
dreport_channel
dreport_mid
dreport_site
dreport_time
dreport_xchan
dreport_queue
...
< 18 579 rows
> URL="tables/dreport.html" tooltip="dreport" ]; "event" [ label=<
event
id
aid
uid
event_xchan
event_hash
start
finish
type
nofinish
adjust
ignore
event_status
event_sequence
event_priority
...
< 412 rows
> URL="tables/event.html" tooltip="event" ]; "group_member" [ label=<
group_member
id
uid
gid
xchan
< 142 rows
> URL="tables/group_member.html" tooltip="group_member" ]; "groups" [ label=<
groups
id
hash
uid
visible
deleted
...
< 310 rows
> URL="tables/groups.html" tooltip="groups" ]; "hubloc" [ label=<
hubloc
hubloc_id
hubloc_guid
hubloc_hash
hubloc_addr
hubloc_network
hubloc_flags
hubloc_status
hubloc_url
hubloc_host
hubloc_connect
hubloc_updated
hubloc_connected
hubloc_primary
hubloc_orphancheck
hubloc_error
hubloc_deleted
...
< 32 658 rows14 >
> URL="tables/hubloc.html" tooltip="hubloc" ]; "item" [ label=<
item
id
mid
aid
uid
parent
parent_mid
created
edited
expires
commented
received
changed
comments_closed
owner_xchan
author_xchan
source_xchan
mimetype
title
body
revision
verb
layout_mid
llink
resource_type
public_policy
comment_policy
allow_cid
allow_gid
deny_cid
deny_gid
item_restrict
item_flags
item_private
item_origin
item_unseen
item_starred
item_uplink
item_consensus
item_wall
item_thread_top
item_notshown
item_nsfw
item_relay
item_mentionsme
item_nocomment
item_obscured
item_verified
item_retained
item_rss
item_deleted
item_type
item_hidden
item_unpublished
item_delayed
item_pending_remove
item_blocked
...
< 337 583 rows
> URL="tables/item.html" tooltip="item" ]; "mail" [ label=<
mail
id
convid
mail_flags
from_xchan
to_xchan
account_id
channel_id
mid
parent_mid
mail_deleted
mail_replied
mail_isreply
mail_seen
mail_recalled
mail_obscured
created
expires
conv_guid
...
< 239 rows
> URL="tables/mail.html" tooltip="mail" ]; "manage" [ label=<
manage
id
uid
xchan
< 10 rows
> URL="tables/manage.html" tooltip="manage" ]; "notify" [ label=<
notify
id
hash
date
aid
uid
link
parent
seen
type
otype
...
< 3528 rows
> URL="tables/notify.html" tooltip="notify" ]; "outq" [ label=<
outq
outq_hash
outq_account
outq_channel
outq_posturl
outq_async
outq_delivered
outq_created
outq_updated
outq_priority
...
< 3660 rows
> URL="tables/outq.html" tooltip="outq" ]; "photo" [ label=<
photo
id
aid
uid
xchan
resource_id
album
type
size
scale
photo_usage
profile
is_nsfw
os_storage
photo_flags
...
< 15 888 rows
> URL="tables/photo.html" tooltip="photo" ]; "profext" [ label=<
profext
id
channel_id
hash
k
...
< 30 rows
> URL="tables/profext.html" tooltip="profext" ]; "register" [ label=<
register
id
hash
created
uid
...
< 30 rows
> URL="tables/register.html" tooltip="register" ]; "shares" [ label=<
shares
share_id
share_type
share_target
share_xchan
< 10 rows
> URL="tables/shares.html" tooltip="shares" ]; "source" [ label=<
source
src_id
src_channel_id
src_channel_xchan
src_xchan
...
< 20 rows
> URL="tables/source.html" tooltip="source" ]; "term" [ label=<
term
tid
aid
uid
oid
otype
type
term
imgurl
term_hash
parent_hash
...
< 68 980 rows
> URL="tables/term.html" tooltip="term" ]; "updates" [ label=<
updates
ud_id
ud_hash
ud_guid
ud_date
ud_last
ud_flags
ud_addr
< 30 rows
> URL="tables/updates.html" tooltip="updates" ]; "vote" [ label=<
vote
vote_id
vote_poll
vote_element
vote_xchan
...
< 10 rows
> URL="tables/vote.html" tooltip="vote" ]; "xchan" [ label=<
xchan
xchan_hash
xchan_guid
xchan_addr
xchan_url
xchan_connurl
xchan_follow
xchan_name
xchan_network
xchan_instance_url
xchan_flags
xchan_hidden
xchan_orphan
xchan_censored
xchan_selfcensored
xchan_system
xchan_pubforum
xchan_deleted
...
< 22 301 rows35 >
> URL="tables/xchan.html" tooltip="xchan" ]; "xchat" [ label=<
xchat
xchat_id
xchat_url
xchat_desc
xchat_xchan
xchat_edited
< 19 rows
> URL="tables/xchat.html" tooltip="xchat" ]; "xconfig" [ label=<
xconfig
id
xchan
cat
k
...
< 18 rows
> URL="tables/xconfig.html" tooltip="xconfig" ]; "xign" [ label=<
xign
id
uid
xchan
< 10 rows
> URL="tables/xign.html" tooltip="xign" ]; "xlink" [ label=<
xlink
xlink_id
xlink_xchan
xlink_link
xlink_rating
xlink_updated
xlink_static
...
< 14 105 rows
> URL="tables/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_hometown
...
< 30 rows
> URL="tables/xprof.html" tooltip="xprof" ]; "xtag" [ label=<
xtag
xtag_id
xtag_hash
xtag_term
xtag_flags
< 30 rows
> URL="tables/xtag.html" tooltip="xtag" ]; "abook":"abook_xchan":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "attach":"hash":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "attach":"hash":w -> "hubloc":"hubloc_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "attach":"hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "channel":"channel_hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "chat":"chat_xchan":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "chatpresence":"cp_xchan":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "dreport":"dreport_xchan":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":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]; "group_member":"xchan":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":e [arrowhead=none dir=back arrowtail=crowodot]; "groups":"hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "hubloc":"hubloc_hash":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "hubloc":"hubloc_hash":w -> "hubloc":"hubloc_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "hubloc":"hubloc_hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "item":"author_xchan":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "item":"owner_xchan":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "item":"source_xchan":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "mail":"from_xchan":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "mail":"to_xchan":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "manage":"xchan":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":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":e [arrowhead=none dir=back arrowtail=teeodot]; "outq":"outq_hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=teeodot]; "photo":"xchan":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "profext":"hash":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "profext":"hash":w -> "hubloc":"hubloc_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "profext":"hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "register":"hash":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "register":"hash":w -> "hubloc":"hubloc_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "register":"hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "shares":"share_xchan":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "source":"src_channel_xchan":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "source":"src_xchan":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "term":"parent_hash":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "term":"parent_hash":w -> "hubloc":"hubloc_hash":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":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":e [arrowhead=none dir=back arrowtail=crowodot]; "updates":"ud_hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "vote":"vote_xchan":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":e [arrowhead=none dir=back arrowtail=teeodot]; "xchat":"xchat_xchan":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "xconfig":"xchan":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "xign":"xchan":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; "xlink":"xlink_xchan":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":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":e [arrowhead=none dir=back arrowtail=crowodot]; "xtag":"xtag_hash":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot]; }