Programming & Development / April 11, 2025

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

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

🇬🇷 Java Enum: Greece’s Regions

Greece is divided into 13 regions. Here’s the Java enum using ISO 3166-2:GR codes:

java

public enum GreeceRegion {
    ATTICA("GR-A"),
    CENTRAL_GREECE("GR-B"),
    CENTRAL_MACEDONIA("GR-C"),
    EASTERN_MACEDONIA_THRACE("GR-D"),
    IONIAN_ISLANDS("GR-E"),
    NORTH_EASTERN_AEGAEAN("GR-F"),
    PELOPONNESE("GR-G"),
    SOUTH_AEGAEAN("GR-H"),
    WESTERN_GREECE("GR-I"),
    WESTERN_MACEDONIA("GR-J"),
    CRETE("GR-K"),
    THESSALY("GR-L"),
    EPIRUS("GR-M");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO greece_regions (name, code) VALUES
('Attica', 'GR-A'),
('Central Greece', 'GR-B'),
('Central Macedonia', 'GR-C'),
('Eastern Macedonia and Thrace', 'GR-D'),
('Ionian Islands', 'GR-E'),
('North Aegean', 'GR-F'),
('Peloponnese', 'GR-G'),
('South Aegean', 'GR-H'),
('Western Greece', 'GR-I'),
('Western Macedonia', 'GR-J'),
('Crete', 'GR-K'),
('Thessaly', 'GR-L'),
('Epirus', 'GR-M');

✅ Summary

This setup covers all 13 regions of Greece using ISO 3166-2:GR 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