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