// dot 2.26.3 on Linux 3.2.0-4-686-pae
// SchemaSpy rev 590
digraph "largeImpliedRelationshipsDiagram" {
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"
];
"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 row | |
>
URL="tables/account.html"
tooltip="account"
];
"addon" [
label=<
| addon |
| id |
| name |
| version |
| installed |
| hidden |
| timestamp |
| plugin_admin |
| | 0 rows | |
>
URL="tables/addon.html"
tooltip="addon"
];
"app" [
label=<
| app |
| id |
| app_id |
| app_sig |
| app_author |
| app_name |
| app_desc |
| app_url |
| app_photo |
| app_version |
| app_channel |
| app_addr |
| app_price |
| app_page |
| app_requires |
| | 0 rows | |
>
URL="tables/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 |
| | 0 rows | |
>
URL="tables/attach.html"
tooltip="attach"
];
"auth_codes" [
label=<
| auth_codes |
| id |
| client_id |
| redirect_uri |
| expires |
| scope |
| | 0 rows | |
>
URL="tables/auth_codes.html"
tooltip="auth_codes"
];
"cache" [
label=<
| cache |
| k |
| v |
| updated |
| | 21 rows | |
>
URL="tables/cache.html"
tooltip="cache"
];
"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 rows | |
>
URL="tables/channel.html"
tooltip="channel"
];
"clients" [
label=<
| clients |
| client_id |
| pw |
| redirect_uri |
| name |
| icon |
| uid |
| | 0 rows | |
>
URL="tables/clients.html"
tooltip="clients"
];
"config" [
label=<
| config |
| id |
| cat |
| k |
| v |
| | 52 rows | |
>
URL="tables/config.html"
tooltip="config"
];
"conv" [
label=<
| conv |
| id |
| guid |
| recips |
| uid |
| creator |
| created |
| updated |
| subject |
| | 0 rows | |
>
URL="tables/conv.html"
tooltip="conv"
];
"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 |
| | 0 rows | |
>
URL="tables/event.html"
tooltip="event"
];
"fcontact" [
label=<
| fcontact |
| id |
| url |
| name |
| photo |
| request |
| nick |
| addr |
| batch |
| notify |
| poll |
| confirm |
| priority |
| network |
| alias |
| pubkey |
| updated |
| | 0 rows | |
>
URL="tables/fcontact.html"
tooltip="fcontact"
];
"ffinder" [
label=<
| ffinder |
| id |
| uid |
| cid |
| fid |
| | 0 rows | |
>
URL="tables/ffinder.html"
tooltip="ffinder"
];
"fserver" [
label=<
| fserver |
| id |
| server |
| posturl |
| key |
| | 0 rows | |
>
URL="tables/fserver.html"
tooltip="fserver"
];
"fsuggest" [
label=<
| fsuggest |
| id |
| uid |
| cid |
| name |
| url |
| request |
| photo |
| note |
| created |
| | 0 rows | |
>
URL="tables/fsuggest.html"
tooltip="fsuggest"
];
"group_member" [
label=<
| group_member |
| id |
| uid |
| gid |
| xchan |
| | 2 rows | |
>
URL="tables/group_member.html"
tooltip="group_member"
];
"groups" [
label=<
| groups |
| id |
| hash |
| uid |
| visible |
| deleted |
| name |
| | 5 rows | |
>
URL="tables/groups.html"
tooltip="groups"
];
"hook" [
label=<
| hook |
| id |
| hook |
| file |
| function |
| priority |
| | 0 rows | |
>
URL="tables/hook.html"
tooltip="hook"
];
"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 |
| | 9 613 rows | |
>
URL="tables/item.html"
tooltip="item"
];
"item_id" [
label=<
| item_id |
| id |
| iid |
| uid |
| sid |
| service |
| | 1 row | |
>
URL="tables/item_id.html"
tooltip="item_id"
];
"likes" [
label=<
| likes |
| id |
| channel_id |
| liker |
| likee |
| iid |
| verb |
| target_type |
| target_id |
| target |
| | 0 rows | |
>
URL="tables/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 |
| | 7 rows | |
>
URL="tables/mail.html"
tooltip="mail"
];
"manage" [
label=<
| manage |
| id |
| uid |
| xchan |
| | 0 rows | |
>
URL="tables/manage.html"
tooltip="manage"
];
"notify" [
label=<
| notify |
| id |
| hash |
| name |
| url |
| photo |
| date |
| msg |
| aid |
| uid |
| link |
| parent |
| seen |
| type |
| verb |
| otype |
| | 59 rows | |
>
URL="tables/notify.html"
tooltip="notify"
];
"pconfig" [
label=<
| pconfig |
| id |
| uid |
| cat |
| k |
| v |
| | 232 rows | |
>
URL="tables/pconfig.html"
tooltip="pconfig"
];
"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 |
| | 3 495 rows | |
>
URL="tables/photo.html"
tooltip="photo"
];
"profdef" [
label=<
| profdef |
| id |
| field_name |
| field_type |
| field_desc |
| field_help |
| field_inputs |
| | 0 rows | |
>
URL="tables/profdef.html"
tooltip="profdef"
];
"profext" [
label=<
| profext |
| id |
| channel_id |
| hash |
| k |
| v |
| | 0 rows | |
>
URL="tables/profext.html"
tooltip="profext"
];
"profile" [
label=<
| profile |
| id |
| profile_guid |
| aid |
| uid |
| profile_name |
| is_default |
| hide_friends |
| name |
| pdesc |
| chandesc |
| dob |
| dob_tz |
| address |
| locality |
| region |
| postal_code |
| country_name |
| hometown |
| gender |
| marital |
| with |
| howlong |
| sexual |
| politic |
| religion |
| keywords |
| likes |
| dislikes |
| about |
| summary |
| music |
| book |
| tv |
| film |
| interest |
| romance |
| work |
| education |
| contact |
| channels |
| homepage |
| photo |
| thumb |
| publish |
| | 4 rows | |
>
URL="tables/profile.html"
tooltip="profile"
];
"profile_check" [
label=<
| profile_check |
| id |
| uid |
| cid |
| dfrn_id |
| sec |
| expire |
| | 0 rows | |
>
URL="tables/profile_check.html"
tooltip="profile_check"
];
"register" [
label=<
| register |
| id |
| hash |
| created |
| uid |
| password |
| language |
| | 0 rows | |
>
URL="tables/register.html"
tooltip="register"
];
"sign" [
label=<
| sign |
| id |
| iid |
| retract_iid |
| signed_text |
| signature |
| signer |
| | 0 rows | |
>
URL="tables/sign.html"
tooltip="sign"
];
"spam" [
label=<
| spam |
| id |
| uid |
| spam |
| ham |
| term |
| date |
| | 0 rows | |
>
URL="tables/spam.html"
tooltip="spam"
];
"sys_perms" [
label=<
| sys_perms |
| id |
| cat |
| k |
| v |
| public_perm |
| | 0 rows | |
>
URL="tables/sys_perms.html"
tooltip="sys_perms"
];
"tokens" [
label=<
| tokens |
| id |
| secret |
| client_id |
| expires |
| scope |
| uid |
| | 0 rows | |
>
URL="tables/tokens.html"
tooltip="tokens"
];
"verify" [
label=<
| verify |
| id |
| channel |
| type |
| token |
| meta |
| created |
| | 1 row | |
>
URL="tables/verify.html"
tooltip="verify"
];
"xconfig" [
label=<
| xconfig |
| id |
| xchan |
| cat |
| k |
| v |
| | 4 rows | |
>
URL="tables/xconfig.html"
tooltip="xconfig"
];
"xign" [
label=<
>
URL="tables/xign.html"
tooltip="xign"
];
"addon":"id":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"app":"id":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"attach":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"auth_codes":"client_id":w -> "clients":"client_id":e [arrowhead=none dir=back arrowtail=crowodot style=dashed];
"auth_codes":"id":w -> "tokens":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"config":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"config":"k":w -> "cache":"k":e [arrowhead=none dir=back arrowtail=crowodot style=dashed];
"conv":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"event":"id":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"fcontact":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"ffinder":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"fserver":"id":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"fsuggest":"id":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"group_member":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"groups":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"hook":"id":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"item":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"item_id":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"likes":"channel_id":w -> "channel":"channel_id":e [arrowhead=none dir=back arrowtail=crowodot style=dashed];
"likes":"id":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];
"manage":"id":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"pconfig":"id":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"pconfig":"k":w -> "cache":"k":e [arrowhead=none dir=back arrowtail=crowodot style=dashed];
"photo":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"profdef":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"profext":"channel_id":w -> "channel":"channel_id":e [arrowhead=none dir=back arrowtail=crowodot style=dashed];
"profext":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"profext":"k":w -> "cache":"k":e [arrowhead=none dir=back arrowtail=crowodot style=dashed];
"profile":"id":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"profile_check":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"register":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"sign":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"spam":"id":w -> "notify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"sys_perms":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"sys_perms":"k":w -> "cache":"k":e [arrowhead=none dir=back arrowtail=crowodot style=dashed];
"tokens":"client_id":w -> "clients":"client_id":e [arrowhead=none dir=back arrowtail=crowodot style=dashed];
"xconfig":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"xconfig":"k":w -> "cache":"k":e [arrowhead=none dir=back arrowtail=crowodot style=dashed];
"xign":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
}