TripOn

This module is used to manage locations under a specific district. It is part of the geography hierarchy (Country → State → District → Location). These locations will be used across the system such as hotels, transporters, sightseeing, and tour planning. Only active locations should be available for selection in dependent modules.

Table

c2b_loc_master

• loc_id (PK) INT AUTO_INCREMENT Unique location ID
• district_id (FK) INT References c2b_district_master.district_id
• loc_name VARCHAR(150) Name of the location
• is_active BOOLEAN DEFAULT TRUE Active / inactive status
• created_at DATETIME Record created date
• updated_at DATETIME Record updated date

Validations

Mandatory

• district_id required
• loc_name required

District

• district_id must exist in c2b_district_master
• district must be active

Location Name

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

Duplicate Validation

• Prevent duplicate location under same district.

Edit

Allow edit:

• loc_name
• is_active

Do NOT allow edit:

• district_id

Delete Rule

• Soft delete only.
• is_active = FALSE

Do not physically delete the record.