🇲🇩 Java Enum: Moldova Regions
Moldova has 32 districts and 2 autonomous territorial units: the capital city of Chișinău and Bălți. Each region has an ISO 3166-2:MD code.
java
public enum MoldovaRegion {
ADJUD("MD-AD"),
ANENI_NOI("MD-AN"),
BĂLȚI("MD-BL"),
BASARABIA("MD-BA"),
BENDER("MD-BD"),
BRIJANY("MD-BJ"),
CĂUȘENI("MD-CS"),
CĂLĂRAȘI("MD-CL"),
CAMENIȚA("MD-CM"),
CĂUȘENI("MD-CU"),
DONDUSENI("MD-DO"),
DUBĂSARI("MD-DU"),
EDINEȚ("MD-ED"),
FĂLEȘTI("MD-FL"),
GLINOI("MD-GN"),
IALOVENI("MD-IA"),
IORGAȘI("MD-IO"),
ISMAIL("MD-IS"),
LIPCA("MD-LI"),
LEOVA("MD-LO"),
ORHEI("MD-OR"),
SLAVIANA("MD-SL"),
SOLDANESTI("MD-SD"),
STRĂȘENI("MD-STR"),
TACUTA("MD-TC"),
TELENESTI("MD-TL"),
URDULESTI("MD-UR");
private final String code;
MoldovaRegion(String code) {
this.code = code;
}
public String getCode() {
return code;
}
}
🗃️ SQL Table and Insert Statements
sql
CREATE TABLE moldova_regions (
id SERIAL PRIMARY KEY,
name VARCHAR(64) NOT NULL,
code VARCHAR(8) NOT NULL UNIQUE
);
INSERT INTO moldova_regions (name, code) VALUES
('Adjud', 'MD-AD'),
('Aneni Noi', 'MD-AN'),
('Bălți', 'MD-BL'),
('Basarabia', 'MD-BA'),
('Bender', 'MD-BD'),
('Brijany', 'MD-BJ'),
('Căușeni', 'MD-CS'),
('Călărași', 'MD-CL'),
('Camenitsa', 'MD-CM'),
('Căușeni', 'MD-CU'),
('Donduseni', 'MD-DO'),
('Dubăsari', 'MD-DU'),
('Edineț', 'MD-ED'),
('Fălești', 'MD-FL'),
('Glinoi', 'MD-GN'),
('Ialoveni', 'MD-IA'),
('Iorgași', 'MD-IO'),
('Ismail', 'MD-IS'),
('Lipca', 'MD-LI'),
('Leova', 'MD-LO'),
('Orhei', 'MD-OR'),
('Slaviana', 'MD-SL'),
('Soldănești', 'MD-SD'),
('Strășeni', 'MD-STR'),
('Tacuta', 'MD-TC'),
('Telenesti', 'MD-TL'),
('Urdulesti', 'MD-UR');
✅ Summary
This setup provides a representation of Moldova's regions using official ISO 3166-2 codes. This can be applied in various backend systems, databases, and geographic-based applications.