Programming & Development / April 11, 2025

Modeling North Macedonia's Regions in Java and SQL Using ISO 3166-2:MK Codes

North Macedonia regions North Macedonia municipalities Java enum North Macedonia ISO 3166-2 MK SQL North Macedonia North Macedonia subdivisions Spring Boot geographic enum North Macedonia administrative units backend regions North Macedonia regions of North Macedonia

🇲🇰 Java Enum: North Macedonia's Regions

North Macedonia is divided into 8 statistical regions, each with its official ISO 3166-2:MK code.

java

public enum NorthMacedoniaRegion {
    VARDAR("MK-VK"),
    EASTERN("MK-ER"),
    SOUTHWESTERN("MK-SW"),
    PELAGONIA("MK-PL"),
    POLKJOPSKA("MK-PK"),
    NORTHERN("MK-NO"),
    SOUTHERN("MK-SO"),
    SKOPJE("MK-SK");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO north_macedonia_regions (name, code) VALUES
('Vardar', 'MK-VK'),
('Eastern', 'MK-ER'),
('Southwestern', 'MK-SW'),
('Pelagonia', 'MK-PL'),
('Polkjopska', 'MK-PK'),
('Northern', 'MK-NO'),
('Southern', 'MK-SO'),
('Skopje', 'MK-SK');

✅ Summary

This setup models North Macedonia's 8 regions with their ISO 3166-2:MK codes. It can be used in backend systems, geographic applications, or databases dealing with North Macedonia's administrative regions.



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