WooCommerce
Explore the interactive ERD
Table & Field Reference
tax_rate_postcode
| Column | Type | Keys |
|---|---|---|
postcode | Unknown | PK |
tax_rate_id | Unknown | PKFK |
tax_rate_city
| Column | Type | Keys |
|---|---|---|
city | Unknown | PK |
tax_rate_id | Unknown | PKFK |
tax_rate
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
class | Unknown | FK |
city | Unknown | |
compound | Unknown | |
country | Unknown | |
name | Unknown | |
orders | Unknown | |
postcode | Unknown | |
priority | Unknown | |
rate | Unknown | |
shipping | Unknown | |
state | Unknown |
shipping_method
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
description | Unknown | |
title | Unknown |
product_review
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
product_id | Unknown | FK |
date_created | Unknown | |
date_created_gmt | Unknown | |
rating | Unknown | |
review | Unknown | |
reviewer | Unknown | |
reviewer_avatar_urls_24 | Unknown | |
reviewer_avatar_urls_48 | Unknown | |
reviewer_avatar_urls_96 | Unknown | |
reviewer_email | Unknown | |
status | Unknown | |
verified | Unknown |
payment_gateway_method_support
| Column | Type | Keys |
|---|---|---|
method_support | Unknown | PK |
payment_gateway_id | Unknown | PKFK |
payment_gateway_setting
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
payment_gateway_id | Unknown | PKFK |
custom_option | Json | |
defaults | Unknown | |
description | Unknown | |
label | Unknown | |
placeholder | Unknown | |
tip | Unknown | |
type | Unknown | |
value | Unknown |
payment_gateway
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
connection_url | Unknown | |
description | Unknown | |
enabled | Unknown | |
method_description | Unknown | |
method_title | Unknown | |
needs_setup | Unknown | |
orders | Unknown | |
post_install_scripts | Json | |
required_settings_keys | Json | |
settings_url | Unknown | |
setup_help_text | Unknown | |
title | Unknown |
product_shipping_class
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
count | Unknown | |
description | Unknown | |
name | Unknown | |
slug | Unknown |
tags
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
count | Unknown | |
description | Unknown | |
name | Unknown | |
slug | Unknown |
subscription_tax_line
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
subscription_id | Unknown | PK |
subscription_status | Unknown | PK |
code | Unknown | |
compound | Unknown | |
rate_id | Unknown | |
title | Unknown | |
total | Unknown |
subscription_shipping_line
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
subscription_id | Unknown | PK |
subscription_status | Unknown | PK |
method_id | Unknown | |
method_title | Unknown | |
total | Unknown |
subscription
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
status | Unknown | PK |
customer_id | Unknown | FK |
parent_order_id | Unknown | FK |
billing_address_address_1 | Unknown | |
billing_address_address_2 | Unknown | |
billing_address_city | Unknown | |
billing_address_company | Unknown | |
billing_address_country | Unknown | |
billing_address_email | Unknown | |
billing_address_first_name | Unknown | |
billing_address_last_name | Unknown | |
billing_address_phone | Unknown | |
billing_address_postcode | Unknown | |
billing_address_state | Unknown | |
billing_schedule_end_at | Unknown | |
billing_schedule_interval | Unknown | |
billing_schedule_next_payment_at | Unknown | |
billing_schedule_period | Unknown | |
billing_schedule_start_at | Unknown | |
billing_schedule_trial_end_at | Unknown | |
cart_tax | Unknown | |
coupon_lines | Json | |
created_at | Unknown | |
currency | Unknown | |
customer_ip | Unknown | |
customer_last_order_date | Unknown | |
customer_last_order_id | Unknown | |
customer_orders_count | Unknown | |
customer_total_spent | Unknown | |
customer_user_agent | Unknown | |
fee_lines | Json | |
note | Unknown | |
order_number | Unknown | |
payment_detail_method_id | Unknown | |
payment_detail_method_title | Unknown | |
payment_detail_paid | Unknown | |
shipping_address_address_1 | Unknown | |
shipping_address_address_2 | Unknown | |
shipping_address_city | Unknown | |
shipping_address_company | Unknown | |
shipping_address_country | Unknown | |
shipping_address_first_name | Unknown | |
shipping_address_last_name | Unknown | |
shipping_address_postcode | Unknown | |
shipping_address_state | Unknown | |
shipping_methods | Unknown | |
shipping_tax | Unknown | |
subscription_status | Unknown | |
subtotal | Unknown | |
total | Unknown | |
total_discount | Unknown | |
total_line_items_quantity | Unknown | |
total_shipping | Unknown | |
total_tax | Unknown | |
updated_at | Unknown |
subscription_line_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
subscription_id | Unknown | PK |
subscription_status | Unknown | PK |
product_id | Unknown | FK |
meta | Json | |
name | Unknown | |
price | Unknown | |
quantity | Unknown | |
sku | Unknown | |
subtotal | Unknown | |
subtotal_tax | Unknown | |
tax_class | Unknown | |
total | Unknown | |
total_tax | Unknown |
attribute_term
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
attribute_id | Unknown | FK |
count | Unknown | |
description | Unknown | |
menu_order | Unknown | |
name | Unknown | |
slug | Unknown |
order_metadata
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
order_id | Unknown | PKFK |
id | Unknown | |
key | Unknown | |
value | Json |
order_line_item_tax
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
order_id | Unknown | PKFK |
order_line_item_id | Unknown | PKFK |
compound | Unknown | |
label | Unknown | |
rate_code | Unknown | |
rate_id | Unknown | |
shipping_tax_total | Unknown | |
subtotal | Unknown | |
tax_total | Unknown | |
total | Unknown |
order_line_item_metadata
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
order_id | Unknown | PKFK |
order_line_item_id | Unknown | PKFK |
id | Unknown | |
key | Unknown | |
value | Json |
order_line_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
order_id | Unknown | PKFK |
product_id | Unknown | FK |
variation_id | Unknown | FK |
name | Unknown | |
price | Unknown | |
quantity | Unknown | |
sku | Unknown | |
subtotal | Unknown | |
subtotal_tax | Unknown | |
tax_class | Unknown | |
total | Unknown | |
total_tax | Unknown |
order_refund
| Column | Type | Keys |
|---|---|---|
order_id | Unknown | PKFK |
refund_id | Unknown | PKFK |
order_tax_line
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
order_id | Unknown | FK |
compound | Unknown | |
label | Unknown | |
meta_data | Json | |
rate_code | Unknown | |
rate_id | Unknown | |
shipping_tax_total | Unknown | |
tax_total | Unknown |
order_shipping_line
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
order_id | Unknown | FK |
meta_data | Json | |
method_id | Unknown | |
method_title | Unknown | |
taxes | Json | |
total | Unknown | |
total_tax | Unknown |
order_fee_line
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
order_id | Unknown | FK |
name | Unknown | |
tax_class | Unknown | |
tax_status | Unknown | |
taxes | Json | |
total | Unknown | |
total_tax | Unknown |
order_coupon_line
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
order_id | Unknown | FK |
code | Unknown | |
discount | Unknown | |
discount_tax | Unknown |
orders
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | FK |
billing_address_1 | Unknown | |
billing_address_2 | Unknown | |
billing_city | Unknown | |
billing_company | Unknown | |
billing_country | Unknown | |
billing_email | Unknown | |
billing_first_name | Unknown | |
billing_last_name | Unknown | |
billing_phone | Unknown | |
billing_postcode | Unknown | |
billing_state | Unknown | |
cart_hash | Unknown | |
cart_tax | Unknown | |
created_via | Unknown | |
currency | Unknown | |
customer_ip_address | Unknown | |
customer_note | Unknown | |
customer_user_agent | Unknown | |
date_completed | Unknown | |
date_completed_gmt | Unknown | |
date_created | Unknown | |
date_created_gmt | Unknown | |
date_modified | Unknown | |
date_modified_gmt | Unknown | |
date_paid | Unknown | |
date_paid_gmt | Unknown | |
discount_tax | Unknown | |
discount_total | Unknown | |
number | Unknown | |
order_key | Unknown | |
parent_id | Unknown | |
payment_method | Unknown | |
payment_method_title | Unknown | |
prices_include_tax | Unknown | |
shipping_address_1 | Unknown | |
shipping_address_2 | Unknown | |
shipping_city | Unknown | |
shipping_company | Unknown | |
shipping_country | Unknown | |
shipping_first_name | Unknown | |
shipping_last_name | Unknown | |
shipping_postcode | Unknown | |
shipping_state | Unknown | |
shipping_tax | Unknown | |
shipping_total | Unknown | |
status | Unknown | |
total | Unknown | |
total_tax | Unknown | |
transaction_id | Unknown | |
version | Unknown |
refund_metadata
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
refund_id | Unknown | PKFK |
id | Unknown | |
key | Unknown | |
value | Json |
refund_line_item_tax
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
refund_id | Unknown | PKFK |
refund_line_item_id | Unknown | PKFK |
refund_total | Unknown | |
subtotal | Unknown | |
total | Unknown |
refund_line_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
refund_id | Unknown | PKFK |
product_id | Unknown | FK |
variation_id | Unknown | FK |
name | Unknown | |
price | Unknown | |
quantity | Unknown | |
sku | Unknown | |
subtotal | Unknown | |
subtotal_tax | Unknown | |
tax_class | Unknown | |
total | Unknown | |
total_tax | Unknown |
refund
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
order_id | Unknown | FK |
amount | Unknown | |
api_refund | Unknown | |
date_created | Unknown | |
date_created_gmt | Unknown | |
reason | Unknown | |
refunded_by | Unknown | |
refunded_payment | Unknown |
continent_country_state
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
continent_country_code | Unknown | FK |
name | Unknown |
continent_country
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
continent_code | Unknown | FK |
currency_code | Unknown | |
currency_pos | Unknown | |
decimal_sep | Unknown | |
dimension_unit | Unknown | |
name | Unknown | |
num_decimals | Unknown | |
thousand_sep | Unknown | |
weight_unit | Unknown |
continent
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
name | Unknown |
order_note
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
order_id | Unknown | FK |
added_by_user | Unknown | |
author | Unknown | |
customer_note | Unknown | |
date_created | Unknown | |
date_created_gmt | Unknown | |
note | Unknown |
shipping_zone_method_setting
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
instance_id | Unknown | PKFK |
defaults | Unknown | |
description | Unknown | |
label | Unknown | |
placeholder | Unknown | |
tip | Unknown | |
type | Unknown | |
value | Unknown | |
custom_option_** |
shipping_zone_method
| Column | Type | Keys |
|---|---|---|
instance_id | Unknown | PK |
method_id | Unknown | FK |
shipping_zone_id | Unknown | FK |
enabled | Unknown | |
method_description | Unknown | |
method_title | Unknown | |
orders | Unknown | |
title | Unknown |
shipping_zone_location
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
shipping_zone_id | Unknown | PKFK |
type | Unknown |
currency
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
name | Unknown | |
symbol | Unknown |
attribute
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
has_archives | Unknown | |
name | Unknown | |
order_by | Unknown | |
slug | Unknown | |
type | Unknown |
product_download
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
product_id | Unknown | FK |
file | Unknown | |
name | Unknown |
product_attribute_option
| Column | Type | Keys |
|---|---|---|
option | Unknown | PK |
product_attribute_id | Unknown | PKFK |
product_attribute_index | Unknown | PKFK |
product_id | Unknown | PKFK |
product_attribute
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
index | Unknown | PK |
product_id | Unknown | PKFK |
name | Unknown | |
position | Unknown | |
variation | Unknown | |
visible | Unknown |
product_image
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
product_id | Unknown | FK |
alt | Unknown | |
date_created | Unknown | |
date_created_gmt | Unknown | |
date_modified | Unknown | |
date_modified_gmt | Unknown | |
name | Unknown | |
src | Unknown |
product_category
| Column | Type | Keys |
|---|---|---|
category_id | Unknown | PKFK |
product_id | Unknown | PKFK |
product_metadata
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
product_id | Unknown | PKFK |
id | Unknown | |
key | Unknown | |
value | Json |
product_related_product_id
| Column | Type | Keys |
|---|---|---|
related_product_id | Unknown | PK |
product_id | Unknown | PKFK |
product_tag
| Column | Type | Keys |
|---|---|---|
product_id | Unknown | PKFK |
tag_id | Unknown | PKFK |
product_default_attribute
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
product_id | Unknown | FK |
name | Unknown | |
option | Unknown |
product
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
shipping_class_id | Unknown | FK |
average_rating | Unknown | |
backordered | Unknown | |
backorders | Unknown | |
backorders_allowed | Unknown | |
button_text | Unknown | |
catalog_visibility | Unknown | |
cross_sell_ids | Json | |
date_created | Unknown | |
date_created_gmt | Unknown | |
date_modified | Unknown | |
date_modified_gmt | Unknown | |
date_on_sale_from | Unknown | |
date_on_sale_from_gmt | Unknown | |
date_on_sale_to | Unknown | |
date_on_sale_to_gmt | Unknown | |
description | Unknown | |
dimensions_height | Unknown | |
dimensions_length | Unknown | |
dimensions_width | Unknown | |
download_expiry | Unknown | |
download_limit | Unknown | |
downloadable | Unknown | |
external_url | Unknown | |
featured | Unknown | |
grouped_products | Json | |
manage_stock | Unknown | |
menu_order | Unknown | |
name | Unknown | |
on_sale | Unknown | |
parent_id | Unknown | |
permalink | Unknown | |
price | Unknown | |
price_html | Unknown | |
purchasable | Unknown | |
purchase_note | Unknown | |
rating_count | Unknown | |
regular_price | Unknown | |
reviews_allowed | Unknown | |
sale_price | Unknown | |
shipping_class | Unknown | |
shipping_required | Unknown | |
shipping_taxable | Unknown | |
short_description | Unknown | |
sku | Unknown | |
slug | Unknown | |
sold_individually | Unknown | |
status | Unknown | |
stock_quantity | Unknown | |
stock_status | Unknown | |
tax_class | Unknown | |
tax_status | Unknown | |
total_sales | Unknown | |
type | Unknown | |
upsell_ids | Json | |
variations | Json | |
virtual | Unknown | |
weight | Unknown |
product_variation_attribute
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
product_variation_id | Unknown | PKFK |
name | Unknown | |
option | Unknown |
product_variation_metadata
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
product_variation_id | Unknown | PKFK |
id | Unknown | |
key | Unknown | |
value | Json |
product_variation_download
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
product_variation_id | Unknown | FK |
file | Unknown | |
name | Unknown |
product_variation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
product_id | Unknown | FK |
shipping_class_id | Unknown | FK |
backordered | Unknown | |
backorders | Unknown | |
backorders_allowed | Unknown | |
date_created | Unknown | |
date_created_gmt | Unknown | |
date_modified | Unknown | |
date_modified_gmt | Unknown | |
date_on_sale_from | Unknown | |
date_on_sale_from_gmt | Unknown | |
date_on_sale_to | Unknown | |
date_on_sale_to_gmt | Unknown | |
description | Unknown | |
dimension_height | Unknown | |
dimension_length | Unknown | |
dimension_width | Unknown | |
download_expiry | Unknown | |
download_limit | Unknown | |
downloadable | Unknown | |
image_alt | Unknown | |
image_date_created | Unknown | |
image_date_created_gmt | Unknown | |
image_date_modified | Unknown | |
image_date_modified_gmt | Unknown | |
image_id | Unknown | |
image_name | Unknown | |
image_src | Unknown | |
manage_stock | Unknown | |
menu_order | Unknown | |
on_sale | Unknown | |
permalink | Unknown | |
price | Unknown | |
purchasable | Unknown | |
regular_price | Unknown | |
sale_price | Unknown | |
shipping_class | Unknown | |
sku | Unknown | |
status | Unknown | |
stock_quantity | Unknown | |
stock_status | Unknown | |
tax_class | Unknown | |
tax_status | Unknown | |
virtual | Unknown | |
weight | Unknown |
coupon_metadata
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
coupon_id | Unknown | PKFK |
id | Unknown | |
key | Unknown | |
value | Json |
coupon
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
amount | Unknown | |
code | Unknown | |
date_created | Unknown | |
date_created_gmt | Unknown | |
date_expires | Unknown | |
date_expires_gmt | Unknown | |
date_modified | Unknown | |
date_modified_gmt | Unknown | |
description | Unknown | |
discount_type | Unknown | |
email_restrictions | Json | |
exclude_sale_items | Unknown | |
excluded_product_categories | Json | |
excluded_product_ids | Json | |
free_shipping | Unknown | |
individual_use | Unknown | |
limit_usage_to_x_items | Unknown | |
maximum_amount | Unknown | |
minimum_amount | Unknown | |
product_categories | Json | |
product_ids | Json | |
usage_count | Unknown | |
usage_limit | Unknown | |
usage_limit_per_user | Unknown | |
used_by | Json |
tax_class
| Column | Type | Keys |
|---|---|---|
slug | Unknown | PK |
name | Unknown |
system_status_tool
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
action | Unknown | |
confirm | Unknown | |
description | Unknown | |
message | Unknown | |
name | Unknown | |
success | Unknown |
report
| Column | Type | Keys |
|---|---|---|
slug | Unknown | PK |
description | Unknown |
shipping_zone
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown | |
orders | Unknown |
category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
count | Unknown | |
description | Unknown | |
display | Unknown | |
image_alt | Unknown | |
image_date_created | Unknown | |
image_date_created_gmt | Unknown | |
image_date_modified | Unknown | |
image_date_modified_gmt | Unknown | |
image_id | Unknown | |
image_name | Unknown | |
image_src | Unknown | |
menu_order | Unknown | |
name | Unknown | |
parent | Unknown | |
slug | Unknown |
customer_metadata
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
customer_id | Unknown | PKFK |
id | Unknown | |
key | Unknown | |
value | Json |
customer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
avatar_url | Unknown | |
billing_address_1 | Unknown | |
billing_address_2 | Unknown | |
billing_city | Unknown | |
billing_company | Unknown | |
billing_country | Unknown | |
billing_email | Unknown | |
billing_first_name | Unknown | |
billing_last_name | Unknown | |
billing_phone | Unknown | |
billing_postcode | Unknown | |
billing_state | Unknown | |
date_created | Unknown | |
date_created_gmt | Unknown | |
date_modified | Unknown | |
date_modified_gmt | Unknown | |
email | Unknown | |
first_name | Unknown | |
is_paying_customer | Unknown | |
last_name | Unknown | |
role | Unknown | |
shipping_address_1 | Unknown | |
shipping_address_2 | Unknown | |
shipping_city | Unknown | |
shipping_company | Unknown | |
shipping_country | Unknown | |
shipping_first_name | Unknown | |
shipping_last_name | Unknown | |
shipping_postcode | Unknown | |
shipping_state | Unknown | |
username | Unknown |