Back to Schema

Database Tables

Connected

Database Overview

58
Total Tables
Online
Connection Status
canaccom
Database Name

Table: booking_hotel_amenities

0 rows

Structure

Field Type Null Key Default Extra
id int NO PRI NULL auto_increment
booking_hotel_id int NO MUL NULL
adjoining_rooms_available tinyint(1) YES 0
suites_available tinyint(1) YES 0
mini_fridge_standard tinyint(1) YES 0
microwave_standard tinyint(1) YES 0
coffee_maker_standard tinyint(1) YES 0
non_smoking_facility tinyint(1) YES 0
no_smoking_rooms_requested tinyint(1) YES 0
breakfast_included tinyint(1) YES 0
breakfast_hot_buffet tinyint(1) YES 0
breakfast_hot_continental tinyint(1) YES 0
breakfast_cold_continental tinyint(1) YES 0
breakfast_vouchers tinyint(1) YES 0
onsite_restaurant tinyint(1) YES 0
can_be_negotiated tinyint(1) YES 0
indoor_pool tinyint(1) YES 0
outdoor_pool tinyint(1) YES 0
hot_tub tinyint(1) YES 0
sauna tinyint(1) YES 0
steam_room tinyint(1) YES 0
waterslide tinyint(1) YES 0
fitness_centre tinyint(1) YES 0
pets_allowed tinyint(1) YES 0
cots tinyint(1) YES 0
equipment_storage tinyint(1) YES 0
meeting_room tinyint(1) YES 0
other_amenities text YES NULL
created_at timestamp YES CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp YES CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP