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 52 in events
id
Primary key.
INTEGER
event_type
booking.created_confirmed
TEXT NOT NULL
entity_type
booking
TEXT NOT NULL
entity_id
79952086
TEXT
payload
NULL
TEXT
created_at
DATETIME (default CURRENT_TIMESTAMP
processed
BOOLEAN (default 0
processed_at
DATETIME
event_id
evt_1766648198070_t6qlt4
TEXT
booking_external_id
79952086
TEXT
occurred_at
DATETIME
payload_json
{"timeStamp":"2025-12-25T07:36:37Z","booking":{"id":79952086,"masterId":null,"bookingGroup":null,"propertyId":131309,"roomId":293386,"unitId":1,"roomQty":1,"offerId":1,"status":"confirmed","subStatus":"none","arrival":"2026-01-02","departure":"2026-01-04","numAdult":2,"numChild":0,"title":"","firstName":"Florent","lastName":"Hennequez","email":"","phone":"33684038239","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\r\n","message":"","groupNote":"","custom1":"","custom2":"","custom3":"","custom4":"","custom5":"","custom6":"","custom7":"","custom8":"","custom9":"","custom10":"","flagColor":"","flagText":"","statusCode":0,"lang":"fr","referer":"kapokier972","refererEditable":"kapokier972","reference":"","channel":"direct","apiSourceId":0,"apiSource":"Direct","apiReference":"","allowChannelUpdate":"all","allowAutoAction":"enable","allowReview":"default","allowCancellation":{"type":"propertyDefault"},"invoiceeId":null,"bookingTime":"2025-12-25T06:43:34Z","modifiedTime":"2025-12-25T06:43:34Z","cancelTime":null,"price":150,"deposit":0,"tax":0,"commission":0,"rateDescription":"Offre 1, \r\n2026-01-02 75 Standard Rate, \r\n2026-01-03 75 Standard Rate,","stripeToken":null,"pcibookingToken":null,"apiMessage":""},"infoItems":[],"invoiceItems":[{"id":142766478,"bookingId":79952086,"type":"charge","subType":1,"description":"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]","status":"","qty":1,"amount":150,"lineTotal":150,"vatRate":0,"invoiceeId":null,"createdBy":72990,"createTime":"2025-12-25T06:43:34Z"}],"messages":[],"retries":0}
TEXT
should_notify
BOOLEAN (default 0
notified_at
DATETIME
Update
Cancel