blob: 7e8a6b6ad9b61b5a5f03ea66ee75a6379904836c (
plain) (
tree)
|
|
// 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];
"config":"elipses":w -> "cache":"k":e [arrowhead=none dir=back arrowtail=crowodot 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];
"pconfig":"elipses":w -> "cache":"k":e [arrowhead=none dir=back arrowtail=crowodot 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];
"profext":"elipses":w -> "cache":"k":e [arrowhead=none dir=back arrowtail=crowodot 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":"id":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"sys_perms":"k":w -> "cache":"k":e [arrowhead=none dir=back arrowtail=crowodot style=dashed];
"xconfig":"elipses":w -> "verify":"id":e [arrowhead=none dir=back arrowtail=teeodot style=dashed];
"xconfig":"elipses":w -> "cache":"k":e [arrowhead=none dir=back arrowtail=crowodot 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">< 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7"> </TD></TR>
</TABLE>>
URL="attach.html"
tooltip="attach"
];
"cache" [
label=<
<TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">cache</TD></TR>
<TR><TD PORT="k" COLSPAN="3" BGCOLOR="#bed1b8" ALIGN="LEFT">k</TD></TR>
<TR><TD PORT="v" COLSPAN="3" ALIGN="LEFT">v</TD></TR>
<TR><TD PORT="updated" COLSPAN="3" ALIGN="LEFT">updated</TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7"> </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">21 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">5 ></TD></TR>
</TABLE>>
URL="cache.html"
tooltip="cache"
];
"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"
];
"pconfig" [
label=<
<TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">pconfig</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">232 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7"> </TD></TR>
</TABLE>>
URL="pconfig.html"
tooltip="pconfig"
];
"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="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
<TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">sys_perms</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="cat" COLSPAN="2" ALIGN="LEFT">cat</TD><TD PORT="cat.type" ALIGN="LEFT">char[255]</TD></TR>
<TR><TD PORT="k" COLSPAN="2" ALIGN="LEFT">k</TD><TD PORT="k.type" ALIGN="LEFT">char[255]</TD></TR>
<TR><TD PORT="v" COLSPAN="2" ALIGN="LEFT">v</TD><TD PORT="v.type" ALIGN="LEFT">mediumtext[16777215]</TD></TR>
<TR><TD PORT="public_perm" COLSPAN="2" ALIGN="LEFT">public_perm</TD><TD PORT="public_perm.type" ALIGN="LEFT">bit[0]</TD></TR>
<TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">< 2</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 ></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"
];
}
|