데이터 파이프라인

테이블 (5)

dim_category (Untitled2)

  • category_uid (Key) — INTEGER — 기본 키 — NOT NULL
  • platform (Field) — STRING
  • original_category (Field2) — STRING
  • standard_category (Field3) — STRING

dim_date (Untitled4)

  • date (Key) — DATE — 기본 키 — NOT NULL
  • year (Field) — INTEGER
  • quarter (Field2) — STRING
  • month (Field3) — INTEGER
  • month_name (Field4) — STRING
  • day (Field5) — INTEGER
  • day_of_week (Field6) — STRING
  • day_of_week_num (Field7) — INTEGER
  • is_weekend (Field8) — BOOLEAN
  • week (Field9) — INTEGER
  • yyyymm (Field10) — INTEGER

dim_platform (Untitled3)

  • platform_id (Key) — INTEGER — 기본 키 — NOT NULL
  • platform (Field) — STRING
  • description (Field4) — STRING
  • homepage_url (Field3) — STRING
  • platform_eng (Field2) — STRING
  • platform_type (Field5) — STRING
  • owner (Field6) — STRING
  • launch_year (Field7) — INTEGER
  • is_mobile_app (Field8) — BOOLEAN

fact_products (Untitled)

  • product_uid (Key) — STRING — 기본 키 — NOT NULL
  • product_id (Field) — STRING
  • name (Field2) — STRING
  • brand (Field3) — STRING
  • price (Field4) — INTEGER
  • rating (Field5) — FLOAT
  • review_count (Field6) — INTEGER
  • category (Field7) — STRING
  • platform (Field8) — STRING
  • scraped_at (Field9) — TIMESTAMP

fact_reviews (Untitled5)

  • review_uid (Key) — STRING — 기본 키 — NOT NULL
  • review_id (Field) — STRING
  • product_id (Field2) — STRING
  • star (Field3) — INTEGER
  • content (Field4) — STRING
  • created_at (Field5) — DATE
  • category (Field6) — STRING
  • platform (Field7) — STRING
  • scraped_at (Field9) — TIMESTAMP