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 232 in bookings
id
Primary key.
INTEGER
external_id
85908097
TEXT
property_id
131309
TEXT NOT NULL
room_id
293386
TEXT NOT NULL
room_name
Chambre Mango
TEXT NOT NULL
guest_name
Charles-Hugo Rime
TEXT NOT NULL
guest_email
crime.901032@guest.booking.com
TEXT
guest_phone
+33 648889675
TEXT
check_in
DATE NOT NULL
check_out
DATE NOT NULL
total_price
DECIMAL(10,2)
status
confirmed
TEXT (default 'pending'
group_id
NULL
TEXT
group_type
NULL
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
Update
Cancel