ㄹㄹㄹ

Tables (10)

brands

  • brand_id — INT — Primary key — NOT NULL — PK
  • brand — VARCHAR(255) — NOT NULL — 브랜드명 (nobrand_N = 미등록 브랜드)

categories

  • category_id — INT — Primary key — NOT NULL — PK
  • level1 — VARCHAR(255) — 대카테고리 (breadcrumb0)
  • level2 — VARCHAR(255) — 중카테고리 (breadcrumb1)
  • level3 — VARCHAR(255) — 소카테고리 (breadcrumb2)

product_colors

  • color_id — INT — Primary key — NOT NULL — PK
  • product_id — INT — Foreign key → products.id — NOT NULL — FK → products.id
  • color_name — VARCHAR(100) — NOT NULL — 색상명

product_descriptions

  • desc_id — INT — Primary key — NOT NULL — PK
  • product_id — INT — Foreign key → products.id — NOT NULL — FK → products.id (상품당 1개)
  • description — TEXT — 상품 상세 설명

product_promotions

  • promotion_id — INT — Primary key — NOT NULL — PK
  • product_id — INT — Foreign key → products.id — NOT NULL — FK → products.id
  • promotion_name — VARCHAR(255) — NOT NULL — 프로모션명

product_specifications

  • spec_id — INT — Primary key — NOT NULL — PK
  • product_id — INT — Foreign key → products.id — NOT NULL — FK → products.id
  • spec_name — VARCHAR(255) — 스펙 항목명 (예: Merek, SKU)
  • spec_value — TEXT — 스펙 값

product_variations

  • variation_id — INT — Primary key — NOT NULL — PK
  • product_id — INT — Foreign key → products.id — NOT NULL — FK → products.id
  • variation_name — VARCHAR(255) — 변형 이름 (예: 색상, 용량)
  • variation_value — VARCHAR(255) — 변형 값 (예: Red, 128GB)

product_warranties

  • warranty_id — INT — Primary key — NOT NULL — PK
  • product_id — INT — Foreign key → products.id — NOT NULL — FK → products.id
  • policy — VARCHAR(255) — NOT NULL — 반품/보증 정책 항목

products

  • id — INT — Primary key — NOT NULL — PK
  • sku — VARCHAR(100) — SKU 코드
  • mpn — BIGINT — 상품 고유번호 (색상 변형 공유)
  • title — TEXT — NOT NULL — 상품명 (NOT NULL)
  • initial_price — FLOAT — 원래 가격 원본 통화 (CHECK >= 0)
  • final_price — FLOAT — 최종 가격 원본 통화 (CHECK >= 0)
  • currency — VARCHAR(10) — 통화 (IDR/MYR/PHP/SGD/THB)
  • price_krw — INT — 최종가격 KRW 환산 (전처리 추가)
  • initial_price_krw — INT — 원래가격 KRW 환산 (전처리 추가)
  • rating — FLOAT — 상품 평점 (0~5, NULL=리뷰없음)
  • reviews — INT — NOT NULL — 리뷰 수
  • number_sold — INT — NOT NULL — 판매량
  • gmv — FLOAT — 총 거래액 IDR 기준
  • color — VARCHAR(100) — 이 행의 색상 (NULL 가능, 50% 결측)
  • domain — VARCHAR(100) — 국가 도메인 (예: lazada.com.my)
  • url — TEXT — 상품 URL
  • image — TEXT — 상품 이미지 URL (JSON 배열)
  • seller_id — INT — Foreign key → sellers.seller_id — FK → sellers.seller_id
  • brand_id — INT — Foreign key → brands.brand_id — FK → brands.brand_id
  • category_id — INT — Foreign key → categories.category_id — FK → categories.category_id

sellers

  • seller_id — INT — Primary key — NOT NULL — PK
  • seller_name — VARCHAR(255) — NOT NULL — 셀러명
  • seller_ratings — FLOAT — 셀러 평점 (0~1, NULL 가능)
  • seller_ship_on_time — VARCHAR(10) — 정시배송률 (예: 100%, NULL 가능)
  • seller_chat_response — VARCHAR(10) — 채팅 응답률 (예: 99%, NULL 가능)
  • is_super_seller — TINYINT — NOT NULL — 슈퍼셀러 여부 (1=슈퍼, 0=일반)
  • lazmall — TINYINT — NOT NULL — 라자다몰 입점 (1=입점, 0=미입점)