데이터 파이프라인
테이블 (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