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