SQLite Web: db.sqlite

id

Primary key. INTEGER

source

TEXT NOT NULL

payload

{"timeStamp":"2026-01-11T12:16:12Z","booking":{"id":80644286,"masterId":null,"bookingGroup":null,"propertyId":131309,"roomId":293387,"unitId":0,"roomQty":1,"offerId":0,"status":"new","subStatus":"none","arrival":"2026-01-13","departure":"2026-01-16","numAdult":2,"numChild":0,"title":"","firstName":"Christoph","lastName":"","email":"","phone":"","mobile":"","fax":"","company":"","address":"","city":"","state":"","postcode":"","country":"de","country2":"DE","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":"de","referer":"Airbnb","refererEditable":"Airbnb","reference":"","channel":"airbnb","apiSourceId":46,"apiSource":"Airbnb","apiReference":"2406966189","allowChannelUpdate":"all","allowAutoAction":"enable","allowReview":"default","allowCancellation":{"type":"propertyDefault"},"invoiceeId":null,"bookingTime":"2026-01-11T12:16:05Z","modifiedTime":"2026-01-11T12:16:05Z","cancelTime":null,"price":174,"deposit":0,"tax":0,"commission":0,"rateDescription":"Base Price 170.12 \nHost Fee -0.00 \nExpected Payout Amount  \n","stripeToken":null,"pcibookingToken":null,"apiMessage":""},"infoItems":[],"invoiceItems":[{"id":145145183,"bookingId":80644286,"type":"charge","subType":8,"description":"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]","status":"","qty":1,"amount":170.12,"lineTotal":170.12,"vatRate":0,"invoiceeId":null,"createdBy":null,"createTime":"2026-01-11T12:16:05Z"},{"id":145145184,"bookingId":80644286,"type":"charge","subType":11,"description":"Host Fee","status":"","qty":1,"amount":0,"lineTotal":0,"vatRate":0,"invoiceeId":null,"createdBy":null,"createTime":"2026-01-11T12:16:05Z"}],"messages":[{"id":131490120,"authorOwnerId":null,"bookingId":80644286,"time":"2026-01-11T12:16:05Z","read":false,"message":"guten morgen carl, meine frau chiara und ich, chris, würden gerne am dienstag für drei nächte bei dir einchecken. wir wollen viel wandern gehn und sonst bei dir kochen und unser doppelbett genießen. wäre das möglich? beste grüße aus st anne. einen schönen sonntag dir","source":"guest"}],"retries":0}

TEXT NOT NULL

received_at

DATETIME (default CURRENT_TIMESTAMP

processed

BOOLEAN (default 0

processed_at

DATETIME

error

TEXT

dedupe_key

TEXT

payload_json

{"timeStamp":"2026-01-11T12:16:12Z","booking":{"id":80644286,"masterId":null,"bookingGroup":null,"propertyId":131309,"roomId":293387,"unitId":0,"roomQty":1,"offerId":0,"status":"new","subStatus":"none","arrival":"2026-01-13","departure":"2026-01-16","numAdult":2,"numChild":0,"title":"","firstName":"Christoph","lastName":"","email":"","phone":"","mobile":"","fax":"","company":"","address":"","city":"","state":"","postcode":"","country":"de","country2":"DE","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":"de","referer":"Airbnb","refererEditable":"Airbnb","reference":"","channel":"airbnb","apiSourceId":46,"apiSource":"Airbnb","apiReference":"2406966189","allowChannelUpdate":"all","allowAutoAction":"enable","allowReview":"default","allowCancellation":{"type":"propertyDefault"},"invoiceeId":null,"bookingTime":"2026-01-11T12:16:05Z","modifiedTime":"2026-01-11T12:16:05Z","cancelTime":null,"price":174,"deposit":0,"tax":0,"commission":0,"rateDescription":"Base Price 170.12 \nHost Fee -0.00 \nExpected Payout Amount  \n","stripeToken":null,"pcibookingToken":null,"apiMessage":""},"infoItems":[],"invoiceItems":[{"id":145145183,"bookingId":80644286,"type":"charge","subType":8,"description":"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]","status":"","qty":1,"amount":170.12,"lineTotal":170.12,"vatRate":0,"invoiceeId":null,"createdBy":null,"createTime":"2026-01-11T12:16:05Z"},{"id":145145184,"bookingId":80644286,"type":"charge","subType":11,"description":"Host Fee","status":"","qty":1,"amount":0,"lineTotal":0,"vatRate":0,"invoiceeId":null,"createdBy":null,"createTime":"2026-01-11T12:16:05Z"}],"messages":[{"id":131490120,"authorOwnerId":null,"bookingId":80644286,"time":"2026-01-11T12:16:05Z","read":false,"message":"guten morgen carl, meine frau chiara und ich, chris, würden gerne am dienstag für drei nächte bei dir einchecken. wir wollen viel wandern gehn und sonst bei dir kochen und unser doppelbett genießen. wäre das möglich? beste grüße aus st anne. einen schönen sonntag dir","source":"guest"}],"retries":0}

TEXT

Update row 93 in inbox_raw