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