WordPress Database Schema?

Liliana

New member
Joined
Mar 14, 2013
Messages
129
Points
0
Do you know about WordPress Database Schema?
Please give me overview about structure of wordpress database, I can control better my data with wordpress :rolleyes:
Thanks
 

Alex Thompson

Moderator
Joined
Jun 6, 2013
Messages
651
Points
43
Understanding the database structure of wordpress is your first step on the road to become a wordpress developer. I hope this information can be useful to you.

The first, WordPress database is fairly simple, including only 11 tables but can be used for many different types of websites. Here we keep the default WordPress table prefix is wp_ . Of course, you can change this prefix if you want, in installation process

View attachment 839

1/ wp_options
Save the configuration information website, the fixed information, little changed.
2/ wp_posts
Containing the post, page, attachment, nav_menu_item,... Generally wp_posts table will contain the data type "single" as products, books,...etc.
3/ wp_postmeta
WordPress gives us wp_postmeta table to store additional information is not limited. For example, for more information about the short description for the post, I added the wp_postmeta table as follows: post_id = [id of the post], meta_key = 'description', meta_value = [paragraph description] and so on.
4/ wp_comments
Save the comment, post comment
5/ wp_commentmeta
More information of comments
6/ wp_terms
Save id, name, slug, the group's taxonomy (category, tag, menu, ...).. Generally save the "container" as trademarks, cities,...etc
7/ wp_term_taxonomy
Save the information of the term: What type (category, tag, menu, ...), description, parent term (the term the public), the number of items contained in it.
8/ wp_term_relationships
Table relationships between post and taxonomy
9/ wp_users
Save user information
10/ wp_usermeta
Save more user information
11/ wp_links
Save the link

Hope it helps!
Alex
:)
 
Latest threads
Replies
1
Views
254
Replies
1
Views
355
Replies
4
Views
1,814
Replies
3
Views
790
Recommended threads
Replies
3
Views
4,586
Replies
1
Views
1,441
Replies
16
Views
6,657

Latest postsNew threads

Referral contests

Referral link for :

Sponsors

Popular tags

You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.

Top