ERD for Tiktok Shop (Seller)

26 tables

Loading diagram…

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

payment_shipping_fee

double

payment_seller_discount

double

payment_platform_discount

double

payment_total_amount

double

payment_original_total_product_price

double

payment_original_shipping_fee

double

payment_shipping_fee_seller_discount

double

payment_shipping_fee_platform_discount

double

payment_shipping_fee_cofunded_discount

double

payment_tax

double

payment_small_order_fee

string

payment_shipping_fee_tax

double

payment_product_tax

double

payment_retail_delivery_fee

string

payment_buyer_service_fee

string

payment_handling_fee

string

payment_shipping_insurance_fee

string

payment_item_insurance_fee

double

payment_item_insurance_tax

double

recipient_address_full_address

string

recipient_address_phone_number

string

recipient_address_name

string

recipient_address_first_name

string

recipient_address_last_name

string

recipient_address_first_name_local_script

string

recipient_address_last_name_local_script

string

recipient_address_address_detail

string

recipient_address_address_line_1

string

recipient_address_address_line_2

string

recipient_address_address_line_3

string

recipient_address_address_line_4

string

recipient_address_delivery_preferences_drop_off_location

string

recipient_address_postal_code

string

recipient_address_region_code

string

recipient_address_post_town

string

status

string

fulfillment_type

string

delivery_type

string

paid_time

date

rts_sla_time

date

tts_sla_time

date

cancel_reason

string

update_time

date

payment_method_name

string

rts_time

date

tracking_number

string

split_or_combine_tag

string

has_updated_recipient_address

boolean

cancel_order_sla_time

date

warehouse_id

string

request_cancel_time

date

shipping_type

string

user_id

string

seller_note

string

delivery_sla_time

date

is_cod

boolean

delivery_option_id

string

cancel_time

date

need_upload_invoice

string

delivery_option_name

string

cpf

string

buyer_email

string

delivery_due_time

date

is_sample_order

boolean

shipping_due_time

date

collection_due_time

date

delivery_option_required_delivery_time

date

is_on_hold_order

boolean

delivery_time

date

is_replacement_order

boolean

collection_time

date

replaced_order_id

string

is_buyer_request_cancel

boolean

pick_up_cut_off_time

date

fast_dispatch_sla_time

date

commerce_platform

string

order_type

string

release_date

date

handling_duration_days

int

handling_duration_type

string

auto_combine_group_id

string

cpf_name

string

is_exchange_order

boolean

exchange_source_order_id

string

consultation_id

string

fast_delivery_program

string

fulfillment_priority_level

int

recommended_shipping_time

date

_weld_synced

date

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

pfand_fee

double

platform_discount

double

seller_discount

double

sku_type

string

cancel_reason

string

original_price

double

rts_time

date

package_status

string

currency

string

shipping_provider_name

string

cancel_user

string

shipping_provider_id

string

is_gift

boolean

tracking_number

string

package_id

string

retail_delivery_fee

double

buyer_service_fee

double

small_order_fee

double

handling_duration_days

int

is_dangerous_good

boolean

needs_prescription

boolean

gift_retail_price

double

_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

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

gmv_breakdowns

product_id

string

shop_id

string

start_date

string

end_date

string

amount

double

currency

string

type

string

_weld_synced

date

unit_sold_breakdowns

product_id

string

shop_id

string

start_date

string

end_date

string

amount

int

type

string

_weld_synced

date

impression_breakdowns

product_id

string

shop_id

string

start_date

string

end_date

string

amount

int

type

string

_weld_synced

date

page_view_breakdowns

product_id

string

shop_id

string

start_date

string

end_date

string

amount

int

type

string

_weld_synced

date

avg_page_visitor_breakdowns

product_id

string

shop_id

string

start_date

string

end_date

string

amount

int

type

string

_weld_synced

date

click_through_rate_breakdowns

product_id

string

shop_id

string

start_date

string

end_date

string

amount

double

type

string

_weld_synced

date

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

avg_order_value_currency

string

units_sold

int

buyers

int

product_impressions

int

product_page_views

int

avg_product_page_visitors

int

refunds_amount

double

refunds_currency

string

cancellations_and_returns

int

_weld_synced

date

buyer_breakdowns

amount

int

type

string

shop_id

string

start_date

string

end_date

string

_weld_synced

date

product_impression_breakdowns

amount

int

type

string

shop_id

string

start_date

string

end_date

string

_weld_synced

date

product_page_view_breakdowns

amount

int

type

string

shop_id

string

start_date

string

end_date

string

_weld_synced

date

avg_product_page_visitor_breakdowns

amount

int

type

string

shop_id

string

start_date

string

end_date

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

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

after_seller_discounts_subtotal_amount

double

currency

string

customer_order_refund_amount

double

customer_paid_shipping_fee_amount

string

customer_paid_shipping_fee_refund_amount

string

customer_payment_amount

double

customer_refund_amount

double

customer_shipping_fee_amount

double

customer_shipping_fee_offset_amount

double

fbm_shipping_cost_amount

double

fbt_fulfillment_fee_amount

double

fbt_fulfillment_fee_reimbursement_amount

double

fbt_shipping_cost_amount

double

fee_amount

double

gross_sales_amount

double

gross_sales_refund_amount

double

isr_income_tax_amount

double

iva_vat_amount

double

net_sales_amount

double

order_create_time

double

pit_amount

double

platform_commission_amount

double

platform_discount_amount

double

platform_discount_refund_amount

double

platform_refund_subsidy_amount

string

platform_shipping_fee_discount_amount

double

promo_shipping_incentive_amount

double

referral_fee_amount

double

refund_administration_fee_amount

double

refund_shipping_cost_discount_amount

double

retail_delivery_fee_amount

double

retail_delivery_fee_payment_amount

double

retail_delivery_fee_refund_amount

double

return_shipping_fee_amount

double

revenue_amount

double

sales_tax_amount

double

sales_tax_payment_amount

double

sales_tax_refund_amount

double

seller_discount_amount

double

seller_discount_refund_amount

double

settlement_amount

double

shipping_cost_amount

double

shipping_cost_discount_amount

double

shipping_fee_amount

double

shipping_fee_subsidy_amount

string

shipping_insurance_fee_amount

double

signature_confirmation_fee_amount

double

transaction_fee_amount

double

type

string

adjustment_id

string

adjustment_order_id

string

_weld_synced

date

Table

Sub table