SQLite Web: db.sqlite

Update row 210 in events

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-21T23:10:32Z","booking":{"id":84061336,"masterId":null,"bookingGroup":null,"propertyId":131309,"roomId":293385,"unitId":1,"roomQty":1,"offerId":0,"status":"confirmed","subStatus":"none","arrival":"2026-03-21","departure":"2026-03-22","numAdult":2,"numChild":0,"title":"","firstName":"Julia","lastName":"Vercruysse","email":"","phone":"33616410515","mobile":"","fax":"","company":"","address":"","city":"","state":"","postcode":"","country":"fr","country2":"FR","arrivalTime":"","voucher":"","comments":"","notes":"","message":"","groupNote":"","custom1":"","custom2":"","custom3":"","custom4":"","custom5":"","custom6":"","custom7":"","custom8":"","custom9":"","custom10":"","flagColor":"ffaad4","flagText":"","statusCode":0,"lang":"fr","referer":"Airbnb","refererEditable":"Airbnb","reference":"","channel":"airbnb","apiSourceId":46,"apiSource":"Airbnb","apiReference":"HMYFM8BS9B","allowChannelUpdate":"all","allowAutoAction":"enable","allowReview":"default","allowCancellation":{"type":"propertyDefault"},"invoiceeId":null,"bookingTime":"2026-03-20T22:39:45Z","modifiedTime":"2026-03-20T22:52:05Z","cancelTime":null,"price":70.81,"deposit":0,"tax":0,"commission":16.19,"rateDescription":"Cancel policy flexible\nBase Price 87 EUR\nAIRBNB Taxe de Sejour (Fr - Saint-pierre (219722253)) 3.04 EUR\nAIRBNB Taxe Additionnelle Departementale (Fr - Saint-pierre (219722253)) 0.30 EUR\nHost Fee -16.19 EUR\nExpected Payout Amount 70.81 EUR\n","stripeToken":null,"pcibookingToken":null,"apiMessage":""},"infoItems":[],"invoiceItems":[{"id":151918730,"bookingId":84061336,"type":"charge","subType":8,"description":"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]","status":"","qty":1,"amount":87,"lineTotal":87,"vatRate":0,"invoiceeId":null,"createdBy":null,"createTime":"2026-03-20T22:39:45Z"},{"id":151918731,"bookingId":84061336,"type":"charge","subType":11,"description":"Host Fee","status":"","qty":1,"amount":-16.19,"lineTotal":-16.19,"vatRate":0.2,"invoiceeId":null,"createdBy":null,"createTime":"2026-03-20T22:39:45Z"}],"messages":[{"id":140075143,"authorOwnerId":null,"bookingId":84061336,"time":"2026-03-20T22:39:51Z","read":false,"message":"bonjour , \nnous souhaitons passer un week end a saint pierre","source":"guest"},{"id":140077060,"authorOwnerId":null,"bookingId":84061336,"time":"2026-03-20T23:01:54Z","read":true,"message":"The Kapokier\n\nJulia,\n\nMerci pour votre réservation, vous pouvez contacter Eliane au sujet de votre heure d'arrivée au 0696 52 28 09. \nSi non disponible, Sonia saura vous répondre au 0696 39 40 76\n\nBon séjour ! N'hésitez pas à laisser un commentaire sur airbnb.fr\n\nCarl","source":"host"},{"id":140167419,"authorOwnerId":null,"bookingId":84061336,"time":"2026-03-21T13:35:45Z","read":false,"message":"Bonjour \nConcernant l’adresse exact numero de porte etc puis -je l’avoir ? Et a partir de quel h et t’il possible d’integrer le logement car vos contact ne mon pas encore répondu merci","source":"guest"},{"id":140193340,"authorOwnerId":null,"bookingId":84061336,"time":"2026-03-21T17:33:23Z","read":true,"message":"Bonjour Julie,\n\nL’adresse du logement est la suivante :\n15 lotissement Saint James, 97250 Saint-Pierre.\n\nLes arrivées (check-in) se font à partir de 17h.\n\nVoici les instructions pour récupérer les clés :\n\t•\tLes clés se trouvent dans une boîte blanche posée sur le banc de la véranda (le banc situé sous la fenêtre).\n\t•\tMerci de prendre les clés correspondant au nom de votre chambre.\n\t•\tIl y a deux clés :\n\t•\tune clé plate pour la porte d’entrée principale,\n\t•\tune clé pour votre chambre.\n\t•\tPour ouvrir la porte principale, insérez la clé horizontalement.\n\nConcernant le stationnement, merci de ne pas vous garer entre les pots de fleurs sur le trottoir afin de ne pas gêner la sortie du véhicule du voisin.\n\nJe vous souhaite un excellent séjour.","source":"host"},{"id":140193786,"authorOwnerId":null,"bookingId":84061336,"time":"2026-03-21T17:39:23Z","read":false,"message":"Je vous remercie il n’est pas possible de rentrée dans le logement vers 15h 30 16h car nous venons de loin et aimerez nous reposer ce serai super gentils de votre part d’accepter","source":"guest"}],"retries":0}

TEXT

should_notify

BOOLEAN (default 0

notified_at

DATETIME

Cancel