ddd

Tables (6)

brands

  • brand_id — BIGINT — Primary key — NOT NULL
  • brand_name — VARCHAR(255)

categories

  • category_id — BIGINT — Primary key — NOT NULL
  • category_path — VARCHAR(500)

product_stats

  • stat_id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT — Foreign key → products.product_id
  • rating — DECIMAL(3,2)
  • review_count — INT
  • sales_quantity — INT
  • gmv — DECIMAL(15,2)

products

  • product_id — BIGINT — Primary key — NOT NULL
  • product_name — VARCHAR(255)
  • brand_id — BIGINT — Foreign key → brands.brand_id
  • seller_id — BIGINT — Foreign key → sellers.seller_id
  • category_id — BIGINT — Foreign key → categories.category_id
  • list_price — DECIMAL(12,2)
  • final_price — DECIMAL(12,2)
  • currency — VARCHAR(10)
  • color — VARCHAR(100)
  • return_warranty — TEXT
  • selected_option — VARCHAR(255)
  • is_lazmall — BOOLEAN
  • domain — VARCHAR(100)

promotions

  • promotion_id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT — Foreign key → products.product_id
  • promotion_name — VARCHAR(255)

sellers

  • seller_id — BIGINT — Primary key — NOT NULL
  • seller_name — VARCHAR(255)
  • on_time_delivery_rate — DECIMAL(5,2)
  • chat_response_rate — DECIMAL(5,2)
  • is_super_seller — BOOLEAN