Enum Representation of Federal Subjects in Russia and SQL Table for Storing Federal Subject Data

Programming & Development / April 12, 2025

Enum Representation of Federal Subjects in Russia and SQL Table for Storing Federal Subject Data

Enum Federal Subject Russia Java SQL Adygea Altai Republic Amur Arkhangelsk Astrakhan Bashkortostan Belgorod Bryansk Buryatia Chelyabinsk Chukchi Chuvashia Dagestan Ingushetia Irkutsk Ivanovo Jewish Autonomous Kabardino-Balkar Kaliningrad Kalmykia Kamchatka Karachay-Cherkessia Kemerovo Khabarovsk Khakassia Kostroma Kurgan Kursk Leningrad Lipetsk Magadan Moscow Murmansk Nizhny Novgorod North Ossetia Omsk Orenburg Penza Perm Primorsky Pskov Rostov Ryazan Sakha Samara Saratov Sakhalin Sverdlovsk Smolensk St. Petersburg Tambov Tatarstan Tomsk Tula Tuva Tver Tyumen Udmurtia Ulyanovsk Vladimir Volgograd Vologda Voronezh Yakutia Yamal-Nenets Yaroslavl Moscow Oblast Region Code

Copy Link Bookmark Print

Enum Representation in Java

Russia is divided into 85 federal subjects, which include oblasts, republics, krais, autonomous okrugs, federal cities, and an autonomous oblast. Below is an enum representation of these federal subjects with their respective codes:

java

public enum FederalSubject {
    ADYGEA("AD"),
    ALTAI_REPUBLIC("AL"),
    AMUR("AM"),
    ARKHANGELSK("ARK"),
    ASTRAKHAN("AST"),
    BASHKORTOSTAN("BA"),
    BELGOROD("BE"),
    BRYANSK("BR"),
    BURYATIA("BU"),
    CHELYABINSK("CHE"),
    CHUKCHI("CHU"),
    CHUVASHIA("CV"),
    DAGESTAN("DA"),
    INGUSHETIA("IN"),
    IRKUTSK("IRK"),
    IVANOVO("IVA"),
    JEWISH_AUTONOMOUS("JA"),
    KABARDINO_BALKAR("KB"),
    KALININGRAD("KA"),
    KALMYKIA("KL"),
    KAMCHATKA("KM"),
    KARACHAY_CHERKESSIA("KC"),
    KEMEROVO("KE"),
    KHABAROVSK("KH"),
    KHAKASSIA("KK"),
    KOSTROMA("KO"),
    KURGAN("KU"),
    KURSK("KS"),
    LENINGRAD("LEN"),
    LIPETSK("LI"),
    MAGADAN("MA"),
    MOSCOW("MO"),
    MURMANSK("MU"),
    NIZHNY_NOVGOROD("NN"),
    NORTH_OSSETIA("NO"),
    OMSK("OM"),
    ORENBURG("OR"),
    PENZA("PE"),
    PERM("PER"),
    PRIMORSKY("PR"),
    PSKOV("PS"),
    ROSTOV("RO"),
    RYAZAN("RY"),
    SAKHA("SA"),
    SAMARA("SAM"),
    SARATOV("SAR"),
    SAKHALIN("SAK"),
    SVERDLOVSK("SV"),
    SMOLENSK("SM"),
    SAINT_PETERSBURG("SPB"),
    TAMBOV("TAM"),
    TATARSTAN("TA"),
    TOMSK("TO"),
    TULA("TU"),
    TUVA("TY"),
    TVER("TV"),
    TYUMEN("TYU"),
    UDMURTIA("UD"),
    ULYANOVSK("UL"),
    VLADIMIR("VL"),
    VOLGOGRAD("VO"),
    VOLOGDA("VO"),
    VORONEZH("VO"),
    YAKUTIA("YA"),
    YAMAL_NENETS("YN"),
    YAROSLAVL("YA"),
    MOSCOW_OBLAST("MO");

    private final String code;

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

    public String getCode() {
        return this.code;
    }
}

In the code:

The enum FederalSubject defines the 85 federal subjects of Russia along with their respective codes.
Each federal subject is associated with a two or three-character abbreviation.
The getCode() method allows access to the federal subject's code.

SQL Representation for Storing Federal Subject Data

To store the federal subjects of Russia in a database, you can create a table and insert the data using the following SQL:

sql

-- Table definition for storing federal subjects of Russia
CREATE TABLE federal_subjects (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    code CHAR(3) NOT NULL
);

-- Inserting data for federal subjects of Russia
INSERT INTO federal_subjects (name, code) VALUES
('Adygea', 'AD'),
('Altai Republic', 'AL'),
('Amur', 'AM'),
('Arkhangelsk', 'ARK'),
('Astrakhan', 'AST'),
('Bashkortostan', 'BA'),
('Belgorod', 'BE'),
('Bryansk', 'BR'),
('Buryatia', 'BU'),
('Chelyabinsk', 'CHE'),
('Chukchi', 'CHU'),
('Chuvashia', 'CV'),
('Dagestan', 'DA'),
('Ingushetia', 'IN'),
('Irkutsk', 'IRK'),
('Ivanovo', 'IVA'),
('Jewish Autonomous', 'JA'),
('Kabardino-Balkar', 'KB'),
('Kaliningrad', 'KA'),
('Kalmykia', 'KL'),
('Kamchatka', 'KM'),
('Karachay-Cherkessia', 'KC'),
('Kemerovo', 'KE'),
('Khabarovsk', 'KH'),
('Khakassia', 'KK'),
('Kostroma', 'KO'),
('Kurgan', 'KU'),
('Kursk', 'KS'),
('Leningrad', 'LEN'),
('Lipetsk', 'LI'),
('Magadan', 'MA'),
('Moscow', 'MO'),
('Murmansk', 'MU'),
('Nizhny Novgorod', 'NN'),
('North Ossetia', 'NO'),
('Omsk', 'OM'),
('Orenburg', 'OR'),
('Penza', 'PE'),
('Perm', 'PER'),
('Primorsky', 'PR'),
('Pskov', 'PS'),
('Rostov', 'RO'),
('Ryazan', 'RY'),
('Sakha', 'SA'),
('Samara', 'SAM'),
('Saratov', 'SAR'),
('Sakhalin', 'SAK'),
('Sverdlovsk', 'SV'),
('Smolensk', 'SM'),
('Saint Petersburg', 'SPB'),
('Tambov', 'TAM'),
('Tatarstan', 'TA'),
('Tomsk', 'TO'),
('Tula', 'TU'),
('Tuva', 'TY'),
('Tver', 'TV'),
('Tyumen', 'TYU'),
('Udmurtia', 'UD'),
('Ulyanovsk', 'UL'),
('Vladimir', 'VL'),
('Volgograd', 'VO'),
('Vologda', 'VO'),
('Voronezh', 'VO'),
('Yakutia', 'YA'),
('Yamal-Nenets', 'YN'),
('Yaroslavl', 'YA'),
('Moscow Oblast', 'MO');

In the SQL:

We define a federal_subjects table with columns id (auto-incremented), name (the name of the federal subject), and code (the abbreviation for the federal subject).
The INSERT INTO statement adds the federal subjects of Russia along with their respective codes into the table.

This setup ensures that you can efficiently store and query the federal subjects of Russia, both in your Java application (via enums) and in a relational database system.

Share this article:

Comments

No comments yet

NUHMAN.com