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 269 in inbox_raw
id
Primary key.
INTEGER
source
webhook
TEXT NOT NULL
payload
{"external_id":"85538880","property_id":131309,"room_id":293385,"room_name":"Chambre Papaye","group_id":null,"group_type":null,"guest_name":"David Remoué","guest_email":"remoued@mailo.com","guest_phone":"00 33 6 26 39 88 00","check_in":"2026-07-26","check_out":"2026-07-27","total_price":78,"commission":0,"status":"new","substatus":"none","source":"iframe","api_reference":"","is_master":0,"is_genius":0,"is_bank_transfer":0,"updated_at":"2026-04-18T19:19:48.421Z","raw_modified_time":"2026-04-18T19:19:45Z","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}","event_id":"evt_1776539988422_n2wh4c","should_notify":1,"dedupe_key":"8525bc8dc1253074302922b80bf4033bf463e788c21afd4ea9cff551689e326d"}
TEXT NOT NULL
received_at
DATETIME (default CURRENT_TIMESTAMP
processed
BOOLEAN (default 0
processed_at
DATETIME
error
NULL
TEXT
dedupe_key
8525bc8dc1253074302922b80bf4033bf463e788c21afd4ea9cff551689e326d
TEXT
payload_json
{"external_id":"85538880","property_id":131309,"room_id":293385,"room_name":"Chambre Papaye","group_id":null,"group_type":null,"guest_name":"David Remoué","guest_email":"remoued@mailo.com","guest_phone":"00 33 6 26 39 88 00","check_in":"2026-07-26","check_out":"2026-07-27","total_price":78,"commission":0,"status":"new","substatus":"none","source":"iframe","api_reference":"","is_master":0,"is_genius":0,"is_bank_transfer":0,"updated_at":"2026-04-18T19:19:48.421Z","raw_modified_time":"2026-04-18T19:19:45Z","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}","event_id":"evt_1776539988422_n2wh4c","should_notify":1,"dedupe_key":"8525bc8dc1253074302922b80bf4033bf463e788c21afd4ea9cff551689e326d"}
TEXT
Update
Cancel