lazada3

Tables (5)

brands

  • id — INT — Primary key — NOT NULL — 브랜드명
  • name — VARCHAR(255) — NOT NULL — 카테고리ID

categories

  • id — INT — Primary key — NOT NULL — 중분류
  • level1 — VARCHAR(255) — NOT NULL — 소분류
  • level2 — VARCHAR(255) — 상품ID
  • level3 — VARCHAR(255) — SKU코드

product_specs

  • id — INT — Primary key — NOT NULL

products

  • id — INT — Primary key — NOT NULL — 상품명
  • sku — VARCHAR(100) — 상품URL
  • mpn — VARCHAR(100) — 이미지목록
  • title — VARCHAR(500) — NOT NULL — 최초가격
  • url — VARCHAR(1000) — 최종판매가
  • image — TEXT — 통화
  • initial_price — DECIMAL(15, 2) — 최초가격KRW
  • final_price — DECIMAL(15, 2) — 최종가격KRW
  • currency — VARCHAR(10) — 할인율
  • initial_price_krw — DECIMAL(15, 2) — 평점
  • final_price_krw — DECIMAL(15, 2) — 리뷰수
  • discount_rate_pct — DECIMAL(5, 2) — 판매량
  • rating — DECIMAL(3, 2) — 총거래액
  • reviews — INT — 총거래액KRW
  • number_sold — INT — 대표색상
  • gmv — DECIMAL(18, 2) — 색상목록
  • gmv_krw — DECIMAL(18, 2) — 옵션목록
  • color — VARCHAR(100) — 선택된옵션
  • colors — TEXT — 반품및보증
  • variations — TEXT — 프로모션
  • product_variation — VARCHAR(255) — 도메인
  • returns_and_warranty — TEXT — 상품설명
  • promotions — TEXT — 판매자ID
  • domain — VARCHAR(255) — 브랜드ID
  • product_description — TEXT — 카테고리ID
  • seller_id — INT — Foreign key → sellers.id — 사양ID
  • brand_id — INT — Foreign key → brands.id — 상품ID
  • category_id — INT — Foreign key → categories.id — 사양항목명

sellers

  • id — INT — Primary key — NOT NULL — 판매자ID
  • name — VARCHAR(255) — NOT NULL — 판매자명
  • rating — DECIMAL(3, 2) — 판매자평점
  • ship_on_time — VARCHAR(50) — 정시배송률
  • chat_response — VARCHAR(50) — 채팅응답률
  • is_super_seller — TINYINT — 슈퍼셀러여부
  • is_lazmall — TINYINT — 라즈몰여부