🔍 Checking Snapshot Table Schema
Date: 2025-11-05 03:48:36

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 241306: 2025-11-15 23:00:00, D0.00, 3 tix, 1 tables, £141.97
- Event 254123: 2025-11-15 23:00:00, D0.00, 0 tix, 0 tables, £0.00
- Event 254065: 2025-11-15 23:00:00, D0.00, 4 tix, 1 tables, £159.96
- Event 241306: 2025-11-14 23:00:00, D1.00, 3 tix, 1 tables, £141.97
- Event 254123: 2025-11-14 23:00:00, D1.00, 0 tix, 0 tables, £0.00

✅ Schema check complete.