TripOn

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