// dot 2.26.3 on Linux 3.2.0-4-686-pae // SchemaSpy rev 590 digraph "compactImpliedRelationshipsDiagram" { 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" ]; "account" [ label=<
account
account_id
account_parent
account_default_channel
account_email
account_external
account_lastlog
account_flags
account_roles
account_expires
account_service_class
account_level
account_password_changed
...
1 row
> URL="tables/account.html" tooltip="account" ]; "addon" [ label=<
addon
id
name
installed
hidden
...
0 rows
> URL="tables/addon.html" tooltip="addon" ]; "app" [ label=<
app
id
app_id
app_name
app_url
app_photo
app_version
app_channel
app_price
...
0 rows
> URL="tables/app.html" tooltip="app" ]; "attach" [ label=<
attach
id
aid
uid
hash
creator
filename
filetype
filesize
revision
folder
flags
is_dir
is_photo
os_storage
created
edited
...
0 rows
> URL="tables/attach.html" tooltip="attach" ]; "auth_codes" [ label=<
auth_codes
id
client_id
...
0 rows
> URL="tables/auth_codes.html" tooltip="auth_codes" ]; "cache" [ label=<
cache
k
...
21 rows
> URL="tables/cache.html" tooltip="cache" ]; "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
...
5 rows
> URL="tables/channel.html" tooltip="channel" ]; "clients" [ label=<
clients
client_id
...
0 rows
> URL="tables/clients.html" tooltip="clients" ]; "config" [ label=<
config
id
cat
k
...
52 rows
> URL="tables/config.html" tooltip="config" ]; "conv" [ label=<
conv
id
created
updated
...
0 rows
> URL="tables/conv.html" tooltip="conv" ]; "event" [ label=<
event
id
aid
uid
event_xchan
event_hash
start
finish
type
nofinish
adjust
ignore
event_status
event_sequence
...
0 rows
> URL="tables/event.html" tooltip="event" ]; "fcontact" [ label=<
fcontact
id
addr
network
...
0 rows
> URL="tables/fcontact.html" tooltip="fcontact" ]; "ffinder" [ label=<
ffinder
id
uid
cid
fid
0 rows
> URL="tables/ffinder.html" tooltip="ffinder" ]; "fserver" [ label=<
fserver
id
server
posturl
...
0 rows
> URL="tables/fserver.html" tooltip="fserver" ]; "fsuggest" [ label=<
fsuggest
id
...
0 rows
> URL="tables/fsuggest.html" tooltip="fsuggest" ]; "group_member" [ label=<
group_member
id
uid
gid
xchan
2 rows
> URL="tables/group_member.html" tooltip="group_member" ]; "groups" [ label=<
groups
id
hash
uid
visible
deleted
...
5 rows
> URL="tables/groups.html" tooltip="groups" ]; "hook" [ label=<
hook
id
hook
...
0 rows
> URL="tables/hook.html" tooltip="hook" ]; "item" [ label=<
item
id
mid
aid
uid
parent
parent_mid
created
edited
expires
commented
received
changed
comments_closed
owner_xchan
author_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
...
9 613 rows
> URL="tables/item.html" tooltip="item" ]; "item_id" [ label=<
item_id
id
iid
uid
sid
service
1 row
> URL="tables/item_id.html" tooltip="item_id" ]; "likes" [ label=<
likes
id
channel_id
liker
likee
iid
verb
target_type
target_id
...
0 rows
> URL="tables/likes.html" tooltip="likes" ]; "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
...
7 rows
> URL="tables/mail.html" tooltip="mail" ]; "manage" [ label=<
manage
id
uid
xchan
0 rows
> URL="tables/manage.html" tooltip="manage" ]; "notify" [ label=<
notify
id
hash
date
aid
uid
link
parent
seen
type
otype
...
59 rows
> URL="tables/notify.html" tooltip="notify" ]; "pconfig" [ label=<
pconfig
id
uid
cat
k
...
232 rows
> URL="tables/pconfig.html" tooltip="pconfig" ]; "photo" [ label=<
photo
id
aid
uid
xchan
resource_id
album
type
size
scale
photo_usage
profile
is_nsfw
os_storage
photo_flags
...
3 495 rows
> URL="tables/photo.html" tooltip="photo" ]; "profdef" [ label=<
profdef
id
field_name
...
0 rows
> URL="tables/profdef.html" tooltip="profdef" ]; "profext" [ label=<
profext
id
channel_id
hash
k
...
0 rows
> URL="tables/profext.html" tooltip="profext" ]; "profile" [ label=<
profile
id
profile_guid
aid
uid
is_default
hide_friends
locality
postal_code
country_name
hometown
gender
marital
sexual
publish
...
4 rows
> URL="tables/profile.html" tooltip="profile" ]; "profile_check" [ label=<
profile_check
id
uid
cid
dfrn_id
sec
expire
0 rows
> URL="tables/profile_check.html" tooltip="profile_check" ]; "register" [ label=<
register
id
hash
created
uid
...
0 rows
> URL="tables/register.html" tooltip="register" ]; "sign" [ label=<
sign
id
iid
retract_iid
...
0 rows
> URL="tables/sign.html" tooltip="sign" ]; "spam" [ label=<
spam
id
uid
spam
ham
term
...
0 rows
> URL="tables/spam.html" tooltip="spam" ]; "sys_perms" [ label=<
sys_perms
id
k
...
0 rows
> URL="tables/sys_perms.html" tooltip="sys_perms" ]; "tokens" [ label=<
tokens
id
client_id
expires
uid
...
0 rows
> URL="tables/tokens.html" tooltip="tokens" ]; "verify" [ label=<
verify
id
channel
type
token
meta
created
1 row
> URL="tables/verify.html" tooltip="verify" ]; "xconfig" [ label=<
xconfig
id
xchan
cat
k
...
4 rows
> URL="tables/xconfig.html" tooltip="xconfig" ]; "xign" [ label=<
xign
id
uid
xchan
0 rows
> URL="tables/xign.html" tooltip="xign" ]; "addon":"id":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "app":"id":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "attach":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "auth_codes":"client_id":w -> "clients":"client_id":e [arrowhead=none dir=back arrowtail=crowodot style=dashed]; "auth_codes":"id":w -> "tokens":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "config":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "config":"k":w -> "cache":"k":e [arrowhead=none dir=back arrowtail=crowodot style=dashed]; "conv":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "event":"id":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "fcontact":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "ffinder":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "fserver":"id":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "fsuggest":"id":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "group_member":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "groups":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "hook":"id":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "item":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "item_id":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "likes":"channel_id":w -> "channel":"channel_id":e [arrowhead=none dir=back arrowtail=crowodot style=dashed]; "likes":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "mail":"account_id":w -> "account":"account_id":e [arrowhead=none dir=back arrowtail=crowodot style=dashed]; "mail":"channel_id":w -> "channel":"channel_id":e [arrowhead=none dir=back arrowtail=crowodot style=dashed]; "mail":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "manage":"id":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "pconfig":"id":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "pconfig":"k":w -> "cache":"k":e [arrowhead=none dir=back arrowtail=crowodot style=dashed]; "photo":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "profdef":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "profext":"channel_id":w -> "channel":"channel_id":e [arrowhead=none dir=back arrowtail=crowodot style=dashed]; "profext":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "profext":"k":w -> "cache":"k":e [arrowhead=none dir=back arrowtail=crowodot style=dashed]; "profile":"id":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "profile_check":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "register":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "sign":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "spam":"id":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "sys_perms":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "sys_perms":"k":w -> "cache":"k":e [arrowhead=none dir=back arrowtail=crowodot style=dashed]; "tokens":"client_id":w -> "clients":"client_id":e [arrowhead=none dir=back arrowtail=crowodot style=dashed]; "xconfig":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "xconfig":"k":w -> "cache":"k":e [arrowhead=none dir=back arrowtail=crowodot style=dashed]; "xign":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; }