diff options
author | redmatrix <redmatrix@redmatrix.me> | 2015-11-08 16:57:56 +1100 |
---|---|---|
committer | redmatrix <redmatrix@redmatrix.me> | 2015-11-08 16:57:56 +1100 |
commit | 1874346c460c29a087bb81833c0b760a91e35970 (patch) | |
tree | 4037bfe80525236c0eb493fcf28f05f663ef83f9 /doc/schemaspy_hubzilla/diagrams/item.1degree.dot | |
parent | 16040063dc7bea1f6d4d76131ae8f84505531900 (diff) | |
parent | df2b687a95b8ad6ed58d9557aaa837f88b57f04a (diff) | |
download | volse-hubzilla-1874346c460c29a087bb81833c0b760a91e35970.tar.gz volse-hubzilla-1874346c460c29a087bb81833c0b760a91e35970.tar.bz2 volse-hubzilla-1874346c460c29a087bb81833c0b760a91e35970.zip |
Merge pull request #129 from HaakonME/master
Hubzilla database entity-relationship documentation and HonO fix
Diffstat (limited to 'doc/schemaspy_hubzilla/diagrams/item.1degree.dot')
-rw-r--r-- | doc/schemaspy_hubzilla/diagrams/item.1degree.dot | 142 |
1 files changed, 142 insertions, 0 deletions
diff --git a/doc/schemaspy_hubzilla/diagrams/item.1degree.dot b/doc/schemaspy_hubzilla/diagrams/item.1degree.dot new file mode 100644 index 000000000..187222dd8 --- /dev/null +++ b/doc/schemaspy_hubzilla/diagrams/item.1degree.dot @@ -0,0 +1,142 @@ +// 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=< + <TABLE BORDER="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff"> + <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">item</TD></TR> + <TR><TD PORT="id" COLSPAN="2" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD><TD PORT="id.type" ALIGN="LEFT">int unsigned[10]</TD></TR> + <TR><TD PORT="mid" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">mid</TD><TD PORT="mid.type" ALIGN="LEFT">char[255]</TD></TR> + <TR><TD PORT="aid" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">aid</TD><TD PORT="aid.type" ALIGN="LEFT">int unsigned[10]</TD></TR> + <TR><TD PORT="uid" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">uid</TD><TD PORT="uid.type" ALIGN="LEFT">int unsigned[10]</TD></TR> + <TR><TD PORT="parent" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">parent</TD><TD PORT="parent.type" ALIGN="LEFT">int unsigned[10]</TD></TR> + <TR><TD PORT="parent_mid" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">parent_mid</TD><TD PORT="parent_mid.type" ALIGN="LEFT">char[255]</TD></TR> + <TR><TD PORT="thr_parent" COLSPAN="2" ALIGN="LEFT">thr_parent</TD><TD PORT="thr_parent.type" ALIGN="LEFT">char[255]</TD></TR> + <TR><TD PORT="created" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">created</TD><TD PORT="created.type" ALIGN="LEFT">datetime[19]</TD></TR> + <TR><TD PORT="edited" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">edited</TD><TD PORT="edited.type" ALIGN="LEFT">datetime[19]</TD></TR> + <TR><TD PORT="expires" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">expires</TD><TD PORT="expires.type" ALIGN="LEFT">datetime[19]</TD></TR> + <TR><TD PORT="commented" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">commented</TD><TD PORT="commented.type" ALIGN="LEFT">datetime[19]</TD></TR> + <TR><TD PORT="received" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">received</TD><TD PORT="received.type" ALIGN="LEFT">datetime[19]</TD></TR> + <TR><TD PORT="changed" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">changed</TD><TD PORT="changed.type" ALIGN="LEFT">datetime[19]</TD></TR> + <TR><TD PORT="comments_closed" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">comments_closed</TD><TD PORT="comments_closed.type" ALIGN="LEFT">datetime[19]</TD></TR> + <TR><TD PORT="owner_xchan" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">owner_xchan</TD><TD PORT="owner_xchan.type" ALIGN="LEFT">char[255]</TD></TR> + <TR><TD PORT="author_xchan" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">author_xchan</TD><TD PORT="author_xchan.type" ALIGN="LEFT">char[255]</TD></TR> + <TR><TD PORT="source_xchan" COLSPAN="2" ALIGN="LEFT">source_xchan</TD><TD PORT="source_xchan.type" ALIGN="LEFT">char[255]</TD></TR> + <TR><TD PORT="mimetype" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">mimetype</TD><TD PORT="mimetype.type" ALIGN="LEFT">char[255]</TD></TR> + <TR><TD PORT="title" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">title</TD><TD PORT="title.type" ALIGN="LEFT">text[65535]</TD></TR> + <TR><TD PORT="body" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">body</TD><TD PORT="body.type" ALIGN="LEFT">mediumtext[16777215]</TD></TR> + <TR><TD PORT="html" COLSPAN="2" ALIGN="LEFT">html</TD><TD PORT="html.type" ALIGN="LEFT">mediumtext[16777215]</TD></TR> + <TR><TD PORT="app" COLSPAN="2" ALIGN="LEFT">app</TD><TD PORT="app.type" ALIGN="LEFT">char[255]</TD></TR> + <TR><TD PORT="lang" COLSPAN="2" ALIGN="LEFT">lang</TD><TD PORT="lang.type" ALIGN="LEFT">char[64]</TD></TR> + <TR><TD PORT="revision" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">revision</TD><TD PORT="revision.type" ALIGN="LEFT">int unsigned[10]</TD></TR> + <TR><TD PORT="verb" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">verb</TD><TD PORT="verb.type" ALIGN="LEFT">char[255]</TD></TR> + <TR><TD PORT="obj_type" COLSPAN="2" ALIGN="LEFT">obj_type</TD><TD PORT="obj_type.type" ALIGN="LEFT">char[255]</TD></TR> + <TR><TD PORT="object" COLSPAN="2" ALIGN="LEFT">object</TD><TD PORT="object.type" ALIGN="LEFT">text[65535]</TD></TR> + <TR><TD PORT="tgt_type" COLSPAN="2" ALIGN="LEFT">tgt_type</TD><TD PORT="tgt_type.type" ALIGN="LEFT">char[255]</TD></TR> + <TR><TD PORT="target" COLSPAN="2" ALIGN="LEFT">target</TD><TD PORT="target.type" ALIGN="LEFT">text[65535]</TD></TR> + <TR><TD PORT="layout_mid" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">layout_mid</TD><TD PORT="layout_mid.type" ALIGN="LEFT">char[255]</TD></TR> + <TR><TD PORT="postopts" COLSPAN="2" ALIGN="LEFT">postopts</TD><TD PORT="postopts.type" ALIGN="LEFT">text[65535]</TD></TR> + <TR><TD PORT="route" COLSPAN="2" ALIGN="LEFT">route</TD><TD PORT="route.type" ALIGN="LEFT">text[65535]</TD></TR> + <TR><TD PORT="llink" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">llink</TD><TD PORT="llink.type" ALIGN="LEFT">char[255]</TD></TR> + <TR><TD PORT="plink" COLSPAN="2" ALIGN="LEFT">plink</TD><TD PORT="plink.type" ALIGN="LEFT">char[255]</TD></TR> + <TR><TD PORT="resource_id" COLSPAN="2" ALIGN="LEFT">resource_id</TD><TD PORT="resource_id.type" ALIGN="LEFT">char[255]</TD></TR> + <TR><TD PORT="resource_type" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">resource_type</TD><TD PORT="resource_type.type" ALIGN="LEFT">char[16]</TD></TR> + <TR><TD PORT="attach" COLSPAN="2" ALIGN="LEFT">attach</TD><TD PORT="attach.type" ALIGN="LEFT">mediumtext[16777215]</TD></TR> + <TR><TD PORT="sig" COLSPAN="2" ALIGN="LEFT">sig</TD><TD PORT="sig.type" ALIGN="LEFT">text[65535]</TD></TR> + <TR><TD PORT="diaspora_meta" COLSPAN="2" ALIGN="LEFT">diaspora_meta</TD><TD PORT="diaspora_meta.type" ALIGN="LEFT">mediumtext[16777215]</TD></TR> + <TR><TD PORT="location" COLSPAN="2" ALIGN="LEFT">location</TD><TD PORT="location.type" ALIGN="LEFT">char[255]</TD></TR> + <TR><TD PORT="coord" COLSPAN="2" ALIGN="LEFT">coord</TD><TD PORT="coord.type" ALIGN="LEFT">char[255]</TD></TR> + <TR><TD PORT="public_policy" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">public_policy</TD><TD PORT="public_policy.type" ALIGN="LEFT">char[255]</TD></TR> + <TR><TD PORT="comment_policy" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">comment_policy</TD><TD PORT="comment_policy.type" ALIGN="LEFT">char[255]</TD></TR> + <TR><TD PORT="allow_cid" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">allow_cid</TD><TD PORT="allow_cid.type" ALIGN="LEFT">mediumtext[16777215]</TD></TR> + <TR><TD PORT="allow_gid" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">allow_gid</TD><TD PORT="allow_gid.type" ALIGN="LEFT">mediumtext[16777215]</TD></TR> + <TR><TD PORT="deny_cid" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">deny_cid</TD><TD PORT="deny_cid.type" ALIGN="LEFT">mediumtext[16777215]</TD></TR> + <TR><TD PORT="deny_gid" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">deny_gid</TD><TD PORT="deny_gid.type" ALIGN="LEFT">mediumtext[16777215]</TD></TR> + <TR><TD PORT="item_restrict" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">item_restrict</TD><TD PORT="item_restrict.type" ALIGN="LEFT">int[10]</TD></TR> + <TR><TD PORT="item_flags" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">item_flags</TD><TD PORT="item_flags.type" ALIGN="LEFT">int[10]</TD></TR> + <TR><TD PORT="item_private" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">item_private</TD><TD PORT="item_private.type" ALIGN="LEFT">bit[0]</TD></TR> + <TR><TD PORT="item_origin" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">item_origin</TD><TD PORT="item_origin.type" ALIGN="LEFT">bit[0]</TD></TR> + <TR><TD PORT="item_unseen" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">item_unseen</TD><TD PORT="item_unseen.type" ALIGN="LEFT">bit[0]</TD></TR> + <TR><TD PORT="item_starred" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">item_starred</TD><TD PORT="item_starred.type" ALIGN="LEFT">bit[0]</TD></TR> + <TR><TD PORT="item_uplink" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">item_uplink</TD><TD PORT="item_uplink.type" ALIGN="LEFT">bit[0]</TD></TR> + <TR><TD PORT="item_consensus" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">item_consensus</TD><TD PORT="item_consensus.type" ALIGN="LEFT">bit[0]</TD></TR> + <TR><TD PORT="item_wall" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">item_wall</TD><TD PORT="item_wall.type" ALIGN="LEFT">bit[0]</TD></TR> + <TR><TD PORT="item_thread_top" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">item_thread_top</TD><TD PORT="item_thread_top.type" ALIGN="LEFT">bit[0]</TD></TR> + <TR><TD PORT="item_notshown" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">item_notshown</TD><TD PORT="item_notshown.type" ALIGN="LEFT">bit[0]</TD></TR> + <TR><TD PORT="item_nsfw" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">item_nsfw</TD><TD PORT="item_nsfw.type" ALIGN="LEFT">bit[0]</TD></TR> + <TR><TD PORT="item_relay" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">item_relay</TD><TD PORT="item_relay.type" ALIGN="LEFT">bit[0]</TD></TR> + <TR><TD PORT="item_mentionsme" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">item_mentionsme</TD><TD PORT="item_mentionsme.type" ALIGN="LEFT">bit[0]</TD></TR> + <TR><TD PORT="item_nocomment" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">item_nocomment</TD><TD PORT="item_nocomment.type" ALIGN="LEFT">bit[0]</TD></TR> + <TR><TD PORT="item_obscured" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">item_obscured</TD><TD PORT="item_obscured.type" ALIGN="LEFT">bit[0]</TD></TR> + <TR><TD PORT="item_verified" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">item_verified</TD><TD PORT="item_verified.type" ALIGN="LEFT">bit[0]</TD></TR> + <TR><TD PORT="item_retained" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">item_retained</TD><TD PORT="item_retained.type" ALIGN="LEFT">bit[0]</TD></TR> + <TR><TD PORT="item_rss" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">item_rss</TD><TD PORT="item_rss.type" ALIGN="LEFT">bit[0]</TD></TR> + <TR><TD PORT="item_deleted" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">item_deleted</TD><TD PORT="item_deleted.type" ALIGN="LEFT">bit[0]</TD></TR> + <TR><TD PORT="item_type" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">item_type</TD><TD PORT="item_type.type" ALIGN="LEFT">int[10]</TD></TR> + <TR><TD PORT="item_hidden" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">item_hidden</TD><TD PORT="item_hidden.type" ALIGN="LEFT">bit[0]</TD></TR> + <TR><TD PORT="item_unpublished" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">item_unpublished</TD><TD PORT="item_unpublished.type" ALIGN="LEFT">bit[0]</TD></TR> + <TR><TD PORT="item_delayed" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">item_delayed</TD><TD PORT="item_delayed.type" ALIGN="LEFT">bit[0]</TD></TR> + <TR><TD PORT="item_pending_remove" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">item_pending_remove</TD><TD PORT="item_pending_remove.type" ALIGN="LEFT">bit[0]</TD></TR> + <TR><TD PORT="item_blocked" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">item_blocked</TD><TD PORT="item_blocked.type" ALIGN="LEFT">bit[0]</TD></TR> + <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">< 3</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">37 583 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 ></TD></TR> + </TABLE>> + URL="item.html" + tooltip="item" + ]; + "xchan" [ + label=< + <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff"> + <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">xchan</TD></TR> + <TR><TD PORT="xchan_hash" COLSPAN="3" BGCOLOR="#bed1b8" ALIGN="LEFT">xchan_hash</TD></TR> + <TR><TD PORT="xchan_guid" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_guid</TD></TR> + <TR><TD PORT="xchan_guid_sig" COLSPAN="3" ALIGN="LEFT">xchan_guid_sig</TD></TR> + <TR><TD PORT="xchan_pubkey" COLSPAN="3" ALIGN="LEFT">xchan_pubkey</TD></TR> + <TR><TD PORT="xchan_photo_mimetype" COLSPAN="3" ALIGN="LEFT">xchan_photo_mimetype</TD></TR> + <TR><TD PORT="xchan_photo_l" COLSPAN="3" ALIGN="LEFT">xchan_photo_l</TD></TR> + <TR><TD PORT="xchan_photo_m" COLSPAN="3" ALIGN="LEFT">xchan_photo_m</TD></TR> + <TR><TD PORT="xchan_photo_s" COLSPAN="3" ALIGN="LEFT">xchan_photo_s</TD></TR> + <TR><TD PORT="xchan_addr" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_addr</TD></TR> + <TR><TD PORT="xchan_url" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_url</TD></TR> + <TR><TD PORT="xchan_connurl" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_connurl</TD></TR> + <TR><TD PORT="xchan_follow" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_follow</TD></TR> + <TR><TD PORT="xchan_connpage" COLSPAN="3" ALIGN="LEFT">xchan_connpage</TD></TR> + <TR><TD PORT="xchan_name" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_name</TD></TR> + <TR><TD PORT="xchan_network" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_network</TD></TR> + <TR><TD PORT="xchan_instance_url" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_instance_url</TD></TR> + <TR><TD PORT="xchan_flags" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_flags</TD></TR> + <TR><TD PORT="xchan_photo_date" COLSPAN="3" ALIGN="LEFT">xchan_photo_date</TD></TR> + <TR><TD PORT="xchan_name_date" COLSPAN="3" ALIGN="LEFT">xchan_name_date</TD></TR> + <TR><TD PORT="xchan_hidden" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_hidden</TD></TR> + <TR><TD PORT="xchan_orphan" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_orphan</TD></TR> + <TR><TD PORT="xchan_censored" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_censored</TD></TR> + <TR><TD PORT="xchan_selfcensored" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_selfcensored</TD></TR> + <TR><TD PORT="xchan_system" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_system</TD></TR> + <TR><TD PORT="xchan_pubforum" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_pubforum</TD></TR> + <TR><TD PORT="xchan_deleted" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">xchan_deleted</TD></TR> + <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">< 2</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">2 301 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">35 ></TD></TR> + </TABLE>> + URL="xchan.html" + tooltip="xchan" + ]; +} |