WooCommerce schema

20 tables

About the connector Start free

20 tables

Joins between these tables aren't mapped yet.

Loading diagram…

wp_commentmeta

4

meta_id

double

comment_id

double

meta_key

string

meta_value

string

wp_comments

15

comment_ID

double

comment_post_ID

double

comment_author

string

comment_author_email

string

comment_author_url

string

comment_author_IP

string

comment_date

date

comment_date_gmt

date

wp_links

13

link_id

double

link_url

string

link_name

string

link_image

string

link_target

string

link_description

string

link_visible

string

link_owner

double

wp_options

4

option_id

double

option_name

string

option_value

string

autoload

string

wp_postmeta

4

meta_id

double

post_id

double

meta_key

string

meta_value

string

wp_posts

23

ID

double

post_author

double

post_date

date

post_date_gmt

date

post_content

string

post_title

string

post_excerpt

string

post_status

string

wp_term_relationships

3

object_id

double

term_taxonomy_id

double

term_order

long

wp_term_taxonomy

6

term_taxonomy_id

double

term_id

double

taxonomy

string

description

string

parent

double

count

double

wp_termmeta

4

meta_id

double

term_id

double

meta_key

string

meta_value

string

wp_terms

4

term_id

double

name

string

slug

string

term_group

double

wp_usermeta

4

umeta_id

double

user_id

double

meta_key

string

meta_value

string

wp_users

11

ID

double

user_login

string

user_pass

string

user_nicename

string

user_email

string

user_url

string

user_registered

date

user_activation_key

string

user_status

long

display_name

string

_weld_synced

date

wp_wc_customer_lookup

13

customer_id

double

user_id

double

username

string

first_name

string

last_name

string

email

string

date_last_active

date

date_registered

date

wp_wc_order_addresses

15

id

double

order_id

double

address_type

string

first_name

string

last_name

string

company

string

address_1

string

address_2

string

city

string

wp_wc_order_operational_data

19

id

double

order_id

double

created_via

string

woocommerce_version

string

prices_include_tax

int

coupon_usages_are_counted

int

download_permission_granted

int

cart_hash

string

new_order_email_sent

int

wp_wc_order_product_lookup

14

order_item_id

double

order_id

double

product_id

double

variation_id

double

customer_id

double

date_created

date

product_qty

long

product_net_revenue

double

wp_wc_order_stats

15

order_id

double

parent_id

double

date_created

date

date_created_gmt

date

num_items_sold

long

total_sales

double

tax_total

double

shipping_total

double

wp_wc_orders

18

id

double

status

string

currency

string

type

string

tax_amount

double

total_amount

double

customer_id

double

billing_email

string

date_created_gmt

date

wp_woocommerce_order_itemmeta

5

meta_id

double

order_item_id

double

meta_key

string

meta_value

string

_weld_synced

date

wp_woocommerce_order_items

5

order_item_id

double

order_item_name

string

order_item_type

string

order_id

double

_weld_synced

date