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