Programming & Development / April 11, 2025

Modeling Mauritius Districts in Java and SQL Using ISO 3166-2:MU Codes

Mauritius Java enum ISO 3166-2 MU Mauritius districts SQL Mauritius regions Spring Boot geography backend enum Mauritius Indian Ocean territories Java country districts Mauritius administrative codes

๐Ÿ‡ฒ๐Ÿ‡บ Java Enum: Mauritius Districts

Mauritius has 9 districts and 3 dependencies (total: 12 subdivisions), each with an official ISO 3166-2:MU code.

java

public enum MauritiusDistrict {
    AGALEGA_ISLANDS("MU-AG"),
    BEAU_BASSIN_ROSE_HILL("MU-BR"),
    BLACK_RIVER("MU-BL"),
    CUREPIPE("MU-CC"),
    FLACQ("MU-FL"),
    GRAND_PORT("MU-GP"),
    MOKA("MU-MO"),
    PAMPLEMOUSSES("MU-PA"),
    PLAINE_WILHEMS("MU-PW"),
    PORT_LOUIS("MU-PL"),
    RODRIGUES_ISLANDS("MU-RO"),
    SAVANNE("MU-SA");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

๐Ÿ—ƒ๏ธ SQL Table and Insert Statements

sql

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

INSERT INTO mauritius_districts (name, code) VALUES
('Agalรฉga Islands', 'MU-AG'),
('Beau Bassin-Rose Hill', 'MU-BR'),
('Black River', 'MU-BL'),
('Curepipe', 'MU-CC'),
('Flacq', 'MU-FL'),
('Grand Port', 'MU-GP'),
('Moka', 'MU-MO'),
('Pamplemousses', 'MU-PA'),
('Plaine Wilhems', 'MU-PW'),
('Port Louis', 'MU-PL'),
('Rodrigues Islands', 'MU-RO'),
('Savanne', 'MU-SA');

โœ… Summary

This Java enum and SQL table use official ISO 3166-2 codes for Mauritius' 12 administrative divisions, perfect for backend systems needing consistent geographic representations.



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