Programming & Development / April 11, 2025

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

Liechtenstein regions Java enum Liechtenstein ISO 3166-2 LI SQL Liechtenstein regions LI region codes Liechtenstein administrative divisions backend region enum Liechtenstein regions Java SQL Spring Boot regions Liechtenstein

🇱🇮 Java Enum: Liechtenstein’s Regions

Liechtenstein is divided into 2 regions. Here’s the Java enum using ISO 3166-2:LI codes:

java

public enum LiechtensteinRegion {
    OBERLAND("LI-01"),
    UNTERLAND("LI-02");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO liechtenstein_regions (name, code) VALUES
('Oberland', 'LI-01'),
('Unterland', 'LI-02');

✅ Summary

This setup covers both regions of Liechtenstein using ISO 3166-2:LI 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