TripOn

This module is used to manage locations that will be exposed through a public API. Each location belongs to a district and can be used by external systems or frontend applications for location selection.

Table

loc_master

• loc_id (PK) INT AUTO_INCREMENT Unique location ID
• district_id (FK) INT References district_master.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
• name required

Name

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

Duplicate Validation

• Prevent duplicate location under the same district.

District

• district_id must exist in district_master
• district must be active

Edit

Allow edit:

• name
• is_active

Do NOT allow edit:

• district_id

Delete

• Soft delete only.

Set:

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