Tiktok Shop (Seller) schema and ERD

40 tables

Loading diagram…

fbt_inventory

order

order_statement_transaction

product

product_performance

return_order

seller_affiliate_order

shop_performance

fbt_inventory

goods_id

string

goods_reference_code

string

goods_name

string

fbt_warehouse_id

string

in_transit_quantity

double

on_hand_detail_total_quantity

double

on_hand_detail_available_quantity

double

on_hand_detail_reserved_quantity

double

on_hand_detail_unfulfillable_quantity

double

shop_id

string

_weld_synced

date

fbt_inventory_goods_sku

string

shop_id

string

goods_id

string

fbt_warehouse_id

string

on_hand_detail_total_quantity

double

on_hand_detail_available_quantity

double

on_hand_detail_reserved_quantity

double

_weld_synced

date

order

string

shop_id

string

buyer_message

string

cancellation_initiator

string

shipping_provider_id

string

create_time

date

shipping_provider

string

payment_currency

string

payment_sub_total

double

order_packages

string

order_id

string

shop_id

string

_weld_synced

date

order_line_items

string

order_id

string

product_id

string

shop_id

string

sku_id

string

display_status

string

product_name

string

seller_sku

string

sku_image

string

sku_name

string

sale_price

double

order_line_items_combined_listing_skus

product_id

string

order_id

string

sku_id

string

sku_count

int

seller_sku

string

shop_id

string

line_item_id

string

_weld_synced

date

order_line_items_item_tax

order_id

string

shop_id

string

line_item_id

string

tax_type

string

tax_amount

double

tax_rate

double

_weld_synced

date

order_recipient_address_district_info

order_id

string

address_level_name

string

address_name

string

address_level

string

shop_id

string

_weld_synced

date

order_statement_transaction

string

order_id

string

statement_id

string

shop_id

string

status

string

statement_time

date

settlement_amount

string

currency

string

revenue_amount

double

sales_tax_payment_amount

double

after_seller_discounts_subtotal_amount

double

order_sku_statement_transaction

order_statement_transaction_id

string

order_id

string

statement_id

string

shop_id

string

sku_id

string

sku_name

string

product_name

string

quantity

double

settlement_amount

double

currency

string

revenue_amount

double

product

string

audit_pre_approved_reasons

string

audit_status

string

create_time

double

is_not_for_sale

boolean

recommended_categories

string

status

string

listing_quality_tier

string

title

string

update_time

double

shop_id

string

_weld_synced

date

product_skus

string

product_id

string

inventory

string

price_currency

string

price_tax_exclusive_price

double

seller_sku

string

index

double

external_list_prices

string

shop_id

string

_weld_synced

date

product_skus_inventory

product_id

string

quantity

double

warehouse_id

string

index

double

sku_id

string

shop_id

string

_weld_synced

date

product_sales_regions

product_id

string

value

string

index

double

shop_id

string

_weld_synced

date

product_performance

string

shop_id

string

start_date

string

end_date

string

gmv_amount

double

gmv_currency

string

orders

int

units_sold

long

impressions

long

page_views

long

avg_page_visitors

long

click_through_rate

double

_weld_synced

date

product_performance_gmv_breakdowns

product_id

string

shop_id

string

start_date

string

end_date

string

amount

double

currency

string

type

string

_weld_synced

date

product_performance_unit_sold_breakdowns

product_id

string

shop_id

string

start_date

string

end_date

string

amount

int

type

string

_weld_synced

date

product_performance_impression_breakdowns

product_id

string

shop_id

string

start_date

string

end_date

string

amount

int

type

string

_weld_synced

date

product_performance_page_view_breakdowns

product_id

string

shop_id

string

start_date

string

end_date

string

amount

int

type

string

_weld_synced

date

product_performance_avg_page_visitor_breakdowns

product_id

string

shop_id

string

start_date

string

end_date

string

amount

int

type

string

_weld_synced

date

product_performance_click_through_rate_breakdowns

product_id

string

shop_id

string

start_date

string

end_date

string

amount

double

type

string

_weld_synced

date

product_performance_list

string

gmv_amount

double

gmv_currency

string

orders

int

units_sold

int

click_through_rate

double

shop_id

string

start_date

string

end_date

string

_weld_synced

date

return_order

order_id

string

return_id

string

shop_id

string

return_type

string

return_status

string

arbitration_status

string

role

string

return_reason

string

return_reason_text

string

return_order_seller_next_action_response

order_id

string

return_id

string

shop_id

string

action

string

deadline

date

_weld_synced

date

return_order_line_items

order_id

string

return_line_item_id

string

return_id

string

shop_id

string

order_line_item_id

string

sku_id

string

sku_name

string

product_name

string

seller_sku

string

return_order_sub_line_items

order_id

string

return_sub_line_item_id

string

return_line_item_id

string

return_id

string

shop_id

string

sub_order_line_item_id

string

order_line_item_id

string

sku_id

string

sku_name

string

return_order_discount_amount

order_id

string

return_id

string

shop_id

string

currency

string

product_seller_discount

double

shipping_fee_platform_discount

double

shipping_fee_seller_discount

double

product_platform_discount

double

_weld_synced

date

return_order_shipping_fee_amount

order_id

string

return_id

string

shop_id

string

currency

string

seller_paid_return_shipping_fee

double

platform_paid_return_shipping_fee

double

buyer_paid_return_shipping_fee

double

_weld_synced

date

seller_affiliate_order

string

shop_id

string

create_time

date

delivery_time

date

status

string

_weld_synced

date

seller_affiliate_order_skus

order_id

string

product_id

string

shop_id

string

sku_id

string

settlement_status

string

open_collaboration_id

string

target_collaboration_id

string

campaign_id

string

creator_username

string

price_amount

double

shop_performance

start_date

string

end_date

string

gmv_amount

double

gmv_currency

string

shop_id

string

sku_orders

int

orders

int

avg_order_value_amount

double

shop_performance_gmv_breakdowns

amount

double

currency

string

type

string

shop_id

string

start_date

string

end_date

string

_weld_synced

date

shop_performance_buyer_breakdowns

amount

int

type

string

shop_id

string

start_date

string

end_date

string

_weld_synced

date

shop_performance_product_impression_breakdowns

amount

int

type

string

shop_id

string

start_date

string

end_date

string

_weld_synced

date

shop_performance_product_page_view_breakdowns

amount

int

type

string

shop_id

string

start_date

string

end_date

string

_weld_synced

date

shop_performance_avg_product_page_visitor_breakdowns

amount

int

type

string

shop_id

string

start_date

string

end_date

string

_weld_synced

date

sku_performance

string

product_id

string

gmv_amount

string

gmv_currency

string

sku_orders

int

units_sold

int

shop_id

string

start_date

string

end_date

string

_weld_synced

date

statement

string

adjustment_amount

double

currency

string

fee_amount

double

net_sales_amount

double

payment_status

string

revenue_amount

double

settlement_amount

double

shipping_cost_amount

double

statement_time

double

shop_id

string

payment_id

string

_weld_synced

date

statement_transaction

string

statement_id

string

order_id

string

shop_id

string

actual_return_shipping_fee_amount

double

actual_shipping_fee_amount

double

adjustment_amount

double

affiliate_ads_commission_amount

double

affiliate_commission_amount

double

affiliate_commission_before_pit

double

affiliate_partner_commission_amount

double

statement_transaction_report

116

string

statement_id

string

order_id

string

shop_id

string

adjustment_id

string

adjustment_order_id

string

reserve_id

string

associated_order_id

string

reserve_status

string

reserve_amount

double

estimated_release_time

date