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 254 in inbox_raw
id
Primary key.
INTEGER
source
webhook
TEXT NOT NULL
payload
{"external_id":"85079857","property_id":131309,"room_id":293385,"room_name":"Chambre Papaye","group_id":"eGF2aWVyX18yMDI2","group_type":"heuristic","guest_name":"Xavier","guest_email":"","guest_phone":null,"check_in":"2026-05-08","check_out":"2026-05-10","total_price":209.04,"commission":47.76,"status":"new","substatus":"none","source":"Airbnb","api_reference":"HMCAECHNCN","is_master":0,"is_genius":0,"is_bank_transfer":0,"updated_at":"2026-04-09T01:35:33.355Z","raw_modified_time":"2026-04-09T01:35:31Z","payload_json":"{\"timeStamp\":\"2026-04-09T01:35:32Z\",\"booking\":{\"id\":85079857,\"masterId\":null,\"bookingGroup\":null,\"propertyId\":131309,\"roomId\":293385,\"unitId\":0,\"roomQty\":1,\"offerId\":0,\"status\":\"new\",\"subStatus\":\"none\",\"arrival\":\"2026-05-08\",\"departure\":\"2026-05-10\",\"numAdult\":5,\"numChild\":0,\"title\":\"\",\"firstName\":\"Xavier\",\"lastName\":\"\",\"email\":\"\",\"phone\":\"\",\"mobile\":\"\",\"fax\":\"\",\"company\":\"\",\"address\":\"\",\"city\":\"\",\"state\":\"\",\"postcode\":\"\",\"country\":\"fr\",\"country2\":\"FR\",\"arrivalTime\":\"\",\"voucher\":\"\",\"comments\":\"\",\"notes\":\"Booked Maison Kapokier · House with a beautiful sea's view at Saint-Pierre - 327594\\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\":\"HMCAECHNCN\",\"allowChannelUpdate\":\"all\",\"allowAutoAction\":\"enable\",\"allowReview\":\"default\",\"allowCancellation\":{\"type\":\"propertyDefault\"},\"invoiceeId\":null,\"bookingTime\":\"2026-04-09T01:35:30Z\",\"modifiedTime\":\"2026-04-09T01:35:31Z\",\"cancelTime\":null,\"price\":209.04,\"deposit\":0,\"tax\":0,\"commission\":47.76,\"rateDescription\":\"Cancel policy tiered_pricing_non_refundable\\nBase Price 256.8 EUR\\nAIRBNB Taxe de Sejour (Fr - Saint-pierre (219722253)) 8.99 EUR\\nAIRBNB Taxe Additionnelle Departementale (Fr - Saint-pierre (219722253)) 0.90 EUR\\nHost Fee -47.76 EUR\\nExpected Payout Amount 209.04 EUR\\n\",\"stripeToken\":null,\"pcibookingToken\":null,\"apiMessage\":\"\"},\"infoItems\":[],\"invoiceItems\":[{\"id\":153953949,\"bookingId\":85079857,\"type\":\"charge\",\"subType\":8,\"description\":\"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]\",\"status\":\"\",\"qty\":1,\"amount\":256.8,\"lineTotal\":256.8,\"vatRate\":0,\"invoiceeId\":null,\"createdBy\":null,\"createTime\":\"2026-04-09T01:35:30Z\"},{\"id\":153953950,\"bookingId\":85079857,\"type\":\"charge\",\"subType\":11,\"description\":\"Host Fee\",\"status\":\"\",\"qty\":1,\"amount\":-47.76,\"lineTotal\":-47.76,\"vatRate\":0.2,\"invoiceeId\":null,\"createdBy\":null,\"createTime\":\"2026-04-09T01:35:30Z\"}],\"messages\":[],\"retries\":0}","event_id":"evt_1775698533356_rfnkq5","should_notify":1,"dedupe_key":"c15ac6c3393f6ee84374a6f53bf7ed732e43614ec68c78dde108104307ede02f"}
TEXT NOT NULL
received_at
DATETIME (default CURRENT_TIMESTAMP
processed
BOOLEAN (default 0
processed_at
DATETIME
error
NULL
TEXT
dedupe_key
c15ac6c3393f6ee84374a6f53bf7ed732e43614ec68c78dde108104307ede02f
TEXT
payload_json
{"external_id":"85079857","property_id":131309,"room_id":293385,"room_name":"Chambre Papaye","group_id":"eGF2aWVyX18yMDI2","group_type":"heuristic","guest_name":"Xavier","guest_email":"","guest_phone":null,"check_in":"2026-05-08","check_out":"2026-05-10","total_price":209.04,"commission":47.76,"status":"new","substatus":"none","source":"Airbnb","api_reference":"HMCAECHNCN","is_master":0,"is_genius":0,"is_bank_transfer":0,"updated_at":"2026-04-09T01:35:33.355Z","raw_modified_time":"2026-04-09T01:35:31Z","payload_json":"{\"timeStamp\":\"2026-04-09T01:35:32Z\",\"booking\":{\"id\":85079857,\"masterId\":null,\"bookingGroup\":null,\"propertyId\":131309,\"roomId\":293385,\"unitId\":0,\"roomQty\":1,\"offerId\":0,\"status\":\"new\",\"subStatus\":\"none\",\"arrival\":\"2026-05-08\",\"departure\":\"2026-05-10\",\"numAdult\":5,\"numChild\":0,\"title\":\"\",\"firstName\":\"Xavier\",\"lastName\":\"\",\"email\":\"\",\"phone\":\"\",\"mobile\":\"\",\"fax\":\"\",\"company\":\"\",\"address\":\"\",\"city\":\"\",\"state\":\"\",\"postcode\":\"\",\"country\":\"fr\",\"country2\":\"FR\",\"arrivalTime\":\"\",\"voucher\":\"\",\"comments\":\"\",\"notes\":\"Booked Maison Kapokier · House with a beautiful sea's view at Saint-Pierre - 327594\\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\":\"HMCAECHNCN\",\"allowChannelUpdate\":\"all\",\"allowAutoAction\":\"enable\",\"allowReview\":\"default\",\"allowCancellation\":{\"type\":\"propertyDefault\"},\"invoiceeId\":null,\"bookingTime\":\"2026-04-09T01:35:30Z\",\"modifiedTime\":\"2026-04-09T01:35:31Z\",\"cancelTime\":null,\"price\":209.04,\"deposit\":0,\"tax\":0,\"commission\":47.76,\"rateDescription\":\"Cancel policy tiered_pricing_non_refundable\\nBase Price 256.8 EUR\\nAIRBNB Taxe de Sejour (Fr - Saint-pierre (219722253)) 8.99 EUR\\nAIRBNB Taxe Additionnelle Departementale (Fr - Saint-pierre (219722253)) 0.90 EUR\\nHost Fee -47.76 EUR\\nExpected Payout Amount 209.04 EUR\\n\",\"stripeToken\":null,\"pcibookingToken\":null,\"apiMessage\":\"\"},\"infoItems\":[],\"invoiceItems\":[{\"id\":153953949,\"bookingId\":85079857,\"type\":\"charge\",\"subType\":8,\"description\":\"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]\",\"status\":\"\",\"qty\":1,\"amount\":256.8,\"lineTotal\":256.8,\"vatRate\":0,\"invoiceeId\":null,\"createdBy\":null,\"createTime\":\"2026-04-09T01:35:30Z\"},{\"id\":153953950,\"bookingId\":85079857,\"type\":\"charge\",\"subType\":11,\"description\":\"Host Fee\",\"status\":\"\",\"qty\":1,\"amount\":-47.76,\"lineTotal\":-47.76,\"vatRate\":0.2,\"invoiceeId\":null,\"createdBy\":null,\"createTime\":\"2026-04-09T01:35:30Z\"}],\"messages\":[],\"retries\":0}","event_id":"evt_1775698533356_rfnkq5","should_notify":1,"dedupe_key":"c15ac6c3393f6ee84374a6f53bf7ed732e43614ec68c78dde108104307ede02f"}
TEXT
Update
Cancel