Programming & Development / April 11, 2025

Modeling the States of Micronesia in Java and SQL Using ISO 3166-2:FM Codes

Micronesia states Java enum Micronesia ISO 3166-2 FM SQL Micronesia FSM backend regions Micronesia database schema Spring Boot ISO enum Federated States of Micronesia Micronesia Java model

πŸ‡«πŸ‡² Java Enum: Micronesia States

Micronesia is composed of 4 states, each consisting of multiple islands. Each state has an ISO 3166-2:FM code:

java

public enum MicronesiaState {
    CHUUK("FM-TRK"),
    KOSRAE("FM-KSA"),
    POHNPEI("FM-PNI"),
    YAP("FM-YAP");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

πŸ—ƒοΈ SQL Table and Insert Statements

sql

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

INSERT INTO micronesia_states (name, code) VALUES
('Chuuk', 'FM-TRK'),
('Kosrae', 'FM-KSA'),
('Pohnpei', 'FM-PNI'),
('Yap', 'FM-YAP');

βœ… Summary

This setup models the 4 federated states of Micronesia using standardized ISO codes. It’s ideal for building country-aware applications with clean, maintainable geography-based data.



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