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
Drop Column
Column name
Select column
id (INTEGER)
external_id (TEXT)
property_id (TEXT)
room_id (TEXT)
room_name (TEXT)
guest_name (TEXT)
guest_email (TEXT)
guest_phone (TEXT)
check_in (DATE)
check_out (DATE)
total_price (DECIMAL(10,2))
status (TEXT)
group_id (TEXT)
group_type (TEXT)
created_at (DATETIME)
updated_at (DATETIME)
notification_sent (BOOLEAN)
notification_type (TEXT)
notification_last_status (TEXT)
is_test_data (BOOLEAN)
Drop column
Cancel