SQLite Web: db.sqlite

id

Primary key. INTEGER

event_type

TEXT NOT NULL

entity_type

TEXT NOT NULL

entity_id

TEXT

payload

TEXT

created_at

DATETIME (default CURRENT_TIMESTAMP

processed

BOOLEAN (default 0

processed_at

DATETIME

event_id

TEXT

booking_external_id

TEXT

occurred_at

DATETIME

payload_json

{"timeStamp":"2026-06-28T23:03:32Z","booking":{"id":88983620,"masterId":null,"bookingGroup":null,"propertyId":131309,"roomId":293385,"unitId":0,"roomQty":1,"offerId":0,"status":"new","subStatus":"none","arrival":"2026-06-28","departure":"2026-06-29","numAdult":2,"numChild":0,"title":"","firstName":"Jimmy","lastName":"","email":"","phone":"","mobile":"","fax":"","company":"","address":"","city":"","state":"","postcode":"","country":"","country2":null,"arrivalTime":"","voucher":"","comments":"","notes":"Note: price less than room min price 65.00\n","message":"","groupNote":"","custom1":"","custom2":"","custom3":"","custom4":"","custom5":"","custom6":"","custom7":"","custom8":"","custom9":"","custom10":"","flagColor":"ffaad4","flagText":"","statusCode":0,"lang":"en","referer":"Airbnb","refererEditable":"Airbnb","reference":"","channel":"airbnb","apiSourceId":46,"apiSource":"Airbnb","apiReference":"2579167019","allowChannelUpdate":"all","allowAutoAction":"enable","allowReview":"default","allowCancellation":{"type":"propertyDefault"},"invoiceeId":null,"bookingTime":"2026-06-28T23:03:26Z","modifiedTime":"2026-06-28T23:03:27Z","cancelTime":null,"price":65,"deposit":0,"tax":0,"commission":0,"rateDescription":"Base Price 52.9 \nHost Fee -0.00 \nExpected Payout Amount  \n","stripeToken":null,"pcibookingToken":null,"apiMessage":""},"infoItems":[],"invoiceItems":[{"id":162203259,"bookingId":88983620,"type":"charge","subType":8,"description":"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]","status":"","qty":1,"amount":52.9,"lineTotal":52.9,"vatRate":0,"invoiceeId":null,"createdBy":null,"createTime":"2026-06-28T23:03:26Z"},{"id":162203260,"bookingId":88983620,"type":"charge","subType":11,"description":"Host Fee","status":"","qty":1,"amount":0,"lineTotal":0,"vatRate":0,"invoiceeId":null,"createdBy":null,"createTime":"2026-06-28T23:03:26Z"}],"messages":[{"id":154103590,"authorOwnerId":null,"bookingId":88983620,"time":"2026-06-28T23:03:27Z","read":false,"message":"Bonjour Carl,\nnous sommes un jeune couple traversant la Martinique en itinérance. Nous sommes au Carbet et votre logement nous intéresse pour passer la nuit. \n\nMalheureusement, nous avons un problème de plafond atteint sur notre carte bancaire, Serait-il possible de vous payer en liquide ?\n\nBien cordialement, Jimmy et Marie \n\n(Si vous nous confirmez nous arriverons dans 1heure)","source":"guest"}],"retries":0}

TEXT

should_notify

BOOLEAN (default 0

notified_at

DATETIME

Update row 443 in events