// 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"
];
"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":"id":w -> "verify":"elipses":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"profext":"channel_id":w -> "channel":"channel_id.type":e [arrowhead=none dir=back arrowtail=crowodot style=dashed];
"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];
"account" [
label=<
>
URL="account.html"
tooltip="account"
];
"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] |
| < 0 | 5 rows | 3 > |
>
URL="channel.html"
tooltip="channel"
];
"likes" [
label=<
| likes |
| id |
| channel_id |
| liker |
| likee |
| iid |
| verb |
| target_type |
| target_id |
| target |
| < 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 |
| < 3 | 7 rows | |
>
URL="mail.html"
tooltip="mail"
];
"profext" [
label=<
| profext |
| id |
| channel_id |
| hash |
| k |
| v |
| < 3 | 0 rows | |
>
URL="profext.html"
tooltip="profext"
];
"verify" [
label=<
>
URL="verify.html"
tooltip="verify"
];
}