aboutsummaryrefslogblamecommitdiffstats
path: root/doc/schemaspy_hubzilla/utilities.html
blob: 2199f2dc61d39e9cdec823ad239b3a156b2f8149 (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><span class='description'>
2015-11-04 - Hubzilla database schema with some corrected cross-table relationships supporting decentralized publishing. Haakon Meland Eriksen.
</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 fr nov 06 17:11 CET 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/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/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/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/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/hook.1degree.png' usemap='#hook' border='0' alt='' align='top' class='impliedNotOrphan'>
  <img src='diagrams/summary/issue.1degree.png' usemap='#issue' border='0' alt='' align='top'>
  <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/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/obj.1degree.png' usemap='#obj' 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/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/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/session.1degree.png' usemap='#session' 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/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/tokens.1degree.png' usemap='#tokens' border='0' alt='' align='top' class='impliedNotOrphan'>
  <img src='diagrams/summary/verify.1degree.png' usemap='#verify' border='0' alt='' align='top' class='impliedNotOrphan'>
  <img src='diagrams/summary/xperm.1degree.png' usemap='#xperm' border='0' alt='' align='top'>
<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,152,221">
</map>
<map id="app" name="app">
<area shape="rect" id="node1" href="tables/app.html" title="app" alt="" coords="5,5,144,425">
</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,139,131">
</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,131,243">
</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="hook" name="hook">
<area shape="rect" id="node1" href="tables/hook.html" title="hook" alt="" coords="5,5,128,176">
</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_id" name="item_id">
<area shape="rect" id="node1" href="tables/item_id.html" title="item_id" alt="" coords="5,5,133,176">
</map>
<map id="likes" name="likes">
<area shape="rect" id="node1" href="tables/likes.html" title="likes" alt="" coords="5,5,136,289">
</map>
<map id="menu" name="menu">
<area shape="rect" id="node1" href="tables/menu.html" title="menu" alt="" coords="5,5,163,221">
</map>
<map id="menu_item" name="menu_item">
<area shape="rect" id="node1" href="tables/menu_item.html" title="menu_item" alt="" coords="5,5,173,312">
</map>
<map id="obj" name="obj">
<area shape="rect" id="node1" href="tables/obj.html" title="obj" alt="" coords="5,5,139,403">
</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="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="profile" name="profile">
<area shape="rect" id="node1" href="tables/profile.html" title="profile" alt="" coords="5,5,155,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="session" name="session">
<area shape="rect" id="node1" href="tables/session.html" title="session" alt="" coords="5,5,128,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,403">
</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="tokens" name="tokens">
<area shape="rect" id="node1" href="tables/tokens.html" title="tokens" alt="" coords="5,5,123,198">
</map>
<map id="verify" name="verify">
<area shape="rect" id="node1" href="tables/verify.html" title="verify" alt="" coords="5,5,120,198">
</map>
<map id="xperm" name="xperm">
<area shape="rect" id="node1" href="tables/xperm.html" title="xperm" alt="" coords="5,5,136,153">
</map>
</a>
</div>
</body>
</html>