Programming & Development / April 11, 2025

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

Guinea-Bissau regions Java enum Guinea-Bissau ISO 3166-2 GW SQL Guinea-Bissau regions GW region codes Guinea-Bissau administrative divisions backend region enum Guinea-Bissau provinces Java SQL Spring Boot regions Guinea-Bissau

🇬🇼 Java Enum: Guinea-Bissau’s Regions

Guinea-Bissau is divided into 7 regions. Here’s the Java enum using ISO 3166-2:GW codes:

java

public enum GuineaBissauRegion {
    BISSALanca("GW-BS"),
    BAFATA("GW-BF"),
    BIOMBA("GW-BM"),
    CACHEU("GW-CA"),
    GABU("GW-GA"),
    OIO("GW-01"),
    TOMBALI("GW-TO");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO guinea_bissau_regions (name, code) VALUES
('Bissau', 'GW-BS'),
('Bafata', 'GW-BF'),
('Biomba', 'GW-BM'),
('Cacheu', 'GW-CA'),
('Gabu', 'GW-GA'),
('Oio', 'GW-01'),
('Tombali', 'GW-TO');

✅ Summary

This setup covers all 7 regions of Guinea-Bissau using ISO 3166-2:GW codes, perfect for backend systems, 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