Programming & Development / April 11, 2025

Modeling Mozambique's Provinces in Java and SQL Using ISO 3166-2:MO Codes

Mozambique provinces Java enum Mozambique ISO 3166-2 MO SQL Mozambique Mozambique regions Mozambican provinces Spring Boot geographic enum Mozambique administrative units Mozambique backend regions provinces of Mozambique

🇲🇿 Java Enum: Mozambique Provinces

Mozambique is divided into 10 provinces, each with its official ISO 3166-2:MO code.

java

public enum MozambiqueProvince {
    MAPUTO("MO-MP"),
    GAZA("MO-G"), 
    INHAMBANE("MO-IA"), 
    SOFALA("MO-SF"), 
    MANICA("MO-MN"),
    TETE("MO-TE"), 
    ZAMBEZIA("MO-ZA"), 
    NAMPULA("MO-NU"), 
    CADAIRA("MO-CA"), 
    NIASSA("MO-NI");
    
    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO mozambique_provinces (name, code) VALUES
('Maputo', 'MO-MP'),
('Gaza', 'MO-G'),
('Inhambane', 'MO-IA'),
('Sofala', 'MO-SF'),
('Manica', 'MO-MN'),
('Tete', 'MO-TE'),
('Zambezia', 'MO-ZA'),
('Nampula', 'MO-NU'),
('Cadera', 'MO-CA'),
('Niassa', 'MO-NI');

✅ Summary

This setup models Mozambique's provinces with their ISO 3166-2:MO codes, making it useful for backend systems, geographic data applications, and database management.



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