Variables

WordPress Database Tables and Columns

Table: wp_actionscheduler_actions

• action_id
• hook
• status
• scheduled_date_gmt
• scheduled_date_local
• args
• schedule
• group_id
• attempts
• last_attempt_gmt
• last_attempt_local
• claim_id
• extended_args
• priority

Table: wp_actionscheduler_claims

• claim_id
• date_created_gmt

Table: wp_actionscheduler_groups

• group_id
• slug

Table: wp_actionscheduler_logs

• log_id
• action_id
• message
• log_date_gmt
• log_date_local

Table: wp_affcoups_stats

• id
• type
• coupon_id
• post_id
• created_at

Table: wp_aioseo_cache

• id
• key
• value
• expiration
• created
• updated

Table: wp_aioseo_notifications

• id
• slug
• addon
• title
• content
• type
• level
• notification_id
• notification_name
• start
• end
• button1_label
• button1_action
• button2_label
• button2_action
• dismissed
• new
• created
• updated

Table: wp_aioseo_posts

• id
• post_id
• title
• description
• keywords
• keyphrases
• page_analysis
• primary_term
• canonical_url
• og_title
• og_description
• og_object_type
• og_image_type
• og_image_url
• og_image_width
• og_image_height
• og_image_custom_url
• og_image_custom_fields
• og_video
• og_custom_url
• og_article_section
• og_article_tags
• twitter_use_og
• twitter_card
• twitter_image_type
• twitter_image_url
• twitter_image_custom_url
• twitter_image_custom_fields
• twitter_title
• twitter_description
• seo_score
• schema
• schema_type
• schema_type_options
• pillar_content
• robots_default
• robots_noindex
• robots_noarchive
• robots_nosnippet
• robots_nofollow
• robots_noimageindex
• robots_noodp
• robots_notranslate
• robots_max_snippet
• robots_max_videopreview
• robots_max_imagepreview
• images
• image_scan_date
• priority
• frequency
• videos
• video_thumbnail
• video_scan_date
• local_seo
• limit_modified_date
• options
• created
• updated

Table: wp_blc_filters

• id
• name
• params

Table: wp_blc_instances

• instance_id
• link_id
• container_id
• container_type
• link_text
• parser_type
• container_field
• link_context
• raw_url

Table: wp_blc_links

• link_id
• url
• first_failure
• last_check
• last_success
• last_check_attempt
• check_count
• final_url
• redirect_count
• log
• http_code
• status_code
• status_text
• request_duration
• timeout
• broken
• warning
• may_recheck
• being_checked
• result_hash
• false_positive
• dismissed

Table: wp_blc_synch

• container_id
• container_type
• synched
• last_synch

Table: wp_commentmeta

• meta_id
• comment_id
• meta_key
• meta_value

Table: wp_comments

• comment_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

Table: wp_daexthrmal_connection

• connection_id
• url_to_connect
• url1
• language1
• script1
• locale1
• url2
• language2
• script2
• locale2
• url3
• language3
• script3
• locale3
• url4
• language4
• script4
• locale4
• url5
• language5
• script5
• locale5
• url6
• language6
• script6
• locale6
• url7
• language7
• script7
• locale7
• url8
• language8
• script8
• locale8
• url9
• language9
• script9
• locale9
• url10
• language10
• script10
• locale10

Table: wp_daily_competition

• id
• email
• points
• last_played

Table: wp_ditty_itemmeta

• meta_id
• item_id
• meta_key
• meta_value

Table: wp_ditty_items

• item_id
• parent_id
• item_type
• item_value
• ditty_id
• layout_value
• attribute_value
• item_index
• item_author
• date_created
• date_modified

Table: wp_e_events

• id
• event_data
• created_at

Table: wp_erp_votes

• id
• post_id
• ip_address
• vote

Table: wp_fvm_cache

• id
• uid
• date
• type
• content
• meta

Table: wp_fvm_logs

• id
• uid
• date
• type
• msg
• meta

Table: wp_glsr_assigned_posts

• rating_id
• post_id
• is_published

Table: wp_glsr_assigned_terms

• rating_id
• term_id

Table: wp_glsr_assigned_users

• rating_id
• user_id

Table: wp_glsr_ratings

• ID
• review_id
• rating
• type
• is_approved
• is_pinned
• name
• email
• avatar
• ip_address
• url
• terms

Table: wp_hfcm_scripts

• script_id
• name
• snippet
• snippet_type
• device_type
• location
• display_on
• lp_count
• s_pages
• ex_pages
• s_posts
• ex_posts
• s_custom_posts
• s_categories
• s_tags
• status
• created_by
• last_modified_by
• created
• last_revision_date

Table: wp_irrp_redirection_logs

• id
• redirect_id
• request_url
• response_url
• request_date
• request_timestamp
• request_code
• response_code
• log_code
• extras

Table: wp_irrp_redirectionmeta

• meta_id
• redirect_id
• meta_key
• meta_value

Table: wp_irrp_redirections

• id
• from
• match
• to
• status
• timestamp
• type

Table: wp_links

• link_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

Table: wp_litespeed_url

• id
• url
• cache_tags

Table: wp_litespeed_url_file

• id
• url_id
• vary
• filename
• type
• expired

Table: wp_maxbuttons_collections

• meta_id
• collection_id
• collection_key
• collection_value

Table: wp_maxbuttons_collections_trans

• id
• name
• value
• expire

Table: wp_maxbuttonsv3

• id
• name
• status
• cache
• responsive
• basic
• color
• dimension
• border
• gradient
• text
• container
• advanced
• meta
• updated
• created

Table: wp_nm_personalized

• productmeta_id
• productmeta_name
• productmeta_validation
• dynamic_price_display
• send_file_attachment
• show_cart_thumb
• aviary_api_key
• productmeta_style
• productmeta_js
• productmeta_categories
• the_meta
• productmeta_created

Table: wp_options

• option_id
• option_name
• option_value
• autoload

Table: wp_pmxe_exports

• id
• parent_id
• attch_id
• options
• scheduled
• registered_on
• friendly_name
• exported
• canceled
• canceled_on
• settings_update_on
• last_activity
• processing
• executing
• triggered
• iteration
• export_post_type
• created_at

Table: wp_pmxe_google_cats

• id
• name
• parent_id
• parent_name
• level

Table: wp_pmxe_posts

• id
• post_id
• export_id
• iteration

Table: wp_pmxe_templates

• id
• name
• options

Table: wp_pmxi_files

• id
• import_id
• name
• path
• registered_on

Table: wp_pmxi_hash

• hash
• post_id
• import_id
• post_type

Table: wp_pmxi_history

• id
• import_id
• type
• time_run
• date
• summary

Table: wp_pmxi_images

• id
• attachment_id
• image_url
• image_filename

Table: wp_pmxi_imports

• id
• parent_import_id
• name
• friendly_name
• type
• feed_type
• path
• xpath
• options
• registered_on
• root_element
• processing
• executing
• triggered
• queue_chunk_number
• first_import
• count
• imported
• created
• updated
• skipped
• deleted
• canceled
• canceled_on
• failed
• failed_on
• settings_update_on
• last_activity
• iteration
• changed_missing

Table: wp_pmxi_posts

• id
• post_id
• import_id
• unique_key
• product_key
• iteration
• specified

Table: wp_pmxi_templates

• id
• options
• scheduled
• name
• title
• content
• is_keep_linebreaks
• is_leave_html
• fix_characters
• meta

Table: wp_popularpostsdata

• postid
• day
• last_viewed
• pageviews

Table: wp_popularpostssummary

• ID
• postid
• pageviews
• view_date
• view_datetime

Table: wp_popularpoststransients

• ID
• tkey
• tkey_date

Table: wp_postmeta

• meta_id
• post_id
• meta_key
• meta_value

Table: wp_posts

• ID
• 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

Table: wp_prli_clicks

• id
• ip
• browser
• btype
• bversion
• os
• referer
• host
• uri
• robot
• first_click
• created_at
• link_id
• vuid

Table: wp_prli_link_metas

• id
• meta_key
• meta_value
• meta_order
• link_id
• created_at

Table: wp_prli_links

• id
• name
• description
• url
• slug
• nofollow
• sponsored
• track_me
• param_forwarding
• param_struct
• redirect_type
• link_status
• created_at
• updated_at
• group_id
• link_cpt_id
• prettypay_link

Table: wp_rank_math_404_logs

• id
• uri
• accessed
• times_accessed
• referer
• user_agent

Table: wp_rank_math_analytics_gsc

• id
• created
• query
• page
• clicks
• impressions
• position
• ctr

Table: wp_rank_math_analytics_inspections

• id
• page
• created
• index_verdict
• indexing_state
• coverage_state
• page_fetch_state
• robots_txt_state
• mobile_usability_verdict
• mobile_usability_issues
• rich_results_verdict
• rich_results_items
• last_crawl_time
• crawled_as
• google_canonical
• user_canonical
• sitemap
• referring_urls
• raw_api_response

Table: wp_rank_math_analytics_objects

• id
• created
• title
• page
• object_type
• object_subtype
• object_id
• primary_key
• seo_score
• page_score
• is_indexable
• schemas_in_use
• desktop_interactive
• desktop_pagescore
• mobile_interactive
• mobile_pagescore
• pagespeed_refreshed

Table: wp_rank_math_internal_links

• id
• url
• post_id
• target_post_id
• type

Table: wp_rank_math_internal_meta

• object_id
• internal_link_count
• external_link_count
• incoming_link_count

Table: wp_rank_math_redirections

• id
• sources
• url_to
• header_code
• hits
• status
• created
• updated
• last_accessed

Table: wp_rank_math_redirections_cache

• id
• from_url
• redirection_id
• object_id
• object_type
• is_redirected

Table: wp_reviewx_criterias

• review_id
• criteria_id
• rating
• is_automated

Table: wp_reviewx_import_history

• batch_id
• file_name
• import_date
• status

Table: wp_reviewx_process_jobs

• id
• process_name
• process_meta

Table: wp_reviewx_reminder_email

• id
• order_id
• customer_email
• order_items
• order_status
• order_date
• status
• max_delivery
• total_delivery
• processed_email
• scheduled_at
• is_subscribe

Table: wp_say_what_strings

• string_id
• orig_string
• domain
• replacement_string
• context

Table: wp_sbi_feed_caches

• id
• feed_id
• cache_key
• cache_value
• cron_update
• last_updated

Table: wp_sbi_feeds

• id
• feed_name
• feed_title
• settings
• author
• status
• last_modified

Table: wp_sbi_instagram_feed_locator

• id
• feed_id
• post_id
• html_location
• shortcode_atts
• last_update

Table: wp_sbi_instagram_feeds_posts

• record_id
• id
• instagram_id
• feed_id
• hashtag

Table: wp_sbi_instagram_posts

• id
• created_on
• instagram_id
• time_stamp
• top_time_stamp
• json_data
• media_id
• sizes
• aspect_ratio
• images_done
• last_requested

Table: wp_sbi_sources

• id
• account_id
• account_type
• privilege
• access_token
• username
• info
• error
• expires
• last_updated
• author

Table: wp_sgrb_category

• id
• review_id
• name

Table: wp_sgrb_comment

• id
• review_id
• category_id
• post_id
• approved
• title
• cdate
• name
• email
• comment

Table: wp_sgrb_comment_rating

• id
• comment_id
• category_id
• rate

Table: wp_sgrb_page_review

• id
• category_id
• product_id
• review_id

Table: wp_sgrb_rate_log

• id
• review_id
• comment_id
• post_id
• ip

Table: wp_sgrb_review

• id
• type
• title
• template_id
• options

Table: wp_sgrb_template

• id
• name
• options

Table: wp_smush_dir_images

• id
• path
• path_hash
• resize
• lossy
• error
• image_size
• orig_size
• file_time
• last_scan
• meta

Table: wp_snippets

• id
• name
• description
• code
• tags
• scope
• priority
• active
• modified

Table: wp_term_relationships

• object_id
• term_taxonomy_id
• term_order

Table: wp_term_taxonomy

• term_taxonomy_id
• term_id
• taxonomy
• description
• parent
• count

Table: wp_termmeta

• meta_id
• term_id
• meta_key
• meta_value

Table: wp_terms

• term_id
• name
• slug
• term_group

Table: wp_tm_taskmeta

• meta_id
• task_id
• meta_key
• meta_value

Table: wp_tm_tasks

• id
• user_id
• type
• class_identifier
• attempts
• description
• time_created
• last_locked_at
• status

Table: wp_user_registration_sessions

• session_id
• session_key
• session_value
• session_expiry

Table: wp_usermeta

• umeta_id
• user_id
• meta_key
• meta_value

Table: wp_users

• ID
• user_login
• user_pass
• user_nicename
• user_email
• user_url
• user_registered
• user_activation_key
• user_status
• display_name

Table: wp_wc_admin_note_actions

• action_id
• note_id
• name
• label
• query
• status
• actioned_text
• nonce_action
• nonce_name

Table: wp_wc_admin_notes

• note_id
• name
• type
• locale
• title
• content
• content_data
• status
• source
• date_created
• date_reminder
• is_snoozable
• layout
• image
• is_deleted
• is_read
• icon

Table: wp_wc_category_lookup

• category_tree_id
• category_id

Table: wp_wc_comments_subscription

• id
• email
• subscribtion_id
• post_id
• subscribtion_type
• activation_key
• confirm
• subscription_date
• imported_from

Table: wp_wc_customer_lookup

• customer_id
• user_id
• username
• first_name
• last_name
• email
• date_last_active
• date_registered
• country
• postcode
• city
• state

Table: wp_wc_download_log

• download_log_id
• timestamp
• permission_id
• user_id
• user_ip_address

Table: wp_wc_feedback_forms

• id
• post_id
• unique_id
• question
• opened
• content

Table: wp_wc_follow_users

• id
• post_id
• user_id
• user_email
• user_name
• follower_id
• follower_email
• follower_name
• activation_key
• confirm
• follow_timestamp
• follow_date

Table: wp_wc_order_coupon_lookup

• order_id
• coupon_id
• date_created
• discount_amount

Table: wp_wc_order_product_lookup

• order_item_id
• order_id
• product_id
• variation_id
• customer_id
• date_created
• product_qty
• product_net_revenue
• product_gross_revenue
• coupon_amount
• tax_amount
• shipping_amount
• shipping_tax_amount

Table: wp_wc_order_stats

• order_id
• parent_id
• date_created
• date_created_gmt
• date_paid
• date_completed
• num_items_sold
• total_sales
• tax_total
• shipping_total
• net_total
• returning_customer
• status
• customer_id

Table: wp_wc_order_tax_lookup

• order_id
• tax_rate_id
• date_created
• shipping_tax
• order_tax
• total_tax

Table: wp_wc_phrases

• id
• phrase_key
• phrase_value

Table: wp_wc_product_attributes_lookup

• product_id
• product_or_parent_id
• taxonomy
• term_id
• is_variation_attribute
• in_stock

Table: wp_wc_product_download_directories

• url_id
• url
• enabled

Table: wp_wc_product_meta_lookup

• product_id
• sku
• virtual
• downloadable
• min_price
• max_price
• onsale
• stock_quantity
• stock_status
• rating_count
• average_rating
• total_sales
• tax_status
• tax_class

Table: wp_wc_rate_limits

• rate_limit_id
• rate_limit_key
• rate_limit_expiry
• rate_limit_remaining

Table: wp_wc_reserved_stock

• order_id
• product_id
• stock_quantity
• timestamp
• expires

Table: wp_wc_tax_rate_classes

• tax_rate_class_id
• name
• slug

Table: wp_wc_users_rated

• id
• post_id
• user_id
• user_ip
• rating
• date

Table: wp_wc_users_voted

• id
• user_id
• comment_id
• vote_type
• is_guest
• post_id
• date

Table: wp_wc_webhooks

• webhook_id
• status
• name
• user_id
• delivery_url
• secret
• topic
• date_created
• date_created_gmt
• date_modified
• date_modified_gmt
• api_version
• failure_count
• pending_delivery

Table: wp_wgm_icons

• id
• type
• title
• desc
• file_name

Table: wp_wgm_markers

• id
• map_id
• marker_name
• marker_desc
• icon
• address
• lat_lng
• have_marker_link
• marker_link
• marker_link_new_tab
• show_desc_by_default
• created_at
• created_by
• updated_at
• updated_by

Table: wp_woocommerce_api_keys

• key_id
• user_id
• description
• permissions
• consumer_key
• consumer_secret
• nonces
• truncated_key
• last_access

Table: wp_woocommerce_attribute_taxonomies

• attribute_id
• attribute_name
• attribute_label
• attribute_type
• attribute_orderby
• attribute_public

Table: wp_woocommerce_downloadable_product_permissions

• permission_id
• download_id
• product_id
• order_id
• order_key
• user_email
• user_id
• downloads_remaining
• access_granted
• access_expires
• download_count

Table: wp_woocommerce_log

• log_id
• timestamp
• level
• source
• message
• context

Table: wp_woocommerce_order_itemmeta

• meta_id
• order_item_id
• meta_key
• meta_value

Table: wp_woocommerce_order_items

• order_item_id
• order_item_name
• order_item_type
• order_id

Table: wp_woocommerce_payment_tokenmeta

• meta_id
• payment_token_id
• meta_key
• meta_value

Table: wp_woocommerce_payment_tokens

• token_id
• gateway_id
• token
• user_id
• type
• is_default

Table: wp_woocommerce_sessions

• session_id
• session_key
• session_value
• session_expiry

Table: wp_woocommerce_shipping_zone_locations

• location_id
• zone_id
• location_code
• location_type

Table: wp_woocommerce_shipping_zone_methods

• zone_id
• instance_id
• method_id
• method_order
• is_enabled

Table: wp_woocommerce_shipping_zones

• zone_id
• zone_name
• zone_order

Table: wp_woocommerce_tax_rate_locations

• location_id
• location_code
• tax_rate_id
• location_type

Table: wp_woocommerce_tax_rates

• tax_rate_id
• tax_rate_country
• tax_rate_state
• tax_rate
• tax_rate_name
• tax_rate_priority
• tax_rate_compound
• tax_rate_shipping
• tax_rate_order
• tax_rate_class

Table: wp_wp_phpmyadmin_extension__errors_log

• id
• gmdate
• function_name
• function_args
• message

Table: wp_wpforms_logs

• id
• title
• message
• types
• create_at
• form_id
• entry_id
• user_id

Table: wp_wpforms_payment_meta

• id
• payment_id
• meta_key
• meta_value

Table: wp_wpforms_payments

• id
• form_id
• status
• subtotal_amount
• discount_amount
• total_amount
• currency
• entry_id
• gateway
• type
• mode
• transaction_id
• customer_id
• subscription_id
• subscription_status
• title
• date_created_gmt
• date_updated_gmt
• is_published

Table: wp_wpforms_tasks_meta

• id
• action
• data
• date

Table: wp_wpmailsmtp_debug_events

• id
• content
• initiator
• event_type
• created_at

Table: wp_wpmailsmtp_tasks_meta

• id
• action
• data
• date

Table: wp_wpwc_posts

• post_id
• post_author
• post_date
• post_status
• post_modified
• post_parent
• post_type
• post_word_count

Table: wp_wt_iew_action_history

• id
• template_type
• item_type
• file_name
• created_at
• status
• status_text
• offset
• total
• data

Table: wp_wt_iew_mapping_template

• id
• template_type
• item_type
• name
• data

Table: wp_yoast_indexable

• id
• permalink
• permalink_hash
• object_id
• object_type
• object_sub_type
• author_id
• post_parent
• title
• description
• breadcrumb_title
• post_status
• is_public
• is_protected
• has_public_posts
• number_of_pages
• canonical
• primary_focus_keyword
• primary_focus_keyword_score
• readability_score
• is_cornerstone
• is_robots_noindex
• is_robots_nofollow
• is_robots_noarchive
• is_robots_noimageindex
• is_robots_nosnippet
• twitter_title
• twitter_image
• twitter_description
• twitter_image_id
• twitter_image_source
• open_graph_title
• open_graph_description
• open_graph_image
• open_graph_image_id
• open_graph_image_source
• open_graph_image_meta
• link_count
• incoming_link_count
• prominent_words_version
• created_at
• updated_at
• blog_id
• language
• region
• schema_page_type
• schema_article_type
• has_ancestors
• estimated_reading_time_minutes
• version
• object_last_modified
• object_published_at
• inclusive_language_score

Table: wp_yoast_indexable_hierarchy

• indexable_id
• ancestor_id
• depth
• blog_id

Table: wp_yoast_migrations

• id
• version

Table: wp_yoast_primary_term

• id
• post_id
• term_id
• taxonomy
• created_at
• updated_at
• blog_id

Table: wp_yoast_seo_links

• id
• url
• post_id
• target_post_id
• type
• indexable_id
• target_indexable_id
• height
• width
• size
• language
• region

Table: wp_yoast_seo_meta

• object_id
• internal_link_count
• incoming_link_count