// 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":"id":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">< 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="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff"> <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">profdef</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="field_name" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">field_name</TD><TD PORT="field_name.type" ALIGN="LEFT">char[255]</TD></TR> <TR><TD PORT="field_type" COLSPAN="2" ALIGN="LEFT">field_type</TD><TD PORT="field_type.type" ALIGN="LEFT">char[16]</TD></TR> <TR><TD PORT="field_desc" COLSPAN="2" ALIGN="LEFT">field_desc</TD><TD PORT="field_desc.type" ALIGN="LEFT">char[255]</TD></TR> <TR><TD PORT="field_help" COLSPAN="2" ALIGN="LEFT">field_help</TD><TD PORT="field_help.type" ALIGN="LEFT">char[255]</TD></TR> <TR><TD PORT="field_inputs" COLSPAN="2" ALIGN="LEFT">field_inputs</TD><TD PORT="field_inputs.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="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="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">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" ]; }