sqlite-web 0.7.0
db.sqlite
events
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 397 in events
id
Primary key.
INTEGER
event_type
booking.cancelled
TEXT NOT NULL
entity_type
booking
TEXT NOT NULL
entity_id
88223102
TEXT
payload
NULL
TEXT
created_at
DATETIME (default CURRENT_TIMESTAMP
processed
BOOLEAN (default 0
processed_at
DATETIME
event_id
evt_1781306942323_zwhs5t
TEXT
booking_external_id
88223102
TEXT
occurred_at
DATETIME
payload_json
{"timeStamp":"2026-06-12T23:29:01Z","booking":{"id":88223102,"masterId":null,"bookingGroup":null,"propertyId":131309,"roomId":293385,"unitId":0,"roomQty":1,"offerId":0,"status":"cancelled","subStatus":"none","arrival":"2026-06-12","departure":"2026-06-13","numAdult":2,"numChild":0,"title":"","firstName":"Inès","lastName":"","email":"","phone":"","mobile":"","fax":"","company":"","address":"","city":"","state":"","postcode":"","country":"fr","country2":"FR","arrivalTime":"","voucher":"","comments":"","notes":"Note: price less than room min price 65.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":"HMW2AFSJHW","allowChannelUpdate":"all","allowAutoAction":"enable","allowReview":"default","allowCancellation":{"type":"propertyDefault"},"invoiceeId":null,"bookingTime":"2026-06-12T19:50:49Z","modifiedTime":"2026-06-12T23:28:51Z","cancelTime":"2026-06-12T23:28:51Z","price":0,"deposit":0,"tax":0,"commission":0,"rateDescription":"Cancel policy flexible\nBase Price 65 EUR\nAIRBNB Taxe de Sejour (Fr - Saint-pierre (219722253)) 2.28 EUR\nAIRBNB Taxe Additionnelle Departementale (Fr - Saint-pierre (219722253)) 0.23 EUR\nHost Fee -2.34 EUR\nExpected Payout Amount 62.66 EUR\n","stripeToken":null,"pcibookingToken":null,"apiMessage":""},"infoItems":[],"invoiceItems":[{"id":160445230,"bookingId":88223102,"type":"charge","subType":8,"description":"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]","status":"","qty":1,"amount":0,"lineTotal":0,"vatRate":0,"invoiceeId":null,"createdBy":72990,"createTime":"2026-06-12T23:28:51Z"},{"id":160445231,"bookingId":88223102,"type":"charge","subType":11,"description":"Host Fee","status":"","qty":1,"amount":0,"lineTotal":0,"vatRate":0,"invoiceeId":null,"createdBy":72990,"createTime":"2026-06-12T23:28:51Z"}],"messages":[{"id":151701071,"authorOwnerId":null,"bookingId":88223102,"time":"2026-06-12T19:50:55Z","read":false,"message":"Bonjour Carl nous souhaitons venir ce soir","source":"guest"}],"retries":0}
TEXT
should_notify
BOOLEAN (default 0
notified_at
DATETIME
Update
Cancel