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 435 in inbox_raw
id
Primary key.
INTEGER
source
webhook
TEXT NOT NULL
payload
{"external_id":"88271570","property_id":131309,"room_id":293387,"room_name":"Chambre Goyave","group_id":null,"group_type":null,"guest_name":"Camille","guest_email":"","guest_phone":null,"check_in":"2026-06-14","check_out":"2026-06-16","total_price":116,"commission":0,"status":"new","substatus":"none","source":"Airbnb","api_reference":"2563577847","is_master":0,"is_genius":0,"is_bank_transfer":0,"updated_at":"2026-06-14T06:07:43.786Z","raw_modified_time":"2026-06-14T01:20:55Z","payload_json":"{\"timeStamp\":\"2026-06-14T06:07:43Z\",\"booking\":{\"id\":88271570,\"masterId\":null,\"bookingGroup\":null,\"propertyId\":131309,\"roomId\":293387,\"unitId\":0,\"roomQty\":1,\"offerId\":0,\"status\":\"new\",\"subStatus\":\"none\",\"arrival\":\"2026-06-14\",\"departure\":\"2026-06-16\",\"numAdult\":1,\"numChild\":0,\"title\":\"\",\"firstName\":\"Camille\",\"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 58.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\":\"2563577847\",\"allowChannelUpdate\":\"all\",\"allowAutoAction\":\"enable\",\"allowReview\":\"default\",\"allowCancellation\":{\"type\":\"propertyDefault\"},\"invoiceeId\":null,\"bookingTime\":\"2026-06-14T01:20:54Z\",\"modifiedTime\":\"2026-06-14T01:20:55Z\",\"cancelTime\":null,\"price\":116,\"deposit\":0,\"tax\":0,\"commission\":0,\"rateDescription\":\"Base Price 100.12 \\nHost Fee -0.00 \\nExpected Payout Amount \\n\",\"stripeToken\":null,\"pcibookingToken\":null,\"apiMessage\":\"\"},\"infoItems\":[],\"invoiceItems\":[{\"id\":160542644,\"bookingId\":88271570,\"type\":\"charge\",\"subType\":8,\"description\":\"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]\",\"status\":\"\",\"qty\":1,\"amount\":100.12,\"lineTotal\":100.12,\"vatRate\":0,\"invoiceeId\":null,\"createdBy\":null,\"createTime\":\"2026-06-14T01:20:54Z\"},{\"id\":160542645,\"bookingId\":88271570,\"type\":\"charge\",\"subType\":11,\"description\":\"Host Fee\",\"status\":\"\",\"qty\":1,\"amount\":0,\"lineTotal\":0,\"vatRate\":0,\"invoiceeId\":null,\"createdBy\":null,\"createTime\":\"2026-06-14T01:20:54Z\"}],\"messages\":[{\"id\":151873858,\"authorOwnerId\":null,\"bookingId\":88271570,\"time\":\"2026-06-14T01:20:55Z\",\"read\":false,\"message\":\"Bonsoir Carl, \\nNous recherchons un logement pour la nuit du dimanche 14 et du lundi 15 juin.\\nVotre logement est-il disponible ? Il y a t’il d’autres voyageurs à ces dates ?\\nBien à vous,\\nCamille & Grégoire\",\"source\":\"guest\"},{\"id\":151895272,\"authorOwnerId\":null,\"bookingId\":88271570,\"time\":\"2026-06-14T06:07:40Z\",\"read\":true,\"message\":\"Bonsoir Camille \\nNous avons une chambre libre pour vos dates \\nBien à vous\",\"source\":\"host\"}],\"retries\":0}","event_id":"evt_1781417263787_7pagq6","should_notify":1,"dedupe_key":"627fce090b1d774ed2b7b6c0938f893ac624fca97ff22e083f0104c2458b153b"}
TEXT NOT NULL
received_at
DATETIME (default CURRENT_TIMESTAMP
processed
BOOLEAN (default 0
processed_at
DATETIME
error
NULL
TEXT
dedupe_key
627fce090b1d774ed2b7b6c0938f893ac624fca97ff22e083f0104c2458b153b
TEXT
payload_json
{"external_id":"88271570","property_id":131309,"room_id":293387,"room_name":"Chambre Goyave","group_id":null,"group_type":null,"guest_name":"Camille","guest_email":"","guest_phone":null,"check_in":"2026-06-14","check_out":"2026-06-16","total_price":116,"commission":0,"status":"new","substatus":"none","source":"Airbnb","api_reference":"2563577847","is_master":0,"is_genius":0,"is_bank_transfer":0,"updated_at":"2026-06-14T06:07:43.786Z","raw_modified_time":"2026-06-14T01:20:55Z","payload_json":"{\"timeStamp\":\"2026-06-14T06:07:43Z\",\"booking\":{\"id\":88271570,\"masterId\":null,\"bookingGroup\":null,\"propertyId\":131309,\"roomId\":293387,\"unitId\":0,\"roomQty\":1,\"offerId\":0,\"status\":\"new\",\"subStatus\":\"none\",\"arrival\":\"2026-06-14\",\"departure\":\"2026-06-16\",\"numAdult\":1,\"numChild\":0,\"title\":\"\",\"firstName\":\"Camille\",\"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 58.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\":\"2563577847\",\"allowChannelUpdate\":\"all\",\"allowAutoAction\":\"enable\",\"allowReview\":\"default\",\"allowCancellation\":{\"type\":\"propertyDefault\"},\"invoiceeId\":null,\"bookingTime\":\"2026-06-14T01:20:54Z\",\"modifiedTime\":\"2026-06-14T01:20:55Z\",\"cancelTime\":null,\"price\":116,\"deposit\":0,\"tax\":0,\"commission\":0,\"rateDescription\":\"Base Price 100.12 \\nHost Fee -0.00 \\nExpected Payout Amount \\n\",\"stripeToken\":null,\"pcibookingToken\":null,\"apiMessage\":\"\"},\"infoItems\":[],\"invoiceItems\":[{\"id\":160542644,\"bookingId\":88271570,\"type\":\"charge\",\"subType\":8,\"description\":\"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]\",\"status\":\"\",\"qty\":1,\"amount\":100.12,\"lineTotal\":100.12,\"vatRate\":0,\"invoiceeId\":null,\"createdBy\":null,\"createTime\":\"2026-06-14T01:20:54Z\"},{\"id\":160542645,\"bookingId\":88271570,\"type\":\"charge\",\"subType\":11,\"description\":\"Host Fee\",\"status\":\"\",\"qty\":1,\"amount\":0,\"lineTotal\":0,\"vatRate\":0,\"invoiceeId\":null,\"createdBy\":null,\"createTime\":\"2026-06-14T01:20:54Z\"}],\"messages\":[{\"id\":151873858,\"authorOwnerId\":null,\"bookingId\":88271570,\"time\":\"2026-06-14T01:20:55Z\",\"read\":false,\"message\":\"Bonsoir Carl, \\nNous recherchons un logement pour la nuit du dimanche 14 et du lundi 15 juin.\\nVotre logement est-il disponible ? Il y a t’il d’autres voyageurs à ces dates ?\\nBien à vous,\\nCamille & Grégoire\",\"source\":\"guest\"},{\"id\":151895272,\"authorOwnerId\":null,\"bookingId\":88271570,\"time\":\"2026-06-14T06:07:40Z\",\"read\":true,\"message\":\"Bonsoir Camille \\nNous avons une chambre libre pour vos dates \\nBien à vous\",\"source\":\"host\"}],\"retries\":0}","event_id":"evt_1781417263787_7pagq6","should_notify":1,"dedupe_key":"627fce090b1d774ed2b7b6c0938f893ac624fca97ff22e083f0104c2458b153b"}
TEXT
Update
Cancel