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 4 in bookings
id
Primary key.
INTEGER
external_id
78514226
TEXT
property_id
131309
TEXT NOT NULL
room_id
293385
TEXT NOT NULL
room_name
Chambre Papaye
TEXT NOT NULL
guest_name
Claude Whalen
TEXT NOT NULL
guest_email
cwhale.986909@guest.booking.com
TEXT
guest_phone
NULL
TEXT
check_in
DATE NOT NULL
check_out
DATE NOT NULL
total_price
DECIMAL(10,2)
status
new
TEXT (default 'pending'
group_id
TEXT
group_type
TEXT
created_at
DATETIME (default CURRENT_TIMESTAMP
updated_at
DATETIME (default CURRENT_TIMESTAMP
notification_sent
BOOLEAN (default 0
notification_type
TEXT
notification_last_status
TEXT
is_test_data
BOOLEAN (default 0
Update
Cancel