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 254 in events
id
Primary key.
INTEGER
event_type
booking.created_confirmed
TEXT NOT NULL
entity_type
booking
TEXT NOT NULL
entity_id
85538880
TEXT
payload
NULL
TEXT
created_at
DATETIME (default CURRENT_TIMESTAMP
processed
BOOLEAN (default 0
processed_at
DATETIME
event_id
evt_1776539988422_n2wh4c
TEXT
booking_external_id
85538880
TEXT
occurred_at
DATETIME
payload_json
{"timeStamp":"2026-04-18T19:19:47Z","booking":{"id":85538880,"masterId":null,"bookingGroup":null,"propertyId":131309,"roomId":293385,"unitId":1,"roomQty":1,"offerId":1,"status":"new","subStatus":"none","arrival":"2026-07-26","departure":"2026-07-27","numAdult":2,"numChild":0,"title":"","firstName":"David","lastName":"Remoué","email":"remoued@mailo.com","phone":"","mobile":"00 33 6 26 39 88 00","fax":"","company":"","address":"","city":"","state":"","postcode":"","country":"","country2":null,"arrivalTime":"18h","voucher":"","comments":"","notes":"","message":"","groupNote":"","custom1":"","custom2":"","custom3":"","custom4":"","custom5":"","custom6":"","custom7":"","custom8":"","custom9":"","custom10":"","flagColor":"","flagText":"","statusCode":0,"lang":"fr","referer":"iframe","refererEditable":"iframe","reference":"","channel":"direct","apiSourceId":0,"apiSource":"Direct","apiReference":"","allowChannelUpdate":"all","allowAutoAction":"enable","allowReview":"default","allowCancellation":{"type":"propertyDefault"},"invoiceeId":null,"bookingTime":"2026-04-18T19:16:43Z","modifiedTime":"2026-04-18T19:19:45Z","cancelTime":null,"price":78,"deposit":78,"tax":0,"commission":0,"rateDescription":" \n2026-07-26 78 Papaye plan","stripeToken":"cus_UMN6b9GxIExN0B","pcibookingToken":null,"apiMessage":""},"infoItems":[{"id":171645924,"bookingId":85538880,"createTime":"2026-04-18T19:19:45Z","code":"CARDTOSTRIPE","text":"Card saved to stripe cus_UMN6b9GxIExN0B"},{"id":171645925,"bookingId":85538880,"createTime":"2026-04-18T19:19:45Z","code":"STRIPEPAYMENT","text":"Payment 78 EUR, ch_3TNeNhLngO1CzI540Xcjb4Xx"}],"invoiceItems":[{"id":154888624,"bookingId":85538880,"type":"charge","subType":1,"description":"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]","status":"","qty":1,"amount":78,"lineTotal":78,"vatRate":0,"invoiceeId":null,"createdBy":null,"createTime":"2026-04-18T19:16:43Z"},{"id":154888784,"bookingId":85538880,"type":"payment","subType":203,"description":"Booking 85538880: David Remoué","status":"Paid","amount":78,"lineTotal":-78,"invoiceeId":null,"createdBy":null,"createTime":"2026-04-18T19:19:45Z"}],"messages":[],"retries":0}
TEXT
should_notify
BOOLEAN (default 0
notified_at
DATETIME
Update
Cancel