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