// 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"
];
"item":"author_xchan":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
"item":"owner_xchan":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
"item":"source_xchan":w -> "xchan":"xchan_hash":e [arrowhead=none dir=back arrowtail=crowodot];
"item" [
label=<
| item |
| id | int unsigned[10] |
| mid | char[255] |
| aid | int unsigned[10] |
| uid | int unsigned[10] |
| parent | int unsigned[10] |
| parent_mid | char[255] |
| thr_parent | char[255] |
| created | datetime[19] |
| edited | datetime[19] |
| expires | datetime[19] |
| commented | datetime[19] |
| received | datetime[19] |
| changed | datetime[19] |
| comments_closed | datetime[19] |
| owner_xchan | char[255] |
| author_xchan | char[255] |
| source_xchan | char[255] |
| mimetype | char[255] |
| title | text[65535] |
| body | mediumtext[16777215] |
| html | mediumtext[16777215] |
| app | char[255] |
| lang | char[64] |
| revision | int unsigned[10] |
| verb | char[255] |
| obj_type | char[255] |
| object | text[65535] |
| tgt_type | char[255] |
| target | text[65535] |
| layout_mid | char[255] |
| postopts | text[65535] |
| route | text[65535] |
| llink | char[255] |
| plink | char[255] |
| resource_id | char[255] |
| resource_type | char[16] |
| attach | mediumtext[16777215] |
| sig | text[65535] |
| diaspora_meta | mediumtext[16777215] |
| location | char[255] |
| coord | char[255] |
| public_policy | char[255] |
| comment_policy | char[255] |
| allow_cid | mediumtext[16777215] |
| allow_gid | mediumtext[16777215] |
| deny_cid | mediumtext[16777215] |
| deny_gid | mediumtext[16777215] |
| item_restrict | int[10] |
| item_flags | int[10] |
| item_private | bit[0] |
| item_origin | bit[0] |
| item_unseen | bit[0] |
| item_starred | bit[0] |
| item_uplink | bit[0] |
| item_consensus | bit[0] |
| item_wall | bit[0] |
| item_thread_top | bit[0] |
| item_notshown | bit[0] |
| item_nsfw | bit[0] |
| item_relay | bit[0] |
| item_mentionsme | bit[0] |
| item_nocomment | bit[0] |
| item_obscured | bit[0] |
| item_verified | bit[0] |
| item_retained | bit[0] |
| item_rss | bit[0] |
| item_deleted | bit[0] |
| item_type | int[10] |
| item_hidden | bit[0] |
| item_unpublished | bit[0] |
| item_delayed | bit[0] |
| item_pending_remove | bit[0] |
| item_blocked | bit[0] |
| < 3 | 37 583 rows | 0 > |
>
URL="item.html"
tooltip="item"
];
"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"
];
}