Wah! Pretty pictures!<br>
<br>
Darned if I know anything about tables, but amazing job, I am sure many people will find this useful!<br>
<br>
Anisa.<br><br><div><span class="gmail_quote">On 6/26/06, <b class="gmail_sendername">sime</b> <<a href="mailto:drupal-docs@drupal.org">drupal-docs@drupal.org</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Issue status update for<br><a href="http://drupal.org/node/70825">http://drupal.org/node/70825</a><br>Post a follow up:<br><a href="http://drupal.org/project/comments/add/70825">http://drupal.org/project/comments/add/70825
</a><br><br> Project: Documentation<br> Version: <none><br> Component: Developer Guide<br> Category: tasks<br> Priority: normal<br> Assigned to: Anonymous<br> Reported by: sime<br> Updated by: sime
<br> Status: active<br><br>A little time ago, I was doing my first multi-site installation and I<br>was trying to work out which tables should be shared between the<br>different sites.<br><br><br>What I needed was a simple description about the purpose of each table.
<br>What I found was this ticket:<br><a href="http://drupal.org/node/28046">http://drupal.org/node/28046</a><br>and this book page:<br><a href="http://drupal.org/node/38977">http://drupal.org/node/38977</a><br><br><br>This is good effort towards a proper data dictionary, which is going to
<br>take a fair bit of work. In the meantime, I decided that a much simpler<br>summary was enough to get a brief overview of what the tables are used<br>for. And something that would help a lot of people in the short term.
<br><br><br>So I have created some pages which give an overview of the standard<br>tables in Drupal. They are grouped according to their usage. My target<br>audience have limited experience with "keys", "querys" and
<br>"relationships", so I largely overlooked these concepts - although<br>you'll see in each diagram, that I do hint at relationships between<br>tables, albeit in a way that doesn't alienate newbies.<br><br><br>
These are all in the moderation queue of course. However, I'd love it<br>if these pages were reviewed as a whole. With an additional request to<br>place them in (more-or-less) the order outlined below.<br><br><br><a href="http://drupal.org/node/22754">
http://drupal.org/node/22754</a> - parent page<br><br><br><a href="http://drupal.org/node/70516">http://drupal.org/node/70516</a> - user tables<br><a href="http://drupal.org/node/70591">http://drupal.org/node/70591</a> - node tables
<br><a href="http://drupal.org/node/70605">http://drupal.org/node/70605</a> - node type tables<br><a href="http://drupal.org/node/70614">http://drupal.org/node/70614</a> - taxonomy tables<br><a href="http://drupal.org/node/70623">
http://drupal.org/node/70623</a> - search tables<br><a href="http://drupal.org/node/70625">http://drupal.org/node/70625</a> - layout & nav tables<br><a href="http://drupal.org/node/70627">http://drupal.org/node/70627</a>
- localization tables<br><a href="http://drupal.org/node/70624">http://drupal.org/node/70624</a> - RSS tables<br><a href="http://drupal.org/node/70791">http://drupal.org/node/70791</a> - tracking tables<br><a href="http://drupal.org/node/70796">
http://drupal.org/node/70796</a> - system tables<br><a href="http://drupal.org/node/70814">http://drupal.org/node/70814</a> - other tables<br><br><br>I look foward to a review.<br>Simon<br><br><br><br><br>sime<br><br>--<br>
Pending work: <a href="http://drupal.org/project/issues/documentation/">http://drupal.org/project/issues/documentation/</a><br>List archives: <a href="http://lists.drupal.org/pipermail/documentation/">http://lists.drupal.org/pipermail/documentation/
</a><br></blockquote></div><br><br clear="all"><br>-- <br>*********************************<br><a href="http://www.AnimeCards.Org">www.AnimeCards.Org</a><br><br>16,000 scans and counting!<br>*********************************