analytics_events table structure: -------------------------------------------------------------------------------- Field Type Null Key Default Extra -------------------------------------------------------------------------------- id int NO PRI NULL auto_increment event_type varchar(50) NO MUL NULL item_id int YES MUL NULL device_id varchar(255) YES NULL user_agent text YES NULL ip_address varchar(45) YES NULL referrer varchar(255) YES created_at timestamp NO MUL CURRENT_TIMESTAMP DEFAULT_GENERATED app_version varchar(50) YES 1.0.0 platform varchar(50) YES unknown webview_urls table structure: -------------------------------------------------------------------------------- Field Type Null Key Default Extra -------------------------------------------------------------------------------- id int NO PRI NULL auto_increment url varchar(500) NO NULL title varchar(255) YES NULL description text YES NULL thumbnail_url varchar(255) YES NULL is_active tinyint(1) YES 1 created_at timestamp YES CURRENT_TIMESTAMP DEFAULT_GENERATED updated_at timestamp YES CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP view_count int NO 0 last_viewed timestamp YES NULL Most recent analytics events: -------------------------------------------------------------------------------- ID: 6707, Type: app_open, Item ID: 1, Device: QKR1.19124..., Date: 2026-04-19 20:44:32 ID: 6706, Type: app_open, Item ID: 1, Device: QKR1.19124..., Date: 2026-04-19 20:43:20 ID: 6705, Type: card_view, Item ID: 244, Device: QKR1.19124..., Date: 2026-04-19 20:42:59 ID: 6704, Type: webview_open, Item ID: 244, Device: QKR1.19124..., Date: 2026-04-19 20:42:59 ID: 6703, Type: app_open, Item ID: 1, Device: QKR1.19124..., Date: 2026-04-19 20:42:58