🇱🇻 Java Enum: Latvia’s Regions
Latvia is divided into 7 regions. Here’s the Java enum using ISO 3166-2:LV codes:
java
public enum LatviaRegion {
RIGA("LV-RIX"),
VIDS("LV-V"),
LATGALE("LV-LG"),
Kurzeme("LV-KZ"),
Zemgale("LV-ZM"),
Kurzeme("LV-KZ"),
Rīgas_pilsēta("LV-RIX");
private final String code;
LatviaRegion(String code) {
this.code = code;
}
public String getCode() {
return code;
}
}
🗃️ SQL Table and Insert Statements
sql
CREATE TABLE latvia_regions (
id SERIAL PRIMARY KEY,
name VARCHAR(64) NOT NULL,
code VARCHAR(8) NOT NULL UNIQUE
);
INSERT INTO latvia_regions (name, code) VALUES
('Riga', 'LV-RIX'),
('Vidus Latgale', 'LV-V'),
('Latgale', 'LV-LG'),
('Kurzeme', 'LV-KZ'),
('Zemgale', 'LV-ZM'),
('Rīgas_Pilsēta', 'LV-RIX');
✅ Summary
This setup covers all 7 regions of Latvia using ISO 3166-2:LV codes, ideal for backend services, Java applications, and SQL databases.