rooms
The Rooms table stores information about individual rooms in a property, likely for a hotel or accommodation management system.
| Field Name | Type | Other | Index |
|---|---|---|---|
| id | int(11) | NOT NULL AUTO_INCREMENT, | PK |
| Name | varchar(200) | CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | |
| description | longtext ) | CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | |
| Availability_Alerts | varchar(100) | CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | |
| Room_Features | text | CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | |
| Rooms_Available_To | int(11) | NOT NULL, | |
| cut_of_nights | varchar(4) | CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, | |
| bedroomscount | varchar(3) | CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | |
| Images | text | CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | |
| Property_Id | int(11) | NOT NULL, | Ya |
| auto_assign | varchar(4) | NOT NULL, | |
| room_order | int(11) | NOT NULL, | Ya |
| room_size_value | int(11) | NOT NULL, | |
| room_size_unit | varchar(20) | NOT NULL, | |
| bed_configurations_code | varchar(10) | NOT NULL, | |
| bed_configurations_count | int(11) | NOT NULL, | |
| bed_configurations_code2 | varchar(10) | NOT NULL, | |
| bed_configurations_count2 | int(11) | NOT NULL, | |
| extra_bed_configurations_code | varchar(50) | NOT NULL, | |
| extra_bed_configurations_count | int(11) | NOT NULL, | |
| room_view_types | varchar(10) | NOT NULL, | |
| accessibility_features | int(11) | NOT NULL, | |
| room_smoking_policy | varchar(16) | NOT NULL, | |
| free_allotment | int(11) | NOT NULL, | |
| amenities | mediumtext | NOT NULL, | |
| dynamic_pricing | int(11) | NOT NULL, | |
| Below is a detailed explanation of each field: |
Basic Identifiers
id: Unique identifier for each room.Property_Id: Links the room to a specific property in the system.
Room Details
Name: The name or type of the room (e.g., Deluxe Room, Standard Suite).description: A textual description of the room, highlighting its features.room_size_value: The numerical size of the room.room_size_unit: Unit of measurement for room size (e.g., square meters, square feet).room_order: Specifies the display order of the room within a property.
Availability & Booking Settings
Availability_Alerts: Alerts related to room availability (e.g., low inventory notifications).Rooms_Available_To: Specifies which user groups or platforms can book the room.cut_of_nights: The cutoff time for booking (e.g., bookings must be made X days in advance).auto_assign: Whether the system automatically assigns rooms based on availability.free_allotment: Indicates whether the room has a free allocation (i.e., reserved for special use).
Room Features & Configurations
Room_Features: List of general features available in the room.bedroomscount: Number of bedrooms in the room.bed_configurations_code: A code representing the type of bed configuration (e.g., "K" for King, "T" for Twin).bed_configurations_count: The number of beds corresponding tobed_configurations_code.bed_configurations_code2: Secondary bed configuration code (if applicable).bed_configurations_count2: Number of beds for the secondary configuration.extra_bed_configurations_code: Code for extra bed options (e.g., rollaway bed, sofa bed).extra_bed_configurations_count: The number of extra beds available.
Room Experience & Policies
room_view_types: Specifies the type of view from the room (e.g., ocean view, city view, garden view).accessibility_features: Lists accessibility features (e.g., wheelchair access, Braille signs).room_smoking_policy: Specifies whether the room is smoking or non-smoking.
Media & Amenities
Images: Stores links or references to room images.amenities: Lists room amenities (e.g., Wi-Fi, minibar, air conditioning).
Pricing & Revenue Management
dynamic_pricing: Indicates whether dynamic pricing is applied to the room (i.e., prices change based on demand and availability).