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 457 in inbox_raw
id
Primary key.
INTEGER
source
webhook
TEXT NOT NULL
payload
{"external_id":"88814382","property_id":131309,"room_id":293386,"room_name":"Chambre Mango","group_id":null,"group_type":null,"guest_name":"Nolane Caliari","guest_email":"","guest_phone":"596696669791","check_in":"2026-06-26","check_out":"2026-06-28","total_price":129,"commission":0,"status":"confirmed","substatus":"none","source":"kapokier972","api_reference":"","is_master":0,"is_genius":0,"is_bank_transfer":0,"updated_at":"2026-06-25T07:49:28.645Z","raw_modified_time":"2026-06-25T07:49:26Z","payload_json":"{\"timeStamp\":\"2026-06-25T07:49:28Z\",\"booking\":{\"id\":88814382,\"masterId\":null,\"bookingGroup\":null,\"propertyId\":131309,\"roomId\":293386,\"unitId\":1,\"roomQty\":1,\"offerId\":1,\"status\":\"confirmed\",\"subStatus\":\"none\",\"arrival\":\"2026-06-26\",\"departure\":\"2026-06-28\",\"numAdult\":2,\"numChild\":0,\"title\":\"\",\"firstName\":\"Nolane\",\"lastName\":\"Caliari\",\"email\":\"\",\"phone\":\"596696669791\",\"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\":\"2026-06-25T07:49:26Z\",\"modifiedTime\":\"2026-06-25T07:49:26Z\",\"cancelTime\":null,\"price\":129,\"deposit\":0,\"tax\":0,\"commission\":0,\"rateDescription\":\"Offre 1, \\r\\n2026-06-26 63 Standard Rate, \\r\\n2026-06-27 66 Standard Rate,\",\"stripeToken\":null,\"pcibookingToken\":null,\"apiMessage\":\"\"},\"infoItems\":[],\"invoiceItems\":[{\"id\":161774313,\"bookingId\":88814382,\"type\":\"charge\",\"subType\":1,\"description\":\"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]\",\"status\":\"\",\"qty\":1,\"amount\":129,\"lineTotal\":129,\"vatRate\":0,\"invoiceeId\":null,\"createdBy\":72990,\"createTime\":\"2026-06-25T07:49:26Z\"}],\"messages\":[],\"retries\":0}","event_id":"evt_1782373768646_wmmi3m","should_notify":1,"dedupe_key":"ee7864d6c684108cb47d5a1b37e9f1b3c1f2668128bd880c72f7c145371c0a6c"}
TEXT NOT NULL
received_at
DATETIME (default CURRENT_TIMESTAMP
processed
BOOLEAN (default 0
processed_at
DATETIME
error
NULL
TEXT
dedupe_key
ee7864d6c684108cb47d5a1b37e9f1b3c1f2668128bd880c72f7c145371c0a6c
TEXT
payload_json
{"external_id":"88814382","property_id":131309,"room_id":293386,"room_name":"Chambre Mango","group_id":null,"group_type":null,"guest_name":"Nolane Caliari","guest_email":"","guest_phone":"596696669791","check_in":"2026-06-26","check_out":"2026-06-28","total_price":129,"commission":0,"status":"confirmed","substatus":"none","source":"kapokier972","api_reference":"","is_master":0,"is_genius":0,"is_bank_transfer":0,"updated_at":"2026-06-25T07:49:28.645Z","raw_modified_time":"2026-06-25T07:49:26Z","payload_json":"{\"timeStamp\":\"2026-06-25T07:49:28Z\",\"booking\":{\"id\":88814382,\"masterId\":null,\"bookingGroup\":null,\"propertyId\":131309,\"roomId\":293386,\"unitId\":1,\"roomQty\":1,\"offerId\":1,\"status\":\"confirmed\",\"subStatus\":\"none\",\"arrival\":\"2026-06-26\",\"departure\":\"2026-06-28\",\"numAdult\":2,\"numChild\":0,\"title\":\"\",\"firstName\":\"Nolane\",\"lastName\":\"Caliari\",\"email\":\"\",\"phone\":\"596696669791\",\"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\":\"2026-06-25T07:49:26Z\",\"modifiedTime\":\"2026-06-25T07:49:26Z\",\"cancelTime\":null,\"price\":129,\"deposit\":0,\"tax\":0,\"commission\":0,\"rateDescription\":\"Offre 1, \\r\\n2026-06-26 63 Standard Rate, \\r\\n2026-06-27 66 Standard Rate,\",\"stripeToken\":null,\"pcibookingToken\":null,\"apiMessage\":\"\"},\"infoItems\":[],\"invoiceItems\":[{\"id\":161774313,\"bookingId\":88814382,\"type\":\"charge\",\"subType\":1,\"description\":\"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]\",\"status\":\"\",\"qty\":1,\"amount\":129,\"lineTotal\":129,\"vatRate\":0,\"invoiceeId\":null,\"createdBy\":72990,\"createTime\":\"2026-06-25T07:49:26Z\"}],\"messages\":[],\"retries\":0}","event_id":"evt_1782373768646_wmmi3m","should_notify":1,"dedupe_key":"ee7864d6c684108cb47d5a1b37e9f1b3c1f2668128bd880c72f7c145371c0a6c"}
TEXT
Update
Cancel