hp

Tables (7)

Brand (Untitled)

  • Key — Primary key — NOT NULL
  • Field

brand (브랜드 ( 검색어 ))

  • id (Key) — LONG — Primary key — NOT NULL
  • brand_id (Field8) — LONG — NOT NULL
  • name (Field) — VARCHAR — NOT NULL
  • is_coupang_searchable (Field2) — BOOLEAN — NOT NULL
  • is_naver_searchable (Field3) — BOOLEAN — NOT NULL
  • created_at (Field4) — DATETIME — NOT NULL
  • updated_at (Field5) — DATETIME — NOT NULL
  • is_public (Field6) — BOOLEAN — NOT NULL
  • is_deleted (Field7) — BOOLEAN — NOT NULL

category (카테고리)

  • id (Key) — LONG — Primary key — NOT NULL
  • parent_id (Key2) — LONG — Foreign key → category.id — NOT NULL
  • pc_category_id (Field8) — LONG — NOT NULL
  • mobile_category_id (Field11) — LONG — NOT NULL
  • name (Field) — VARCHAR — NOT NULL
  • description (Field6) — VARCHAR — NOT NULL
  • interval_hours (Field7) — LONG — NOT NULL
  • deps (Field9) — LONG — NOT NULL
  • url (Field10) — VARCHAR — NOT NULL
  • created_at (Field2) — DATETIME — NOT NULL
  • updated_at (Field3) — DATETIME — NOT NULL
  • is_public (Field4) — BOOLEAN — NOT NULL
  • is_deleted (Field5) — BOOLEAN — NOT NULL

category_mobile (모바일 카테고리)

  • id (Key) — LONG — Primary key — NOT NULL
  • category_id (Field) — LONG — NOT NULL
  • link_code (Field2) — LONG — NOT NULL
  • name (Field3) — VARCHAR — NOT NULL
  • description (Field4) — VARCHAR — NOT NULL
  • url (Field5) — VARCHAR — NOT NULL
  • deps (Field6) — LONG — NOT NULL
  • interval_hours (Field7) — LONG — NOT NULL
  • parent_id (Field8) — LONG — NOT NULL

category_pc (데스크탑 카테고리)

  • id (Key) — LONG — Primary key — NOT NULL
  • category_id (Field8) — LONG — NOT NULL
  • name (Field) — VARCHAR — NOT NULL
  • description (Field6) — VARCHAR — NOT NULL
  • interval_hours (Field7) — LONG — NOT NULL
  • deps (Field9) — LONG — NOT NULL
  • url (Field10) — VARCHAR — NOT NULL
  • created_at (Field2) — DATETIME — NOT NULL
  • updated_at (Field3) — DATETIME — NOT NULL
  • is_public (Field4) — BOOLEAN — NOT NULL
  • is_deleted (Field5) — BOOLEAN — NOT NULL
  • parent_id (Field11) — LONG — NOT NULL

coupang_product_staging (쿠팡 상품 임시저장)

  • Id (Key) — LONG — Primary key — NOT NULL
  • category_id (Field22) — LONG — NOT NULL
  • type (Field) — ENUM — NOT NULL
  • name (Field3) — VARCHAR — NOT NULL
  • price (Field2) — LONG — NOT NULL
  • price_per_unit (Field20) — LONG — NOT NULL
  • etc (Field4) — VARCHAR — NOT NULL
  • quantity (Field9) — INT — NOT NULL
  • review_cnt (Field21) — INT — NOT NULL
  • review_point_avg (Field8) — DOUBLE — NOT NULL
  • url (Field11) — VARCHAR — NOT NULL
  • image (Field12) — VARCHAR — NOT NULL
  • is_action_required (Field10) — BOOLEAN — NOT NULL
  • unit_amount (Field6) — INT — NOT NULL
  • unit_type (Field7) — ENUM — NOT NULL

naver_product_staging (네이버 상품 임시저장)

  • Id (Key) — LONG — Primary key — NOT NULL
  • category_id (Field22) — LONG — NOT NULL
  • brand_id (Field15) — LONG — NOT NULL
  • brand_name (Field16) — VARCHAR — NOT NULL
  • type (Field) — ENUM — NOT NULL
  • is_super_point (Field10) — BOOLEAN — NOT NULL
  • code (Field5) — VRACHAR — NOT NULL
  • name (Field3) — VARCHAR — NOT NULL
  • normal_price (Field2) — LONG — NOT NULL
  • delivery_fee (Field14) — LONG — NOT NULL
  • delivery_price (Field20) — LONG — NOT NULL
  • unit_amount (Field6) — INT — NOT NULL
  • unit_type (Field7) — ENUM — NOT NULL
  • review_cnt (Field21) — INT — NOT NULL
  • review_point_avg (Field8) — DOUBLE — NOT NULL
  • etc (Field4) — VARCHAR — NOT NULL
  • quantity (Field9) — INT — NOT NULL
  • pc_url (Field11) — VARCHAR — NOT NULL
  • mobile_url (Field13) — VARCHAR — NOT NULL
  • image (Field12) — VARCHAR — NOT NULL