sqlite-web 0.7.0
db.sqlite
bookings
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 379 in bookings
id
Primary key.
INTEGER
external_id
91943063
TEXT
property_id
131309
TEXT NOT NULL
room_id
293385
TEXT NOT NULL
room_name
Chambre Papaye
TEXT NOT NULL
guest_name
Raulain Sandrine
TEXT NOT NULL
guest_email
rsandr.972099@guest.booking.com
TEXT
guest_phone
+596 696 25 66 69
TEXT
check_in
DATE NOT NULL
check_out
DATE NOT NULL
total_price
DECIMAL(10,2)
status
confirmed
TEXT (default 'pending'
group_id
91943061
TEXT
group_type
masterId
TEXT
created_at
DATETIME (default CURRENT_TIMESTAMP
updated_at
DATETIME (default CURRENT_TIMESTAMP
notification_sent
BOOLEAN (default 0
notification_type
NULL
TEXT
notification_last_status
NULL
TEXT
is_test_data
BOOLEAN (default 0
source
NULL
TEXT
commission
DECIMAL(10,2)
Update
Cancel