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 284 in bookings
id
Primary key.
INTEGER
external_id
89635558
TEXT
property_id
131309
TEXT NOT NULL
room_id
293386
TEXT NOT NULL
room_name
Chambre Mango
TEXT NOT NULL
guest_name
Patrick SOLITUDE
TEXT NOT NULL
guest_email
psolit.381614@guest.booking.com
TEXT
guest_phone
+33 6 12 96 47 33
TEXT
check_in
DATE NOT NULL
check_out
DATE NOT NULL
total_price
DECIMAL(10,2)
status
new
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