RdsDiagram
youwp_post
ID: BIGINT
post_author: BIGINT
post_date: DATE
post_date_gmt: DATE
post_content: LONGTEXT
post_title: TIME
post_exceprt: TEXT
post_status: VARCHAR(20)
comment_status: VARCHAR(20)
ping_status: VARCHAR(20)
post_password: VARCHAR(20)
post_name: VARCHAR(200)
to_ping: TEXT
pinged: TEXT
post_modified: DATE
post_modified_gmt: DATE
post_content_filtered: LONGTEXT
post_parent: BIGINT
guid: VARCHAR(255)
menu_order: INTEGER
post_type: VARCHAR(20)
post_mime_type: VARCHAR(100)
comment_count: BIGINT
youwp_users
ID: BIGINT
user_login: VARCHAR(60)
user_pass: VARCHAR(255)
user_nicename: VARCHAR(50)
user_email: VARCHAR(100)
user_url: VARCHAR(100)
user_registered: DATE
user_activation_key: VARCHAR(255)
user_status: INTEGER
display_name: VARCHAR(255)
youwp_woocommerce_order_items
order_item_id: BIGINT
order_id: BIGINT
order_item_name
order_item_type: VARCHAR(200)
you_ambassador
entry_id: INTEGER
user_id: BIGINT
coupon_code: VARCHAR(200)
youwp_postmeta
meta_id: BIGINT
post_id: BIGINT
meta_key: VARCHAR(255)
meta_value: LONGTEXT
youwp_woocommerce_order_itemmeta
meta_id: BIGINT
order_item_id: BIGINT
meta_key: VARCHAR(255)
meta_value
wp_comments
comment_ID: BIGINT
comment_post: BIGINT
comment_author: TINYTEXT
comment_author_email: VARCHAR(100)
comment_author_url: VARCHAR(200)
comment_author_IP: VARCHAR(100)
comment_date: DATE
comment_date_gmt: DATE
comment_karma: INTEGER
comment_approved: VARCHAR(20)
comment_agent: VARCHAR(255)
comment_type: VARCHAR(20)
comment_parent: BIGINT
user_id: BIGINT
wp_commentmeta
meta_id: BIGINT
comment_id: BIGINT
meta_key: VARCHAR(255)
meta_value: LONGTEXT
wp_options
option_id: BIGINT
blog_id: INTEGER
option_name: VARCHAR(64)
option_value: LONGTEXT
autoload: VARCHAR(20)
wp_links
link_id: BIGINT
link_url: VARCHAR(255)
link_name: VARCHAR(255)
link_image: VARCHAR(255)
link_target: VARCHAR(25)
link_description: VARCHAR(255)
link_visible: VARCHAR(20)
link_owner: BIGINT
link_rating: INTEGER
link_updated: DATE
link_rel: VARCHAR(255)
link_notes: TEXT
link_rss: VARCHAR(255)
wp_usermeta
umeta_id: BIGINT
user_id: BIGINT
meta_key: VARCHAR(255)
meta_value: LONGTEXT
wp_term_relationships
object_id: BIGINT
term_taxonomy_id: BIGINT
link_id: BIGINT
wp_term_taxonomy
term_taxonomy_id: BIGINT
term_id: BIGINT
taxonomy: VARCHAR(32)
description: LONGTEXT
parent: BIGINT
count: BIGINT
wp_terms
term_id: BIGINT
name: VARCHAR(255)
slug: VARCHAR(255)
term_group: BIGINT
youwp_woocommerce_api_keys
key_id: BIGINT
user_id: BIGINT
description: LONGTEXT
permissions: VARCHAR(10)
consumer_key: CHARACTER(64)
consumer_secret: CHARACTER(43)
nonces: LONGTEXT
truncated_key: CHARACTER(7)
last_access: DATE
youwp_woocommerce_attribute_taxonomies
attribute_id: BIGINT
attribute_name: VARCHAR(200)
attribute_label: LONGTEXT
attribute_type: VARCHAR(200)
attribute_orderby : VARCHAR(200)
attribute_public: INTEGER
youwp_woocommerce_downloadable_product_permissions
permission_id: BIGINT
download_id: VARCHAR(32)
product_id: BIGINT
order_id: BIGINT
order_key: VARCHAR(200)
user_email: VARCHAR(200)
user_id: BIGINT
downloads_remaining: VARCHAR(9)
access_granted: DATE
access_expires: DATE
download_count: BIGINT
youwp_woocommerce_tax_rates
tax_rate_id: BIGINT
tax_rate_country: VARCHAR(200)
tax_rate_state: VARCHAR(200)
tax_rate: VARCHAR(200)
tax_rate_name: VARCHAR(200)
tax_rate_priority: BIGINT
tax_rate_compound: INTEGER
tax_rate_shipping: INTEGER
tax_rate_order: BIGINT
tax_rate_class: VARCHAR(200)
youwp_woocommerce_tax_rate_locations
location_id: BIGINT
location_code: VARCHAR(255)
tax_rate_id: BIGINT
location_type: VARCHAR(40)
youwp_woocommerce_termmeta
meta_id: BIGINT
woocommerce_term_id : BIGINT
meta_key: VARCHAR(255)
meta_value: LONGTEXT
youwp_post
ID: BIGINT
post_author: BIGINT
post_date: DATE
post_date_gmt: DATE
post_content: LONGTEXT
post_title: TIME
post_exceprt: TEXT
post_status: VARCHAR(20)
comment_status: VARCHAR(20)
ping_status: VARCHAR(20)
post_password: VARCHAR(20)
post_name: VARCHAR(200)
to_ping: TEXT
pinged: TEXT
post_modified: DATE
post_modified_gmt: DATE
post_content_filtered: LONGTEXT
post_parent: BIGINT
guid: VARCHAR(255)
menu_order: INTEGER
post_type: VARCHAR(20)
post_mime_type: VARCHAR(100)
comment_count: BIGINT