# TikTok Shop Partner Center schema ERD

Table and field reference for the Fivetran TikTok Shop Partner Center connector.

## Table & Field Reference

### shop_video_performance_product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| shop_video_performance_id | Unknown | PK, FK |

### 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 | PK, FK |
| listing_platform | Unknown |  |
| position | Unknown |  |
| reasons | Json |  |
| suggestions | Json |  |

### product_detail_category_chain

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| parent_id | Unknown | FK |
| id | Unknown |  |
| is_leaf | Boolean |  |
| local_name | Unknown |  |

### product_detail_certification

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | PK, FK |
| expiration_date | Instant |  |
| files | Json |  |
| title | Unknown |  |

### product_detail_delivery_option

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| id | Unknown |  |
| is_available | Boolean |  |
| name | Unknown |  |

### product_detail_attribute

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| id | Unknown |  |
| name | Unknown |  |
| values | Json |  |

### product_detail_manufacturer

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| manufacturer_id | Unknown |  |

### product_detail_responsible_person

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| responsible_person_id | Unknown |  |

### product_detail_global_sku_mapping

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

### product_detail_subscribe_promotion_config

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| discount_level | Unknown |  |
| discount_options | Json |  |
| max_discount | Unknown |  |
| min_discount | Unknown |  |

### product_detail_sku

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| product_id | Unknown | PK, FK |
| shop_video_performance_detail_interval_index | Unknown | PK, FK |
| shop_video_performance_id | Unknown | PK, FK |
| start_date | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| cancellation_line_item_id | Unknown | PK, FK |
| sub_order_line_item_id | Unknown | FK |

### cancellation_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| cancellation_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| shop_sku_performance_id | Unknown | PK, FK |
| shop_sku_performance_interval_index | Unknown | PK, FK |
| start_date | Unknown | PK, FK |
| amount | Unknown |  |
| currency | Unknown |  |
| type | Unknown |  |

### shop_sku_performance_interval_items_sold_breakdown

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| end_date | Unknown | PK, FK |
| shop_sku_performance_id | Unknown | PK, FK |
| shop_sku_performance_interval_index | Unknown | PK, FK |
| start_date | Unknown | PK, FK |
| 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 | PK, FK |
| id | Unknown |  |

### orders_line_item_tax

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_id | Unknown | PK, FK |
| orders_line_item_id | Unknown | PK, FK |
| tax_amount | Unknown |  |
| tax_rate | Unknown |  |
| tax_type | Unknown |  |

### orders_line_item_sub_item_info

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | PK, FK |
| orders_line_item_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| sku_id | Unknown | FK |

### orders_line_item

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

### marketplace_creator_performance_content_gmv_distribution

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| marketplace_creator_performance_id | Unknown | PK, FK |
| content_type | Unknown |  |
| value | Unknown |  |

### marketplace_creator_performance_top_brand

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| marketplace_creator_performance_id | Unknown | PK, FK |
| brand_id | Unknown |  |

### marketplace_creator_performance_category

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| marketplace_creator_performance_id | Unknown | PK, FK |
| category_id | Unknown |  |

### marketplace_creator_performance_follower_location

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| marketplace_creator_performance_id | Unknown | PK, FK |
| key | Unknown |  |
| value | Unknown |  |

### marketplace_creator_performance_follower_age

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| marketplace_creator_performance_id | Unknown | PK, FK |
| key | Unknown |  |
| value | Unknown |  |

### marketplace_creator_performance_follower_gender

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| marketplace_creator_performance_id | Unknown | PK, FK |
| key | Unknown |  |
| value | Unknown |  |

### marketplace_creator_performance

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

### seller_search_creator_on_marketplace_age_range

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| seller_search_creator_on_marketplace_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| create_time | Instant |  |
| status | Unknown |  |

### seller_affiliate_order_sku

| Column | Type | Keys |
| --- | --- | --- |
| seller_affiliate_order_id | Unknown | PK, FK |
| sku_id | Unknown | PK, FK |
| 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 | PK, FK |
| product_sku_id | Unknown | PK, FK |
| 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 | PK, FK |
| product_sku_id | Unknown | PK, FK |
| amount | Unknown |  |
| currency | Unknown |  |
| source | Unknown |  |

### product_sku_fee

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| product_sku_id | Unknown | PK, FK |
| additional_attribute | Unknown |  |
| amount | Unknown |  |
| type | Unknown |  |

### product_sku

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

### product_recommended_category

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| id | Unknown |  |
| local_name | Unknown |  |

### product_family

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

### product_integrated_platform_status

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

### coupon_product_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| coupon_id | Unknown | PK, FK |
| product_id | Unknown |  |

### coupon_live_task

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| coupon_id | Unknown | PK, FK |
| 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 | PK, FK |
| affiliate_partner_campaign_product_id | Unknown | PK, FK |
| affiliate_partner_campaign_product_sku_information_sku_id | Unknown | PK, FK |
| 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 | PK, FK |
| affiliate_partner_campaign_product_id | Unknown | PK, FK |
| affiliate_partner_campaign_product_sku_information_sku_id | Unknown | PK, FK |
| name | Unknown |  |
| value_name | Unknown |  |

### affiliate_partner_campaign_product_sku_information

| Column | Type | Keys |
| --- | --- | --- |
| affiliate_partner_campaign_id | Unknown | PK, FK |
| affiliate_partner_campaign_product_id | Unknown | PK, FK |
| sku_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| platform | Unknown |  |

### transactions_by_order_sku_transaction

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

### return_line_item

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

## Relationships

- shop_video_performance_product(id) → product(id)
- shop_video_performance_product(shop_video_performance_id) → shop_video_performance(id)
- shop_video_performance(creator_open_id) → seller_search_creator_on_marketplace(id)
- product_detail_audit_failed_reason(product_id) → product_detail(id)
- product_detail_category_chain(parent_id) → product_detail_category_chain(id)
- product_detail_category_chain(product_id) → product_detail(id)
- product_detail_certification(product_id) → product_detail(id)
- product_detail_delivery_option(product_id) → product_detail(id)
- product_detail_attribute(product_id) → product_detail(id)
- product_detail_manufacturer(product_id) → product_detail(id)
- product_detail_responsible_person(product_id) → product_detail(id)
- product_detail_global_sku_mapping(local_sku_id) → product_sku(id)
- product_detail_global_sku_mapping(product_id) → product_detail(id)
- product_detail_subscribe_discount_detail(product_id) → product_detail(id)
- product_detail_subscribe_promotion_config(product_id) → product_detail(id)
- product_detail_sku(id) → product_sku(id)
- product_detail_sku(product_id) → product_detail(id)
- product_detail(id) → product(id)
- affiliate_partner_campaign_target_shop(affiliate_partner_campaign_id) → affiliate_partner_campaign_detail(id)
- shop_video_performance_detail_interval_sales_breakdown(product_id) → shop_product_performance(id)
- shop_video_performance_detail_interval_sales_breakdown(shop_video_performance_detail_interval_index) → shop_video_performance_detail_interval(index)
- shop_video_performance_detail_interval_sales_breakdown(shop_video_performance_id) → shop_video_performance_detail_interval(shop_video_performance_id)
- shop_video_performance_detail_interval_sales_breakdown(start_date) → shop_video_performance_detail_interval(start_date)
- shop_video_performance_detail_interval_sales_breakdown(end_date) → shop_video_performance_detail_interval(end_date)
- shop_product_performance(id) → product(id)
- cancellation_sub_line_item(sub_order_line_item_id) → orders_line_item_sub_item_info(id)
- cancellation_sub_line_item(cancellation_line_item_id) → cancellation_line_item(id)
- cancellation_sub_line_item(cancellation_id) → cancellation_line_item(cancellation_id)
- cancellation_line_item(order_line_item_id) → orders_line_item(id)
- cancellation_line_item(cancellation_id) → cancellation(id)
- cancellation_next_action(cancellation_id) → cancellation(id)
- cancellation(order_id) → orders(id)
- shop_sku_performance_interval_gmv_breakdown(shop_sku_performance_interval_index) → shop_sku_performance_interval(index)
- shop_sku_performance_interval_gmv_breakdown(start_date) → shop_sku_performance_interval(start_date)
- shop_sku_performance_interval_gmv_breakdown(end_date) → shop_sku_performance_interval(end_date)
- shop_sku_performance_interval_gmv_breakdown(shop_sku_performance_id) → shop_sku_performance_interval(shop_sku_performance_id)
- shop_sku_performance_interval_items_sold_breakdown(shop_sku_performance_interval_index) → shop_sku_performance_interval(index)
- shop_sku_performance_interval_items_sold_breakdown(start_date) → shop_sku_performance_interval(start_date)
- shop_sku_performance_interval_items_sold_breakdown(end_date) → shop_sku_performance_interval(end_date)
- shop_sku_performance_interval_items_sold_breakdown(shop_sku_performance_id) → shop_sku_performance_interval(shop_sku_performance_id)
- shop_sku_performance_interval(shop_sku_performance_product_id) → product(id)
- orders_package(order_id) → orders(id)
- orders_line_item_tax(orders_line_item_id) → orders_line_item(id)
- orders_line_item_tax(order_id) → orders_line_item(order_id)
- orders_line_item_sub_item_info(sku_id) → product_sku(id)
- orders_line_item_sub_item_info(product_id) → product(id)
- orders_line_item_sub_item_info(orders_line_item_id) → orders_line_item(id)
- orders_line_item_sub_item_info(order_id) → orders_line_item(order_id)
- orders_line_item(product_id) → product(id)
- orders_line_item(package_id) → orders_package(id)
- orders_line_item(sku_id) → product_sku(id)
- orders_line_item(order_id) → orders(id)
- marketplace_creator_performance_category_gmv_distribution(category_id) → marketplace_creator_performance_category(category_id)
- marketplace_creator_performance_category_gmv_distribution(marketplace_creator_performance_id) → marketplace_creator_performance(id)
- marketplace_creator_performance_content_gmv_distribution(marketplace_creator_performance_id) → marketplace_creator_performance(id)
- marketplace_creator_performance_top_brand(marketplace_creator_performance_id) → marketplace_creator_performance(id)
- marketplace_creator_performance_category(marketplace_creator_performance_id) → marketplace_creator_performance(id)
- marketplace_creator_performance_follower_location(marketplace_creator_performance_id) → marketplace_creator_performance(id)
- marketplace_creator_performance_follower_age(marketplace_creator_performance_id) → marketplace_creator_performance(id)
- marketplace_creator_performance_follower_gender(marketplace_creator_performance_id) → marketplace_creator_performance(id)
- marketplace_creator_performance(id) → seller_search_creator_on_marketplace(id)
- seller_search_creator_on_marketplace_category(seller_search_creator_on_marketplace_id) → seller_search_creator_on_marketplace(id)
- seller_search_creator_on_marketplace_age_range(seller_search_creator_on_marketplace_id) → seller_search_creator_on_marketplace(id)
- transactions_by_statement_transaction(associated_order_id) → orders(id)
- transactions_by_statement_transaction(order_id) → orders(id)
- transactions_by_statement_transaction(adjustment_order_id) → orders(id)
- transactions_by_statement_transaction(statement_id) → transactions_by_statement(id)
- transactions_by_statement(id) → statement(id)
- seller_affiliate_order_sku(product_id) → product(id)
- seller_affiliate_order_sku(campaign_id) → affiliate_partner_campaign_detail(id)
- seller_affiliate_order_sku(sku_id) → product_sku(id)
- seller_affiliate_order_sku(seller_affiliate_order_id) → orders(id)
- statement(payment_id) → payment(id)
- product_sku_inventory(product_sku_id) → product_sku(id)
- product_sku_inventory(product_id) → product_sku(product_id)
- product_sku_external_list_price(product_sku_id) → product_sku(id)
- product_sku_external_list_price(product_id) → product_sku(product_id)
- product_sku_fee(product_sku_id) → product_sku(id)
- product_sku_fee(product_id) → product_sku(product_id)
- product_sku(product_id) → product(id)
- product_sales_region(product_id) → product(id)
- product_recommended_category(product_id) → product(id)
- product_family(product_id) → product(id)
- product_integrated_platform_status(product_id) → product(id)
- coupon_display_channel(coupon_id) → coupon(id)
- coupon_product_id(coupon_id) → coupon(id)
- coupon_live_task(coupon_id) → coupon(id)
- affiliate_partner_campaign_product_sku_information_region_price(affiliate_partner_campaign_product_sku_information_sku_id) → affiliate_partner_campaign_product_sku_information(sku_id)
- affiliate_partner_campaign_product_sku_information_region_price(affiliate_partner_campaign_product_id) → affiliate_partner_campaign_product_sku_information(affiliate_partner_campaign_product_id)
- affiliate_partner_campaign_product_sku_information_region_price(affiliate_partner_campaign_id) → affiliate_partner_campaign_product_sku_information(affiliate_partner_campaign_id)
- affiliate_partner_campaign_product_sku_information_property(affiliate_partner_campaign_product_sku_information_sku_id) → affiliate_partner_campaign_product_sku_information(sku_id)
- affiliate_partner_campaign_product_sku_information_property(affiliate_partner_campaign_product_id) → affiliate_partner_campaign_product_sku_information(affiliate_partner_campaign_product_id)
- affiliate_partner_campaign_product_sku_information_property(affiliate_partner_campaign_id) → affiliate_partner_campaign_product_sku_information(affiliate_partner_campaign_id)
- affiliate_partner_campaign_product_sku_information(sku_id) → product_sku(id)
- affiliate_partner_campaign_product_sku_information(affiliate_partner_campaign_product_id) → affiliate_partner_campaign_product(id)
- affiliate_partner_campaign_product_sku_information(affiliate_partner_campaign_id) → affiliate_partner_campaign_product(affiliate_partner_campaign_id)
- affiliate_partner_campaign_product(category_id) → category_asset(id)
- affiliate_partner_campaign_product(id) → product(id)
- external_order(orders_id) → orders(id)
- transactions_by_order_sku_transaction(statement_id) → statement(id)
- transactions_by_order_sku_transaction(sku_id) → product_sku(id)
- transactions_by_order_sku_transaction(order_id) → orders(id)
- return_sub_line_item(sub_order_line_item_id) → orders_line_item_sub_item_info(id)
- return_sub_line_item(return_line_item_id) → return_line_item(id)
- return_sub_line_item(return_id) → return_line_item(return_id)
- return_line_item(order_line_item_id) → orders_line_item(id)
- return_line_item(return_id) → return(id)
- return_discount_amount(return_id) → return(id)
- return_shipping_fee_amount(return_id) → return(id)
- return_next_action(return_id) → return(id)
- return(order_id) → orders(id)