SQLite Web: db.sqlite

id

Primary key. INTEGER

source

TEXT NOT NULL

payload

{"timeStamp":"2025-12-26T22:39:43Z","booking":{"id":80003208,"masterId":null,"bookingGroup":null,"propertyId":131309,"roomId":293386,"unitId":1,"roomQty":1,"offerId":0,"status":"confirmed","subStatus":"none","arrival":"2025-12-26","departure":"2025-12-27","numAdult":1,"numChild":0,"title":"","firstName":"Marc","lastName":"Mannari","email":"","phone":"33688302199","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":"HM4CTM3J8K","allowChannelUpdate":"all","allowAutoAction":"enable","allowReview":"default","allowCancellation":{"type":"propertyDefault"},"invoiceeId":null,"bookingTime":"2025-12-26T22:13:35Z","modifiedTime":"2025-12-26T22:37:13Z","cancelTime":null,"price":61.04,"deposit":0,"tax":0,"commission":13.96,"rateDescription":"Cancel policy flexible\nBase Price 75 EUR\nAIRBNB Taxe de Sejour (Fr - Saint-pierre (219722253)) 1.88 EUR\nAIRBNB Taxe Additionnelle Departementale (Fr - Saint-pierre (219722253)) 0.19 EUR\nHost Fee -13.96 EUR\nExpected Payout Amount 61.04 EUR\n","stripeToken":null,"pcibookingToken":null,"apiMessage":""},"infoItems":[],"invoiceItems":[{"id":142886372,"bookingId":80003208,"type":"charge","subType":8,"description":"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]","status":"","qty":1,"amount":75,"lineTotal":75,"vatRate":0,"invoiceeId":null,"createdBy":72990,"createTime":"2025-12-26T22:37:13Z"},{"id":142886373,"bookingId":80003208,"type":"charge","subType":11,"description":"Host Fee","status":"","qty":1,"amount":-13.96,"lineTotal":-13.96,"vatRate":0.2,"invoiceeId":null,"createdBy":72990,"createTime":"2025-12-26T22:37:13Z"}],"messages":[{"id":129564197,"authorOwnerId":null,"bookingId":80003208,"time":"2025-12-26T22:13:36Z","read":true,"message":"bonjour, avez vous une place pour deux ce soir et la chambre est elle climatisée?\nmerci de votre réponse rapide nous sommes à Saint pierre.","source":"guest"},{"id":129564679,"authorOwnerId":null,"bookingId":80003208,"time":"2025-12-26T22:20:38Z","read":true,"message":"Bonjour,\r\n\r\nEffectivement nous avons de la place ce soir et la chambre est climatisé.\r\n\r\nBien à vous","source":"host"},{"id":129564900,"authorOwnerId":null,"bookingId":80003208,"time":"2025-12-26T22:24:31Z","read":true,"message":"A combien du centre êtes vous à pied","source":"guest"},{"id":129564978,"authorOwnerId":null,"bookingId":80003208,"time":"2025-12-26T22:26:01Z","read":true,"message":"Est ce possible de venir directement  chez vous car impossible d avoir une connexion correcte pour finaliser le paiement ?","source":"guest"},{"id":129565077,"authorOwnerId":null,"bookingId":80003208,"time":"2025-12-26T22:27:16Z","read":true,"message":"Nous sommes sur les hauteurs de Saint-Pierre à 20 minutes à pied du centre ville.","source":"host"},{"id":129565136,"authorOwnerId":null,"bookingId":80003208,"time":"2025-12-26T22:28:26Z","read":true,"message":"Nous préférons que vous régliez votre séjour avant de vous partager les accès au logement.","source":"host"},{"id":129565289,"authorOwnerId":null,"bookingId":80003208,"time":"2025-12-26T22:30:12Z","read":true,"message":"Je comprends mais la connexion n est pas assez stable pour finaliser , j essaie depuis une demi heure!\nMais je peux régler à la personne sur place avant de rentrer sans problème","source":"guest"},{"id":129565735,"authorOwnerId":null,"bookingId":80003208,"time":"2025-12-26T22:38:10Z","read":false,"message":"Normalement cela a fonctionné,  est bon?","source":"guest"}],"retries":0}

TEXT NOT NULL

received_at

DATETIME (default CURRENT_TIMESTAMP

processed

BOOLEAN (default 0

processed_at

DATETIME

error

TEXT

dedupe_key

TEXT

payload_json

{"timeStamp":"2025-12-26T22:39:43Z","booking":{"id":80003208,"masterId":null,"bookingGroup":null,"propertyId":131309,"roomId":293386,"unitId":1,"roomQty":1,"offerId":0,"status":"confirmed","subStatus":"none","arrival":"2025-12-26","departure":"2025-12-27","numAdult":1,"numChild":0,"title":"","firstName":"Marc","lastName":"Mannari","email":"","phone":"33688302199","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":"HM4CTM3J8K","allowChannelUpdate":"all","allowAutoAction":"enable","allowReview":"default","allowCancellation":{"type":"propertyDefault"},"invoiceeId":null,"bookingTime":"2025-12-26T22:13:35Z","modifiedTime":"2025-12-26T22:37:13Z","cancelTime":null,"price":61.04,"deposit":0,"tax":0,"commission":13.96,"rateDescription":"Cancel policy flexible\nBase Price 75 EUR\nAIRBNB Taxe de Sejour (Fr - Saint-pierre (219722253)) 1.88 EUR\nAIRBNB Taxe Additionnelle Departementale (Fr - Saint-pierre (219722253)) 0.19 EUR\nHost Fee -13.96 EUR\nExpected Payout Amount 61.04 EUR\n","stripeToken":null,"pcibookingToken":null,"apiMessage":""},"infoItems":[],"invoiceItems":[{"id":142886372,"bookingId":80003208,"type":"charge","subType":8,"description":"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]","status":"","qty":1,"amount":75,"lineTotal":75,"vatRate":0,"invoiceeId":null,"createdBy":72990,"createTime":"2025-12-26T22:37:13Z"},{"id":142886373,"bookingId":80003208,"type":"charge","subType":11,"description":"Host Fee","status":"","qty":1,"amount":-13.96,"lineTotal":-13.96,"vatRate":0.2,"invoiceeId":null,"createdBy":72990,"createTime":"2025-12-26T22:37:13Z"}],"messages":[{"id":129564197,"authorOwnerId":null,"bookingId":80003208,"time":"2025-12-26T22:13:36Z","read":true,"message":"bonjour, avez vous une place pour deux ce soir et la chambre est elle climatisée?\nmerci de votre réponse rapide nous sommes à Saint pierre.","source":"guest"},{"id":129564679,"authorOwnerId":null,"bookingId":80003208,"time":"2025-12-26T22:20:38Z","read":true,"message":"Bonjour,\r\n\r\nEffectivement nous avons de la place ce soir et la chambre est climatisé.\r\n\r\nBien à vous","source":"host"},{"id":129564900,"authorOwnerId":null,"bookingId":80003208,"time":"2025-12-26T22:24:31Z","read":true,"message":"A combien du centre êtes vous à pied","source":"guest"},{"id":129564978,"authorOwnerId":null,"bookingId":80003208,"time":"2025-12-26T22:26:01Z","read":true,"message":"Est ce possible de venir directement  chez vous car impossible d avoir une connexion correcte pour finaliser le paiement ?","source":"guest"},{"id":129565077,"authorOwnerId":null,"bookingId":80003208,"time":"2025-12-26T22:27:16Z","read":true,"message":"Nous sommes sur les hauteurs de Saint-Pierre à 20 minutes à pied du centre ville.","source":"host"},{"id":129565136,"authorOwnerId":null,"bookingId":80003208,"time":"2025-12-26T22:28:26Z","read":true,"message":"Nous préférons que vous régliez votre séjour avant de vous partager les accès au logement.","source":"host"},{"id":129565289,"authorOwnerId":null,"bookingId":80003208,"time":"2025-12-26T22:30:12Z","read":true,"message":"Je comprends mais la connexion n est pas assez stable pour finaliser , j essaie depuis une demi heure!\nMais je peux régler à la personne sur place avant de rentrer sans problème","source":"guest"},{"id":129565735,"authorOwnerId":null,"bookingId":80003208,"time":"2025-12-26T22:38:10Z","read":false,"message":"Normalement cela a fonctionné,  est bon?","source":"guest"}],"retries":0}

TEXT

Update row 56 in inbox_raw