Programming & Development / April 11, 2025

How to Represent The Gambia’s Regions in Java and SQL Using ISO 3166-2 Codes

Gambia regions Java enum Gambia ISO 3166-2 GM SQL Gambia regions GM region codes Gambia administrative divisions backend region enum Gambia provinces Java SQL Spring Boot regions Gambia

🇬🇲 Java Enum: The Gambia’s Regions

The Gambia is divided into 5 regions. Here’s the Java enum using ISO 3166-2:GM codes:

java

public enum GambiaRegion {
    BANJUL("GM-BJ"),
    BRIKAMA("GM-BK"),
    KEREWAN("GM-KW"),
    KUNTYANG("GM-KY"),
    LOWER_RIVER("GM-LR");

    private final String code;

    GambiaRegion(String code) {
        this.code = code;
    }

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

CREATE TABLE gambia_regions (
    id SERIAL PRIMARY KEY,
    name VARCHAR(64) NOT NULL,
    code VARCHAR(8) NOT NULL UNIQUE
);

INSERT INTO gambia_regions (name, code) VALUES
('Banjul', 'GM-BJ'),
('Brikama', 'GM-BK'),
('Kerewan', 'GM-KW'),
('Kuntjang', 'GM-KY'),
('Lower River', 'GM-LR');

✅ Summary

This setup covers all 5 regions of The Gambia using ISO 3166-2:GM codes, ideal for backend services, Java applications, and SQL databases.


Comments

No comments yet

Add a new Comment

NUHMAN.COM

Information Technology website for Programming & Development, Web Design & UX/UI, Startups & Innovation, Gadgets & Consumer Tech, Cloud Computing & Enterprise Tech, Cybersecurity, Artificial Intelligence (AI) & Machine Learning (ML), Gaming Technology, Mobile Development, Tech News & Trends, Open Source & Linux, Data Science & Analytics

Categories

Tags

©{" "} Nuhmans.com . All Rights Reserved. Designed by{" "} HTML Codex