>>> [!note] Migrated issue <!-- Drupal.org comment --> <!-- Migrated from issue #70825. --> Reported by: [sime](https://www.drupal.org/user/35266) >>> <p>A little time ago, I was doing my first multi-site installation and I was trying to work out which tables should be shared between the different sites. </p> <!--break--><p> What I needed was a simple description about the purpose of each table. 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></p> <p>This is good effort towards a proper data dictionary, which is going to take a fair bit of work. In the meantime, I decided that a much simpler summary was enough to get a brief overview of what the tables are used for. And something that would help a lot of people in the short term.</p> <p>So I have created some pages which give an overview of the standard tables in Drupal. They are grouped according to their usage. My target audience have limited experience with "keys", "querys" and "relationships", so I largely overlooked these concepts - although you'll see in each diagram, that I do hint at relationships between tables, albeit in a way that doesn't alienate newbies.</p> <p>These are all in the moderation queue of course. However, I'd love it if these pages were reviewed as a whole. With an additional request to place them in (more-or-less) the order outlined below.</p> <p><a href="http://drupal.org/node/22754">http://drupal.org/node/22754</a> - parent page</p> <p><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 &amp; 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</p> <p>I look foward to a review.<br> Simon</p>