Task #176
Updated by Dana Basheer about 2 months ago
This module is used to manage country details in the system. Countries are the top-level geographic entities used to organize states, districts, and locations. These records will be referenced by other modules such as state master, district master, and location master. Only active countries should be available for selection in dependent modules.
**Table**
c2b_country_master
* country_id (PK) INT AUTO_INCREMENT Unique country ID
* country_name VARCHAR(150) Name of the country
* country_code VARCHAR(10) Country code (example: IN, US)
* is_active BOOLEAN DEFAULT TRUE Active / inactive status
* created_at DATETIME Record created date
* updated_at DATETIME Record updated date
**Validations**
Mandatory
* country_name required
* country_code required
Country Name
* Minimum 2 characters
* Maximum 150 characters
* Cannot be empty
Country Code
* Must contain 2–5 characters
* Should be uppercase
* Must be unique
Duplicate
* Prevent duplicate country
Edit
Allow edit
* country_name
* country_code
* is_active
Do Not edit
* country_id
Delete
* Soft delete only
* set
is_active=False