TripOn

The Sight Seeing module is used to manage tourist attractions available at a specific Tourist Location.
Each sight-seeing entry represents a place that users can visit, along with its fee, distance, vendor details, images, and description.

***Table

sight_seeing_master

Field Name Type Notes

• id (PK) INT Primary key
• sight_seeing_name VARCHAR(150) Case-insensitive unique per location
• geog_id (FK) INT References geography (Tourist Location)
• distance_km DECIMAL(6,2) Clarify base distance
• vendor_id INT FK (optional, if vendor table used)
• sight_seeing_fee DECIMAL(10,2) Default 0.00
• image_url VARCHAR(255) Image path
• description TEXT Optional
• is_active BOOLEAN Soft delete
• created_at DATETIME Created date

***Validations

• Sight Seeing Name is mandatory
• Sight Seeing Name must have minimum 3 characters
• Sight Seeing Name must be unique under the same Tourist Location
• Duplicate check must be case-insensitive
• Location must be selected from Geography Master
• Location must be of Tourist Location level only
• Distance must be a positive number
• Sight Seeing Fee:
  * Can be 0
  * Must not be negative
• Vendor Contact Number:
  * Must contain valid digits only
  * Length validation as per standard (10–15 digits)
• Image:
  * Allowed formats: JPG / PNG
  * Optional field
• Description:
  * Optional
  * Should not exceed defined character limit