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-03-14T15:33:43Z","booking":{"id":83746928,"masterId":null,"bookingGroup":null,"propertyId":131309,"roomId":293387,"unitId":1,"roomQty":1,"offerId":1,"status":"new","subStatus":"none","arrival":"2026-04-05","departure":"2026-04-08","numAdult":2,"numChild":0,"title":"","firstName":"Yann","lastName":"Gudefin","email":"","phone":"33664873940","mobile":"","fax":"","company":"","address":"","city":"","state":"","postcode":"","country":"","country2":null,"arrivalTime":"","voucher":"","comments":"","notes":"","message":"","groupNote":"","custom1":"","custom2":"","custom3":"","custom4":"","custom5":"","custom6":"","custom7":"","custom8":"","custom9":"","custom10":"","flagColor":"","flagText":"","statusCode":0,"lang":"fr","referer":"kapokier972","refererEditable":"kapokier972","reference":"","channel":"direct","apiSourceId":0,"apiSource":"Direct","apiReference":"","allowChannelUpdate":"all","allowAutoAction":"enable","allowReview":"default","allowCancellation":{"type":"propertyDefault"},"invoiceeId":null,"bookingTime":"2026-03-14T15:03:34Z","modifiedTime":"2026-03-14T15:28:25Z","cancelTime":null,"price":240,"deposit":0,"tax":0,"commission":0,"rateDescription":"Offre 1, \r\n2026-04-05 80 Goyave plan, \r\n2026-04-06 80 Goyave plan,","stripeToken":null,"pcibookingToken":null,"apiMessage":""},"infoItems":[],"invoiceItems":[{"id":151270938,"bookingId":83746928,"type":"charge","subType":1,"description":"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]","status":"","qty":1,"amount":240,"lineTotal":240,"vatRate":0,"invoiceeId":null,"createdBy":72990,"createTime":"2026-03-14T15:03:34Z"}],"messages":[],"retries":0}

TEXT

should_notify

BOOLEAN (default 0

notified_at

DATETIME

Update row 191 in events