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/sign.implied2degrees.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/sign.implied2degrees.dot')
-rw-r--r-- | doc/schemaspy_hubzilla/diagrams/sign.implied2degrees.dot | 262 |
1 files changed, 262 insertions, 0 deletions
diff --git a/doc/schemaspy_hubzilla/diagrams/sign.implied2degrees.dot b/doc/schemaspy_hubzilla/diagrams/sign.implied2degrees.dot new file mode 100644 index 000000000..6d0bc1bdf --- /dev/null +++ b/doc/schemaspy_hubzilla/diagrams/sign.implied2degrees.dot @@ -0,0 +1,262 @@ +// 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":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; + "config":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; + "conv":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; + "fcontact":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; + "ffinder":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; + "group_member":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; + "groups":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; + "item":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; + "item_id":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; + "likes":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; + "mail":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; + "photo":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; + "profdef":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; + "profext":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; + "profile_check":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; + "register":"elipses":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]; + "sys_perms":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; + "xconfig":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; + "xign":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed]; + "attach" [ + label=< + <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff"> + <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">attach</TD></TR> + <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR> + <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">< 4</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">105 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7"> </TD></TR> + </TABLE>> + URL="attach.html" + tooltip="attach" + ]; + "config" [ + label=< + <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff"> + <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">config</TD></TR> + <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR> + <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">< 2</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">83 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7"> </TD></TR> + </TABLE>> + URL="config.html" + tooltip="config" + ]; + "conv" [ + label=< + <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff"> + <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">conv</TD></TR> + <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR> + <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">< 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">15 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7"> </TD></TR> + </TABLE>> + URL="conv.html" + tooltip="conv" + ]; + "fcontact" [ + label=< + <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff"> + <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">fcontact</TD></TR> + <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR> + <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">< 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7"> </TD></TR> + </TABLE>> + URL="fcontact.html" + tooltip="fcontact" + ]; + "ffinder" [ + label=< + <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff"> + <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">ffinder</TD></TR> + <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR> + <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">< 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7"> </TD></TR> + </TABLE>> + URL="ffinder.html" + tooltip="ffinder" + ]; + "group_member" [ + label=< + <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff"> + <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">group_member</TD></TR> + <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR> + <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">< 2</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">42 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7"> </TD></TR> + </TABLE>> + URL="group_member.html" + tooltip="group_member" + ]; + "groups" [ + label=< + <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff"> + <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">groups</TD></TR> + <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR> + <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">< 4</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">10 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7"> </TD></TR> + </TABLE>> + URL="groups.html" + tooltip="groups" + ]; + "item" [ + label=< + <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff"> + <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">item</TD></TR> + <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR> + <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">< 4</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">37 583 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7"> </TD></TR> + </TABLE>> + URL="item.html" + tooltip="item" + ]; + "item_id" [ + label=< + <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff"> + <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">item_id</TD></TR> + <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR> + <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">< 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">194 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7"> </TD></TR> + </TABLE>> + URL="item_id.html" + tooltip="item_id" + ]; + "likes" [ + label=< + <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff"> + <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">likes</TD></TR> + <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR> + <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">< 2</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7"> </TD></TR> + </TABLE>> + URL="likes.html" + tooltip="likes" + ]; + "mail" [ + label=< + <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff"> + <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">mail</TD></TR> + <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR> + <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">< 5</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">39 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7"> </TD></TR> + </TABLE>> + URL="mail.html" + tooltip="mail" + ]; + "photo" [ + label=< + <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff"> + <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">photo</TD></TR> + <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR> + <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">< 2</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">5 888 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7"> </TD></TR> + </TABLE>> + URL="photo.html" + tooltip="photo" + ]; + "profdef" [ + label=< + <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff"> + <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">profdef</TD></TR> + <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR> + <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">< 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7"> </TD></TR> + </TABLE>> + URL="profdef.html" + tooltip="profdef" + ]; + "profext" [ + label=< + <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff"> + <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">profext</TD></TR> + <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR> + <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">< 6</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7"> </TD></TR> + </TABLE>> + URL="profext.html" + tooltip="profext" + ]; + "profile_check" [ + label=< + <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff"> + <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">profile_check</TD></TR> + <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR> + <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">< 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7"> </TD></TR> + </TABLE>> + URL="profile_check.html" + tooltip="profile_check" + ]; + "register" [ + label=< + <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff"> + <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">register</TD></TR> + <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR> + <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">< 4</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7"> </TD></TR> + </TABLE>> + URL="register.html" + tooltip="register" + ]; + "sign" [ + label=< + <TABLE BORDER="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff"> + <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">sign</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="iid" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">iid</TD><TD PORT="iid.type" ALIGN="LEFT">int unsigned[10]</TD></TR> + <TR><TD PORT="retract_iid" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">retract_iid</TD><TD PORT="retract_iid.type" ALIGN="LEFT">int unsigned[10]</TD></TR> + <TR><TD PORT="signed_text" COLSPAN="2" ALIGN="LEFT">signed_text</TD><TD PORT="signed_text.type" ALIGN="LEFT">mediumtext[16777215]</TD></TR> + <TR><TD PORT="signature" COLSPAN="2" ALIGN="LEFT">signature</TD><TD PORT="signature.type" ALIGN="LEFT">text[65535]</TD></TR> + <TR><TD PORT="signer" COLSPAN="2" ALIGN="LEFT">signer</TD><TD PORT="signer.type" ALIGN="LEFT">char[255]</TD></TR> + <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">< 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 ></TD></TR> + </TABLE>> + URL="sign.html" + tooltip="sign" + ]; + "sys_perms" [ + label=< + <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff"> + <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">sys_perms</TD></TR> + <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR> + <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">< 2</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7"> </TD></TR> + </TABLE>> + URL="sys_perms.html" + tooltip="sys_perms" + ]; + "verify" [ + label=< + <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff"> + <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">verify</TD></TR> + <TR><TD PORT="id" COLSPAN="3" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD></TR> + <TR><TD PORT="channel" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">channel</TD></TR> + <TR><TD PORT="type" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">type</TD></TR> + <TR><TD PORT="token" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">token</TD></TR> + <TR><TD PORT="meta" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">meta</TD></TR> + <TR><TD PORT="created" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">created</TD></TR> + <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7"> </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">20 ></TD></TR> + </TABLE>> + URL="verify.html" + tooltip="verify" + ]; + "xconfig" [ + label=< + <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff"> + <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">xconfig</TD></TR> + <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR> + <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">< 3</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">8 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7"> </TD></TR> + </TABLE>> + URL="xconfig.html" + tooltip="xconfig" + ]; + "xign" [ + label=< + <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff"> + <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">xign</TD></TR> + <TR><TD PORT="elipses" COLSPAN="3" ALIGN="LEFT">...</TD></TR> + <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">< 2</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7"> </TD></TR> + </TABLE>> + URL="xign.html" + tooltip="xign" + ]; +} |