TripOn

To add and manage season-based room rates for hotels. Admin can define season name, start date, end date, room category, room type (Single/Double – static), and rate. This allows the system to apply different room rates based on season period and room type. The listing screen shows all season rates added for hotel room categories.

Table

hotel_room_season_master

• id INT PK AUTO_INCREMENT Unique ID
• hotel_id INT FK → hotel_master.id Hotel reference
• room_category_id INT FK → hotel_category_master.id Room category
• room_type ENUM('Single','Double') Room type (static)
• season_name VARCHAR(100) Season name (Peak, Off, etc.)
• start_date DATE Season start date
• end_date DATE Season end date
• rate DECIMAL(10,2) Room rate
• enterprise_id INT FK → enterprise_master.id Enterprise reference
• is_active BOOLEAN Active / inactive
• created_at DATETIME Created time
• updated_at DATETIME Updated time

Validations

Mandatory

• hotel_id required
• room_category_id required
• room_type required
• season_name required
• start_date required
• end_date required
• rate required
• enterprise_id required

Room Type

Must be only:

• Single
• Double

No other values allowed

Date

• start_date must be ≤ end_date
• Cannot allow invalid date range

Rate

• Must be numeric
• Must be ≥ 0
• Cannot be empty

Duplicate

Prevent duplicate combination:

Same:

• hotel_id
• room_category_id
• room_type
• season_name
• start_date
• end_date
• enterprise_id

cannot be added twice

Enterprise

enterprise_id must match hotel_master.enterprise_id

Edit

Allow edit:

• season_name
• start_date
• end_date
• rate
• is_active

Active / Inactive

• is_active = TRUE → usable
• is_active = FALSE → hidden
• Soft delete only