Trendit
Tables (5)
product
- Key — Primary key — NOT NULL
- product_id — VARCHAR(50)
- user_id — VARCHAR(100)
- category — VARCHAR(50)
- price — DOUBLE
product_ctr_stat
- product_id — VARCHAR(50)
- window_start — TIMESTAMP
- window_end — TIMESTAMP
- impressions — INT
- purchases — INT
- ctr — DOUBLE
top_product_stat
- product_id — VARCHAR(50)
- window_start — TIMESTAMP
- window_end — TIMESTAMP
- purchase_count — INT
- revenue — DOUBLE
user
- user_id — VARCHAR(20) — Primary key — NOT NULL
- age — INT
- gender — VARCHAR(10)
- region — VARCHAR(50)
- name — VARCHAR(30)
user_event
- event_id — UUID
- user_id — VARCHAR(50)
- product_id — VARCHAR(50)
- event_type — VARCHAR(20)
- price — DOUBLE
- comment — TEXT — EX
- ts — TIMESTAMP