TripOn

This module is used to manage district details in the system. Each district belongs to a specific state. District records are used in other modules such as location master, hotel master, transporter master, and sightseeing master to maintain geographic hierarchy. Only active districts should be available for selection in dependent modules.

Table

c2b_district_master

• district_id (PK) INT AUTO_INCREMENT Unique district ID
• state_id (FK) INT References c2b_state_master.state_id
• district_name VARCHAR(150) Name of the district
• district_code VARCHAR(10) Short code for the district
• is_active BOOLEAN DEFAULT TRUE Active / inactive status
• created_at DATETIME Record created date
• updated_at DATETIME Record updated date

Validations

Mandatory

• state_id required
• district_name required
• district_code required

State

• state_id must exist in c2b_state_master
• state must be active

District Name

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

District Code

• Maximum 10 characters
• Usually uppercase
• Must be unique within the state

Duplicate

• Prevent duplicate district in the same state.

Edit

Allow edit:

• district_name
• district_code
• is_active

Do NOT allow edit:

• state_id

Delete Rule

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