CREATE TABLE bookings  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  external_id TEXT UNIQUE,
  property_id TEXT NOT NULL,
  room_id TEXT NOT NULL,
  room_name TEXT NOT NULL,
  guest_name TEXT NOT NULL,
  guest_email TEXT,
  guest_phone TEXT,
  check_in DATE NOT NULL,
  check_out DATE NOT NULL,
  total_price DECIMAL(10,2),
  status TEXT DEFAULT 'pending',
  group_id TEXT,
  group_type TEXT,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  notification_sent BOOLEAN DEFAULT 0,
  notification_type TEXT,
  notification_last_status TEXT,
  is_test_data BOOLEAN DEFAULT 0
)