🔍 Checking Snapshot Table Schema
Date: 2025-12-17 05:28:13

Table: wp_coco_event_snapshots
Columns:
- id (bigint unsigned)
- event_id (bigint unsigned)
- snapshot_ts (datetime)
- days_to_event (decimal(5,2))
- tickets_sold (int)
- tables_sold (int)
- revenue_to_date (decimal(12,2))
- forecast_attendance_p50 (int)
- forecast_revenue_p50 (decimal(12,2))

Sample data (last 5 records):
- Event 273490: 2025-12-25 23:00:00, D0.00, 0 tix, 0 tables, £0.00
- Event 273490: 2025-12-24 23:00:00, D1.00, 0 tix, 0 tables, £0.00
- Event 273490: 2025-12-23 23:00:00, D2.00, 0 tix, 0 tables, £0.00
- Event 273490: 2025-12-22 23:00:00, D3.00, 0 tix, 0 tables, £0.00
- Event 263947: 2025-12-22 23:00:00, D-1.00, 0 tix, 0 tables, £0.00

✅ Schema check complete.