SQLite Web: db.sqlite

id

Primary key. INTEGER

source

TEXT NOT NULL

payload

{"external_id":"88983620","property_id":131309,"room_id":293385,"room_name":"Chambre Papaye","group_id":null,"group_type":null,"guest_name":"Jimmy","guest_email":"","guest_phone":null,"check_in":"2026-06-28","check_out":"2026-06-29","total_price":65,"commission":0,"status":"new","substatus":"none","source":"Airbnb","api_reference":"2579167019","is_master":0,"is_genius":0,"is_bank_transfer":0,"updated_at":"2026-06-28T23:29:43.039Z","raw_modified_time":"2026-06-28T23:03:27Z","payload_json":"{\"timeStamp\":\"2026-06-28T23:29:42Z\",\"booking\":{\"id\":88983620,\"masterId\":null,\"bookingGroup\":null,\"propertyId\":131309,\"roomId\":293385,\"unitId\":0,\"roomQty\":1,\"offerId\":0,\"status\":\"new\",\"subStatus\":\"none\",\"arrival\":\"2026-06-28\",\"departure\":\"2026-06-29\",\"numAdult\":2,\"numChild\":0,\"title\":\"\",\"firstName\":\"Jimmy\",\"lastName\":\"\",\"email\":\"\",\"phone\":\"\",\"mobile\":\"\",\"fax\":\"\",\"company\":\"\",\"address\":\"\",\"city\":\"\",\"state\":\"\",\"postcode\":\"\",\"country\":\"\",\"country2\":null,\"arrivalTime\":\"\",\"voucher\":\"\",\"comments\":\"\",\"notes\":\"Note: price less than room min price 65.00\\n\",\"message\":\"\",\"groupNote\":\"\",\"custom1\":\"\",\"custom2\":\"\",\"custom3\":\"\",\"custom4\":\"\",\"custom5\":\"\",\"custom6\":\"\",\"custom7\":\"\",\"custom8\":\"\",\"custom9\":\"\",\"custom10\":\"\",\"flagColor\":\"ffaad4\",\"flagText\":\"\",\"statusCode\":0,\"lang\":\"en\",\"referer\":\"Airbnb\",\"refererEditable\":\"Airbnb\",\"reference\":\"\",\"channel\":\"airbnb\",\"apiSourceId\":46,\"apiSource\":\"Airbnb\",\"apiReference\":\"2579167019\",\"allowChannelUpdate\":\"all\",\"allowAutoAction\":\"enable\",\"allowReview\":\"default\",\"allowCancellation\":{\"type\":\"propertyDefault\"},\"invoiceeId\":null,\"bookingTime\":\"2026-06-28T23:03:26Z\",\"modifiedTime\":\"2026-06-28T23:03:27Z\",\"cancelTime\":null,\"price\":65,\"deposit\":0,\"tax\":0,\"commission\":0,\"rateDescription\":\"Base Price 52.9 \\nHost Fee -0.00 \\nExpected Payout Amount  \\n\",\"stripeToken\":null,\"pcibookingToken\":null,\"apiMessage\":\"\"},\"infoItems\":[],\"invoiceItems\":[{\"id\":162203259,\"bookingId\":88983620,\"type\":\"charge\",\"subType\":8,\"description\":\"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]\",\"status\":\"\",\"qty\":1,\"amount\":52.9,\"lineTotal\":52.9,\"vatRate\":0,\"invoiceeId\":null,\"createdBy\":null,\"createTime\":\"2026-06-28T23:03:26Z\"},{\"id\":162203260,\"bookingId\":88983620,\"type\":\"charge\",\"subType\":11,\"description\":\"Host Fee\",\"status\":\"\",\"qty\":1,\"amount\":0,\"lineTotal\":0,\"vatRate\":0,\"invoiceeId\":null,\"createdBy\":null,\"createTime\":\"2026-06-28T23:03:26Z\"}],\"messages\":[{\"id\":154103590,\"authorOwnerId\":null,\"bookingId\":88983620,\"time\":\"2026-06-28T23:03:27Z\",\"read\":false,\"message\":\"Bonjour Carl,\\nnous sommes un jeune couple traversant la Martinique en itinérance. Nous sommes au Carbet et votre logement nous intéresse pour passer la nuit. \\n\\nMalheureusement, nous avons un problème de plafond atteint sur notre carte bancaire, Serait-il possible de vous payer en liquide ?\\n\\nBien cordialement, Jimmy et Marie \\n\\n(Si vous nous confirmez nous arriverons dans 1heure)\",\"source\":\"guest\"},{\"id\":154105628,\"authorOwnerId\":null,\"bookingId\":88983620,\"time\":\"2026-06-28T23:25:46Z\",\"read\":true,\"message\":\"Bonjour Jimmy,\\nMalheureusement je ne peux pas donner suite à votre demande \\nBonne soirée\",\"source\":\"host\"},{\"id\":154105946,\"authorOwnerId\":null,\"bookingId\":88983620,\"time\":\"2026-06-28T23:29:40Z\",\"read\":false,\"message\":\"Bonsoir, dommage, bonne soirée\",\"source\":\"guest\"}],\"retries\":0}","event_id":"evt_1782689383039_3mpjmt","should_notify":1,"dedupe_key":"069f48a3145493f34f6df4dec1fb60d4508d5df2141aabbc448fe6016122cd1f"}

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":"88983620","property_id":131309,"room_id":293385,"room_name":"Chambre Papaye","group_id":null,"group_type":null,"guest_name":"Jimmy","guest_email":"","guest_phone":null,"check_in":"2026-06-28","check_out":"2026-06-29","total_price":65,"commission":0,"status":"new","substatus":"none","source":"Airbnb","api_reference":"2579167019","is_master":0,"is_genius":0,"is_bank_transfer":0,"updated_at":"2026-06-28T23:29:43.039Z","raw_modified_time":"2026-06-28T23:03:27Z","payload_json":"{\"timeStamp\":\"2026-06-28T23:29:42Z\",\"booking\":{\"id\":88983620,\"masterId\":null,\"bookingGroup\":null,\"propertyId\":131309,\"roomId\":293385,\"unitId\":0,\"roomQty\":1,\"offerId\":0,\"status\":\"new\",\"subStatus\":\"none\",\"arrival\":\"2026-06-28\",\"departure\":\"2026-06-29\",\"numAdult\":2,\"numChild\":0,\"title\":\"\",\"firstName\":\"Jimmy\",\"lastName\":\"\",\"email\":\"\",\"phone\":\"\",\"mobile\":\"\",\"fax\":\"\",\"company\":\"\",\"address\":\"\",\"city\":\"\",\"state\":\"\",\"postcode\":\"\",\"country\":\"\",\"country2\":null,\"arrivalTime\":\"\",\"voucher\":\"\",\"comments\":\"\",\"notes\":\"Note: price less than room min price 65.00\\n\",\"message\":\"\",\"groupNote\":\"\",\"custom1\":\"\",\"custom2\":\"\",\"custom3\":\"\",\"custom4\":\"\",\"custom5\":\"\",\"custom6\":\"\",\"custom7\":\"\",\"custom8\":\"\",\"custom9\":\"\",\"custom10\":\"\",\"flagColor\":\"ffaad4\",\"flagText\":\"\",\"statusCode\":0,\"lang\":\"en\",\"referer\":\"Airbnb\",\"refererEditable\":\"Airbnb\",\"reference\":\"\",\"channel\":\"airbnb\",\"apiSourceId\":46,\"apiSource\":\"Airbnb\",\"apiReference\":\"2579167019\",\"allowChannelUpdate\":\"all\",\"allowAutoAction\":\"enable\",\"allowReview\":\"default\",\"allowCancellation\":{\"type\":\"propertyDefault\"},\"invoiceeId\":null,\"bookingTime\":\"2026-06-28T23:03:26Z\",\"modifiedTime\":\"2026-06-28T23:03:27Z\",\"cancelTime\":null,\"price\":65,\"deposit\":0,\"tax\":0,\"commission\":0,\"rateDescription\":\"Base Price 52.9 \\nHost Fee -0.00 \\nExpected Payout Amount  \\n\",\"stripeToken\":null,\"pcibookingToken\":null,\"apiMessage\":\"\"},\"infoItems\":[],\"invoiceItems\":[{\"id\":162203259,\"bookingId\":88983620,\"type\":\"charge\",\"subType\":8,\"description\":\"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]\",\"status\":\"\",\"qty\":1,\"amount\":52.9,\"lineTotal\":52.9,\"vatRate\":0,\"invoiceeId\":null,\"createdBy\":null,\"createTime\":\"2026-06-28T23:03:26Z\"},{\"id\":162203260,\"bookingId\":88983620,\"type\":\"charge\",\"subType\":11,\"description\":\"Host Fee\",\"status\":\"\",\"qty\":1,\"amount\":0,\"lineTotal\":0,\"vatRate\":0,\"invoiceeId\":null,\"createdBy\":null,\"createTime\":\"2026-06-28T23:03:26Z\"}],\"messages\":[{\"id\":154103590,\"authorOwnerId\":null,\"bookingId\":88983620,\"time\":\"2026-06-28T23:03:27Z\",\"read\":false,\"message\":\"Bonjour Carl,\\nnous sommes un jeune couple traversant la Martinique en itinérance. Nous sommes au Carbet et votre logement nous intéresse pour passer la nuit. \\n\\nMalheureusement, nous avons un problème de plafond atteint sur notre carte bancaire, Serait-il possible de vous payer en liquide ?\\n\\nBien cordialement, Jimmy et Marie \\n\\n(Si vous nous confirmez nous arriverons dans 1heure)\",\"source\":\"guest\"},{\"id\":154105628,\"authorOwnerId\":null,\"bookingId\":88983620,\"time\":\"2026-06-28T23:25:46Z\",\"read\":true,\"message\":\"Bonjour Jimmy,\\nMalheureusement je ne peux pas donner suite à votre demande \\nBonne soirée\",\"source\":\"host\"},{\"id\":154105946,\"authorOwnerId\":null,\"bookingId\":88983620,\"time\":\"2026-06-28T23:29:40Z\",\"read\":false,\"message\":\"Bonsoir, dommage, bonne soirée\",\"source\":\"guest\"}],\"retries\":0}","event_id":"evt_1782689383039_3mpjmt","should_notify":1,"dedupe_key":"069f48a3145493f34f6df4dec1fb60d4508d5df2141aabbc448fe6016122cd1f"}

TEXT

Update row 475 in inbox_raw