diff options
Diffstat (limited to 'hubzilla_er/diagrams/attach.implied2degrees.dot')
-rw-r--r-- | hubzilla_er/diagrams/attach.implied2degrees.dot | 279 |
1 files changed, 279 insertions, 0 deletions
diff --git a/hubzilla_er/diagrams/attach.implied2degrees.dot b/hubzilla_er/diagrams/attach.implied2degrees.dot new file mode 100644 index 000000000..fb253bf66 --- /dev/null +++ b/hubzilla_er/diagrams/attach.implied2degrees.dot @@ -0,0 +1,279 @@ +// 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":"id":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":"elipses":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="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff"> + <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">attach</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="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="hash" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">hash</TD><TD PORT="hash.type" ALIGN="LEFT">char[64]</TD></TR> + <TR><TD PORT="creator" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">creator</TD><TD PORT="creator.type" ALIGN="LEFT">char[128]</TD></TR> + <TR><TD PORT="filename" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">filename</TD><TD PORT="filename.type" ALIGN="LEFT">char[255]</TD></TR> + <TR><TD PORT="filetype" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">filetype</TD><TD PORT="filetype.type" ALIGN="LEFT">char[64]</TD></TR> + <TR><TD PORT="filesize" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">filesize</TD><TD PORT="filesize.type" ALIGN="LEFT">int unsigned[10]</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="folder" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">folder</TD><TD PORT="folder.type" ALIGN="LEFT">char[64]</TD></TR> + <TR><TD PORT="flags" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">flags</TD><TD PORT="flags.type" ALIGN="LEFT">int unsigned[10]</TD></TR> + <TR><TD PORT="is_dir" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">is_dir</TD><TD PORT="is_dir.type" ALIGN="LEFT">bit[0]</TD></TR> + <TR><TD PORT="is_photo" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">is_photo</TD><TD PORT="is_photo.type" ALIGN="LEFT">bit[0]</TD></TR> + <TR><TD PORT="os_storage" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">os_storage</TD><TD PORT="os_storage.type" ALIGN="LEFT">bit[0]</TD></TR> + <TR><TD PORT="os_path" COLSPAN="2" ALIGN="LEFT">os_path</TD><TD PORT="os_path.type" ALIGN="LEFT">mediumtext[16777215]</TD></TR> + <TR><TD PORT="display_path" COLSPAN="2" ALIGN="LEFT">display_path</TD><TD PORT="display_path.type" ALIGN="LEFT">mediumtext[16777215]</TD></TR> + <TR><TD PORT="data" COLSPAN="2" ALIGN="LEFT">data</TD><TD PORT="data.type" ALIGN="LEFT">longblob[2147483647]</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="allow_cid" COLSPAN="2" ALIGN="LEFT">allow_cid</TD><TD PORT="allow_cid.type" ALIGN="LEFT">mediumtext[16777215]</TD></TR> + <TR><TD PORT="allow_gid" COLSPAN="2" ALIGN="LEFT">allow_gid</TD><TD PORT="allow_gid.type" ALIGN="LEFT">mediumtext[16777215]</TD></TR> + <TR><TD PORT="deny_cid" COLSPAN="2" ALIGN="LEFT">deny_cid</TD><TD PORT="deny_cid.type" ALIGN="LEFT">mediumtext[16777215]</TD></TR> + <TR><TD PORT="deny_gid" COLSPAN="2" ALIGN="LEFT">deny_gid</TD><TD PORT="deny_gid.type" ALIGN="LEFT">mediumtext[16777215]</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="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">52 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">0 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">< 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">2 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">< 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">5 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">< 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">9 613 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">1 row</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">< 3</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">7 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">< 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">3 495 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">< 3</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">< 1</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="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff"> + <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">sign</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="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">1 row</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">< 2</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">4 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">< 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7"> </TD></TR> + </TABLE>> + URL="xign.html" + tooltip="xign" + ]; +} |