// 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":"hash":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"attach":"hash":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"attach":"hash":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"attach":"id":w -> "verify":"id.type":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"channel":"elipses":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"config":"id":w -> "verify":"id.type":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"config":"k":w -> "cache":"elipses":e [arrowhead=none dir=back arrowtail=crowodot style=dashed];
"conv":"id":w -> "verify":"id.type":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"fcontact":"id":w -> "verify":"id.type":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"ffinder":"id":w -> "verify":"id.type":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"group_member":"id":w -> "verify":"id.type":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"group_member":"xchan":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"groups":"hash":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"groups":"hash":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"groups":"hash":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"groups":"id":w -> "verify":"id.type":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"hubloc":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"hubloc":"elipses":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"item":"author_xchan":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"item":"id":w -> "verify":"id.type":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"item":"owner_xchan":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"item":"source_xchan":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"item_id":"id":w -> "verify":"id.type":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"likes":"channel_id":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot style=dashed];
"likes":"id":w -> "verify":"id.type":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":"elipses":e [arrowhead=none dir=back arrowtail=crowodot style=dashed];
"mail":"from_xchan":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"mail":"id":w -> "verify":"id.type":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"mail":"to_xchan":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"photo":"id":w -> "verify":"id.type":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"photo":"xchan":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"profdef":"id":w -> "verify":"id.type":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"profext":"channel_id":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot style=dashed];
"profext":"hash":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"profext":"hash":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"profext":"hash":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"profext":"id":w -> "verify":"id.type":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"profext":"k":w -> "cache":"elipses":e [arrowhead=none dir=back arrowtail=crowodot style=dashed];
"profile_check":"id":w -> "verify":"id.type":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"register":"hash":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"register":"hash":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"register":"hash":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"register":"id":w -> "verify":"id.type":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"sign":"id":w -> "verify":"id.type":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"sys_perms":"id":w -> "verify":"id.type":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"sys_perms":"k":w -> "cache":"elipses":e [arrowhead=none dir=back arrowtail=crowodot style=dashed];
"xchan":"elipses":w -> "channel":"elipses":e [arrowhead=none dir=back arrowtail=teeodot];
"xchan":"elipses":w -> "hubloc":"elipses":e [arrowhead=none dir=back arrowtail=teeodot];
"xconfig":"id":w -> "verify":"id.type":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"xconfig":"k":w -> "cache":"elipses":e [arrowhead=none dir=back arrowtail=crowodot style=dashed];
"xconfig":"xchan":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"xign":"id":w -> "verify":"id.type":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"xign":"xchan":w -> "xchan":"elipses":e [arrowhead=none dir=back arrowtail=crowodot];
"account" [
label=<
>
URL="account.html"
tooltip="account"
];
"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 |
| ... |
| < 1 | 12 rows | 17 > |
>
URL="channel.html"
tooltip="channel"
];
"config" [
label=<
| config |
| id |
| cat |
| k |
| v |
| < 2 | 83 rows | |
>
URL="config.html"
tooltip="config"
];
"conv" [
label=<
| conv |
| id |
| guid |
| recips |
| uid |
| creator |
| created |
| updated |
| subject |
| < 1 | 15 rows | |
>
URL="conv.html"
tooltip="conv"
];
"fcontact" [
label=<
| fcontact |
| id |
| url |
| name |
| photo |
| request |
| nick |
| addr |
| batch |
| notify |
| poll |
| confirm |
| priority |
| network |
| alias |
| pubkey |
| updated |
| < 1 | 0 rows | |
>
URL="fcontact.html"
tooltip="fcontact"
];
"ffinder" [
label=<
| ffinder |
| id |
| uid |
| cid |
| fid |
| < 1 | 0 rows | |
>
URL="ffinder.html"
tooltip="ffinder"
];
"group_member" [
label=<
| group_member |
| id |
| uid |
| gid |
| xchan |
| < 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"
];
"hubloc" [
label=<
| hubloc |
| ... |
| < 3 | 2 658 rows | 14 > |
>
URL="hubloc.html"
tooltip="hubloc"
];
"item" [
label=<
| item |
| id |
| mid |
| aid |
| uid |
| parent |
| parent_mid |
| thr_parent |
| created |
| edited |
| expires |
| commented |
| received |
| changed |
| comments_closed |
| owner_xchan |
| author_xchan |
| source_xchan |
| mimetype |
| title |
| body |
| html |
| app |
| lang |
| revision |
| verb |
| obj_type |
| object |
| tgt_type |
| target |
| layout_mid |
| postopts |
| route |
| llink |
| plink |
| resource_id |
| resource_type |
| attach |
| sig |
| diaspora_meta |
| location |
| coord |
| 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 |
| < 4 | 37 583 rows | |
>
URL="item.html"
tooltip="item"
];
"item_id" [
label=<
| item_id |
| id |
| iid |
| uid |
| sid |
| service |
| < 1 | 194 rows | |
>
URL="item_id.html"
tooltip="item_id"
];
"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"
];
"photo" [
label=<
| photo |
| id |
| aid |
| uid |
| xchan |
| resource_id |
| created |
| edited |
| title |
| description |
| album |
| filename |
| type |
| height |
| width |
| size |
| data |
| scale |
| photo_usage |
| profile |
| is_nsfw |
| os_storage |
| os_path |
| display_path |
| photo_flags |
| allow_cid |
| allow_gid |
| deny_cid |
| deny_gid |
| < 2 | 5 888 rows | |
>
URL="photo.html"
tooltip="photo"
];
"profdef" [
label=<
| profdef |
| id |
| field_name |
| field_type |
| field_desc |
| field_help |
| field_inputs |
| < 1 | 0 rows | |
>
URL="profdef.html"
tooltip="profdef"
];
"profext" [
label=<
| profext |
| id |
| channel_id |
| hash |
| k |
| v |
| < 6 | 0 rows | |
>
URL="profext.html"
tooltip="profext"
];
"profile_check" [
label=<
| profile_check |
| id |
| uid |
| cid |
| dfrn_id |
| sec |
| expire |
| < 1 | 0 rows | |
>
URL="profile_check.html"
tooltip="profile_check"
];
"register" [
label=<
| register |
| id |
| hash |
| created |
| uid |
| password |
| language |
| < 4 | 0 rows | |
>
URL="register.html"
tooltip="register"
];
"sign" [
label=<
| sign |
| id |
| iid |
| retract_iid |
| signed_text |
| signature |
| signer |
| < 1 | 0 rows | |
>
URL="sign.html"
tooltip="sign"
];
"sys_perms" [
label=<
| sys_perms |
| id |
| cat |
| k |
| v |
| public_perm |
| < 2 | 0 rows | |
>
URL="sys_perms.html"
tooltip="sys_perms"
];
"verify" [
label=<
| verify |
| id | int unsigned[10] |
| channel | int unsigned[10] |
| type | char[32] |
| token | char[255] |
| meta | char[255] |
| created | datetime[19] |
| < 0 | 0 rows | 20 > |
>
URL="verify.html"
tooltip="verify"
];
"xchan" [
label=<
| xchan |
| ... |
| < 2 | 2 301 rows | 35 > |
>
URL="xchan.html"
tooltip="xchan"
];
"xconfig" [
label=<
| xconfig |
| id |
| xchan |
| cat |
| k |
| v |
| < 3 | 8 rows | |
>
URL="xconfig.html"
tooltip="xconfig"
];
"xign" [
label=<
| xign |
| id |
| uid |
| xchan |
| < 2 | 0 rows | |
>
URL="xign.html"
tooltip="xign"
];
}