LAZADA_test1

테이블 (16)

categories (카테고리 경로)

  • categories_id (PK) — VARCHAR(50) — 기본 키 — NOT NULL
  • breadcrumb (Field) — TEXT
  • category_depth_1 (Field2)
  • category_depth_2 (Field3)
  • category_depth_3 (Field4)

product_images (상품 이미지)

  • image_id (PK) — VARCHAR(50) — 기본 키 — NOT NULL
  • products_id (PK2) — VARCHAR(50) — 외래 키 → products.products_id — NOT NULL
  • seller_id (PK22) — VARCHAR(50) — 외래 키 → products.seller_id — NOT NULL
  • categories_id (PK3) — VARCHAR(50) — 외래 키 → products.categories_id — NOT NULL
  • image (Field) — TEXT

product_metrics (성과/리뷰 지표)

  • product_metrics_id (PK) — VARCHAR(50) — 기본 키 — NOT NULL
  • products_id (PK2) — VARCHAR(50) — 외래 키 → products.products_id — NOT NULL
  • seller_id (PK22) — VARCHAR(50) — 외래 키 → products.seller_id — NOT NULL
  • categories_id (PK3) — VARCHAR(50) — 외래 키 → products.categories_id — NOT NULL
  • rating (Field)
  • reviews (Field2) — INT
  • gmv (Field3)
  • number_sold (Field4) — INT
  • has_review (Field5)
  • rating_for_analysis (Field6)

product_prices (가격 정보)

  • product_prices_id (PK) — VARCHAR(50) — 기본 키 — NOT NULL
  • products_id (PK2) — VARCHAR(50) — 외래 키 → products.products_id — NOT NULL
  • seller_id (PK22) — VARCHAR(50) — 외래 키 → products.seller_id — NOT NULL
  • categories_id (PK3) — VARCHAR(50) — 외래 키 → products.categories_id — NOT NULL
  • initial_price (Field) — DECIMAL(12,2)
  • final_price (Field2) — DECIMAL(12,2)
  • currency (Field3) — VARCHAR(10)
  • discount_amount (Field4) — DECIMAL(12,2)
  • discount_rate (Field5)
  • price_outlier_flag (Field6) — BOOLEAN

product_promotions (프로모션 정보)

  • promotions_id (PK) — VARCHAR(50) — 기본 키 — NOT NULL
  • products_id (PK2) — VARCHAR(50) — 외래 키 → products.products_id — NOT NULL
  • seller_id (PK22) — VARCHAR(50) — 외래 키 → products.seller_id — NOT NULL
  • categories_id (PK3) — VARCHAR(50) — 외래 키 → products.categories_id — NOT NULL
  • promotions (Field) — TEXT

product_specifications (상품사양)

  • product_specifications_id (Key) — VARCHAR(50) — 기본 키 — NOT NULL
  • products_id (PK) — VARCHAR(50) — 외래 키 → products.products_id — NOT NULL
  • seller_id (PK2) — VARCHAR(50) — 외래 키 → products.seller_id — NOT NULL
  • categories_id (PK3) — VARCHAR(50) — 외래 키 → products.categories_id — NOT NULL
  • product_specifications (Field) — TEXT

product_variations (옵션/색상 정보)

  • variations_id (PK) — VARCHAR(50) — 기본 키 — NOT NULL
  • products_id (PK2) — VARCHAR(50) — 외래 키 → products.products_id — NOT NULL
  • seller_id (PK22) — VARCHAR(50) — 외래 키 → products.seller_id — NOT NULL
  • categories_id (PK3) — VARCHAR(50) — 외래 키 → products.categories_id — NOT NULL
  • colors (Field) — TEXT
  • variations (Field2) — TEXT
  • color (Field3)
  • product_variation (Field4) — VARCHAR(255)
  • sku (Field5) — VARCHAR(100)

products (상품정보)

  • products_id (PK) — VARCHAR(50) — 기본 키 — NOT NULL
  • seller_id (PK2) — VARCHAR(50) — 외래 키 → sellers.seller_id — NOT NULL
  • categories_id (PK3) — VARCHAR(50) — 외래 키 → categories.categories_id — NOT NULL
  • url (Field) — TEXT
  • title (Field2) — VARCHAR(500)
  • brand (Field3) — VARCHAR(100)
  • domain (Field4) — VARCHAR(100)
  • lazmall (Field5) — BOOLEAN
  • mpn (Field7) — VARCHAR(100)
  • product_description (Field10) — TEXT
  • brand_clean (Field6) — VARCHAR(255)

returns_warranty (반품/보증 정보)

  • warranty_id (PK) — VARCHAR(50) — 기본 키 — NOT NULL
  • products_id (PK2) — VARCHAR(50) — 외래 키 → products.products_id — NOT NULL
  • seller_id (PK22) — VARCHAR(50) — 외래 키 → products.seller_id — NOT NULL
  • categories_id (PK3) — VARCHAR(50) — 외래 키 → products.categories_id — NOT NULL
  • returns_warranty (Field) — TEXT

sellers (판매자)

  • seller_id (PK) — VARCHAR(50) — 기본 키 — NOT NULL
  • seller_name (Field) — VARCHAR(255)
  • seller_ratings (Field2)
  • seller_ship_on_time (Field3) — DECIMAL(5,2)
  • seller_chat_response (Field4) — DECIMAL(5,2)
  • is_super_seller (Field5) — BOOLEAN

가입일시 (Untitled5)

  • created_at (PK) — 기본 키 — NOT NULL

권한구분 (Untitled4)

  • role (PK) — 기본 키 — NOT NULL
  • admin (Field)
  • user (Field2)

로그인ID (Untitled2)

  • username (PK) — 기본 키 — NOT NULL

비밀번호 (Untitled3)

  • password (PK) — 기본 키 — NOT NULL

상품 변경 이력 (Untitled6)

  • log_id (PK) — 기본 키 — NOT NULL

회원아이디 (Untitled)

  • user_id (PK) — 기본 키 — NOT NULL