Task #160
Updated by Dana Basheer about 2 months ago
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. These hotels will be used in other modules such as tour planning, hotel selection, and public APIs.
**Table**
hotel_master
* hotel_id (PK) INT AUTO_INCREMENT Unique hotel ID
* loc_id (FK) INT References loc_master.loc_id
* sight_seeing_id (FK) INT References sightseeing_master.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
Sightseeing
* sight_seeing_id must exist in sightseeing_master
* sightseeing should belong to the same location
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.