// 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.type":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];
"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.type":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];
"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.type":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];
"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.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":"channel_id":w -> "channel":"channel_id.type":e [arrowhead=none dir=back arrowtail=crowodot style=dashed];
"likes":"id":w -> "verify":"elipses":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"mail":"account_id":w -> "account":"elipses":e [arrowhead=none dir=back arrowtail=crowodot style=dashed];
"mail":"channel_id":w -> "channel":"channel_id.type":e [arrowhead=none dir=back arrowtail=crowodot style=dashed];
"mail":"from_xchan":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
"mail":"id":w -> "verify":"elipses":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"mail":"to_xchan":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.type":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.type":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];
"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.type":e [arrowhead=none dir=back arrowtail=crowodot style=dashed];
"profext":"hash":w -> "channel":"channel_hash.type":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];
"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.type":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];
"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.type":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.type":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.type":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":"elipses":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
"xchan":"xchan_hash":w -> "channel":"channel_hash.type":e [arrowhead=none dir=back arrowtail=teeodot];
"xchan":"xchan_hash":w -> "hubloc":"hubloc_hash":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.type":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.type":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];
"abook" [
label=<
>
URL="abook.html"
tooltip="abook"
];
"account" [
label=<
>
URL="account.html"
tooltip="account"
];
"addon" [
label=<
>
URL="addon.html"
tooltip="addon"
];
"app" [
label=<
>
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 |
| < 4 | 105 rows | |
>
URL="attach.html"
tooltip="attach"
];
"cache" [
label=<
>
URL="cache.html"
tooltip="cache"
];
"channel" [
label=<
| channel |
| channel_id | int unsigned[10] |
| channel_account_id | int unsigned[10] |
| channel_primary | bit[0] |
| channel_name | char[255] |
| channel_address | char[255] |
| channel_guid | char[255] |
| channel_guid_sig | text[65535] |
| channel_hash | char[255] |
| channel_timezone | char[128] |
| channel_location | char[255] |
| channel_theme | char[255] |
| channel_startpage | char[255] |
| channel_pubkey | text[65535] |
| channel_prvkey | text[65535] |
| channel_notifyflags | int unsigned[10] |
| channel_pageflags | int unsigned[10] |
| channel_dirdate | datetime[19] |
| channel_lastpost | datetime[19] |
| channel_deleted | datetime[19] |
| channel_max_anon_mail | int unsigned[10] |
| channel_max_friend_req | int unsigned[10] |
| channel_expire_days | int[10] |
| channel_passwd_reset | char[255] |
| channel_default_group | char[255] |
| channel_allow_cid | mediumtext[16777215] |
| channel_allow_gid | mediumtext[16777215] |
| channel_deny_cid | mediumtext[16777215] |
| channel_deny_gid | mediumtext[16777215] |
| channel_r_stream | int unsigned[10] |
| channel_r_profile | int unsigned[10] |
| channel_r_photos | int unsigned[10] |
| channel_r_abook | int unsigned[10] |
| channel_w_stream | int unsigned[10] |
| channel_w_wall | int unsigned[10] |
| channel_w_tagwall | int unsigned[10] |
| channel_w_comment | int unsigned[10] |
| channel_w_mail | int unsigned[10] |
| channel_w_photos | int unsigned[10] |
| channel_w_chat | int unsigned[10] |
| channel_a_delegate | int unsigned[10] |
| channel_r_storage | int unsigned[10] |
| channel_w_storage | int unsigned[10] |
| channel_r_pages | int unsigned[10] |
| channel_w_pages | int unsigned[10] |
| channel_a_republish | int unsigned[10] |
| channel_w_like | int unsigned[10] |
| channel_removed | bit[0] |
| channel_system | bit[0] |
| < 1 | 12 rows | 17 > |
>
URL="channel.html"
tooltip="channel"
];
"chat" [
label=<
>
URL="chat.html"
tooltip="chat"
];
"chatpresence" [
label=<
| chatpresence |
| ... |
| < 1 | 1 row | |
>
URL="chatpresence.html"
tooltip="chatpresence"
];
"dreport" [
label=<
| dreport |
| ... |
| < 1 | 8 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 |
| < 5 | 12 rows | |
>
URL="event.html"
tooltip="event"
];
"fserver" [
label=<
>
URL="fserver.html"
tooltip="fserver"
];
"fsuggest" [
label=<
>
URL="fsuggest.html"
tooltip="fsuggest"
];
"group_member" [
label=<
| group_member |
| ... |
| < 2 | 42 rows | |
>
URL="group_member.html"
tooltip="group_member"
];
"groups" [
label=<
| groups |
| id |
| hash |
| uid |
| visible |
| deleted |
| name |
| < 4 | 10 rows | |
>
URL="groups.html"
tooltip="groups"
];
"hook" [
label=<
>
URL="hook.html"
tooltip="hook"
];
"hubloc" [
label=<
| hubloc |
| hubloc_id |
| hubloc_guid |
| hubloc_guid_sig |
| hubloc_hash |
| hubloc_addr |
| hubloc_network |
| hubloc_flags |
| hubloc_status |
| hubloc_url |
| hubloc_url_sig |
| hubloc_host |
| hubloc_callback |
| hubloc_connect |
| hubloc_sitekey |
| hubloc_updated |
| hubloc_connected |
| hubloc_primary |
| hubloc_orphancheck |
| hubloc_error |
| hubloc_deleted |
| < 3 | 2 658 rows | 14 > |
>
URL="hubloc.html"
tooltip="hubloc"
];
"item" [
label=<
>
URL="item.html"
tooltip="item"
];
"likes" [
label=<
| likes |
| id |
| channel_id |
| liker |
| likee |
| iid |
| verb |
| target_type |
| target_id |
| target |
| i_mid |
| < 2 | 0 rows | |
>
URL="likes.html"
tooltip="likes"
];
"mail" [
label=<
| mail |
| id |
| convid |
| mail_flags |
| from_xchan |
| to_xchan |
| account_id |
| channel_id |
| title |
| body |
| sig |
| attach |
| mid |
| parent_mid |
| mail_deleted |
| mail_replied |
| mail_isreply |
| mail_seen |
| mail_recalled |
| mail_obscured |
| created |
| expires |
| conv_guid |
| < 5 | 39 rows | |
>
URL="mail.html"
tooltip="mail"
];
"manage" [
label=<
>
URL="manage.html"
tooltip="manage"
];
"notify" [
label=<
| notify |
| id |
| hash |
| name |
| url |
| photo |
| date |
| msg |
| aid |
| uid |
| link |
| parent |
| seen |
| type |
| verb |
| otype |
| < 3 | 528 rows | 10 > |
>
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 |
| < 3 | 660 rows | |
>
URL="outq.html"
tooltip="outq"
];
"pconfig" [
label=<
>
URL="pconfig.html"
tooltip="pconfig"
];
"photo" [
label=<
>
URL="photo.html"
tooltip="photo"
];
"profext" [
label=<
| profext |
| id |
| channel_id |
| hash |
| k |
| v |
| < 6 | 0 rows | |
>
URL="profext.html"
tooltip="profext"
];
"profile" [
label=<
>
URL="profile.html"
tooltip="profile"
];
"register" [
label=<
| register |
| id |
| hash |
| created |
| uid |
| password |
| language |
| < 4 | 0 rows | |
>
URL="register.html"
tooltip="register"
];
"shares" [
label=<
>
URL="shares.html"
tooltip="shares"
];
"source" [
label=<
>
URL="source.html"
tooltip="source"
];
"spam" [
label=<
>
URL="spam.html"
tooltip="spam"
];
"term" [
label=<
| term |
| tid |
| aid |
| uid |
| oid |
| otype |
| type |
| term |
| url |
| imgurl |
| term_hash |
| parent_hash |
| < 6 | 8 980 rows | |
>
URL="term.html"
tooltip="term"
];
"updates" [
label=<
| updates |
| ud_id |
| ud_hash |
| ud_guid |
| ud_date |
| ud_last |
| ud_flags |
| ud_addr |
| < 3 | 0 rows | |
>
URL="updates.html"
tooltip="updates"
];
"verify" [
label=<
>
URL="verify.html"
tooltip="verify"
];
"vote" [
label=<
>
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 |
| < 2 | 2 301 rows | 35 > |
>
URL="xchan.html"
tooltip="xchan"
];
"xchat" [
label=<
>
URL="xchat.html"
tooltip="xchat"
];
"xconfig" [
label=<
>
URL="xconfig.html"
tooltip="xconfig"
];
"xign" [
label=<
>
URL="xign.html"
tooltip="xign"
];
"xlink" [
label=<
>
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 |
| < 3 | 0 rows | |
>
URL="xprof.html"
tooltip="xprof"
];
"xtag" [
label=<
| xtag |
| xtag_id |
| xtag_hash |
| xtag_term |
| xtag_flags |
| < 3 | 0 rows | |
>
URL="xtag.html"
tooltip="xtag"
];
}