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 172 in inbox_raw
id
Primary key.
INTEGER
source
webhook
TEXT NOT NULL
payload
{"timeStamp":"2026-03-02T14:33:01Z","booking":{"id":83143530,"masterId":null,"bookingGroup":null,"propertyId":131309,"roomId":293387,"unitId":1,"roomQty":1,"offerId":0,"status":"new","subStatus":"none","arrival":"2026-03-04","departure":"2026-03-05","numAdult":2,"numChild":0,"title":"","firstName":"Philippe","lastName":"Epaillard","email":"","phone":"33607833479","mobile":"33631498658","fax":"","company":"","address":"","city":"","state":"","postcode":"","country":"fr","country2":"FR","arrivalTime":"","voucher":"","comments":"","notes":"Note: price less than room min price 58.00\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":"HMYFMFBC8F","allowChannelUpdate":"all","allowAutoAction":"enable","allowReview":"default","allowCancellation":{"type":"propertyDefault"},"invoiceeId":null,"bookingTime":"2026-03-02T14:32:57Z","modifiedTime":"2026-03-02T14:32:57Z","cancelTime":null,"price":58,"deposit":0,"tax":0,"commission":12.89,"rateDescription":"Cancel policy tiered_pricing_non_refundable\nBase Price 69.3 EUR\nAIRBNB Taxe de Sejour (Fr - Saint-pierre (219722253)) 2.43 EUR\nAIRBNB Taxe Additionnelle Departementale (Fr - Saint-pierre (219722253)) 0.24 EUR\nHost Fee -12.89 EUR\nExpected Payout Amount 56.41 EUR\n","stripeToken":null,"pcibookingToken":null,"apiMessage":""},"infoItems":[],"invoiceItems":[{"id":150077206,"bookingId":83143530,"type":"charge","subType":8,"description":"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]","status":"","qty":1,"amount":69.3,"lineTotal":69.3,"vatRate":0,"invoiceeId":null,"createdBy":null,"createTime":"2026-03-02T14:32:57Z"},{"id":150077207,"bookingId":83143530,"type":"charge","subType":11,"description":"Host Fee","status":"","qty":1,"amount":-12.89,"lineTotal":-12.89,"vatRate":0.2,"invoiceeId":null,"createdBy":null,"createTime":"2026-03-02T14:32:57Z"}],"messages":[],"retries":0}
TEXT NOT NULL
received_at
DATETIME (default CURRENT_TIMESTAMP
processed
BOOLEAN (default 0
processed_at
DATETIME
error
NULL
TEXT
dedupe_key
35a14f3c
TEXT
payload_json
{"timeStamp":"2026-03-02T14:33:01Z","booking":{"id":83143530,"masterId":null,"bookingGroup":null,"propertyId":131309,"roomId":293387,"unitId":1,"roomQty":1,"offerId":0,"status":"new","subStatus":"none","arrival":"2026-03-04","departure":"2026-03-05","numAdult":2,"numChild":0,"title":"","firstName":"Philippe","lastName":"Epaillard","email":"","phone":"33607833479","mobile":"33631498658","fax":"","company":"","address":"","city":"","state":"","postcode":"","country":"fr","country2":"FR","arrivalTime":"","voucher":"","comments":"","notes":"Note: price less than room min price 58.00\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":"HMYFMFBC8F","allowChannelUpdate":"all","allowAutoAction":"enable","allowReview":"default","allowCancellation":{"type":"propertyDefault"},"invoiceeId":null,"bookingTime":"2026-03-02T14:32:57Z","modifiedTime":"2026-03-02T14:32:57Z","cancelTime":null,"price":58,"deposit":0,"tax":0,"commission":12.89,"rateDescription":"Cancel policy tiered_pricing_non_refundable\nBase Price 69.3 EUR\nAIRBNB Taxe de Sejour (Fr - Saint-pierre (219722253)) 2.43 EUR\nAIRBNB Taxe Additionnelle Departementale (Fr - Saint-pierre (219722253)) 0.24 EUR\nHost Fee -12.89 EUR\nExpected Payout Amount 56.41 EUR\n","stripeToken":null,"pcibookingToken":null,"apiMessage":""},"infoItems":[],"invoiceItems":[{"id":150077206,"bookingId":83143530,"type":"charge","subType":8,"description":"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]","status":"","qty":1,"amount":69.3,"lineTotal":69.3,"vatRate":0,"invoiceeId":null,"createdBy":null,"createTime":"2026-03-02T14:32:57Z"},{"id":150077207,"bookingId":83143530,"type":"charge","subType":11,"description":"Host Fee","status":"","qty":1,"amount":-12.89,"lineTotal":-12.89,"vatRate":0.2,"invoiceeId":null,"createdBy":null,"createTime":"2026-03-02T14:32:57Z"}],"messages":[],"retries":0}
TEXT
Update
Cancel