sqlite-web 0.7.0
db.sqlite
inbox_raw
Create
Query
bookings
commands
events
inbox_raw
messages
notifications_log
properties_config
raw_webhooks
sqlite_sequence
system_logs
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Update row 190 in inbox_raw
id
Primary key.
INTEGER
source
webhook
TEXT NOT NULL
payload
{"timeStamp":"2026-03-14T14:51:12Z","booking":{"id":83746427,"masterId":null,"bookingGroup":null,"propertyId":131309,"roomId":293385,"unitId":0,"roomQty":1,"offerId":0,"status":"new","subStatus":"none","arrival":"2026-04-05","departure":"2026-04-08","numAdult":5,"numChild":2,"title":"","firstName":"Yann","lastName":"","email":"","phone":"","mobile":"","fax":"","company":"","address":"","city":"","state":"","postcode":"","country":"fr","country2":"FR","arrivalTime":"","voucher":"","comments":"","notes":"Booked Maison Kapokier · House with a beautiful sea's view at Saint-Pierre - 327594\n","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":"HMYXSJPMMD","allowChannelUpdate":"all","allowAutoAction":"enable","allowReview":"default","allowCancellation":{"type":"propertyDefault"},"invoiceeId":null,"bookingTime":"2026-03-14T14:51:07Z","modifiedTime":"2026-03-14T14:51:07Z","cancelTime":null,"price":335.53,"deposit":0,"tax":0,"commission":0,"rateDescription":"Base Price 335.53 \nHost Fee -0.00 \nExpected Payout Amount \n","stripeToken":null,"pcibookingToken":null,"apiMessage":""},"infoItems":[],"invoiceItems":[{"id":151269820,"bookingId":83746427,"type":"charge","subType":8,"description":"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]","status":"","qty":1,"amount":335.53,"lineTotal":335.53,"vatRate":0,"invoiceeId":null,"createdBy":null,"createTime":"2026-03-14T14:51:07Z"},{"id":151269821,"bookingId":83746427,"type":"charge","subType":11,"description":"Host Fee","status":"","qty":1,"amount":0,"lineTotal":0,"vatRate":0,"invoiceeId":null,"createdBy":null,"createTime":"2026-03-14T14:51:07Z"}],"messages":[{"id":139197320,"authorOwnerId":null,"bookingId":83746427,"time":"2026-03-14T14:51:07Z","read":false,"message":"Bonjour, nous sommes une famille de 5 avec 3 enfants de 14, 12 et 6 ans. Nous venons de la métropole et souhaitons découvrir votre magnifique île. Nous sommes intéressés par votre logement afin de découvrir le nord de l’île et ses nombreux atouts. \nEn espérant que votre logement soit disponible. \nYann et Isabelle","source":"guest"}],"retries":0}
TEXT NOT NULL
received_at
DATETIME (default CURRENT_TIMESTAMP
processed
BOOLEAN (default 0
processed_at
DATETIME
error
NULL
TEXT
dedupe_key
7855c521
TEXT
payload_json
{"timeStamp":"2026-03-14T14:51:12Z","booking":{"id":83746427,"masterId":null,"bookingGroup":null,"propertyId":131309,"roomId":293385,"unitId":0,"roomQty":1,"offerId":0,"status":"new","subStatus":"none","arrival":"2026-04-05","departure":"2026-04-08","numAdult":5,"numChild":2,"title":"","firstName":"Yann","lastName":"","email":"","phone":"","mobile":"","fax":"","company":"","address":"","city":"","state":"","postcode":"","country":"fr","country2":"FR","arrivalTime":"","voucher":"","comments":"","notes":"Booked Maison Kapokier · House with a beautiful sea's view at Saint-Pierre - 327594\n","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":"HMYXSJPMMD","allowChannelUpdate":"all","allowAutoAction":"enable","allowReview":"default","allowCancellation":{"type":"propertyDefault"},"invoiceeId":null,"bookingTime":"2026-03-14T14:51:07Z","modifiedTime":"2026-03-14T14:51:07Z","cancelTime":null,"price":335.53,"deposit":0,"tax":0,"commission":0,"rateDescription":"Base Price 335.53 \nHost Fee -0.00 \nExpected Payout Amount \n","stripeToken":null,"pcibookingToken":null,"apiMessage":""},"infoItems":[],"invoiceItems":[{"id":151269820,"bookingId":83746427,"type":"charge","subType":8,"description":"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]","status":"","qty":1,"amount":335.53,"lineTotal":335.53,"vatRate":0,"invoiceeId":null,"createdBy":null,"createTime":"2026-03-14T14:51:07Z"},{"id":151269821,"bookingId":83746427,"type":"charge","subType":11,"description":"Host Fee","status":"","qty":1,"amount":0,"lineTotal":0,"vatRate":0,"invoiceeId":null,"createdBy":null,"createTime":"2026-03-14T14:51:07Z"}],"messages":[{"id":139197320,"authorOwnerId":null,"bookingId":83746427,"time":"2026-03-14T14:51:07Z","read":false,"message":"Bonjour, nous sommes une famille de 5 avec 3 enfants de 14, 12 et 6 ans. Nous venons de la métropole et souhaitons découvrir votre magnifique île. Nous sommes intéressés par votre logement afin de découvrir le nord de l’île et ses nombreux atouts. \nEn espérant que votre logement soit disponible. \nYann et Isabelle","source":"guest"}],"retries":0}
TEXT
Update
Cancel