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 62 in inbox_raw
id
Primary key.
INTEGER
source
webhook
TEXT NOT NULL
payload
{"timeStamp":"2025-12-28T19:26:42Z","booking":{"id":80064042,"masterId":null,"bookingGroup":null,"propertyId":131309,"roomId":293385,"unitId":0,"roomQty":1,"offerId":0,"status":"new","subStatus":"none","arrival":"2026-02-11","departure":"2026-02-15","numAdult":5,"numChild":0,"title":"","firstName":"Mayra Elizabeth","lastName":"","email":"","phone":"","mobile":"","fax":"","company":"","address":"","city":"","state":"","postcode":"","country":"","country2":null,"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":"en","referer":"Airbnb","refererEditable":"Airbnb","reference":"","channel":"airbnb","apiSourceId":46,"apiSource":"Airbnb","apiReference":"2391413278","allowChannelUpdate":"all","allowAutoAction":"enable","allowReview":"default","allowCancellation":{"type":"propertyDefault"},"invoiceeId":null,"bookingTime":"2025-12-28T19:26:38Z","modifiedTime":"2025-12-28T19:26:38Z","cancelTime":null,"price":479.44,"deposit":0,"tax":0,"commission":0,"rateDescription":"Base Price 479.44 \nHost Fee -0.00 \nExpected Payout Amount \n","stripeToken":null,"pcibookingToken":null,"apiMessage":""},"infoItems":[],"invoiceItems":[{"id":143019540,"bookingId":80064042,"type":"charge","subType":8,"description":"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]","status":"","qty":1,"amount":479.44,"lineTotal":479.44,"vatRate":0,"invoiceeId":null,"createdBy":null,"createTime":"2025-12-28T19:26:38Z"},{"id":143019541,"bookingId":80064042,"type":"charge","subType":11,"description":"Host Fee","status":"","qty":1,"amount":0,"lineTotal":0,"vatRate":0,"invoiceeId":null,"createdBy":null,"createTime":"2025-12-28T19:26:38Z"}],"messages":[{"id":129835090,"authorOwnerId":null,"bookingId":80064042,"time":"2025-12-28T19:26:38Z","read":false,"message":"Hi Carl \nWe would love to stay at your lively place.\nDoes it offer good internet conecto to work from there ?? Thank you","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
39925df5
TEXT
payload_json
{"timeStamp":"2025-12-28T19:26:42Z","booking":{"id":80064042,"masterId":null,"bookingGroup":null,"propertyId":131309,"roomId":293385,"unitId":0,"roomQty":1,"offerId":0,"status":"new","subStatus":"none","arrival":"2026-02-11","departure":"2026-02-15","numAdult":5,"numChild":0,"title":"","firstName":"Mayra Elizabeth","lastName":"","email":"","phone":"","mobile":"","fax":"","company":"","address":"","city":"","state":"","postcode":"","country":"","country2":null,"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":"en","referer":"Airbnb","refererEditable":"Airbnb","reference":"","channel":"airbnb","apiSourceId":46,"apiSource":"Airbnb","apiReference":"2391413278","allowChannelUpdate":"all","allowAutoAction":"enable","allowReview":"default","allowCancellation":{"type":"propertyDefault"},"invoiceeId":null,"bookingTime":"2025-12-28T19:26:38Z","modifiedTime":"2025-12-28T19:26:38Z","cancelTime":null,"price":479.44,"deposit":0,"tax":0,"commission":0,"rateDescription":"Base Price 479.44 \nHost Fee -0.00 \nExpected Payout Amount \n","stripeToken":null,"pcibookingToken":null,"apiMessage":""},"infoItems":[],"invoiceItems":[{"id":143019540,"bookingId":80064042,"type":"charge","subType":8,"description":"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]","status":"","qty":1,"amount":479.44,"lineTotal":479.44,"vatRate":0,"invoiceeId":null,"createdBy":null,"createTime":"2025-12-28T19:26:38Z"},{"id":143019541,"bookingId":80064042,"type":"charge","subType":11,"description":"Host Fee","status":"","qty":1,"amount":0,"lineTotal":0,"vatRate":0,"invoiceeId":null,"createdBy":null,"createTime":"2025-12-28T19:26:38Z"}],"messages":[{"id":129835090,"authorOwnerId":null,"bookingId":80064042,"time":"2025-12-28T19:26:38Z","read":false,"message":"Hi Carl \nWe would love to stay at your lively place.\nDoes it offer good internet conecto to work from there ?? Thank you","source":"guest"}],"retries":0}
TEXT
Update
Cancel