<!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 - All Relationships</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 id='current'><a href='relationships.html' title='Diagram of table relationships'>Relationships</a></li>
<li><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> - All Relationships</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&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 name='options' action=''>
<span title="Show relationships implied by column name/type/size matching another table's primary key">
<label for='implied'><input type='checkbox' id='implied'>Implied relationships</label>
</span>
<span title="By default only columns that are primary keys, foreign keys or indexes are shown">
<label for='showNonKeys'><input type='checkbox' id='showNonKeys'>All columns</label>
</span>
</form>
</td></tr></table>
<table width="100%"><tr><td class="container">
<map id="compactRelationshipsDiagram" name="compactRelationshipsDiagram">
<area shape="rect" id="node1" href="tables/abook.html" title="abook" alt="" coords="757,3381,941,3937">
<area shape="rect" id="node24" href="tables/xchan.html" title="xchan" alt="" coords="505,3051,697,3517">
<area shape="rect" id="node2" href="tables/attach.html" title="attach" alt="" coords="776,305,923,748">
<area shape="rect" id="node3" href="tables/channel.html" title="channel" alt="" coords="21,1679,216,2643">
<area shape="rect" id="node10" href="tables/hubloc.html" title="hubloc" alt="" coords="261,1771,459,2213">
<area shape="rect" id="node4" href="tables/chat.html" title="chat" alt="" coords="784,3953,915,4124">
<area shape="rect" id="node5" href="tables/chatpresence.html" title="chatpresence" alt="" coords="784,4141,915,4334">
<area shape="rect" id="node6" href="tables/dreport.html" title="dreport" alt="" coords="760,4350,939,4589">
<area shape="rect" id="node7" href="tables/event.html" title="event" alt="" coords="769,1839,929,2236">
<area shape="rect" id="node8" href="tables/group_member.html" title="group_member" alt="" coords="772,4605,927,4753">
<area shape="rect" id="node9" href="tables/groups.html" title="groups" alt="" coords="784,1141,915,1334">
<area shape="rect" id="node11" href="tables/item.html" title="item" alt="" coords="744,4769,955,6119">
<area shape="rect" id="node12" href="tables/mail.html" title="mail" alt="" coords="773,6136,925,6624">
<area shape="rect" id="node13" href="tables/manage.html" title="manage" alt="" coords="787,6641,912,6767">
<area shape="rect" id="node14" href="tables/notify.html" title="notify" alt="" coords="781,1351,917,1657">
<area shape="rect" id="node15" href="tables/outq.html" title="outq" alt="" coords="769,5,929,289">
<area shape="rect" id="node16" href="tables/photo.html" title="photo" alt="" coords="768,6784,931,7181">
<area shape="rect" id="node17" href="tables/profext.html" title="profext" alt="" coords="784,953,915,1124">
<area shape="rect" id="node18" href="tables/register.html" title="register" alt="" coords="788,765,911,936">
<area shape="rect" id="node19" href="tables/shares.html" title="shares" alt="" coords="781,7198,917,7346">
<area shape="rect" id="node20" href="tables/source.html" title="source" alt="" coords="768,2253,931,2424">
<area shape="rect" id="node21" href="tables/term.html" title="term" alt="" coords="768,7363,931,7669">
<area shape="rect" id="node22" href="tables/updates.html" title="updates" alt="" coords="787,7687,912,7903">
<area shape="rect" id="node23" href="tables/vote.html" title="vote" alt="" coords="780,2441,919,2612">
<area shape="rect" id="node25" href="tables/xchat.html" title="xchat" alt="" coords="781,2629,917,2800">
<area shape="rect" id="node26" href="tables/xconfig.html" title="xconfig" alt="" coords="788,2817,911,2988">
<area shape="rect" id="node27" href="tables/xign.html" title="xign" alt="" coords="789,3005,909,3131">
<area shape="rect" id="node28" href="tables/xlink.html" title="xlink" alt="" coords="765,3148,933,3364">
<area shape="rect" id="node29" href="tables/xprof.html" title="xprof" alt="" coords="773,7920,925,8272">
<area shape="rect" id="node30" href="tables/xtag.html" title="xtag" alt="" coords="785,1674,913,1822">
</map>
<a name='diagram'><img id='realCompactImg' src='diagrams/summary/relationships.real.compact.png' usemap='#compactRelationshipsDiagram' class='diagram' border='0' alt=''></a>
<map id="largeRelationshipsDiagram" name="largeRelationshipsDiagram">
<area shape="rect" id="node1" href="tables/abook.html" title="abook" alt="" coords="779,3968,963,4547">
<area shape="rect" id="node24" href="tables/xchan.html" title="xchan" alt="" coords="509,3617,719,4263">
<area shape="rect" id="node2" href="tables/attach.html" title="attach" alt="" coords="795,351,947,929">
<area shape="rect" id="node3" href="tables/channel.html" title="channel" alt="" coords="25,1971,219,3117">
<area shape="rect" id="node10" href="tables/hubloc.html" title="hubloc" alt="" coords="265,2062,462,2573">
<area shape="rect" id="node4" href="tables/chat.html" title="chat" alt="" coords="806,4564,937,4735">
<area shape="rect" id="node5" href="tables/chatpresence.html" title="chatpresence" alt="" coords="806,4751,937,4945">
<area shape="rect" id="node6" href="tables/dreport.html" title="dreport" alt="" coords="782,4961,961,5223">
<area shape="rect" id="node7" href="tables/event.html" title="event" alt="" coords="787,2132,955,2801">
<area shape="rect" id="node8" href="tables/group_member.html" title="group_member" alt="" coords="794,5239,949,5387">
<area shape="rect" id="node9" href="tables/groups.html" title="groups" alt="" coords="806,1343,937,1537">
<area shape="rect" id="node11" href="tables/item.html" title="item" alt="" coords="766,5404,977,7116">
<area shape="rect" id="node12" href="tables/mail.html" title="mail" alt="" coords="795,7133,947,7689">
<area shape="rect" id="node13" href="tables/manage.html" title="manage" alt="" coords="809,7705,934,7831">
<area shape="rect" id="node14" href="tables/notify.html" title="notify" alt="" coords="803,1553,939,1951">
<area shape="rect" id="node15" href="tables/outq.html" title="outq" alt="" coords="791,5,951,334">
<area shape="rect" id="node16" href="tables/photo.html" title="photo" alt="" coords="790,7847,953,8539">
<area shape="rect" id="node17" href="tables/profext.html" title="profext" alt="" coords="806,1156,937,1327">
<area shape="rect" id="node18" href="tables/register.html" title="register" alt="" coords="807,946,935,1139">
<area shape="rect" id="node19" href="tables/shares.html" title="shares" alt="" coords="803,8555,939,8703">
<area shape="rect" id="node20" href="tables/source.html" title="source" alt="" coords="790,2819,953,2989">
<area shape="rect" id="node21" href="tables/term.html" title="term" alt="" coords="790,8720,953,9027">
<area shape="rect" id="node22" href="tables/updates.html" title="updates" alt="" coords="809,9044,934,9260">
<area shape="rect" id="node23" href="tables/vote.html" title="vote" alt="" coords="802,3007,941,3177">
<area shape="rect" id="node25" href="tables/xchat.html" title="xchat" alt="" coords="803,3195,939,3365">
<area shape="rect" id="node26" href="tables/xconfig.html" title="xconfig" alt="" coords="810,3383,933,3553">
<area shape="rect" id="node27" href="tables/xign.html" title="xign" alt="" coords="811,3571,931,3696">
<area shape="rect" id="node28" href="tables/xlink.html" title="xlink" alt="" coords="783,3713,959,3951">
<area shape="rect" id="node29" href="tables/xprof.html" title="xprof" alt="" coords="794,9277,949,9675">
<area shape="rect" id="node30" href="tables/xtag.html" title="xtag" alt="" coords="807,1967,935,2115">
</map>
<a name='diagram'><img id='realLargeImg' src='diagrams/summary/relationships.real.large.png' usemap='#largeRelationshipsDiagram' class='diagram' border='0' alt=''></a>
<map id="compactImpliedRelationshipsDiagram" name="compactImpliedRelationshipsDiagram">
<area shape="rect" id="node1" href="tables/abook.html" title="abook" alt="" coords="779,2946,963,3502">
<area shape="rect" id="node48" href="tables/xchan.html" title="xchan" alt="" coords="516,4102,708,4567">
<area shape="rect" id="node2" href="tables/account.html" title="account" alt="" coords="505,6863,719,7215">
<area shape="rect" id="node3" href="tables/addon.html" title="addon" alt="" coords="1039,1100,1164,1271">
<area shape="rect" id="node29" href="tables/notify.html" title="notify" alt="" coords="803,891,939,1197">
<area shape="rect" id="node4" href="tables/app.html" title="app" alt="" coords="1033,1288,1169,1595">
<area shape="rect" id="node5" href="tables/attach.html" title="attach" alt="" coords="797,6525,944,6968">
<area shape="rect" id="node8" href="tables/channel.html" title="channel" alt="" coords="21,3278,216,4242">
<area shape="rect" id="node23" href="tables/hubloc.html" title="hubloc" alt="" coords="261,2332,459,2775">
<area shape="rect" id="node46" href="tables/verify.html" title="verify" alt="" coords="555,8421,669,8614">
<area shape="rect" id="node6" href="tables/auth_codes.html" title="auth_codes" alt="" coords="1036,72,1167,197">
<area shape="rect" id="node11" href="tables/clients.html" title="clients" alt="" coords="553,95,671,198">
<area shape="rect" id="node44" href="tables/tokens.html" title="tokens" alt="" coords="812,5,929,176">
<area shape="rect" id="node7" href="tables/cache.html" title="cache" alt="" coords="549,10317,675,10419">
<area shape="rect" id="node9" href="tables/chat.html" title="chat" alt="" coords="805,3519,936,3689">
<area shape="rect" id="node10" href="tables/chatpresence.html" title="chatpresence" alt="" coords="805,3706,936,3899">
<area shape="rect" id="node12" href="tables/config.html" title="config" alt="" coords="812,10435,929,10583">
<area shape="rect" id="node13" href="tables/conv.html" title="conv" alt="" coords="808,8982,933,9130">
<area shape="rect" id="node14" href="tables/dreport.html" title="dreport" alt="" coords="781,3987,960,4226">
<area shape="rect" id="node15" href="tables/event.html" title="event" alt="" coords="1021,2220,1181,2617">
<area shape="rect" id="node16" href="tables/fcontact.html" title="fcontact" alt="" coords="813,9146,928,9294">
<area shape="rect" id="node17" href="tables/ffinder.html" title="ffinder" alt="" coords="816,9310,925,9458">
<area shape="rect" id="node18" href="tables/fserver.html" title="fserver" alt="" coords="1045,1611,1157,1759">
<area shape="rect" id="node19" href="tables/fsuggest.html" title="fsuggest" alt="" coords="1043,214,1160,317">
<area shape="rect" id="node20" href="tables/group_member.html" title="group_member" alt="" coords="793,8114,948,8262">
<area shape="rect" id="node21" href="tables/groups.html" title="groups" alt="" coords="805,6985,936,7178">
<area shape="rect" id="node22" href="tables/hook.html" title="hook" alt="" coords="1043,333,1160,459">
<area shape="rect" id="node24" href="tables/item.html" title="item" alt="" coords="765,4971,976,6320">
<area shape="rect" id="node25" href="tables/item_id.html" title="item_id" alt="" coords="807,9663,935,9833">
<area shape="rect" id="node26" href="tables/likes.html" title="likes" alt="" coords="805,9993,936,10277">
<area shape="rect" id="node27" href="tables/mail.html" title="mail" alt="" coords="795,7195,947,7683">
<area shape="rect" id="node28" href="tables/manage.html" title="manage" alt="" coords="1039,3255,1164,3380">
<area shape="rect" id="node30" href="tables/outq.html" title="outq" alt="" coords="791,2377,951,2661">
<area shape="rect" id="node31" href="tables/pconfig.html" title="pconfig" alt="" coords="1037,6639,1165,6809">
<area shape="rect" id="node32" href="tables/photo.html" title="photo" alt="" coords="789,7700,952,8097">
<area shape="rect" id="node33" href="tables/profdef.html" title="profdef" alt="" coords="807,9851,935,9976">
<area shape="rect" id="node34" href="tables/profext.html" title="profext" alt="" coords="805,8421,936,8592">
<area shape="rect" id="node35" href="tables/profile.html" title="profile" alt="" coords="1027,476,1176,873">
<area shape="rect" id="node36" href="tables/profile_check.html" title="profile_check" alt="" coords="801,8609,940,8802">
<area shape="rect" id="node37" href="tables/register.html" title="register" alt="" coords="809,6337,932,6508">
<area shape="rect" id="node38" href="tables/shares.html" title="shares" alt="" coords="803,4242,939,4390">
<area shape="rect" id="node39" href="tables/sign.html" title="sign" alt="" coords="809,8818,932,8966">
<area shape="rect" id="node40" href="tables/source.html" title="source" alt="" coords="789,4407,952,4577">
<area shape="rect" id="node41" href="tables/spam.html" title="spam" alt="" coords="1047,890,1156,1083">
<area shape="rect" id="node42" href="tables/sys_perms.html" title="sys_perms" alt="" coords="807,10293,935,10419">
<area shape="rect" id="node43" href="tables/term.html" title="term" alt="" coords="789,1251,952,1557">
<area shape="rect" id="node45" href="tables/updates.html" title="updates" alt="" coords="808,1575,933,1791">
<area shape="rect" id="node47" href="tables/vote.html" title="vote" alt="" coords="801,4595,940,4765">
<area shape="rect" id="node49" href="tables/xchat.html" title="xchat" alt="" coords="803,4783,939,4953">
<area shape="rect" id="node50" href="tables/xconfig.html" title="xconfig" alt="" coords="809,9475,932,9645">
<area shape="rect" id="node51" href="tables/xign.html" title="xign" alt="" coords="811,8279,931,8404">
<area shape="rect" id="node52" href="tables/xlink.html" title="xlink" alt="" coords="787,2713,955,2929">
<area shape="rect" id="node53" href="tables/xprof.html" title="xprof" alt="" coords="795,1972,947,2324">
<area shape="rect" id="node54" href="tables/xtag.html" title="xtag" alt="" coords="807,1807,935,1955">
</map>
<a name='diagram'><img id='impliedCompactImg' src='diagrams/summary/relationships.implied.compact.png' usemap='#compactImpliedRelationshipsDiagram' class='diagram' border='0' alt=''></a>
<map id="largeImpliedRelationshipsDiagram" name="largeImpliedRelationshipsDiagram">
<area shape="rect" id="node1" href="tables/abook.html" title="abook" alt="" coords="782,4067,966,4645">
<area shape="rect" id="node48" href="tables/xchan.html" title="xchan" alt="" coords="510,5291,721,5938">
<area shape="rect" id="node2" href="tables/account.html" title="account" alt="" coords="509,8425,722,8890">
<area shape="rect" id="node3" href="tables/addon.html" title="addon" alt="" coords="1035,2017,1182,2233">
<area shape="rect" id="node29" href="tables/notify.html" title="notify" alt="" coords="806,1808,942,2205">
<area shape="rect" id="node4" href="tables/app.html" title="app" alt="" coords="1039,2250,1178,2670">
<area shape="rect" id="node5" href="tables/attach.html" title="attach" alt="" coords="798,8077,950,8656">
<area shape="rect" id="node8" href="tables/channel.html" title="channel" alt="" coords="25,4397,219,5542">
<area shape="rect" id="node23" href="tables/hubloc.html" title="hubloc" alt="" coords="265,3362,462,3873">
<area shape="rect" id="node46" href="tables/verify.html" title="verify" alt="" coords="558,10469,673,10662">
<area shape="rect" id="node6" href="tables/auth_codes.html" title="auth_codes" alt="" coords="1043,83,1174,253">
<area shape="rect" id="node11" href="tables/clients.html" title="clients" alt="" coords="550,117,681,310">
<area shape="rect" id="node44" href="tables/tokens.html" title="tokens" alt="" coords="815,5,933,198">
<area shape="rect" id="node7" href="tables/cache.html" title="cache" alt="" coords="549,12863,682,12988">
<area shape="rect" id="node9" href="tables/chat.html" title="chat" alt="" coords="809,4663,939,4833">
<area shape="rect" id="node10" href="tables/chatpresence.html" title="chatpresence" alt="" coords="809,4850,939,5043">
<area shape="rect" id="node12" href="tables/config.html" title="config" alt="" coords="815,13003,933,13151">
<area shape="rect" id="node13" href="tables/conv.html" title="conv" alt="" coords="811,11075,937,11314">
<area shape="rect" id="node14" href="tables/dreport.html" title="dreport" alt="" coords="785,5132,963,5393">
<area shape="rect" id="node15" href="tables/event.html" title="event" alt="" coords="1025,3273,1193,3943">
<area shape="rect" id="node16" href="tables/fcontact.html" title="fcontact" alt="" coords="815,11330,933,11750">
<area shape="rect" id="node17" href="tables/ffinder.html" title="ffinder" alt="" coords="819,11766,929,11914">
<area shape="rect" id="node18" href="tables/fserver.html" title="fserver" alt="" coords="1053,2686,1165,2834">
<area shape="rect" id="node19" href="tables/fsuggest.html" title="fsuggest" alt="" coords="1050,271,1167,532">
<area shape="rect" id="node20" href="tables/group_member.html" title="group_member" alt="" coords="797,10162,951,10310">
<area shape="rect" id="node21" href="tables/groups.html" title="groups" alt="" coords="809,8673,939,8866">
<area shape="rect" id="node22" href="tables/hook.html" title="hook" alt="" coords="1047,549,1170,720">
<area shape="rect" id="node24" href="tables/item.html" title="item" alt="" coords="769,6139,979,7851">
<area shape="rect" id="node25" href="tables/item_id.html" title="item_id" alt="" coords="810,12119,938,12289">
<area shape="rect" id="node26" href="tables/likes.html" title="likes" alt="" coords="809,12515,939,12799">
<area shape="rect" id="node27" href="tables/mail.html" title="mail" alt="" coords="798,8882,950,9438">
<area shape="rect" id="node28" href="tables/manage.html" title="manage" alt="" coords="1046,4489,1171,4615">
<area shape="rect" id="node30" href="tables/outq.html" title="outq" alt="" coords="794,3430,954,3759">
<area shape="rect" id="node31" href="tables/pconfig.html" title="pconfig" alt="" coords="1045,8585,1173,8756">
<area shape="rect" id="node32" href="tables/photo.html" title="photo" alt="" coords="793,9454,955,10146">
<area shape="rect" id="node33" href="tables/profdef.html" title="profdef" alt="" coords="809,12306,939,12499">
<area shape="rect" id="node34" href="tables/profext.html" title="profext" alt="" coords="809,10469,939,10640">
<area shape="rect" id="node35" href="tables/profile.html" title="profile" alt="" coords="1034,737,1183,1791">
<area shape="rect" id="node36" href="tables/profile_check.html" title="profile_check" alt="" coords="805,10657,943,10850">
<area shape="rect" id="node37" href="tables/register.html" title="register" alt="" coords="810,7867,938,8061">
<area shape="rect" id="node38" href="tables/shares.html" title="shares" alt="" coords="806,5410,942,5558">
<area shape="rect" id="node39" href="tables/sign.html" title="sign" alt="" coords="809,10866,939,11059">
<area shape="rect" id="node40" href="tables/source.html" title="source" alt="" coords="793,5575,955,5745">
<area shape="rect" id="node41" href="tables/spam.html" title="spam" alt="" coords="1054,1807,1163,2001">
<area shape="rect" id="node42" href="tables/sys_perms.html" title="sys_perms" alt="" coords="807,12816,941,12987">
<area shape="rect" id="node43" href="tables/term.html" title="term" alt="" coords="793,2259,955,2565">
<area shape="rect" id="node45" href="tables/updates.html" title="updates" alt="" coords="811,2583,937,2799">
<area shape="rect" id="node47" href="tables/vote.html" title="vote" alt="" coords="805,5763,943,5933">
<area shape="rect" id="node49" href="tables/xchat.html" title="xchat" alt="" coords="806,5951,942,6121">
<area shape="rect" id="node50" href="tables/xconfig.html" title="xconfig" alt="" coords="813,11931,935,12101">
<area shape="rect" id="node51" href="tables/xign.html" title="xign" alt="" coords="814,10327,934,10452">
<area shape="rect" id="node52" href="tables/xlink.html" title="xlink" alt="" coords="786,3811,962,4050">
<area shape="rect" id="node53" href="tables/xprof.html" title="xprof" alt="" coords="797,2980,951,3377">
<area shape="rect" id="node54" href="tables/xtag.html" title="xtag" alt="" coords="810,2815,938,2963">
</map>
<a name='diagram'><img id='impliedLargeImg' src='diagrams/summary/relationships.implied.large.png' usemap='#largeImpliedRelationshipsDiagram' class='diagram' border='0' alt=''></a>
</td></tr></table>
</div>
</body>
</html>
