Lazada ERD v2
Tables (4)
brands
- id — INT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
categories
- id — INT — Primary key — NOT NULL
- level1 — VARCHAR(255)
- level2 — VARCHAR(255)
- level3 — VARCHAR(255)
products
- id — INT — Primary key — NOT NULL
- sku — VARCHAR(100) — NOT NULL
- mpn — VARCHAR(100)
- title — TEXT — NOT NULL
- url — TEXT
- currency — VARCHAR(10)
- initial_price — DECIMAL(20,2)
- final_price — DECIMAL(20,2) — NOT NULL
- discount_rate — DECIMAL(5,2)
- rating — DECIMAL(3,2)
- reviews — INT
- number_sold — INT
- gmv — DECIMAL(20,2)
- colors — TEXT
- color — VARCHAR(255)
- product_description — TEXT
- returns_and_warranty — TEXT
- seller_id — INT — Foreign key → sellers.id
- brand_id — INT — Foreign key → brands.id
- category_id — INT — Foreign key → categories.id
sellers
- id — INT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- rating — DECIMAL(4,2)
- ship_on_time — DECIMAL(4,2)
- chat_response — DECIMAL(4,2)
- is_super_seller — TINYINT(1)
- is_lazmall — TINYINT(1)
- domain — VARCHAR(100)