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.

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!

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?

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,

I believe field_data_body.entity_id is a foreign key, that points to various tables, depending on value of field_data_body.entity_type. If field_data_body.entity_type='node', then field_data_body.entity_id joins on node.nid.

I'm new to Drupal, so I don't know whether it joins to any other tables. You could 'SELECT DISTINCT field_data_body.entity_type' from a populated instance and see.