ERD Test
Tables (5)
brands
- id — INT — Primary key — NOT NULL
- name — VARCHAR(150) — NOT NULL
categories
- id — INT — Primary key — NOT NULL
- level1 — VARCHAR(100) — NOT NULL
- level2 — VARCHAR(100)
- level3 — VARCHAR(100)
product_specs
- id — INT — Primary key — NOT NULL
- product_id — INT — Foreign key → products.id — NOT NULL
- spec_key — VARCHAR(150) — NOT NULL
- spec_value — VARCHAR(500) — NOT NULL
products
- id — INT — Primary key — NOT NULL
- sku — VARCHAR(100)
- mpn — VARCHAR(100)
- title — VARCHAR(500) — NOT NULL
- url — VARCHAR(1000)
- initial_price — DECIMAL(15,2)
- final_price — DECIMAL(15,2) — NOT NULL
- currency — VARCHAR(10) — NOT NULL
- rating — DECIMAL(3,2)
- reviews — INT — NOT NULL
- number_sold — INT — NOT NULL
- gmv — DECIMAL(20,2) — NOT NULL
- promotions — VARCHAR(500)
- warranty — VARCHAR(200)
- colors — VARCHAR(300)
- variations — VARCHAR(500)
- seller_id — INT — Foreign key → sellers.id — NOT NULL
- brand_id — INT — Foreign key → brands.id
- category_id — INT — Foreign key → categories.id
sellers
- id — INT — Primary key — NOT NULL
- name — VARCHAR(200) — NOT NULL
- rating — DECIMAL(3,2)
- ship_on_time — VARCHAR(10)
- chat_response — VARCHAR(10)
- is_super_seller — TINYINT(1) — NOT NULL
- is_lazmall — TINYINT(1) — NOT NULL