lazada 0624

Tables (14)

Untitled (sellers)

  • Key (id) — INT — Primary key — NOT NULL
  • Field (seller_name) — TEXT
  • Field2 (super_seller) — BOOLEAN
  • 셀러점수 0~1 (seller_rating) — FLOAT
  • Field (seller_chat_response) — INT
  • Field (ship_on_time)
  • Field2 (is_lazmall)

Untitled (brands)

  • Key (id) — INT — Primary key — NOT NULL
  • Field (name) — TEXT

Untitled (delivery)

  • Key (id) — INT — Primary key — NOT NULL
  • Key (custormer_id) — INT — Foreign key → Untitled.Key — NOT NULL

Untitled (categories)

  • Key (id) — INT — Primary key — NOT NULL
  • Field (level1) — TEXT
  • Field (level2) — TEXT
  • Field (level3) — TEXT

Untitled (review)

  • Key (id) — INT — Primary key — NOT NULL
  • Key (customer_id) — INT — Foreign key → Untitled.Key — NOT NULL

Untitled (inquiry)

  • Key (id) — INT — Primary key — NOT NULL
  • Key (customer_id) — INT — Foreign key → Untitled.Key — NOT NULL

Untitled (customers)

  • Key (id) — INT — Primary key — NOT NULL
  • Field (customer_name) — TEXT
  • Field (mobile) — TEXT
  • Field (address) — TEXT
  • Field (age) — INT

Untitled (orders)

  • Key (id) — Primary key — NOT NULL
  • Key (customer_id) — Foreign key → Untitled.Key — NOT NULL
  • Key (brnad_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (product_id) — INT — Foreign key → Untitled2.Key — NOT NULL
  • Key (seller_id) — INT — Foreign key → Untitled2.Key — NOT NULL
  • Key (brand_id) — INT — Foreign key → Untitled2.Key — NOT NULL
  • Key (domain_id) — INT — Foreign key → Untitled2.Key — NOT NULL
  • Key (category_id) — INT — Foreign key → Untitled2.Key — NOT NULL
  • Field (product_quantity) — INT
  • Field

Untitled (domains)

  • Key (id) — INT — Primary key — NOT NULL
  • Field (url)
  • Field (country_code)

Untitled (product_specs)

  • Key (id) — INT — Primary key — NOT NULL
  • Key (product_id) — INT — Foreign key → Untitled2.Key — NOT NULL
  • Key (seller_id) — INT — Foreign key → Untitled2.Key — NOT NULL
  • Key (brand_id) — INT — Foreign key → Untitled2.Key — NOT NULL
  • Key (domain_id) — INT — Foreign key → Untitled2.Key — NOT NULL
  • Key (category_id) — INT — Foreign key → Untitled2.Key — NOT NULL
  • Field (spec_name) — TEXT
  • Field (spec_value) — TEXT

Untitled (product_stats)

  • Key (id) — INT — Primary key — NOT NULL
  • Key (product_id) — INT — Foreign key → Untitled2.Key — NOT NULL
  • Key (seller_id) — INT — Foreign key → Untitled2.Key — NOT NULL
  • Key (brand_id) — INT — Foreign key → Untitled2.Key — NOT NULL
  • Key (domain_id) — INT — Foreign key → Untitled2.Key — NOT NULL
  • Key (category_id) — INT — Foreign key → Untitled2.Key — NOT NULL
  • Field (numver_sold) — INT
  • Field (gmv) — REAL
  • Field (discount_rate) — REAL

Untitled (product_warrianties)

  • Key (id) — INT — Primary key — NOT NULL
  • Key (product_id) — INT — Foreign key → Untitled2.Key — NOT NULL
  • Key (seller_id) — INT — Foreign key → Untitled2.Key — NOT NULL
  • Key (brand_id) — INT — Foreign key → Untitled2.Key — NOT NULL
  • Key (domain_id) — INT — Foreign key → Untitled2.Key — NOT NULL
  • Key (category_id) — INT — Foreign key → Untitled2.Key — NOT NULL
  • Field (policy) — TEXT

Untitled (product_promotions)

  • Key (id) — INT — Primary key — NOT NULL
  • Key (product_id) — INT — Foreign key → Untitled2.Key — NOT NULL
  • Key (seller_id) — INT — Foreign key → Untitled2.Key — NOT NULL
  • Key (brand_id) — INT — Foreign key → Untitled2.Key — NOT NULL
  • Key (domain_id) — INT — Foreign key → Untitled2.Key — NOT NULL
  • Key (category_id) — INT — Foreign key → Untitled2.Key — NOT NULL
  • Field (promotion) — TEXT

Untitled2 (products)

  • Key (id) — INT — Primary key — NOT NULL
  • Key (seller_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (brand_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (domain_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (category_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (initial_price) — INT
  • Field2 (final_price) — INT
  • Field2 (image) — TEXT
  • Field (product_promotions) — TEXT
  • Field (mpn)
  • Field (color_combines)
  • Field (product_description)
  • Field (reviews)
  • Field2 (url)
  • Field (rating)
  • Field (currency)