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)