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