tbbe
Tables (3)
fulfillments
- id — BIGINT — Primary key — NOT NULL
- order_id — BIGINT — Foreign key → orders.order_product_id — NOT NULL
- overseas_order_status — VARCHAR(50)
- domestic_order_status — VARCHAR(50)
- domestic_mall_name — VARCHAR(50)
- domestic_order_no — VARCHAR(100)
- domestic_courier — VARCHAR(50)
- domestic_tracking_number — VARCHAR(100)
- overseas_courier — VARCHAR(50)
- overseas_tracking_number — VARCHAR(100)
- shipped_at — DATETIME
- updated_at — DATETIME
order_products
- id — BIGINT — Primary key — NOT NULL
- seller_id — VARCHAR(100)
- domestic_site — VARCHAR(50)
- domestic_pid — VARCHAR(100)
- domestic_url — TEXT
- overseas_site — VARCHAR(50)
- overseas_listing_id — VARCHAR(100)
- created_at — DATETIME
orders
- id — BIGINT — Primary key — NOT NULL
- order_product_id — BIGINT — Foreign key → order_products.id — NOT NULL
- overseas_order_key — VARCHAR(100)
- buyer_id — VARCHAR(100)
- currency — VARCHAR(3)
- paid_amount — DECIMAL(10,2)
- order_date — DATETIME
- created_at — DATETIME