Jump to Navigation

Drupal 7 Database Schema

June 30, 2011 - 6:11pm — ursula
A while ago, the data model of Drupal was discussed in the LinkedIn Drupal group. A number of good pointers to data models of D6 and D5, and one for CiviCRM came up. http://drupal.org/node/22754
http://knownexception.blogspot.com/2009/12/drupal-6x-approx-core-databas...
http://www.r2idrupal.com/blog/drupal-erd-data-model-and-meta-dictionary-...
http://drupal.org/files/issues/Drupal5RC1_Database_0.png
http://kuchtohai.blogspot.com/2005/12/drupal-e-r-diagram.html
http://wiki.civicrm.org/confluence/display/CRMDOC33/CiviCRM+data+archite... However, it doesn't seem that a D7 data model is available online. This is my first go on creating a Drupal 7 database schema. I used all modules enabled in the "Standard Installation". It was created using MySQL workbench. The schema certainly needs revisions. Feel free to leave a comment,and I'll incorporate the revision. The usefulness of this data model in Drupal programming is debatable, especially since many regularly used contributed modules are missing. However, the creation of the model helped me to further understand the Drupal 7 structure, and made me more familiar with the dependencies, thus the creation was helpful and educational.
Download Attachment: 
drupal7.mwb

Comments

fndtn357 (not verified) - July 9, 2011 - 10:03am.
I just downloaded it to look at for awhile. Thanks for taking the time to start documenting this. I will try to find time to add to this if I can.

ursula - July 15, 2011 - 9:47am.
Thanks, any additions are welcome! It took me a month to actually put this up, after I made it, and sure can need a refresher, by going through it again.

marya lusy (not verified) - May 8, 2013 - 9:43pm.
I was verifying consistently this web blog and I’m impressed! Extremely details specifically the last part I care for such information and facts much. I was searching for this certain details for some time
resource | visit site | Good resource for weight loss

marya lusy (not verified) - May 8, 2013 - 9:43pm.
The post is absolutely fantastic! Lots of great information and inspiration, both of which we all need! Also like to Logo design admire the time and effort you put into your blog and detailed information you offer! I will bookmark your blog and have my children check up here often.
web site | official site

jasondaniels (not verified) - May 20, 2013 - 11:30pm.
It is important to choose right one since the first time. Thank you for the tips. Proper care will save money in long term. www.freegamblingslot.com

efrainwillson87 (not verified) - May 22, 2013 - 8:53pm.
It was very useful for me. Keep sharing such ideas in the future as well. This was actually what I was looking for, and I am glad to came here! Thanks for sharing such a information with us.
cell phone spyware
clubmz reviews

Bev (not verified) - November 12, 2012 - 7:08pm.
My coder is trying to convince me to move to .
net from PHP. I have always disliked the idea because of the costs.
But he's tryiong none the less. I've been using WordPress
on several websites for about a year and
am worried about switching to another platform. I have heard great things about blogengine.net. Is there a way I can transfer all my wordpress content
into it? Any kind of help would be really appreciated!

Anonymous (not verified) - December 3, 2012 - 1:12am.
Moving a blog from wordpress to .NET would be plain stupidity in 98% of all thinkable cases. Why replace a well established system used be millions of sites with an incredible amount of modules, themes and information with one that barely anyone knows and that might be gone in a year?

Zammu1 (not verified) - March 20, 2013 - 11:47pm.
www.theshoppingwebsites.com This will be cool go for it I will use it. Thank You

Zammu1 (not verified) - March 20, 2013 - 11:48pm.
www.girlsshoppingonline.com Hello everyone, it�s my first go to see at this web site, and post is actually fruitful designed for me, keep up posting these content.

Maks (not verified) - March 26, 2013 - 2:08am.
I have downloaded it. And it is really good, just try to find some time to use it.
my site: buy term papers

Hostgator 1 cen... (not verified) - May 19, 2013 - 11:27pm.
Get your free trial of hostgator coupon here. hostgator super1centdeal 2013

nitin (not verified) - May 20, 2013 - 10:26pm.
iphone screen protector
I am definitely tired of struggling to find relevant and intelligent commentary on this subject.

John Corning (not verified) - April 10, 2013 - 12:38am.
Your posting is really enlightening! Reading through your work has enlightened me. Learned a lot from it. I will store your webpage and will continue to keep read through your new articles. Wonderful! Thanks!essays.mightystudents.com

maryalusy (not verified) - April 25, 2013 - 10:23pm.
Thanks for the unmatchable diary.it was rale useful for me.navigator sharing specified ideas in the instant as symptomless.this was actually what i was labour for,and i am voluntary to came here!'
anti wrinkle cream for men | sizegenetics reviews

maryalusy (not verified) - April 25, 2013 - 10:22pm.
This is a really quality post.I find this information through Google Search engine. I read your Article very carefully it is really very informatic Article,I bookmarked your site.'
raspberry ketone | raspberry ketone side effects | acai berry weight loss

maryalusy (not verified) - April 25, 2013 - 10:43pm.
Great post. If they are familiar with each other, it should make for an interesting game.
raspberry ketone | raspberry ketone side effects | acai berry weight loss

maryalusy (not verified) - April 25, 2013 - 10:44pm.
Great job for publishing such a beneficial web site. Your web log isn’t only useful but it is additionally really creative too. There tend to be not many people who can certainly write not so simple posts that artistically. Continue the nice writing..
raspberry ketone | raspberry ketone side effects | acai berry weight loss

maryalusy (not verified) - April 25, 2013 - 10:51pm.
The article written very well, writing technique looked very skillful and has a good sense of humor, let a person think, and let people with a cheerful mood, the feeling is very good. I like the article, the heart be thank the authors of shares.
raspberry ketone | raspberry ketone side effects | acai berry weight loss

marya lusy (not verified) - May 8, 2013 - 9:37pm.
This is a really quality post.I find this information through Google Search engine. I read your Article very carefully it is really very informatic Article,I bookmarked your site.
web site | official site

marya lusy (not verified) - May 8, 2013 - 9:36pm.
I admire the valuable information you offer in your content articles. I will bookmark your weblog. I am quite certain i will learn lots of new stuff right here than anybody else!
resource | visit site | Good resource for weight loss

marya lusy (not verified) - May 8, 2013 - 9:44pm.
Valuable information and excellent design you got here! I would like to thank you for sharing your thoughts and time into the stuff you post!!
resource | visit site | Good resource for weight loss

marya lusy (not verified) - May 21, 2013 - 9:06pm.
Useful information.I am actual blessed to read this article.thanks for giving us this advantageous information.I acknowledge this post.and I would like bookmark this post.Thanks
garcinia | garciniacambogiawheretobuy1.webs.com

marya lusy (not verified) - May 21, 2013 - 9:06pm.
What a fantastic post ! it was absolutely actual informative.I attending advanced in account added of your assignment post, And accomplish you abiding that i will bookmark your post how ever i can appear a back latter.
breastenlargementpill.webs | naturalbreastenlargementpills.tripod.co.uk

kirkilj (not verified) - July 15, 2011 - 7:02am.
Yours is cleaner than the one I came up with. Thanks for doing this.

Zhatakk (not verified) - July 22, 2011 - 10:09am.
Hehe, the website took fairly a great deal of time to load but it was worth it.
Jon Milak

Anthony (not verified) - July 24, 2011 - 8:16pm.
Thanks. I love getting the database diagrams. Couldn't wait for a Drupal 7 one and this one is perfect. I put it up on my wall.

zaurav (not verified) - September 30, 2011 - 11:49am.
How did you get the relationship lines? I'm using MYSQL Workbench to reverse engineer my db and I get the Diagrams but no relationship lines. Could you help me out? Thanks.

ursula - October 22, 2011 - 11:26am.
Hi, I added the relationship lines manually, by looking at the tables, and using workbench's tools. It made me look at each table, and understand the relationships.

optimizacijasajta (not verified) - June 2, 2012 - 4:43pm.
Good article. I will be facing some of these issues as well.
.

Herman Sentrigos (not verified) - December 14, 2011 - 8:49am.
That's a cleaner code than mine.

AmirHossein (not verified) - January 3, 2012 - 4:57am.
thank you! :)

Jeffrey Schrab (not verified) - January 28, 2012 - 3:14pm.
I have some D7 to D7 database black magick I need to do in the very near future - finding this is VERY timely! Thank a mint for sharing!

Anonymous (not verified) - February 15, 2012 - 7:21am.
excellent!

jaffa (not verified) - June 13, 2012 - 4:21am.
The utilization of databases is now so widespread that virtually every technology and product relies on databases and DBMSs for its development and commercialization, or even may have such software embedded in it. Also, organizations and companies, from small to large, depend heavily on databases for their operations. Thanks.
Regards,

Gyozo Kudor (not verified) - March 6, 2012 - 12:11am.
Hello thank you for this, can you upload the mwb file somewhere? So I can open it with mysql workbench? Thanks.

ursula - March 13, 2012 - 5:10pm.
I added the file to the page. Enjoy!

Guillermo (not verified) - September 6, 2012 - 3:06am.
Great work Ursula!

Moshe (not verified) - October 5, 2012 - 7:27pm.
I neеded to thank уou for this fantаstic read!
! I definitеly enϳoyed eѵery little bit оf it. I have got you book marκed tο cheсk out new thіngѕ you ρost… my blοg pοѕt - επιπλα μοντερνα

Anonymous (not verified) - September 8, 2012 - 4:41am.
Thanks a lot!

jungyi (not verified) - October 19, 2012 - 5:06pm.
Thank you a lot!

Michael (not verified) - November 15, 2012 - 5:10am.
Great resource! Thanks for sharing!

pedram (not verified) - January 22, 2013 - 6:28am.
thanks for sharing :)

Dani (not verified) - January 24, 2013 - 1:28am.
Thank you so much .you definatly saved alot of time for me.thank you again

niki453 (not verified) - March 14, 2013 - 6:09am.
I like your site very much, I fall here by google search and start reading your post, by watching all pages I get to know that you are posting nice stuff on your pages,Edinburgh meet and greet I would share this information with all my friends, as you are providing a nice information resource to all people, this is only one place I seen this much information all together, because people search for such places where they can get all they looking for. Im really happy to find this place and I would talk about your site with my friends. I would definitely return back to your site as I book marked your page url to visit you again.Bristol meet and greet I hope you will keep posting nice stuff on different important issues, and will share all your nice stuff with us, and all your experience to give more knowledge to people, the design of your website is really nice and you are working hard to provide a best information resource. No doubt that you are one of the best people who are working hard to make this internet world more worth full as there are many website who are not providing that they should. They are just trying to waste people time and give no good results. But im really happy with your site and design you are using is very good.I am happy to find your distinguished way of writing the post. Now you make it easy for me to understand and implement the concept. I really loved reading your blog. It was very well authored and easy to understand. Unlike additional I have read which are really not tht good. I also found your posts very interesting. In fact after reading, I had to go show it to my friend and he enjoyed it as well!Thanks so much for this! I have not been this thrilled by a blog post for quite some time! You’ve got it,Glasgow meet and greetwhatever that means in blogging. Anyway, You’re definitely someone that has something to say that people should hear. Keep up the wonderful job. Keep on inspiring the people.

http://www.fore... (not verified) - March 29, 2013 - 2:38am.
It is really a pleasant along with beneficial piece of information. Now i'm happy that you simply distributed this specific helpful information around and extremely very happy to observe ones content, I will be a lot to help just like as well as go along with your perspective. http://www.forextradinghour.com

Napoleon (not verified) - March 31, 2013 - 4:12am.
:)

led (not verified) - April 7, 2013 - 8:03pm.
The shaple of LED Corn Light bulbs are similar with corn cobs. In general,LED lamps lighting-emitting angle is 120 degrees, yet A led corn light could emit 360-degree light horizontal direction,to brighten wall and floor.

led (not verified) - April 7, 2013 - 8:03pm.
Most GaN-based LEDs begin life with the deposition of multilayer semiconductor structures on sapphire substrates. Cree uses silicon carbide for its LED production , while some manufacturers such as Toshiba are using silicon substrates. GaN substrates offer a significant advantage for the growth of GaN-based layers, namely the much lower lattice mismatch between the layers and the substrate. However, GaN bulk crystals are difficult to grow, and commercially available GaN substrates are generally small in size and very expensive.

led (not verified) - April 7, 2013 - 8:24pm.
The shaple of LED Corn Light bulbs are similar with corn cobs. In general,LED lamps lighting-emitting angle is 120 degrees, yet A led corn light could emit 360-degree light horizontal direction,to brighten wall and floor.

Add new comment

(If you're a human, don't change the following field)
Your first name.

More information about text formats

Filtered HTML

  • Lines and paragraphs break automatically.
  • To post pieces of code, surround them with <code>...</code> tags. For PHP code, you can use <?php ... ?>, which will also colour it based on syntax.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd><h3><h4><img><pre><br>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.