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 96 in inbox_raw
id
Primary key.
INTEGER
source
webhook
TEXT NOT NULL
payload
{"timeStamp":"2026-01-11T14:36:02Z","booking":{"id":80649988,"masterId":null,"bookingGroup":null,"propertyId":131309,"roomId":293385,"unitId":1,"roomQty":1,"offerId":1,"status":"new","subStatus":"none","arrival":"2026-01-13","departure":"2026-01-14","numAdult":2,"numChild":0,"title":"","firstName":"Louise","lastName":"Chartier","email":"chartierlouise1@gmail.com","phone":"","mobile":"0662323809","fax":"","company":"","address":"","city":"","state":"","postcode":"","country":"","country2":null,"arrivalTime":"17 h 30 - 19 h","voucher":"","comments":"","notes":"","message":"","groupNote":"","custom1":"","custom2":"","custom3":"","custom4":"","custom5":"","custom6":"","custom7":"","custom8":"","custom9":"","custom10":"","flagColor":"","flagText":"","statusCode":0,"lang":"fr","referer":"iframe","refererEditable":"iframe","reference":"","channel":"direct","apiSourceId":0,"apiSource":"Direct","apiReference":"","allowChannelUpdate":"all","allowAutoAction":"enable","allowReview":"default","allowCancellation":{"type":"propertyDefault"},"invoiceeId":null,"bookingTime":"2026-01-11T14:31:19Z","modifiedTime":"2026-01-11T14:35:51Z","cancelTime":null,"price":69,"deposit":69,"tax":0,"commission":0,"rateDescription":" \n2026-01-13 69 Papaye plan","stripeToken":"cus_TlxbbDTf5zazwX","pcibookingToken":null,"apiMessage":""},"infoItems":[{"id":158187952,"bookingId":80649988,"createTime":"2026-01-11T14:35:51Z","code":"STRIPEPAYMENT","text":"Payment 69 EUR, ch_3SoPk6LngO1CzI540X7iyYMd"}],"invoiceItems":[{"id":145156272,"bookingId":80649988,"type":"charge","subType":1,"description":"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]","status":"","qty":1,"amount":69,"lineTotal":69,"vatRate":0,"invoiceeId":null,"createdBy":null,"createTime":"2026-01-11T14:31:19Z"},{"id":145156661,"bookingId":80649988,"type":"payment","subType":203,"description":"Booking 80649988: Louise Chartier","status":"Paid","amount":69,"lineTotal":-69,"invoiceeId":null,"createdBy":null,"createTime":"2026-01-11T14:35:51Z"}],"messages":[],"retries":0}
TEXT NOT NULL
received_at
DATETIME (default CURRENT_TIMESTAMP
processed
BOOLEAN (default 0
processed_at
DATETIME
error
NULL
TEXT
dedupe_key
34002854
TEXT
payload_json
{"timeStamp":"2026-01-11T14:36:02Z","booking":{"id":80649988,"masterId":null,"bookingGroup":null,"propertyId":131309,"roomId":293385,"unitId":1,"roomQty":1,"offerId":1,"status":"new","subStatus":"none","arrival":"2026-01-13","departure":"2026-01-14","numAdult":2,"numChild":0,"title":"","firstName":"Louise","lastName":"Chartier","email":"chartierlouise1@gmail.com","phone":"","mobile":"0662323809","fax":"","company":"","address":"","city":"","state":"","postcode":"","country":"","country2":null,"arrivalTime":"17 h 30 - 19 h","voucher":"","comments":"","notes":"","message":"","groupNote":"","custom1":"","custom2":"","custom3":"","custom4":"","custom5":"","custom6":"","custom7":"","custom8":"","custom9":"","custom10":"","flagColor":"","flagText":"","statusCode":0,"lang":"fr","referer":"iframe","refererEditable":"iframe","reference":"","channel":"direct","apiSourceId":0,"apiSource":"Direct","apiReference":"","allowChannelUpdate":"all","allowAutoAction":"enable","allowReview":"default","allowCancellation":{"type":"propertyDefault"},"invoiceeId":null,"bookingTime":"2026-01-11T14:31:19Z","modifiedTime":"2026-01-11T14:35:51Z","cancelTime":null,"price":69,"deposit":69,"tax":0,"commission":0,"rateDescription":" \n2026-01-13 69 Papaye plan","stripeToken":"cus_TlxbbDTf5zazwX","pcibookingToken":null,"apiMessage":""},"infoItems":[{"id":158187952,"bookingId":80649988,"createTime":"2026-01-11T14:35:51Z","code":"STRIPEPAYMENT","text":"Payment 69 EUR, ch_3SoPk6LngO1CzI540X7iyYMd"}],"invoiceItems":[{"id":145156272,"bookingId":80649988,"type":"charge","subType":1,"description":"[ROOMNAME1] [FIRSTNIGHT] - [LEAVINGDAY]","status":"","qty":1,"amount":69,"lineTotal":69,"vatRate":0,"invoiceeId":null,"createdBy":null,"createTime":"2026-01-11T14:31:19Z"},{"id":145156661,"bookingId":80649988,"type":"payment","subType":203,"description":"Booking 80649988: Louise Chartier","status":"Paid","amount":69,"lineTotal":-69,"invoiceeId":null,"createdBy":null,"createTime":"2026-01-11T14:35:51Z"}],"messages":[],"retries":0}
TEXT
Update
Cancel