ㄹㄹㄹ
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=미입점)