SQLite Web: db.sqlite

id

Primary key. INTEGER

source

TEXT NOT NULL

payload

{"external_id":"85773055","property_id":131309,"room_id":293386,"room_name":"Chambre Mango","group_id":null,"group_type":null,"guest_name":"Astrid","guest_email":"","guest_phone":null,"check_in":"2026-04-25","check_out":"2026-04-26","total_price":61.04,"commission":0,"status":"new","substatus":"none","source":"Airbnb","api_reference":"2510838665","is_master":0,"is_genius":0,"is_bank_transfer":0,"updated_at":"2026-04-23T16:54:17.376Z","raw_modified_time":"2026-04-23T16:54:15Z","payload_json":"{\"timeStamp\":\"2026-04-23T16:54:16Z\",\"booking\":{\"id\":85773055,\"masterId\":null,\"bookingGroup\":null,\"propertyId\":131309,\"roomId\":293386,\"unitId\":0,\"roomQty\":1,\"offerId\":0,\"status\":\"new\",\"subStatus\":\"none\",\"arrival\":\"2026-04-25\",\"departure\":\"2026-04-26\",\"numAdult\":2,\"numChild\":0,\"title\":\"\",\"firstName\":\"Astrid\",\"lastName\":\"\",\"email\":\"\",\"phone\":\"\",\"mobile\":\"\",\"fax\":\"\",\"company\":\"\",\"address\":\"\",\"city\":\"\",\"state\":\"\",\"postcode\":\"\",\"country\":\"fr\",\"country2\":\"FR\",\"arrivalTime\":\"\",\"voucher\":\"\",\"comments\":\"\",\"notes\":\"\",\"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\":\"2510838665\",\"allowChannelUpdate\":\"all\",\"allowAutoAction\":\"enable\",\"allowReview\":\"default\",\"allowCancellation\":{\"type\":\"propertyDefault\"},\"invoiceeId\":null,\"bookingTime\":\"2026-04-23T16:54:15Z\",\"modifiedTime\":\"2026-04-23T16:54:15Z\",\"cancelTime\":null,\"price\":61.04,\"deposit\":0,\"tax\":0,\"commission\":0,\"rateDescription\":\"Base Price 61.04 \\nHost Fee -0.00 \\nExpected Payout Amount  \\n\",\"stripeToken\":null,\"pcibookingToken\":null,\"apiMessage\":\"\"},\"infoItems\":[],\"invoiceItems\":[{\"id\":155359942,\"bookingId\":85773055,\"type\":\"charge\",\"subType\":8,\"description\":\"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]\",\"status\":\"\",\"qty\":1,\"amount\":61.04,\"lineTotal\":61.04,\"vatRate\":0,\"invoiceeId\":null,\"createdBy\":null,\"createTime\":\"2026-04-23T16:54:15Z\"},{\"id\":155359943,\"bookingId\":85773055,\"type\":\"charge\",\"subType\":11,\"description\":\"Host Fee\",\"status\":\"\",\"qty\":1,\"amount\":0,\"lineTotal\":0,\"vatRate\":0,\"invoiceeId\":null,\"createdBy\":null,\"createTime\":\"2026-04-23T16:54:15Z\"}],\"messages\":[{\"id\":144685640,\"authorOwnerId\":null,\"bookingId\":85773055,\"time\":\"2026-04-23T16:54:15Z\",\"read\":false,\"message\":\"bonjour ! \\npeut on venir avec un bébé ? j'ai un petit lit pliable. \\nça serait pour ce weekend. \\n\\nMerci ! \\n\\nAstrid\",\"source\":\"guest\"}],\"retries\":0}","event_id":"evt_1776963257376_9hudpt","should_notify":1,"dedupe_key":"e659807b98f28671945069006c735af918dbd78cb37e09efbb20ad487efa900b"}

TEXT NOT NULL

received_at

DATETIME (default CURRENT_TIMESTAMP

processed

BOOLEAN (default 0

processed_at

DATETIME

error

TEXT

dedupe_key

TEXT

payload_json

{"external_id":"85773055","property_id":131309,"room_id":293386,"room_name":"Chambre Mango","group_id":null,"group_type":null,"guest_name":"Astrid","guest_email":"","guest_phone":null,"check_in":"2026-04-25","check_out":"2026-04-26","total_price":61.04,"commission":0,"status":"new","substatus":"none","source":"Airbnb","api_reference":"2510838665","is_master":0,"is_genius":0,"is_bank_transfer":0,"updated_at":"2026-04-23T16:54:17.376Z","raw_modified_time":"2026-04-23T16:54:15Z","payload_json":"{\"timeStamp\":\"2026-04-23T16:54:16Z\",\"booking\":{\"id\":85773055,\"masterId\":null,\"bookingGroup\":null,\"propertyId\":131309,\"roomId\":293386,\"unitId\":0,\"roomQty\":1,\"offerId\":0,\"status\":\"new\",\"subStatus\":\"none\",\"arrival\":\"2026-04-25\",\"departure\":\"2026-04-26\",\"numAdult\":2,\"numChild\":0,\"title\":\"\",\"firstName\":\"Astrid\",\"lastName\":\"\",\"email\":\"\",\"phone\":\"\",\"mobile\":\"\",\"fax\":\"\",\"company\":\"\",\"address\":\"\",\"city\":\"\",\"state\":\"\",\"postcode\":\"\",\"country\":\"fr\",\"country2\":\"FR\",\"arrivalTime\":\"\",\"voucher\":\"\",\"comments\":\"\",\"notes\":\"\",\"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\":\"2510838665\",\"allowChannelUpdate\":\"all\",\"allowAutoAction\":\"enable\",\"allowReview\":\"default\",\"allowCancellation\":{\"type\":\"propertyDefault\"},\"invoiceeId\":null,\"bookingTime\":\"2026-04-23T16:54:15Z\",\"modifiedTime\":\"2026-04-23T16:54:15Z\",\"cancelTime\":null,\"price\":61.04,\"deposit\":0,\"tax\":0,\"commission\":0,\"rateDescription\":\"Base Price 61.04 \\nHost Fee -0.00 \\nExpected Payout Amount  \\n\",\"stripeToken\":null,\"pcibookingToken\":null,\"apiMessage\":\"\"},\"infoItems\":[],\"invoiceItems\":[{\"id\":155359942,\"bookingId\":85773055,\"type\":\"charge\",\"subType\":8,\"description\":\"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]\",\"status\":\"\",\"qty\":1,\"amount\":61.04,\"lineTotal\":61.04,\"vatRate\":0,\"invoiceeId\":null,\"createdBy\":null,\"createTime\":\"2026-04-23T16:54:15Z\"},{\"id\":155359943,\"bookingId\":85773055,\"type\":\"charge\",\"subType\":11,\"description\":\"Host Fee\",\"status\":\"\",\"qty\":1,\"amount\":0,\"lineTotal\":0,\"vatRate\":0,\"invoiceeId\":null,\"createdBy\":null,\"createTime\":\"2026-04-23T16:54:15Z\"}],\"messages\":[{\"id\":144685640,\"authorOwnerId\":null,\"bookingId\":85773055,\"time\":\"2026-04-23T16:54:15Z\",\"read\":false,\"message\":\"bonjour ! \\npeut on venir avec un bébé ? j'ai un petit lit pliable. \\nça serait pour ce weekend. \\n\\nMerci ! \\n\\nAstrid\",\"source\":\"guest\"}],\"retries\":0}","event_id":"evt_1776963257376_9hudpt","should_notify":1,"dedupe_key":"e659807b98f28671945069006c735af918dbd78cb37e09efbb20ad487efa900b"}

TEXT

Update row 275 in inbox_raw