// 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" ]; "attach":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "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]; "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]; "groups":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "item":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "item_id":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "likes":"elipses":w -> "channel":"channel_id":e [arrowhead=none dir=back arrowtail=crowodot style=dashed]; "likes":"elipses":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]; "photo":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "profdef":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "profext":"elipses":w -> "channel":"channel_id":e [arrowhead=none dir=back arrowtail=crowodot style=dashed]; "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 -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "sign":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "sys_perms":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "xconfig":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "xign":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; "account" [ label=<
account
account_id
account_parent
account_default_channel
account_salt
account_password
account_email
account_external
account_language
account_created
account_lastlog
account_flags
account_roles
account_reset
account_expires
account_expire_notified
account_service_class
account_level
account_password_changed
1 row1 >
> URL="account.html" tooltip="account" ]; "attach" [ label=<
attach
...
< 10 rows
> URL="attach.html" tooltip="attach" ]; "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
5 rows3 >
> URL="channel.html" tooltip="channel" ]; "config" [ label=<
config
...
< 252 rows
> URL="config.html" tooltip="config" ]; "conv" [ label=<
conv
...
< 10 rows
> URL="conv.html" tooltip="conv" ]; "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
...
< 12 rows
> URL="group_member.html" tooltip="group_member" ]; "groups" [ label=<
groups
...
< 15 rows
> URL="groups.html" tooltip="groups" ]; "item" [ label=<
item
...
< 19 613 rows
> URL="item.html" tooltip="item" ]; "item_id" [ label=<
item_id
...
< 11 row
> URL="item_id.html" tooltip="item_id" ]; "likes" [ label=<
likes
...
< 20 rows
> URL="likes.html" tooltip="likes" ]; "mail" [ label=<
mail
idint unsigned[10]
convidint unsigned[10]
mail_flagsint unsigned[10]
from_xchanchar[255]
to_xchanchar[255]
account_idint unsigned[10]
channel_idint unsigned[10]
titletext[65535]
bodymediumtext[16777215]
sigtext[65535]
attachmediumtext[16777215]
midchar[255]
parent_midchar[255]
mail_deletedtinyint[3]
mail_repliedtinyint[3]
mail_isreplytinyint[3]
mail_seentinyint[3]
mail_recalledtinyint[3]
mail_obscuredsmallint[5]
createddatetime[19]
expiresdatetime[19]
< 37 rows0 >
> URL="mail.html" tooltip="mail" ]; "photo" [ label=<
photo
...
< 13 495 rows
> URL="photo.html" tooltip="photo" ]; "profdef" [ label=<
profdef
...
< 10 rows
> URL="profdef.html" tooltip="profdef" ]; "profext" [ label=<
profext
...
< 30 rows
> URL="profext.html" tooltip="profext" ]; "profile_check" [ label=<
profile_check
...
< 10 rows
> URL="profile_check.html" tooltip="profile_check" ]; "register" [ label=<
register
...
< 10 rows
> URL="register.html" tooltip="register" ]; "sign" [ label=<
sign
...
< 10 rows
> URL="sign.html" tooltip="sign" ]; "sys_perms" [ label=<
sys_perms
...
< 20 rows
> URL="sys_perms.html" tooltip="sys_perms" ]; "verify" [ label=<
verify
id
channel
type
token
meta
created
1 row20 >
> URL="verify.html" tooltip="verify" ]; "xconfig" [ label=<
xconfig
...
< 24 rows
> URL="xconfig.html" tooltip="xconfig" ]; "xign" [ label=<
xign
...
< 10 rows
> URL="xign.html" tooltip="xign" ]; }