aboutsummaryrefslogtreecommitdiffstats
path: root/hubzilla_er/diagrams/item_id.implied2degrees.dot
diff options
context:
space:
mode:
Diffstat (limited to 'hubzilla_er/diagrams/item_id.implied2degrees.dot')
-rw-r--r--hubzilla_er/diagrams/item_id.implied2degrees.dot261
1 files changed, 261 insertions, 0 deletions
diff --git a/hubzilla_er/diagrams/item_id.implied2degrees.dot b/hubzilla_er/diagrams/item_id.implied2degrees.dot
new file mode 100644
index 000000000..7cdbd3403
--- /dev/null
+++ b/hubzilla_er/diagrams/item_id.implied2degrees.dot
@@ -0,0 +1,261 @@
+// 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":"id":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="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">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 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">&lt; 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">&lt; 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">&lt; 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">&lt; 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">&lt; 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">&lt; 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">&lt; 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="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
+ <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">item_id</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[10]</TD></TR>
+ <TR><TD PORT="uid" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">uid</TD><TD PORT="uid.type" ALIGN="LEFT">int[10]</TD></TR>
+ <TR><TD PORT="sid" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">sid</TD><TD PORT="sid.type" ALIGN="LEFT">char[255]</TD></TR>
+ <TR><TD PORT="service" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">service</TD><TD PORT="service.type" ALIGN="LEFT">char[255]</TD></TR>
+ <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 row</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 &gt;</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">&lt; 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">&lt; 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">&lt; 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">&lt; 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">&lt; 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">&lt; 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">&lt; 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">&lt; 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">&lt; 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 &gt;</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">&lt; 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">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7"> </TD></TR>
+ </TABLE>>
+ URL="xign.html"
+ tooltip="xign"
+ ];
+}