aboutsummaryrefslogblamecommitdiffstats
path: root/hubzilla_er/utilities.html
blob: 647e748abce83ccad7f7696961cc7b55568338ff (plain) (tree)













































































































































































































































































































































                                                                                                                                                                                                                                                                                  
<!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&nbsp;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&amp;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'>&lt; <em>n</em> &gt; 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>
&nbsp;
</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>