TripOn

This module is used to manage hotel details in the system. Each hotel belongs to a specific location and can optionally be associated with nearby sightseeing places. The module stores information such as hotel name, location, description, and image.

Table

c2b_hotel_master

• hotel_id (PK) INT AUTO_INCREMENT Unique hotel ID
• loc_id (FK) INT References loc_master.loc_id
• hotel_name VARCHAR(150) Name of the hotel
• description TEXT Hotel description
• image_url VARCHAR(255) Hotel image URL
• is_active BOOLEAN DEFAULT TRUE Active / inactive status
• created_at DATETIME Record created date
• updated_at DATETIME Record updated date

Validations

Mandatory

• loc_id required
• hotel_name required

Hotel Name

• Minimum 2 characters
• Maximum 150 characters
• Cannot be empty

Duplicate

• Prevent duplicate hotel name within the same location.

Location

• loc_id must exist in loc_master
• location must be active

Image

• Allowed formats: jpg, jpeg, png, webp
• Maximum file size: 5 MB
• Stored as image_url

Edit

Allow edit:

• hotel_name
• description
• image_url
• is_active

Do NOT allow edit:

• loc_id

Delete

• Soft delete only.

Set:

• is_active = FALSE
• Do not physically delete the record.