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
Insert row into bookings
external_id
TEXT
property_id
TEXT NOT NULL
room_id
TEXT NOT NULL
room_name
TEXT NOT NULL
guest_name
TEXT NOT NULL
guest_email
TEXT
guest_phone
TEXT
check_in
DATE NOT NULL
check_out
DATE NOT NULL
total_price
DECIMAL(10,2)
status
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)
Insert
Cancel