// dot 2.26.3 on Linux 3.2.0-4-686-pae
// SchemaSpy rev 590
digraph "oneDegreeRelationshipsDiagram" {
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":"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];
"hubloc":"hubloc_hash":w -> "channel":"channel_hash":e [arrowhead=none dir=back arrowtail=crowodot];
"hubloc":"hubloc_hash":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];
"attach" [
label=<
| attach |
| id | int unsigned[10] |
| aid | int unsigned[10] |
| uid | int unsigned[10] |
| hash | char[64] |
| creator | char[128] |
| filename | char[255] |
| filetype | char[64] |
| filesize | int unsigned[10] |
| revision | int unsigned[10] |
| folder | char[64] |
| flags | int unsigned[10] |
| is_dir | bit[0] |
| is_photo | bit[0] |
| os_storage | bit[0] |
| os_path | mediumtext[16777215] |
| display_path | mediumtext[16777215] |
| data | longblob[2147483647] |
| created | datetime[19] |
| edited | datetime[19] |
| allow_cid | mediumtext[16777215] |
| allow_gid | mediumtext[16777215] |
| deny_cid | mediumtext[16777215] |
| deny_gid | mediumtext[16777215] |
| < 3 | 105 rows | 0 > |
>
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 |
| < 1 | 12 rows | 14 > |
>
URL="channel.html"
tooltip="channel"
];
"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"
];
"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"
];
}