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