Xreport_output

Tables (4)

Sim agent (sim_agent)

  • Agent pk (agent_pk) — bigserial — Primary key — NOT NULL
  • Run id (run_id) — bigserial — Foreign key → Sim run.Run id — NOT NULL
  • Agent id (agent_id) — varchar(50)
  • Agent name (agent_name) — varchar(100)
  • Age group (age_group) — varchar(20)
  • Gender (gender) — varchar(10)

Sim agent event (sim_agent_event)

  • Event id (event_id) — bigserial — Primary key — NOT NULL
  • ts — timestampz
  • Weekday (weekday) — varchar(10)
  • Time slot (time_slot) — varchar(20)
  • Is active (is_active) — boolean
  • Lat (lat) — numeric(10,7) — NOT NULL
  • Visible stores count (visible_stroes_count) — int — NOT NULL
  • Report recived (report_recived) — blooean — NOT NULL
  • Decision (decision) — varchar(50) — NOT NULL
  • Decision reason (decision_reason) — text — NOT NULL
  • Visited store (visited_store) — varchar(200) — NOT NULL
  • Visited category (visited_category) — varchar(100) — NOT NULL

Sim run (sim_run)

  • Run id (run_id) — bigserial — Primary key — NOT NULL
  • Run name (run_name) — varchar(200)
  • Seed (seed) — int — NOT NULL
  • Start ts (start_ts) — timestampz
  • End ts (end_ts) — timestampz
  • Params (params) — jsonb — NOT NULL
  • Created at (created at) — timestampz

Sim run summary (sim_run_summary)

  • Run summary id (run_summary_id) — bigserial — Primary key — NOT NULL
  • Run id (run_id) — bigserial — Foreign key → Sim run.Run id — NOT NULL
  • Total events (total_events) — bigint
  • Active rate (active rate) — numeric(6,4) — NOT NULL
  • Total visits (total_visits) — bigint — NOT NULL
  • Unique visited stores (unique_visitedu_stores) — int
  • Top category (top_category) — jsonb
  • Time slot distribution (time_slot_distribution) — jsonb
  • Weekday distribution (weekday_distribution) — jsonb
  • Created at (created_at) — timestampz