TripOn

The Hotel Management module is used to manage hotels available in the system for accommodation booking. This module stores hotel details such as category, contact information, managing agency, images, description, and rating, which are later used for search, filtering, and package creation.

***Tables

hotel_master

Field Name Type Description

• id (PK) INT Hotel unique ID
• hotel_category_id (FK) INT References hotel_category_master.id
• hotel_name VARCHAR(150) Hotel name (case-insensitive unique per location)
• contact_number VARCHAR(15) Hotel contact number
• geog_id (FK) INT References khm_loc_mst_geography.geog_id (City / Tourist Location)
• agency_name VARCHAR(150) Managing agency / owner name
• image_url VARCHAR(255) Hotel image path
• description TEXT Hotel description
• rating INT Rating (1–5)
• enterprise_id INT Enterprise / owner reference
• is_active BOOLEAN Active / Inactive (soft delete)
• created_at DATETIME Created date
• updated_at DATETIME Updated date

***Validation

*Hotel Category:
* Mandatory
* Must be selected from Hotel Category Master

• Hotel Name:
  • Mandatory
  • Minimum 3 characters
  • Must be unique under the same location
  • Duplicate check must be case-insensitive
• Contact Number:
  • Mandatory
  • Numeric only
  • Length between 10–15 digits
• Location:
  • Mandatory
  • Must be selected from Geography Master
  • Restricted to City or Tourist Location level
• Agency Name:
  • Mandatory
  • Minimum 3 characters
• Image:
  • Optional
  • Allowed formats: JPG / PNG
• Description:
  • Optional
  • Should not exceed defined character limit
• Rating:
  • Must be a number between 1 and 5
• Soft delete should be used instead of hard delete