TripOn

The Geography module is used to manage hierarchical location data such as World, Country, State, and City.
It supports search, add, edit, and delete operations while maintaining parent–child relationships.

***Table Structure

khm_loc_mst_geography

• geog_id (PK)-Geography ID
• geog_level_id-Geography level (World /Country / State / City)
• geog_name-Name of the location
• geog_parent_id-Parent geography ID
• geog_is_arrival-Arrival location flag
• geog_latitude-Latitude
• geog_longitude-Longitude
• geog_timezone-Timezone
  *geog_img-jpg,png
• geog_description-Description
• deleted-Soft delete flag
• enterprise_id-Enterprise reference

***geo_level_master

• id (PK)-INT-Unique level ID
• level_name-VARCHAR(50)-World / Country / State / City
• level_order-INT-Hierarchy order (1–World, 2–Country, etc.)
• is_active-BOOLEAN-Active / Inactive
• created_at-DATETIME-Created date
• updated_at-DATETIME-Updated date

***Validations (Add Geography)

• Geography Name is mandatory
• Geography Level selection is mandatory
• Parent selection is mandatory except for World
• Geography Name must be unique under same parent
• Trim leading & trailing spaces
• Save should be blocked if validation fails

***Validations (Edit Geography)

• Existing values should auto-fill
• Geography Name cannot be empty
• Duplicate name under same parent is not allowed
• Parent change should revalidate uniqueness
• Changes should reflect immediately in hierarchy list

***Validations (Delete Geography)

• Confirmation popup is mandatory
• If child locations exist → deletion must be blocked
• Soft delete (deleted = 1) preferred
• Proper error message must be shown