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: 6678, Type: app_open, Item ID: 1, Device: TP1A.22062..., Date: 2026-04-12 10:36:00 ID: 6677, Type: view, Item ID: 1, Device: test-devic..., Date: 2026-04-09 19:07:45 ID: 6676, Type: view, Item ID: 1, Device: test-devic..., Date: 2026-04-09 13:46:29 ID: 6675, Type: card_view, Item ID: 240, Device: T1SSIS33.1..., Date: 2026-04-06 17:58:20 ID: 6674, Type: app_open, Item ID: 1, Device: T1SSIS33.1..., Date: 2026-04-06 17:58:17