<!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN' 'http://www.w3.org/TR/html4/loose.dtd'> <html> <head> <!-- SchemaSpy rev 590 --> <title>SchemaSpy - zot - Utility Tables</title> <link rel=stylesheet href='schemaSpy.css' type='text/css'> <meta HTTP-EQUIV='Content-Type' CONTENT='text/html; charset=ISO-8859-1'> <SCRIPT LANGUAGE='JavaScript' TYPE='text/javascript' SRC='jquery.js'></SCRIPT> <SCRIPT LANGUAGE='JavaScript' TYPE='text/javascript' SRC='schemaSpy.js'></SCRIPT> </head> <body> <table id='headerHolder' cellspacing='0' cellpadding='0'><tr><td> <div id='header'> <ul> <li><a href='index.html' title='All tables and views in the schema'>Tables</a></li> <li><a href='relationships.html' title='Diagram of table relationships'>Relationships</a></li> <li id='current'><a href='utilities.html' title='View of tables with neither parents nor children'>Utility Tables</a></li> <li><a href='constraints.html' title='Useful for diagnosing error messages that just give constraint name or number'>Constraints</a></li> <li><a href='anomalies.html' title="Things that might not be quite right">Anomalies</a></li> <li><a href='columns.byTable.html' title="All of the columns in the schema">Columns</a></li> <li><a href='http://sourceforge.net/donate/index.php?group_id=137197' title='Please help keep SchemaSpy alive' target='_blank'>Donate</a></li> </ul> </div> </td></tr></table> <div class='content' style='clear:both;'> <table width='100%' border='0' cellpadding='0'> <tr> <td class='heading' valign='middle'><span class='header'>SchemaSpy Analysis of <span title='Database'>zot</span> - Utility Tables</span></td> <td class='heading' align='right' valign='top' title='John Currier - Creator of Cool Tools'><span class='indent'>Generated by</span><br><span class='indent'><span class='signature'><a href='http://schemaspy.sourceforge.net' target='_blank'>SchemaSpy</a></span></span></td> </tr> </table> <table class='container' width='100%'> <tr><td class='container'> <span class='container'>Generated by <span class='signature'><a href='http://schemaspy.sourceforge.net' target='_blank'>SchemaSpy</a></span> on on aug 19 21:08 CEST 2015</span> </td> <td class='container' align='right' valign='top' rowspan='2'> <table class='legend' border='0'> <tr> <td class='dataTable' valign='bottom'>Legend:</td> <td class='container' align='right' valign='top'><a href='http://sourceforge.net' target='_blank'><img src='http://sourceforge.net/sflogo.php?group_id=137197&type=1' alt='SourceForge.net' border='0' height='31' width='88'></a></td> </tr> <tr><td class='container' colspan='2'> <table class='dataTable' border='1'> <tbody> <tr><td class='primaryKey'>Primary key columns</td></tr> <tr><td class='indexedColumn'>Columns with indexes</td></tr> <tr><td class='excludedColumn'>Excluded column relationships</td></tr> <tr class='impliedRelationship'><td class='legendDetail'>Dashed lines show implied relationships</td></tr> <tr><td class='legendDetail'>< <em>n</em> > number of related tables</td></tr> </table> </td></tr> </table> <div style="margin-right: 2pt;"> <script type="text/javascript"><!-- google_ad_client = "pub-9598353634003340"; google_ad_channel ="SchemaSpy-generated"; google_ad_width = 234; google_ad_height = 60; google_ad_format = "234x60_as"; google_ad_type = "text"; google_color_border = "9bab96"; google_color_link = "489148"; google_color_text = "000000"; //--> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script> </div> </td></tr> <tr><td class='container' align='left' valign='top'> <form action=''> <label for='removeImpliedOrphans'><input type=checkbox id='removeImpliedOrphans'> Hide tables with implied relationships</label> </form> </td></tr></table> <a name='diagram'> <img src='diagrams/summary/abook.1degree.png' usemap='#abook' border='0' alt='' align='top'> <img src='diagrams/summary/account.1degree.png' usemap='#account' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/addon.1degree.png' usemap='#addon' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/app.1degree.png' usemap='#app' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/attach.1degree.png' usemap='#attach' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/auth_codes.1degree.png' usemap='#auth_codes' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/cache.1degree.png' usemap='#cache' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/channel.1degree.png' usemap='#channel' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/chat.1degree.png' usemap='#chat' border='0' alt='' align='top'> <img src='diagrams/summary/chatpresence.1degree.png' usemap='#chatpresence' border='0' alt='' align='top'> <img src='diagrams/summary/chatroom.1degree.png' usemap='#chatroom' border='0' alt='' align='top'> <img src='diagrams/summary/clients.1degree.png' usemap='#clients' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/config.1degree.png' usemap='#config' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/conv.1degree.png' usemap='#conv' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/event.1degree.png' usemap='#event' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/fcontact.1degree.png' usemap='#fcontact' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/ffinder.1degree.png' usemap='#ffinder' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/fserver.1degree.png' usemap='#fserver' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/fsuggest.1degree.png' usemap='#fsuggest' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/group_member.1degree.png' usemap='#group_member' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/groups.1degree.png' usemap='#groups' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/hook.1degree.png' usemap='#hook' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/hubloc.1degree.png' usemap='#hubloc' border='0' alt='' align='top'> <img src='diagrams/summary/issue.1degree.png' usemap='#issue' border='0' alt='' align='top'> <img src='diagrams/summary/item.1degree.png' usemap='#item' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/item_id.1degree.png' usemap='#item_id' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/likes.1degree.png' usemap='#likes' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/mail.1degree.png' usemap='#mail' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/manage.1degree.png' usemap='#manage' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/menu.1degree.png' usemap='#menu' border='0' alt='' align='top'> <img src='diagrams/summary/menu_item.1degree.png' usemap='#menu_item' border='0' alt='' align='top'> <img src='diagrams/summary/notify.1degree.png' usemap='#notify' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/obj.1degree.png' usemap='#obj' border='0' alt='' align='top'> <img src='diagrams/summary/outq.1degree.png' usemap='#outq' border='0' alt='' align='top'> <img src='diagrams/summary/pconfig.1degree.png' usemap='#pconfig' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/photo.1degree.png' usemap='#photo' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/poll.1degree.png' usemap='#poll' border='0' alt='' align='top'> <img src='diagrams/summary/poll_elm.1degree.png' usemap='#poll_elm' border='0' alt='' align='top'> <img src='diagrams/summary/profdef.1degree.png' usemap='#profdef' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/profext.1degree.png' usemap='#profext' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/profile.1degree.png' usemap='#profile' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/profile_check.1degree.png' usemap='#profile_check' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/register.1degree.png' usemap='#register' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/session.1degree.png' usemap='#session' border='0' alt='' align='top'> <img src='diagrams/summary/shares.1degree.png' usemap='#shares' border='0' alt='' align='top'> <img src='diagrams/summary/sign.1degree.png' usemap='#sign' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/site.1degree.png' usemap='#site' border='0' alt='' align='top'> <img src='diagrams/summary/source.1degree.png' usemap='#source' border='0' alt='' align='top'> <img src='diagrams/summary/spam.1degree.png' usemap='#spam' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/sys_perms.1degree.png' usemap='#sys_perms' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/term.1degree.png' usemap='#term' border='0' alt='' align='top'> <img src='diagrams/summary/tokens.1degree.png' usemap='#tokens' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/updates.1degree.png' usemap='#updates' border='0' alt='' align='top'> <img src='diagrams/summary/verify.1degree.png' usemap='#verify' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/vote.1degree.png' usemap='#vote' border='0' alt='' align='top'> <img src='diagrams/summary/xchan.1degree.png' usemap='#xchan' border='0' alt='' align='top'> <img src='diagrams/summary/xchat.1degree.png' usemap='#xchat' border='0' alt='' align='top'> <img src='diagrams/summary/xconfig.1degree.png' usemap='#xconfig' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/xign.1degree.png' usemap='#xign' border='0' alt='' align='top' class='impliedNotOrphan'> <img src='diagrams/summary/xlink.1degree.png' usemap='#xlink' border='0' alt='' align='top'> <img src='diagrams/summary/xperm.1degree.png' usemap='#xperm' border='0' alt='' align='top'> <img src='diagrams/summary/xprof.1degree.png' usemap='#xprof' border='0' alt='' align='top'> <img src='diagrams/summary/xtag.1degree.png' usemap='#xtag' border='0' alt='' align='top'> <map id="abook" name="abook"> <area shape="rect" id="node1" href="tables/abook.html" title="abook" alt="" coords="5,5,181,584"> </map> <map id="account" name="account"> <area shape="rect" id="node1" href="tables/account.html" title="account" alt="" coords="7,5,220,470"> </map> <map id="addon" name="addon"> <area shape="rect" id="node1" href="tables/addon.html" title="addon" alt="" coords="5,5,144,221"> </map> <map id="app" name="app"> <area shape="rect" id="node1" href="tables/app.html" title="app" alt="" coords="5,5,144,379"> </map> <map id="attach" name="attach"> <area shape="rect" id="node1" href="tables/attach.html" title="attach" alt="" coords="5,5,141,584"> </map> <map id="auth_codes" name="auth_codes"> <area shape="rect" id="node1" href="tables/auth_codes.html" title="auth_codes" alt="" coords="5,5,136,176"> </map> <map id="cache" name="cache"> <area shape="rect" id="node1" href="tables/cache.html" title="cache" alt="" coords="5,5,131,131"> </map> <map id="channel" name="channel"> <area shape="rect" id="node1" href="tables/channel.html" title="channel" alt="" coords="7,5,196,1150"> </map> <map id="chat" name="chat"> <area shape="rect" id="node1" href="tables/chat.html" title="chat" alt="" coords="5,5,136,176"> </map> <map id="chatpresence" name="chatpresence"> <area shape="rect" id="node1" href="tables/chatpresence.html" title="chatpresence" alt="" coords="7,5,137,198"> </map> <map id="chatroom" name="chatroom"> <area shape="rect" id="node1" href="tables/chatroom.html" title="chatroom" alt="" coords="5,5,133,312"> </map> <map id="clients" name="clients"> <area shape="rect" id="node1" href="tables/clients.html" title="clients" alt="" coords="5,5,136,198"> </map> <map id="config" name="config"> <area shape="rect" id="node1" href="tables/config.html" title="config" alt="" coords="5,5,123,153"> </map> <map id="conv" name="conv"> <area shape="rect" id="node1" href="tables/conv.html" title="conv" alt="" coords="5,5,123,243"> </map> <map id="event" name="event"> <area shape="rect" id="node1" href="tables/event.html" title="event" alt="" coords="5,5,165,629"> </map> <map id="fcontact" name="fcontact"> <area shape="rect" id="node1" href="tables/fcontact.html" title="fcontact" alt="" coords="5,5,123,425"> </map> <map id="ffinder" name="ffinder"> <area shape="rect" id="node1" href="tables/ffinder.html" title="ffinder" alt="" coords="5,5,115,153"> </map> <map id="fserver" name="fserver"> <area shape="rect" id="node1" href="tables/fserver.html" title="fserver" alt="" coords="5,5,117,153"> </map> <map id="fsuggest" name="fsuggest"> <area shape="rect" id="node1" href="tables/fsuggest.html" title="fsuggest" alt="" coords="5,5,123,267"> </map> <map id="group_member" name="group_member"> <area shape="rect" id="node1" href="tables/group_member.html" title="group_member" alt="" coords="5,5,152,153"> </map> <map id="groups" name="groups"> <area shape="rect" id="node1" href="tables/groups.html" title="groups" alt="" coords="5,5,117,198"> </map> <map id="hook" name="hook"> <area shape="rect" id="node1" href="tables/hook.html" title="hook" alt="" coords="5,5,120,176"> </map> <map id="hubloc" name="hubloc"> <area shape="rect" id="node1" href="tables/hubloc.html" title="hubloc" alt="" coords="7,5,204,515"> </map> <map id="issue" name="issue"> <area shape="rect" id="node1" href="tables/issue.html" title="issue" alt="" coords="5,5,163,221"> </map> <map id="item" name="item"> <area shape="rect" id="node1" href="tables/item.html" title="item" alt="" coords="7,5,209,1717"> </map> <map id="item_id" name="item_id"> <area shape="rect" id="node1" href="tables/item_id.html" title="item_id" alt="" coords="7,5,111,176"> </map> <map id="likes" name="likes"> <area shape="rect" id="node1" href="tables/likes.html" title="likes" alt="" coords="5,5,136,267"> </map> <map id="mail" name="mail"> <area shape="rect" id="node1" href="tables/mail.html" title="mail" alt="" coords="5,5,149,539"> </map> <map id="manage" name="manage"> <area shape="rect" id="node1" href="tables/manage.html" title="manage" alt="" coords="5,5,123,131"> </map> <map id="menu" name="menu"> <area shape="rect" id="node1" href="tables/menu.html" title="menu" alt="" coords="7,5,156,221"> </map> <map id="menu_item" name="menu_item"> <area shape="rect" id="node1" href="tables/menu_item.html" title="menu_item" alt="" coords="7,5,159,312"> </map> <map id="notify" name="notify"> <area shape="rect" id="node1" href="tables/notify.html" title="notify" alt="" coords="5,5,123,403"> </map> <map id="obj" name="obj"> <area shape="rect" id="node1" href="tables/obj.html" title="obj" alt="" coords="5,5,139,289"> </map> <map id="outq" name="outq"> <area shape="rect" id="node1" href="tables/outq.html" title="outq" alt="" coords="5,5,149,334"> </map> <map id="pconfig" name="pconfig"> <area shape="rect" id="node1" href="tables/pconfig.html" title="pconfig" alt="" coords="5,5,133,176"> </map> <map id="photo" name="photo"> <area shape="rect" id="node1" href="tables/photo.html" title="photo" alt="" coords="7,5,169,697"> </map> <map id="poll" name="poll"> <area shape="rect" id="node1" href="tables/poll.html" title="poll" alt="" coords="5,5,141,176"> </map> <map id="poll_elm" name="poll_elm"> <area shape="rect" id="node1" href="tables/poll_elm.html" title="poll_elm" alt="" coords="5,5,136,176"> </map> <map id="profdef" name="profdef"> <area shape="rect" id="node1" href="tables/profdef.html" title="profdef" alt="" coords="5,5,136,198"> </map> <map id="profext" name="profext"> <area shape="rect" id="node1" href="tables/profext.html" title="profext" alt="" coords="5,5,133,176"> </map> <map id="profile" name="profile"> <area shape="rect" id="node1" href="tables/profile.html" title="profile" alt="" coords="5,5,147,1059"> </map> <map id="profile_check" name="profile_check"> <area shape="rect" id="node1" href="tables/profile_check.html" title="profile_check" alt="" coords="5,5,144,198"> </map> <map id="register" name="register"> <area shape="rect" id="node1" href="tables/register.html" title="register" alt="" coords="5,5,128,198"> </map> <map id="session" name="session"> <area shape="rect" id="node1" href="tables/session.html" title="session" alt="" coords="5,5,128,153"> </map> <map id="shares" name="shares"> <area shape="rect" id="node1" href="tables/shares.html" title="shares" alt="" coords="5,5,141,153"> </map> <map id="sign" name="sign"> <area shape="rect" id="node1" href="tables/sign.html" title="sign" alt="" coords="5,5,136,198"> </map> <map id="site" name="site"> <area shape="rect" id="node1" href="tables/site.html" title="site" alt="" coords="5,5,160,357"> </map> <map id="source" name="source"> <area shape="rect" id="node1" href="tables/source.html" title="source" alt="" coords="5,5,168,176"> </map> <map id="spam" name="spam"> <area shape="rect" id="node1" href="tables/spam.html" title="spam" alt="" coords="5,5,115,198"> </map> <map id="sys_perms" name="sys_perms"> <area shape="rect" id="node1" href="tables/sys_perms.html" title="sys_perms" alt="" coords="5,5,139,176"> </map> <map id="term" name="term"> <area shape="rect" id="node1" href="tables/term.html" title="term" alt="" coords="7,5,169,312"> </map> <map id="tokens" name="tokens"> <area shape="rect" id="node1" href="tables/tokens.html" title="tokens" alt="" coords="5,5,123,198"> </map> <map id="updates" name="updates"> <area shape="rect" id="node1" href="tables/updates.html" title="updates" alt="" coords="5,5,123,221"> </map> <map id="verify" name="verify"> <area shape="rect" id="node1" href="tables/verify.html" title="verify" alt="" coords="7,5,113,198"> </map> <map id="vote" name="vote"> <area shape="rect" id="node1" href="tables/vote.html" title="vote" alt="" coords="5,5,144,176"> </map> <map id="xchan" name="xchan"> <area shape="rect" id="node1" href="tables/xchan.html" title="xchan" alt="" coords="7,5,217,651"> </map> <map id="xchat" name="xchat"> <area shape="rect" id="node1" href="tables/xchat.html" title="xchat" alt="" coords="5,5,141,176"> </map> <map id="xconfig" name="xconfig"> <area shape="rect" id="node1" href="tables/xconfig.html" title="xconfig" alt="" coords="5,5,117,176"> </map> <map id="xign" name="xign"> <area shape="rect" id="node1" href="tables/xign.html" title="xign" alt="" coords="5,5,115,131"> </map> <map id="xlink" name="xlink"> <area shape="rect" id="node1" href="tables/xlink.html" title="xlink" alt="" coords="5,5,171,243"> </map> <map id="xperm" name="xperm"> <area shape="rect" id="node1" href="tables/xperm.html" title="xperm" alt="" coords="5,5,136,153"> </map> <map id="xprof" name="xprof"> <area shape="rect" id="node1" href="tables/xprof.html" title="xprof" alt="" coords="5,5,160,403"> </map> <map id="xtag" name="xtag"> <area shape="rect" id="node1" href="tables/xtag.html" title="xtag" alt="" coords="5,5,131,153"> </map> </a> </div> </body> </html>