// 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.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];
"channel":"channel_hash":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];
"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];
"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];
"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];
"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];
"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];
"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];
"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];
"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];
"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 |
| < 3 | 105 rows | |
>
URL="attach.html"
tooltip="attach"
];
"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 | 14 > |
>
URL="channel.html"
tooltip="channel"
];
"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 |
| < 4 | 12 rows | |
>
URL="event.html"
tooltip="event"
];
"groups" [
label=<
| groups |
| id |
| hash |
| uid |
| visible |
| deleted |
| name |
| < 3 | 10 rows | |
>
URL="groups.html"
tooltip="groups"
];
"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"
];
"notify" [
label=<
| notify |
| id |
| hash |
| name |
| url |
| photo |
| date |
| msg |
| aid |
| uid |
| link |
| parent |
| seen |
| type |
| verb |
| otype |
| < 3 | 528 rows | |
>
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"
];
"profext" [
label=<
| profext |
| id |
| channel_id |
| hash |
| k |
| v |
| < 3 | 0 rows | |
>
URL="profext.html"
tooltip="profext"
];
"register" [
label=<
| register |
| id |
| hash |
| created |
| uid |
| password |
| language |
| < 3 | 0 rows | |
>
URL="register.html"
tooltip="register"
];
"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"
];
"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"
];
"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"
];
}