# WooCommerce schema ERD

Table and field reference for the Fivetran WooCommerce connector.

## Table & Field Reference

### tax_rate_postcode

| Column | Type | Keys |
| --- | --- | --- |
| postcode | Unknown | PK |
| tax_rate_id | Unknown | PK, FK |

### tax_rate_city

| Column | Type | Keys |
| --- | --- | --- |
| city | Unknown | PK |
| tax_rate_id | Unknown | PK, FK |

### 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 | PK, FK |

### payment_gateway_setting

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| payment_gateway_id | Unknown | PK, FK |
| 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 | PK, FK |
| id | Unknown |  |
| key | Unknown |  |
| value | Json |  |

### order_line_item_tax

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | PK, FK |
| order_line_item_id | Unknown | PK, FK |
| 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 | PK, FK |
| order_line_item_id | Unknown | PK, FK |
| id | Unknown |  |
| key | Unknown |  |
| value | Json |  |

### order_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | PK, FK |
| 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 | PK, FK |
| refund_id | Unknown | PK, FK |

### 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 | PK, FK |
| id | Unknown |  |
| key | Unknown |  |
| value | Json |  |

### refund_line_item_tax

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| refund_id | Unknown | PK, FK |
| refund_line_item_id | Unknown | PK, FK |
| refund_total | Unknown |  |
| subtotal | Unknown |  |
| total | Unknown |  |

### refund_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| refund_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| product_attribute_index | Unknown | PK, FK |
| product_id | Unknown | PK, FK |

### product_attribute

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| 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 | PK, FK |
| product_id | Unknown | PK, FK |

### product_metadata

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| id | Unknown |  |
| key | Unknown |  |
| value | Json |  |

### product_related_product_id

| Column | Type | Keys |
| --- | --- | --- |
| related_product_id | Unknown | PK |
| product_id | Unknown | PK, FK |

### product_tag

| Column | Type | Keys |
| --- | --- | --- |
| product_id | Unknown | PK, FK |
| tag_id | Unknown | PK, FK |

### 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 | PK, FK |
| name | Unknown |  |
| option | Unknown |  |

### product_variation_metadata

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_variation_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- tax_rate_postcode(tax_rate_id) → tax_rate(id)
- tax_rate_city(tax_rate_id) → tax_rate(id)
- tax_rate(class) → tax_class(slug)
- product_review(product_id) → product(id)
- payment_gateway_method_support(payment_gateway_id) → payment_gateway(id)
- payment_gateway_setting(payment_gateway_id) → payment_gateway(id)
- subscription(parent_order_id) → orders(id)
- subscription(customer_id) → customer(id)
- subscription_line_item(product_id) → product(id)
- attribute_term(attribute_id) → attribute(id)
- order_metadata(order_id) → orders(id)
- order_line_item_tax(order_line_item_id) → order_line_item(id)
- order_line_item_tax(order_id) → order_line_item(order_id)
- order_line_item_metadata(order_line_item_id) → order_line_item(id)
- order_line_item_metadata(order_id) → order_line_item(order_id)
- order_line_item(product_id) → product(id)
- order_line_item(variation_id) → product_variation(id)
- order_line_item(order_id) → orders(id)
- order_refund(refund_id) → refund(id)
- order_refund(order_id) → orders(id)
- order_tax_line(order_id) → orders(id)
- order_shipping_line(order_id) → orders(id)
- order_fee_line(order_id) → orders(id)
- order_coupon_line(order_id) → orders(id)
- orders(customer_id) → customer(id)
- refund_metadata(refund_id) → refund(id)
- refund_line_item_tax(refund_line_item_id) → refund_line_item(id)
- refund_line_item_tax(refund_id) → refund_line_item(refund_id)
- refund_line_item(product_id) → product(id)
- refund_line_item(variation_id) → product_variation(id)
- refund_line_item(refund_id) → refund(id)
- refund(order_id) → orders(id)
- continent_country_state(continent_country_code) → continent_country(code)
- continent_country(continent_code) → continent(code)
- order_note(order_id) → orders(id)
- shipping_zone_method_setting(instance_id) → shipping_zone_method(instance_id)
- shipping_zone_method(method_id) → shipping_method(id)
- shipping_zone_method(shipping_zone_id) → shipping_zone(id)
- shipping_zone_location(shipping_zone_id) → shipping_zone(id)
- product_download(product_id) → product(id)
- product_attribute_option(product_attribute_id) → product_attribute(id)
- product_attribute_option(product_attribute_index) → product_attribute(index)
- product_attribute_option(product_id) → product_attribute(product_id)
- product_attribute(product_id) → product(id)
- product_image(product_id) → product(id)
- product_category(category_id) → category(id)
- product_category(product_id) → product(id)
- product_metadata(product_id) → product(id)
- product_related_product_id(product_id) → product(id)
- product_tag(tag_id) → tags(id)
- product_tag(product_id) → product(id)
- product_default_attribute(product_id) → product(id)
- product(shipping_class_id) → product_shipping_class(id)
- product_variation_attribute(product_variation_id) → product_variation(id)
- product_variation_metadata(product_variation_id) → product_variation(id)
- product_variation_download(product_variation_id) → product_variation(id)
- product_variation(shipping_class_id) → product_shipping_class(id)
- product_variation(product_id) → product(id)
- coupon_metadata(coupon_id) → coupon(id)
- customer_metadata(customer_id) → customer(id)