dd

Tables (12)

Brands

  • brand_id — INT — Primary key — NOT NULL — brand_id
  • brand_name — VARCHAR(100) — NOT NULL — 브랜드명

Categories

  • category_id — INT — Primary key — NOT NULL — category_id
  • breadcrumb_path — TEXT — NOT NULL — 카테고리 경로
  • primary_category — VARCHAR(100) — 대분류
  • sub_category — VARCHAR(100) — 소분류

Domains

  • domain_id — INT — Primary key — NOT NULL — domain_id
  • domain_name — VARCHAR(100) — NOT NULL — 도메인 주소
  • country_code — VARCHAR(10) — 국가 코드

Product_Content

  • content_id — BIGINT — Primary key — NOT NULL — content_id
  • product_id — BIGINT — Foreign key → Products.product_id — NOT NULL — product_id
  • product_specifications — LONGTEXT — 상세 스펙
  • product_description — LONGTEXT — 상세 설명

Product_Images

  • image_id — BIGINT — Primary key — NOT NULL — image_id
  • product_id — BIGINT — Foreign key → Products.product_id — NOT NULL — product_id
  • image_url — TEXT — NOT NULL — 이미지 URL
  • is_main — BOOLEAN — 대표 이미지 여부

Product_Metrics

  • metric_id — BIGINT — Primary key — NOT NULL — metric_id
  • product_id — BIGINT — Foreign key → Products.product_id — NOT NULL — product_id
  • rating — DECIMAL(3, 2) — 상품 평점
  • reviews_count — INT — 리뷰 수
  • number_sold — INT — 판매 수량
  • gmv — DECIMAL(20, 2) — 총 거래액
  • updated_at — TIMESTAMP — updated_at

Product_Prices

  • price_id — BIGINT — Primary key — NOT NULL — price_id
  • product_id — BIGINT — Foreign key → Products.product_id — NOT NULL — product_id
  • initial_price — DECIMAL(15, 2) — 최초 가격
  • final_price — DECIMAL(15, 2) — 최종 판매 가격
  • currency — VARCHAR(10) — NOT NULL — 통화 단위
  • updated_at — TIMESTAMP — updated_at

Product_Promotions

  • promotion_id — BIGINT — Primary key — NOT NULL — promotion_id
  • product_id — BIGINT — Foreign key → Products.product_id — NOT NULL — product_id
  • promotion_details — TEXT — 프로모션 내용

Product_Skus

  • sku_id — BIGINT — Primary key — NOT NULL — sku_id
  • product_id — BIGINT — Foreign key → Products.product_id — NOT NULL — product_id
  • sku_code — VARCHAR(100) — NOT NULL — sku_code
  • color — VARCHAR(100) — 색상
  • colors_list — TEXT — 색상 목록
  • variations — TEXT — 옵션 종류
  • product_variation — VARCHAR(255) — 상세 옵션

Products

  • product_id — BIGINT — Primary key — NOT NULL — product_id
  • title — VARCHAR(500) — NOT NULL — 상품명
  • url — TEXT — NOT NULL — 상품 URL
  • mpn — VARCHAR(100) — mpn
  • brand_id — INT — Foreign key → Brands.brand_id — brand_id
  • seller_id — INT — Foreign key → Sellers.seller_id — NOT NULL — seller_id
  • category_id — INT — Foreign key → Categories.category_id — category_id
  • domain_id — INT — Foreign key → Domains.domain_id — domain_id
  • lazmall — BOOLEAN — 라자몰 입점 여부
  • created_at — TIMESTAMP — created_at

Seller_Warranties

  • warranty_id — BIGINT — Primary key — NOT NULL — warranty_id
  • product_id — BIGINT — Foreign key → Products.product_id — NOT NULL — product_id
  • returns_and_warranty — TEXT — 보증 및 반품 조건

Sellers

  • seller_id — INT — Primary key — NOT NULL — seller_id
  • seller_name — VARCHAR(255) — NOT NULL — 판매자명
  • seller_rating — DECIMAL(5, 2) — 판매자 평점
  • seller_ship_on_time — VARCHAR(50) — 정시 배송율
  • seller_chat_response — VARCHAR(50) — 채팅 응대율
  • is_super_seller — BOOLEAN — 우수 판매자 여부
  • created_at — TIMESTAMP — created_at