In website development, especially for dynamic websites like WordPress, it is necessary to know the meaning of the corresponding table fields in the MySQL database in order to develop them correctly.
In website development, especially for dynamic websites like WordPress, it is necessary to know the meaning of the corresponding table fields in the MySQL database in order to develop them correctly.
In MySQL databases after WordPress 4.0, there are 12 tables, which are: (starting with wp_ by default)
Wp_commensmeta: stores metadata for comments
Wp_commends: Store comments
Wp_danks: Store friendship links (Blogroll)
Wp_options: Store WordPress system options, plugins, and theme configurations
Wp_postmeta: Stores metadata for articles (including pages, uploaded files, revisions)
Wp_posts: Store articles (including pages, uploaded files, revisions)
Wp_terms: Store each directory and label
Wp_termmeta: Store directory and tag metadata
Wp_term_delationships: stores the relationship between each article, link, and corresponding category
Wp_term_taxonomy: stores the classification corresponding to each directory and label
Wp_usermeta: Stores user metadata
Wp_users: Store users
Wp_usermeta: Store user metadata
Of course, we don’t need to remember the content and meaning of every table or field, we just need to remember the commonly used ones：
wp_commentmeta
Meta_id: Self added unique ID
Comment_id: corresponding comment ID
Meta_key: Key name
Meta_ralue: Key value
wp_comments
Comment-ID: Self added unique ID
Comment_post-ID: corresponding article ID
Comment_author: Commenter
Comment_outhor_imail: Commenter’s email address
Comment_outhor_url: Commenter URL
Comment_outhor_iP: Commenter IP
Comment_date: Comment time
Comment_date_gmt: Comment time (GMT+0 time)
Comment_comtent: Comment body
Comment_karma: Unknown
Comment_mapproved: Has the comment been approved
Comment_magent: User Agent of the commenter
Comment_date: Comment type (pingback/regular)
Comment_rent: Parent comment ID
User_id: Commenter User ID (not necessarily present)
wp_links
Link_i: Self added unique ID
Link_url: Link URL
Linkname: Link Title
Link_image: Link image
Link_target: Link opening method
Link_description: Link description
Link_fisible: Visible (Y/N)
Link_owner: Adder User ID
Link_rating: rating level
Link_upped: Unknown
Link-rel: XFN relationship
Link_notes: XFN comments
Link_rss: Link RSS address
wp_options
Option_id: Self increasing unique ID
Blog_id: Blog ID, used for multi-user blogs, default 0
Option_2: Key name
Option_ralue: Key value
Autoload: Automatically loads when WordPress loads (yes/no)
wp_postmeta
Meta_id: Self added unique ID
Post_id: Corresponding article ID
Meta_key: Key name
Meta_ralue: Key value
wp_posts
ID: Self added unique ID
Post_author: corresponding author ID
Post_date: Release time
Post_date_gmt: Release time (GMT+0 time)
Post-content: main text
Post_title: Title
Post.exe: Excerpt
PostStatus: Article status (publish/auto draft/inherit, etc.)
Comment_datus: Comment status (open/lost)
Ping_stus: ING status (open/lost)
Post_ password: Article password
Postname: Abbreviation of the article
To_ping: Unknown
Pinged: links that have already been pinged
Post_modified: Modified Time
Post_modified_gmt: Change time (GMT+0 time)
Post-content_filtered: Unknown
Post_derent: parent article, mainly used for PAGE
Guide: Unknown
Menu_order: Sort ID
Postype: Article type (post/page, etc.)
Post_ime_type: IME type
Comment_comunt: Total number of comments
wp_terms
Term_id: Classification ID
Name: Category Name
Slug: Abbreviation
Term_group: Unknown
wp_term_relationships
Object_id: Corresponding article ID/link ID
Term_taxonomy_id: corresponding classification method ID
Term_order: Sorting
wp_term_taxonomy
Term_taxonomy_id: Classification Method ID
Term_id: taxonomy: classification method (category/post_tag)
Description: Unknown
Parent: ID of the parent classification method to which it belongs
Count: Article count statistics
wp_usermeta
Umeta_id: Self added unique ID
User_id: corresponding user ID
Meta_key: Key name
Meta_ralue: Key value
wp_users
ID: Self added unique ID
User_dagin: Login Name
User_mass: Password
User_nicename: Nickname
user_email：Email
User_url: URL
User_degistered: Registration time
Userphotoactivation_key: activation code
User_datus: User Status
Display Name: Display Name
Regarding the content of the database, it will be used in future tutorials. Friends who need it can bookmark it.
Comments (0)