TikTok Shop Partner Center

Explore the interactive ERD

Table & Field Reference

shop_video_performance_product

Column	Type	Keys
`id`	Unknown	PKFK
`shop_video_performance_id`	Unknown	PKFK

shop_video_performance

Column	Type	Keys
`end_date`	Unknown	PK
`id`	Unknown	PK
`start_date`	Unknown	PK
`creator_open_id`	Unknown	FK
`duration`	Unknown
`hash_tags`	Json
`title`	Unknown
`video_post_time`	LocalDateTime

product_detail_audit_failed_reason

Column	Type	Keys
`index`	Unknown	PK
`product_id`	Unknown	PKFK
`listing_platform`	Unknown
`position`	Unknown
`reasons`	Json
`suggestions`	Json

product_detail_category_chain

Column	Type	Keys
`index`	Unknown	PK
`product_id`	Unknown	PKFK
`parent_id`	Unknown	FK
`id`	Unknown
`is_leaf`	Boolean
`local_name`	Unknown

product_detail_certification

Column	Type	Keys
`id`	Unknown	PK
`product_id`	Unknown	PKFK
`expiration_date`	Instant
`files`	Json
`title`	Unknown

product_detail_delivery_option

Column	Type	Keys
`index`	Unknown	PK
`product_id`	Unknown	PKFK
`id`	Unknown
`is_available`	Boolean
`name`	Unknown

product_detail_attribute

Column	Type	Keys
`index`	Unknown	PK
`product_id`	Unknown	PKFK
`id`	Unknown
`name`	Unknown
`values`	Json

product_detail_manufacturer

Column	Type	Keys
`index`	Unknown	PK
`product_id`	Unknown	PKFK
`manufacturer_id`	Unknown

product_detail_responsible_person

Column	Type	Keys
`index`	Unknown	PK
`product_id`	Unknown	PKFK
`responsible_person_id`	Unknown

product_detail_global_sku_mapping

Column	Type	Keys
`index`	Unknown	PK
`product_id`	Unknown	PKFK
`local_sku_id`	Unknown	FK
`global_sku_id`	Unknown
`sales_attribute_mappings`	Json

product_detail_subscribe_discount_detail

Column	Type	Keys
`index`	Unknown	PK
`product_id`	Unknown	PKFK
`discount_level`	Unknown
`discount_value`	Unknown

product_detail_subscribe_promotion_config

Column	Type	Keys
`index`	Unknown	PK
`product_id`	Unknown	PKFK
`discount_level`	Unknown
`discount_options`	Json
`max_discount`	Unknown
`min_discount`	Unknown

product_detail_sku

Column	Type	Keys
`id`	Unknown	PKFK
`product_id`	Unknown	PKFK
`combined_skus`	Json
`external_sku_id`	Unknown
`external_urls`	Json
`extra_identifier_codes`	Json
`global_listing_policy_inventory_type`	Unknown
`global_listing_policy_price_sync`	Unknown
`identifier_code`	Unknown
`identifier_code_type`	Unknown
`purchase_cumulative_order_quantity`	Unknown
`purchase_maximum_order_quantity`	Unknown
`replicate_source_product_id`	Unknown
`replicate_source_shop_id`	Unknown
`replicate_source_sku_id`	Unknown
`sku_dimensions`	Json
`sku_unit_count`	Unknown
`sku_weight`	Json

product_detail

Column	Type	Keys
`id`	Unknown	PKFK
`brand_id`	Unknown
`brand_name`	Unknown
`description`	Unknown
`external_product_id`	Unknown
`global_product_id`	Unknown
`is_cod_allowed`	Boolean
`is_pre_owned`	Boolean
`is_replicated`	Boolean
`key_product_features`	Json
`minimum_order_quantity`	Unknown
`needs_prescription`	Unknown
`package_dimensions`	Json
`package_weight`	Json
`primary_combined_product_id`	Unknown
`product_types`	Json
`search_terms`	Json
`shipping_insurance_requirement`	Unknown
`shipping_template_id`	Unknown
`size_chart_template_id`	Unknown
`subscribe_status`	Unknown
`support_subscribe`	Unknown
`video_id`	Unknown

affiliate_partner_campaign_target_shop

Column	Type	Keys
`index`	Unknown	PK
`affiliate_partner_campaign_id`	Unknown	PKFK
`code`	Unknown
`name`	Unknown

affiliate_partner_campaign_detail

Column	Type	Keys
`id`	Unknown	PK
`campaign_end_time`	Instant
`campaign_start_time`	Instant
`commission_rate`	Unknown
`description`	Unknown
`email`	Unknown
`line`	Unknown
`name`	Unknown
`phone`	Unknown
`region`	Unknown
`registration_end_time`	Instant
`registration_start_time`	Instant
`status`	Unknown
`target_seller_type_value`	Json
`viber`	Unknown
`whatsapp`	Unknown
`zalo`	Unknown

shop_video_performance_detail_interval_sales_breakdown

Column	Type	Keys
`end_date`	Unknown	PKFK
`product_id`	Unknown	PKFK
`shop_video_performance_detail_interval_index`	Unknown	PKFK
`shop_video_performance_id`	Unknown	PKFK
`start_date`	Unknown	PKFK
`customers`	Unknown
`gmv_amount`	Unknown
`gmv_currency`	Unknown
`gpm_amount`	Unknown
`gpm_currency`	Unknown

shop_video_performance_detail_interval

Column	Type	Keys
`end_date`	Unknown	PK
`index`	Unknown	PK
`shop_video_performance_id`	Unknown	PK
`start_date`	Unknown	PK
`traffic_comments`	Unknown
`traffic_likes`	Unknown
`traffic_new_followers`	Unknown
`traffic_shares`	Unknown
`traffic_views`	Unknown

shop_video_performance_detail_viewer_profile

Column	Type	Keys
`end_date`	Unknown	PK
`index`	Unknown	PK
`shop_video_performance_id`	Unknown	PK
`start_date`	Unknown	PK
`age_distribution`	Json
`country_distribution`	Json
`gender_distribution`	Json
`type`	Unknown

shop_product_performance

Column	Type	Keys
`end_date`	Unknown	PK
`start_date`	Unknown	PK
`id`	Unknown	PKFK
`affiliate_live_add_cart_count`	Unknown
`affiliate_live_add_cart_rate`	Unknown
`affiliate_live_atc_users`	Unknown
`affiliate_live_click_order_rate`	Unknown
`affiliate_live_ctr`	Unknown
`affiliate_live_new_live_count`	Unknown
`affiliate_live_product_clicks`	Unknown
`affiliate_live_product_impressions`	Unknown
`affiliate_live_unique_atc_rate`	Unknown
`affiliate_live_unique_click_order_rate`	Unknown
`affiliate_live_unique_clicks`	Unknown
`affiliate_live_unique_ctr`	Unknown
`affiliate_live_unique_product_impressions`	Unknown
`affiliate_total_add_cart_count`	Unknown
`affiliate_total_add_cart_rate`	Unknown
`affiliate_total_add_cart_users`	Unknown
`affiliate_total_attributed_orders`	Unknown
`affiliate_total_attributed_sku_orders`	Unknown
`affiliate_total_attributed_sold_items`	Unknown
`affiliate_total_avg_daily_creator_posted_content`	Unknown
`affiliate_total_click_order_rate`	Unknown
`affiliate_total_ctr`	Unknown
`affiliate_total_estimated_customers`	Unknown
`affiliate_total_product_clicks`	Unknown
`affiliate_total_product_impressions`	Unknown
`affiliate_total_unique_atc_rate`	Unknown
`affiliate_total_unique_click_order_rate`	Unknown
`affiliate_total_unique_clicks`	Unknown
`affiliate_total_unique_ctr`	Unknown
`affiliate_total_unique_product_impressions`	Unknown
`affiliate_video_add_cart_count`	Unknown
`affiliate_video_add_cart_rate`	Unknown
`affiliate_video_atc_users`	Unknown
`affiliate_video_click_order_rate`	Unknown
`affiliate_video_ctr`	Unknown
`affiliate_video_new_video_count`	Unknown
`affiliate_video_product_clicks`	Unknown
`affiliate_video_product_impressions`	Unknown
`affiliate_video_unique_atc_rate`	Unknown
`affiliate_video_unique_click_order_rate`	Unknown
`affiliate_video_unique_clicks`	Unknown
`affiliate_video_unique_ctr`	Unknown
`affiliate_video_unique_product_impressions`	Unknown
`seller_live_add_cart_count`	Unknown
`seller_live_add_cart_rate`	Unknown
`seller_live_add_cart_users`	Unknown
`seller_live_attributed_orders`	Unknown
`seller_live_attributed_sku_orders`	Unknown
`seller_live_attributed_sold_items`	Unknown
`seller_live_click_order_rate`	Unknown
`seller_live_ctr`	Unknown
`seller_live_estimated_customers`	Unknown
`seller_live_new_live_count`	Unknown
`seller_live_product_clicks`	Unknown
`seller_live_product_impressions`	Unknown
`seller_live_unique_atc_rate`	Unknown
`seller_live_unique_click_order_rate`	Unknown
`seller_live_unique_clicks`	Unknown
`seller_live_unique_ctr`	Unknown
`seller_live_unique_product_impressions`	Unknown
`seller_product_card_add_cart_count`	Unknown
`seller_product_card_add_cart_rate`	Unknown
`seller_product_card_add_cart_users`	Unknown
`seller_product_card_attributed_orders`	Unknown
`seller_product_card_attributed_sku_orders`	Unknown
`seller_product_card_attributed_sold_items`	Unknown
`seller_product_card_click_order_rate`	Unknown
`seller_product_card_ctr`	Unknown
`seller_product_card_estimated_customers`	Unknown
`seller_product_card_product_clicks`	Unknown
`seller_product_card_product_impressions`	Unknown
`seller_product_card_unique_atc_rate`	Unknown
`seller_product_card_unique_click_order_rate`	Unknown
`seller_product_card_unique_clicks`	Unknown
`seller_product_card_unique_ctr`	Unknown
`seller_product_card_unique_product_impressions`	Unknown
`seller_video_add_cart_count`	Unknown
`seller_video_add_cart_rate`	Unknown
`seller_video_add_cart_users`	Unknown
`seller_video_attributed_orders`	Unknown
`seller_video_attributed_sku_orders`	Unknown
`seller_video_attributed_sold_items`	Unknown
`seller_video_click_order_rate`	Unknown
`seller_video_ctr`	Unknown
`seller_video_estimated_customers`	Unknown
`seller_video_new_video_count`	Unknown
`seller_video_product_clicks`	Unknown
`seller_video_product_impressions`	Unknown
`seller_video_unique_atc_rate`	Unknown
`seller_video_unique_click_order_rate`	Unknown
`seller_video_unique_clicks`	Unknown
`seller_video_unique_ctr`	Unknown
`seller_video_unique_product_impressions`	Unknown
`shop_tab_performance_estimated_shop_tab_customers`	Unknown
`shop_tab_performance_shop_tab_ctor_sku`	Unknown
`shop_tab_performance_shop_tab_ctr`	Unknown
`shop_tab_performance_shop_tab_product_clicks`	Unknown
`shop_tab_performance_shop_tab_product_impressions`	Unknown
`shop_tab_performance_shop_tab_sold_items`	Unknown
`shop_tab_performance_unique_shop_tab_product_clicks`	Unknown
`total_add_cart_count`	Unknown
`total_add_cart_rate`	Unknown
`total_add_cart_users`	Unknown
`total_click_order_rate`	Unknown
`total_ctr`	Unknown
`total_estimated_customers`	Unknown
`total_product_clicks`	Unknown
`total_product_impressions`	Unknown
`total_refund_customers`	Unknown
`total_refunded_items`	Unknown
`total_unique_atc_rate`	Unknown
`total_unique_click_order_rate`	Unknown
`total_unique_clicks`	Unknown
`total_unique_ctr`	Unknown
`total_unique_product_impressions`	Unknown

payment

Column	Type	Keys
`id`	Unknown	PK
`create_time`	Instant
`exchange_rate`	Unknown
`final_amount_currency`	Unknown
`final_amount_value`	Unknown
`paid_time`	Instant
`payment_amount_before_exchange_currency`	Unknown
`payment_amount_before_exchange_value`	Unknown
`settlement_amount_currency`	Unknown
`settlement_amount_value`	Unknown
`status`	Unknown

cancellation_sub_line_item

Column	Type	Keys
`id`	Unknown	PK
`cancellation_id`	Unknown	PKFK
`cancellation_line_item_id`	Unknown	PKFK
`sub_order_line_item_id`	Unknown	FK

cancellation_line_item

Column	Type	Keys
`id`	Unknown	PK
`cancellation_id`	Unknown	PKFK
`order_line_item_id`	Unknown	FK
`refund_buyer_service_fee`	Unknown
`refund_currency`	Unknown
`refund_retail_delivery_fee`	Unknown
`refund_shipping_fee`	Unknown
`refund_subtotal`	Unknown
`refund_tax`	Unknown

cancellation_next_action

Column	Type	Keys
`index`	Unknown	PK
`cancellation_id`	Unknown	PKFK
`action`	Unknown
`deadline`	Instant

cancellation

Column	Type	Keys
`id`	Unknown	PK
`order_id`	Unknown	FK
`create_time`	Instant
`reason`	Unknown
`reason_text`	Unknown
`role`	Unknown
`should_replenish_stock`	Boolean
`status`	Unknown
`type`	Unknown
`update_time`	Instant

shop_sku_performance_interval_gmv_breakdown

Column	Type	Keys
`index`	Unknown	PK
`end_date`	Unknown	PKFK
`shop_sku_performance_id`	Unknown	PKFK
`shop_sku_performance_interval_index`	Unknown	PKFK
`start_date`	Unknown	PKFK
`amount`	Unknown
`currency`	Unknown
`type`	Unknown

shop_sku_performance_interval_items_sold_breakdown

Column	Type	Keys
`index`	Unknown	PK
`end_date`	Unknown	PKFK
`shop_sku_performance_id`	Unknown	PKFK
`shop_sku_performance_interval_index`	Unknown	PKFK
`start_date`	Unknown	PKFK
`amount`	Unknown
`type`	Unknown

shop_sku_performance_interval

Column	Type	Keys
`end_date`	Unknown	PK
`index`	Unknown	PK
`shop_sku_performance_id`	Unknown	PK
`start_date`	Unknown	PK
`shop_sku_performance_product_id`	Unknown	FK

orders_package

Column	Type	Keys
`index`	Unknown	PK
`order_id`	Unknown	PKFK
`id`	Unknown

orders_line_item_tax

Column	Type	Keys
`index`	Unknown	PK
`order_id`	Unknown	PKFK
`orders_line_item_id`	Unknown	PKFK
`tax_amount`	Unknown
`tax_rate`	Unknown
`tax_type`	Unknown

orders_line_item_sub_item_info

Column	Type	Keys
`id`	Unknown	PK
`order_id`	Unknown	PKFK
`orders_line_item_id`	Unknown	PKFK
`product_id`	Unknown	FK
`sku_id`	Unknown	FK

orders_line_item

Column	Type	Keys
`id`	Unknown	PK
`order_id`	Unknown	PKFK
`package_id`	Unknown	FK
`product_id`	Unknown	FK
`sku_id`	Unknown	FK
`buyer_service_fee`	Unknown
`cancel_reason`	Unknown
`cancel_user`	Unknown
`currency`	Unknown
`display_status`	Unknown
`distance_fee`	Unknown
`distance_shipping_fee`	Unknown
`gift_retail_price`	Unknown
`is_dangerous_good`	Unknown
`is_gift`	Unknown
`is_unboxing_item`	Unknown
`needs_prescription`	Unknown
`original_price`	Unknown
`package_status`	Unknown
`platform_discount`	Unknown
`product_name`	Unknown
`retail_delivery_fee`	Unknown
`rts_time`	Instant
`sale_price`	Unknown
`seller_discount`	Unknown
`shipping_provider_id`	Unknown
`shipping_provider_name`	Unknown
`shipping_vat_amount`	Unknown
`shipping_vat_rate`	Unknown
`small_order_fee`	Unknown
`tracking_number`	Unknown
`unboxing_case`	Json
`unboxing_sku_code`	Unknown

orders

Column	Type	Keys
`id`	Unknown	PK
`auto_combine_group_id`	Unknown
`buyer_email`	Unknown
`buyer_message`	Unknown
`buyer_nickname`	Unknown
`cancel_order_sla_time`	Instant
`cancel_time`	Instant
`cancellation_initiator`	Unknown
`collection_due_time`	Instant
`collection_time`	Instant
`commerce_platform`	Unknown
`consultation_id`	Unknown
`cpf_name`	Unknown
`create_time`	Instant
`delivery_due_time`	Instant
`delivery_option_id`	Unknown
`delivery_option_name`	Unknown
`delivery_option_required_delivery_time`	Instant
`delivery_sla_time`	Instant
`delivery_time`	Instant
`delivery_type`	Unknown
`exchange_source_id`	Unknown
`fast_delivery_program`	Unknown
`fast_dispatch_sla_time`	Instant
`fulfillment_priority_level`	Unknown
`fulfillment_type`	Unknown
`handling_duration_days`	Unknown
`handling_duration_type`	Unknown
`handling_fee`	Unknown
`has_updated_recipient_address`	Unknown
`is_buyer_request_cancel`	Unknown
`is_cod`	Unknown
`is_exchange_order`	Unknown
`is_on_hold_order`	Unknown
`is_replacement_order`	Unknown
`is_sample_order`	Unknown
`is_subscription_order`	Unknown
`item_insurance_fee`	Unknown
`item_insurance_tax`	Unknown
`need_upload_invoice`	Unknown
`order_rights`	Json
`order_type`	Unknown
`original_shipping_fee`	Unknown
`original_total_product_price`	Unknown
`paid_time`	Instant
`payment_discount_service_fee`	Unknown
`payment_method_name`	Unknown
`payment_platform_discount`	Unknown
`pick_up_cut_off_time`	Instant
`product_tax`	Unknown
`recipient_address_detail`	Unknown
`recipient_delivery_preference_drop_off_location`	Unknown
`recipient_district_info`	Json
`recipient_first_name`	Unknown
`recipient_first_name_local_script`	Unknown
`recipient_full_address`	Unknown
`recipient_last_name`	Unknown
`recipient_last_name_local_script`	Unknown
`recipient_name`	Unknown
`recipient_phone_number`	Unknown
`recipient_post_town`	Unknown
`recipient_postal_code`	Unknown
`recipient_region_code`	Unknown
`recommended_shipping_time`	Instant
`release_date`	Unknown
`replaced_order_id`	Unknown
`request_cancel_time`	Instant
`rts_sla_time`	Instant
`seller_note`	Unknown
`shipping_due_time`	Instant
`shipping_fee_cofunded_discount`	Unknown
`shipping_fee_platform_discount`	Unknown
`shipping_fee_seller_discount`	Unknown
`shipping_fee_tax`	Unknown
`shipping_insurance_fee`	Unknown
`shipping_type`	Unknown
`split_or_combine_tag`	Unknown
`status`	Unknown
`tts_sla_time`	Instant
`update_time`	Instant
`user_id`	Unknown
`warehouse_id`	Unknown

marketplace_creator_performance_category_gmv_distribution

Column	Type	Keys
`index`	Unknown	PK
`marketplace_creator_performance_id`	Unknown	PKFK
`category_id`	Unknown	FK
`value`	Unknown

marketplace_creator_performance_content_gmv_distribution

Column	Type	Keys
`index`	Unknown	PK
`marketplace_creator_performance_id`	Unknown	PKFK
`content_type`	Unknown
`value`	Unknown

marketplace_creator_performance_top_brand

Column	Type	Keys
`index`	Unknown	PK
`marketplace_creator_performance_id`	Unknown	PKFK
`brand_id`	Unknown

marketplace_creator_performance_category

Column	Type	Keys
`index`	Unknown	PK
`marketplace_creator_performance_id`	Unknown	PKFK
`category_id`	Unknown

marketplace_creator_performance_follower_location

Column	Type	Keys
`index`	Unknown	PK
`marketplace_creator_performance_id`	Unknown	PKFK
`key`	Unknown
`value`	Unknown

marketplace_creator_performance_follower_age

Column	Type	Keys
`index`	Unknown	PK
`marketplace_creator_performance_id`	Unknown	PKFK
`key`	Unknown
`value`	Unknown

marketplace_creator_performance_follower_gender

Column	Type	Keys
`index`	Unknown	PK
`marketplace_creator_performance_id`	Unknown	PKFK
`key`	Unknown
`value`	Unknown

marketplace_creator_performance

Column	Type	Keys
`profile_tt_uri`	Unknown	PK
`id`	Unknown	PKFK
`avg_commission_rate`	Unknown
`avg_commission_rate_maximum_amount`	Unknown
`avg_commission_rate_minimum_amount`	Unknown
`avg_ec_live_comment_count`	Unknown
`avg_ec_live_like_count`	Unknown
`avg_ec_live_share_count`	Unknown
`avg_ec_live_view_count`	Unknown
`avg_ec_video_comment_count`	Unknown
`avg_ec_video_like_count`	Unknown
`avg_ec_video_play_count`	Unknown
`avg_ec_video_share_count`	Unknown
`avg_gmv_per_buyer_amount`	Unknown
`avg_gmv_per_buyer_currency`	Unknown
`avg_gmv_per_buyer_range_currency`	Unknown
`avg_gmv_per_buyer_range_formatted_range`	Unknown
`avg_gmv_per_buyer_range_maximum_amount`	Unknown
`avg_gmv_per_buyer_range_minimum_amount`	Unknown
`bio_description`	Unknown
`brand_collaboration_count`	Unknown
`ec_live_count`	Unknown
`ec_live_engagement_rate`	Unknown
`ec_video_count`	Unknown
`ec_video_engagement_rate`	Unknown
`gpm_amount`	Unknown
`gpm_currency`	Unknown
`gpm_range_currency`	Unknown
`gpm_range_formatted_range`	Unknown
`gpm_range_maximum_amount`	Unknown
`gpm_range_minimum_amount`	Unknown
`live_gpm_amount`	Unknown
`live_gpm_currency`	Unknown
`live_gpm_range_currency`	Unknown
`live_gpm_range_formatted_range`	Unknown
`live_gpm_range_maximum_amount`	Unknown
`live_gpm_range_minimum_amount`	Unknown
`post_rate`	Unknown
`pps`	Unknown
`product_original_price_currency`	Unknown
`product_original_price_maximum_amount`	Unknown
`product_original_price_minimum_amount`	Unknown
`promoted_product_num`	Unknown
`rating`	Unknown
`units_sold`	Unknown
`units_sold_range_formatted_range`	Unknown
`units_sold_range_maximum_amount`	Unknown
`units_sold_range_minimum_amount`	Unknown
`video_gpm_amount`	Unknown
`video_gpm_currency`	Unknown
`video_gpm_range_currency`	Unknown
`video_gpm_range_formatted_range`	Unknown
`video_gpm_range_maximum_amount`	Unknown
`video_gpm_range_minimum_amount`	Unknown

seller_search_creator_on_marketplace_category

Column	Type	Keys
`index`	Unknown	PK
`seller_search_creator_on_marketplace_id`	Unknown	PKFK
`category_id`	Unknown

seller_search_creator_on_marketplace_age_range

Column	Type	Keys
`index`	Unknown	PK
`seller_search_creator_on_marketplace_id`	Unknown	PKFK
`age_range`	Unknown

seller_search_creator_on_marketplace

Column	Type	Keys
`id`	Unknown	PK
`avg_ec_live_uv`	Unknown
`avg_ec_video_view_count`	Unknown
`follower_count`	Unknown
`gmv_amount`	Unknown
`gmv_currency`	Unknown
`gmv_range_currency`	Unknown
`gmv_range_formatted_range`	Unknown
`gmv_range_maximum_amount`	Unknown
`gmv_range_minimum_amount`	Unknown
`live_gmv_amount`	Unknown
`live_gmv_currency`	Unknown
`nickname`	Unknown
`selection_region`	Unknown
`top_follower_demographics_major_gender`	Unknown
`top_follower_demographics_major_gender_percentage`	Unknown
`units_sold_range_formatted_range`	Unknown
`units_sold_range_maximum_amount`	Unknown
`units_sold_range_minimum_amount`	Unknown
`username`	Unknown
`video_gmv_amount`	Unknown
`video_gmv_currency`	Unknown

shop_live_performance

Column	Type	Keys
`id`	Unknown	PK
`acu`	Unknown
`avg_price_amount`	Unknown
`avg_price_currency`	Unknown
`avg_viewing_duration`	Unknown
`click_through_rate`	Unknown
`click_to_order_rate`	Unknown
`comments`	Unknown
`created_sku_orders`	Unknown
`customers`	Unknown
`different_products_sold`	Unknown
`end_time`	Instant
`items_sold`	Unknown
`likes`	Unknown
`live_24_h_gmv_amount`	Unknown
`live_24_h_gmv_currency`	Unknown
`new_followers`	Unknown
`pcu`	Unknown
`product_clicks`	Unknown
`product_impressions`	Unknown
`products_added`	Unknown
`sales_gmv_amount`	Unknown
`sales_gmv_currency`	Unknown
`shares`	Unknown
`sku_orders`	Unknown
`start_time`	Instant
`title`	Unknown
`username`	Unknown
`viewers`	Unknown
`views`	Unknown

transactions_by_statement_transaction

Column	Type	Keys
`id`	Unknown	PK
`statement_id`	Unknown	PKFK
`adjustment_order_id`	Unknown	FK
`associated_order_id`	Unknown	FK
`order_id`	Unknown	FK
`adjustment_id`	Unknown
`customer_payment_amount`	Unknown
`customer_refund_amount`	Unknown
`estimated_release_time`	Instant
`platform_cofunded_discount_amount`	Unknown
`platform_cofunded_discount_refund_amount`	Unknown
`platform_discount_amount`	Unknown
`platform_discount_refund_amount`	Unknown
`reserve_amount`	Unknown
`reserve_id`	Unknown
`reserve_status`	Unknown
`retail_delivery_fee_amount`	Unknown
`retail_delivery_fee_payment_amount`	Unknown
`retail_delivery_fee_refund_amount`	Unknown
`sales_tax_amount`	Unknown
`sales_tax_payment_amount`	Unknown
`sales_tax_refund_amount`	Unknown
`seller_cofunded_discount_amount`	Unknown
`seller_cofunded_discount_refund_amount`	Unknown
`type`	Unknown

transactions_by_statement

Column	Type	Keys
`id`	Unknown	PKFK
`create_time`	Instant
`status`	Unknown

seller_affiliate_order_sku

Column	Type	Keys
`seller_affiliate_order_id`	Unknown	PKFK
`sku_id`	Unknown	PKFK
`campaign_id`	Unknown	FK
`product_id`	Unknown	FK
`actual_cofunded_creator_bonus_amount`	Unknown
`actual_cofunded_creator_bonus_currency`	Unknown
`actual_commission_base_amount`	Unknown
`actual_commission_base_currency`	Unknown
`actual_paid_commission_amount`	Unknown
`actual_paid_commission_currency`	Unknown
`actual_paid_partner_commission_amount`	Unknown
`actual_paid_partner_commission_currency`	Unknown
`actual_paid_shop_ads_commission_amount`	Unknown
`actual_paid_shop_ads_commission_currency`	Unknown
`commission_model`	Unknown
`commission_rate`	Unknown
`commission_tier_setting`	Unknown
`content_id`	Unknown
`content_type`	Unknown
`creator_username`	Unknown
`estimated_cofunded_creator_bonus_amount`	Unknown
`estimated_cofunded_creator_bonus_currency`	Unknown
`estimated_commission_base_amount`	Unknown
`estimated_commission_base_currency`	Unknown
`estimated_paid_commission_amount`	Unknown
`estimated_paid_commission_currency`	Unknown
`estimated_paid_partner_commission_amount`	Unknown
`estimated_paid_partner_commission_currency`	Unknown
`estimated_paid_shop_ads_commission_amount`	Unknown
`estimated_paid_shop_ads_commission_currency`	Unknown
`fully_return`	Unknown
`open_collaboration_id`	Unknown
`partner_commission_rate`	Unknown
`price_amount`	Unknown
`price_currency`	Unknown
`quantity`	Unknown
`refunded_quantity`	Unknown
`returned_quantity`	Unknown
`settlement_status`	Unknown
`shop_ads_commission_rate`	Unknown
`target_collaboration_id`	Unknown

statement

Column	Type	Keys
`id`	Unknown	PK
`payment_id`	Unknown	FK
`adjustment_amount`	Unknown
`currency`	Unknown
`fee_amount`	Unknown
`net_sales_amount`	Unknown
`revenue_amount`	Unknown
`settlement_amount`	Unknown
`shipping_cost_amount`	Unknown
`statement_time`	Instant

category_asset

Column	Type	Keys
`id`	Unknown	PK
`name`	Unknown
`target_market`	Unknown

product_sku_inventory

Column	Type	Keys
`index`	Unknown	PK
`product_id`	Unknown	PKFK
`product_sku_id`	Unknown	PKFK
`backorder_quantity`	Unknown
`handling_time`	Unknown
`quantity`	Unknown
`warehouse_id`	Unknown

product_sku_external_list_price

Column	Type	Keys
`index`	Unknown	PK
`product_id`	Unknown	PKFK
`product_sku_id`	Unknown	PKFK
`amount`	Unknown
`currency`	Unknown
`source`	Unknown

product_sku_fee

Column	Type	Keys
`index`	Unknown	PK
`product_id`	Unknown	PKFK
`product_sku_id`	Unknown	PKFK
`additional_attribute`	Unknown
`amount`	Unknown
`type`	Unknown

product_sku

Column	Type	Keys
`id`	Unknown	PK
`product_id`	Unknown	PKFK
`deactivation_source`	Unknown
`list_price_amount`	Unknown
`list_price_currency`	Unknown
`pre_sale_fulfillment_typehandling_duration_days`	Unknown
`pre_sale_fulfillment_typerelease_date`	Unknown
`pre_sale_type`	Unknown
`price_currency`	Unknown
`price_sale_price`	Unknown
`price_starting_bid_price`	Unknown
`price_tax_exclusive_price`	Unknown
`seller_sku`	Unknown
`status`	Unknown

product_sales_region

Column	Type	Keys
`index`	Unknown	PK
`product_id`	Unknown	PKFK
`sales_region`	Unknown

product_recommended_category

Column	Type	Keys
`index`	Unknown	PK
`product_id`	Unknown	PKFK
`id`	Unknown
`local_name`	Unknown

product_family

Column	Type	Keys
`index`	Unknown	PK
`product_id`	Unknown	PKFK
`id`	Unknown

product_integrated_platform_status

Column	Type	Keys
`index`	Unknown	PK
`product_id`	Unknown	PKFK
`platform`	Unknown
`status`	Unknown

product

Column	Type	Keys
`id`	Unknown	PK
`audit_pre_approved_reasons`	Json
`audit_status`	Unknown
`create_time`	Instant
`has_draft`	Boolean
`is_enabled_scheduled_sale`	Unknown
`is_not_for_sale`	Boolean
`listing_quality_tier`	Unknown
`product_sync_fail_reasons`	Json
`product_tags`	Json
`schedule_sale_time`	Instant
`status`	Unknown
`title`	Unknown
`update_time`	Instant

coupon_display_channel

Column	Type	Keys
`index`	Unknown	PK
`coupon_id`	Unknown	PKFK
`display_channel`	Unknown

coupon_product_id

Column	Type	Keys
`index`	Unknown	PK
`coupon_id`	Unknown	PKFK
`product_id`	Unknown

coupon_live_task

Column	Type	Keys
`index`	Unknown	PK
`coupon_id`	Unknown	PKFK
`min_watch_time`	Unknown
`type`	Unknown

coupon

Column	Type	Keys
`id`	Unknown	PK
`claim_duration_end_time`	Instant
`claim_duration_start_time`	Instant
`create_time`	Instant
`creation_source`	Unknown
`discount_max_amount`	Unknown
`discount_max_currency`	Unknown
`discount_percentage`	Unknown
`discount_reduction_amount`	Unknown
`discount_reduction_currency`	Unknown
`discount_type`	Unknown
`display_type`	Unknown
`product_scope`	Unknown
`promo_code`	Unknown
`redemption_duration_end_time`	Instant
`redemption_duration_relative_time`	Unknown
`redemption_duration_start_time`	Instant
`redemption_duration_type`	Unknown
`redemption_limit`	Unknown
`seller_tnc`	Unknown
`single_buyer_claim_limit`	Unknown
`status`	Unknown
`target_buyer_segment`	Unknown
`threshold_min_spend_amount`	Unknown
`threshold_min_spend_currency`	Unknown
`threshold_type`	Unknown
`title`	Unknown
`total_claim_limit`	Unknown
`update_time`	Instant
`usage_stats_claimed_count`	Unknown
`usage_stats_redeemed_count`	Unknown

affiliate_partner_campaign_product_sku_information_region_price

Column	Type	Keys
`index`	Unknown	PK
`affiliate_partner_campaign_id`	Unknown	PKFK
`affiliate_partner_campaign_product_id`	Unknown	PKFK
`affiliate_partner_campaign_product_sku_information_sku_id`	Unknown	PKFK
`currency`	Unknown
`list_price`	Unknown
`localized_dutiable_price`	Unknown
`region_code`	Unknown
`sale_price`	Unknown

affiliate_partner_campaign_product_sku_information_property

Column	Type	Keys
`index`	Unknown	PK
`affiliate_partner_campaign_id`	Unknown	PKFK
`affiliate_partner_campaign_product_id`	Unknown	PKFK
`affiliate_partner_campaign_product_sku_information_sku_id`	Unknown	PKFK
`name`	Unknown
`value_name`	Unknown

affiliate_partner_campaign_product_sku_information

Column	Type	Keys
`affiliate_partner_campaign_id`	Unknown	PKFK
`affiliate_partner_campaign_product_id`	Unknown	PKFK
`sku_id`	Unknown	PKFK
`available_quantity`	Unknown
`base_price`	Unknown
`base_price_currency`	Unknown
`base_price_localized_dutiable_price`	Unknown
`base_price_region_code`	Unknown
`base_price_sale_price`	Unknown
`sku_name`	Unknown

affiliate_partner_campaign_product

Column	Type	Keys
`affiliate_partner_campaign_id`	Unknown	PK
`id`	Unknown	PKFK
`category_id`	Unknown	FK
`creator_commission_rate`	Unknown
`highest_price_amount`	Unknown
`highest_price_currency`	Unknown
`inventory`	Unknown
`is_available`	Boolean
`lowest_price_amount`	Unknown
`lowest_price_currency`	Unknown
`name`	Unknown
`open_collaboration_commission_rate`	Unknown
`partner_commission_rate`	Unknown
`product_description`	Unknown
`product_sales`	Unknown
`review_status`	Unknown
`sample_quota`	Unknown
`shop_name`	Unknown
`total_commission_rate`	Unknown

external_order

Column	Type	Keys
`id`	Unknown	PK
`orders_id`	Unknown	PKFK
`platform`	Unknown

transactions_by_order_sku_transaction

Column	Type	Keys
`index`	Unknown	PK
`order_id`	Unknown	PKFK
`sku_id`	Unknown	FK
`statement_id`	Unknown	FK
`actual_shipping_fee_amount`	Unknown
`affiliate_ads_commission_amount`	Unknown
`affiliate_commission_amount`	Unknown
`affiliate_commission_amount_before_pit`	Unknown
`affiliate_commission_deposit`	Unknown
`affiliate_commission_release`	Unknown
`affiliate_partner_commission_amount`	Unknown
`anti_dumping_duty_amount`	Unknown
`bonus_cashback_service_fee_amount`	Unknown
`brand_amplification_program_commission`	Unknown
`brand_amplification_program_fee_tax`	Unknown
`brand_campaign_fee`	Unknown
`brand_campaign_fee_tax`	Unknown
`buyer_fault_return_shipping_fee`	Unknown
`campaign_period_fee_cfp_amount`	Unknown
`campaign_period_fee_cfp_tax_amount`	Unknown
`campaign_period_fee_sp_amount`	Unknown
`campaign_period_fee_sp_tax_amount`	Unknown
`campaign_resource_fee`	Unknown
`category_led_campaign_fee_amount`	Unknown
`category_led_campaign_fee_tax_amount`	Unknown
`cedular_tax`	Unknown
`cod_service_fee_amount`	Unknown
`cofunded_creator_bonus_amount`	Unknown
`cofunded_promotion_service_fee_amount`	Unknown
`credit_card_handling_fee_amount`	Unknown
`customer_paid_shipping_fee_amount`	Unknown
`customer_shipping_fee_offset_amount`	Unknown
`customs_clearance_amount`	Unknown
`customs_duty_amount`	Unknown
`distant_item_fee_amount`	Unknown
`distant_shipping_fee_amount`	Unknown
`dt_handling_fee_amount`	Unknown
`dynamic_commission_amount`	Unknown
`epr_pob_service_fee_amount`	Unknown
`exchange_shipping_fee_amount`	Unknown
`external_affiliate_marketing_fee_amount`	Unknown
`failed_delivery_shipping_fee`	Unknown
`failed_delivery_subsidy_amount`	Unknown
`fbm_shipping_cost_amount`	Unknown
`fbt_free_shipping_fee_amount`	Unknown
`fbt_fulfillment_fee_amount`	Unknown
`fbt_fulfillment_fee_reimbursement_amount`	Unknown
`fbt_key_merchant_subsidy`	Unknown
`fbt_overall_merchant_subsidy`	Unknown
`fbt_shipping_cost_amount`	Unknown
`fee_per_item_sold_amount`	Unknown
`flash_sales_service_fee_amount`	Unknown
`free_return_subsidy_amount`	Unknown
`gmv_max_ad_fee_amount`	Unknown
`gmv_max_coupon_fee`	Unknown
`gst_amount`	Unknown
`import_vat_amount`	Unknown
`installation_service_fee`	Unknown
`insurance_fee`	Unknown
`isr_amount`	Unknown
`iva_amount`	Unknown
`live_specials_fee_amount`	Unknown
`local_vat_amount`	Unknown
`logistics_service_fee`	Unknown
`mall_service_fee_amount`	Unknown
`pit_amount`	Unknown
`platform_commission_amount`	Unknown
`platform_semi_managed_commission_fee`	Unknown
`platform_semi_managed_commission_fee_tax`	Unknown
`platform_shipping_fee_discount_amount`	Unknown
`platform_special_service_fee_amount`	Unknown
`pre_order_service_fee_amount`	Unknown
`promo_shipping_incentive_amount`	Unknown
`quantity`	Unknown
`referral_fee_amount`	Unknown
`refund_administration_fee_amount`	Unknown
`refund_cod_service_fee_amount`	Unknown
`refund_subtotal_before_discount_amount`	Unknown
`refunded_customer_shipping_fee_amount`	Unknown
`replacement_shipping_fee_amount`	Unknown
`return_refund_subsidy_amount`	Unknown
`return_shipping_fee_amount`	Unknown
`return_shipping_fee_paid_buyer_amount`	Unknown
`return_shipping_label_fee_amount`	Unknown
`sales_tax_referral_fee_amount`	Unknown
`seller_discount_amount`	Unknown
`seller_discount_refund_amount`	Unknown
`seller_growth_fee_amount`	Unknown
`seller_paylater_handling_fee_amount`	Unknown
`seller_self_shipping_service_fee_amount`	Unknown
`seller_shipping_fee_discount_amount`	Unknown
`sfp_service_fee_amount`	Unknown
`shipping_app_service_fee_amount`	Unknown
`shipping_fee_discount_amount`	Unknown
`shipping_fee_guarantee_reimbursement`	Unknown
`shipping_fee_guarantee_service_fee`	Unknown
`shipping_fee_subsidy_amount`	Unknown
`shipping_insurance_fee_amount`	Unknown
`signature_confirmation_fee_amount`	Unknown
`smart_promotion_fee_amount`	Unknown
`smart_promotion_fee_tax_amount`	Unknown
`sst_amount`	Unknown
`subtotal_before_discount_amount`	Unknown
`tap_shop_ads_commission`	Unknown
`tiktok_shop_shipping_incentive_amount`	Unknown
`transaction_fee_amount`	Unknown
`tsp_commission_amount`	Unknown
`vat_amount`	Unknown
`vn_fix_infrastructure_fee`	Unknown
`voucher_xtra_service_fee_amount`	Unknown

return_sub_line_item

Column	Type	Keys
`id`	Unknown	PK
`return_id`	Unknown	PKFK
`return_line_item_id`	Unknown	PKFK
`sub_order_line_item_id`	Unknown	FK

return_line_item

Column	Type	Keys
`id`	Unknown	PK
`return_id`	Unknown	PKFK
`order_line_item_id`	Unknown	FK
`refund_buyer_service_fee`	Unknown
`refund_currency`	Unknown
`refund_retail_delivery_fee`	Unknown
`refund_shipping_fee`	Unknown
`refund_subtotal`	Unknown
`refund_tax`	Unknown

return_discount_amount

Column	Type	Keys
`index`	Unknown	PK
`return_id`	Unknown	PKFK
`currency`	Unknown
`product_platform_discount`	Unknown
`product_seller_discount`	Unknown
`shipping_fee_platform_discount`	Unknown
`shipping_fee_seller_discount`	Unknown

return_shipping_fee_amount

Column	Type	Keys
`index`	Unknown	PK
`return_id`	Unknown	PKFK
`buyer_paid_return_shipping_fee`	Unknown
`currency`	Unknown
`platform_paid_return_shipping_fee`	Unknown
`seller_paid_return_shipping_fee`	Unknown

return_next_action

Column	Type	Keys
`index`	Unknown	PK
`return_id`	Unknown	PKFK
`action`	Unknown
`deadline`	Instant

return

Column	Type	Keys
`id`	Unknown	PK
`order_id`	Unknown	FK
`arbitration_status`	Unknown
`buyer_rejected_partial_refund`	Boolean
`can_buyer_keep_item`	Boolean
`combined_return_id`	Unknown
`create_time`	Instant
`handover_method`	Unknown
`is_combined_return`	Boolean
`is_quick_refund`	Boolean
`method`	Unknown
`next_return_id`	Unknown
`partial_refund_amount`	Unknown
`partial_refund_currency`	Unknown
`pre_return_id`	Unknown
`provider_id`	Unknown
`provider_name`	Unknown
`reason`	Unknown
`reason_text`	Unknown
`return_shipping_document_type`	Unknown
`return_warehouse_full_address`	Unknown
`role`	Unknown
`seller_proposed_return_type`	Unknown
`shipment_type`	Unknown
`status`	Unknown
`tracking_number`	Unknown
`type`	Unknown
`update_time`	Instant