Task #178
Updated by Dana Basheer about 2 months ago
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** 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.