Initial WordPress database structure

TableColumns
wp_commentmetameta_id, comment_id, meta_key, meta_value
wp_commentscomment_ID, comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, comment_content, comment_karma, comment_approved, comment_agent, comment_type, comment_parent, user_id
wp_linkslink_id, link_url, link_name, link_image, link_target, link_description, link_visible, link_owner, link_rating, link_updated, link_rel, link_notes, link_rss
wp_optionsoption_id, option_name, option_value, autoload
wp_postmetameta_id, post_id, meta_key, meta_value
wp_postsID, post_author, post_date, post_date_gmt, post_content, post_title, post_excerpt, post_status, comment_status, ping_status, post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt, post_content_filtered, post_parent, guid, menu_order, post_type, post_mime_type, comment_count
wp_termmetameta_id, term_id, meta_key, meta_value
wp_termsterm_id, name, slug, term_group
wp_term_relationshipsobject_id, term_taxonomy_id, term_order
wp_term_taxonomyterm_taxonomy_id, term_id, taxonomy, description, parent, count
wp_usermetaumeta_id, user_id, meta_key, meta_value
wp_usersID, user_login, user_pass, user_nicename, user_email, user_url, user_registered, user_activation_key, user_status, display_name
WordPress v6.5.3

Leave a Comment