🇨🇩 Java Enum: DRC Provinces
The Democratic Republic of the Congo is divided into 26 provinces, including the capital city Kinshasa as a province. Here's the Java enum using ISO 3166-2:CD codes:
java
public enum DRCProvince {
BAS_UELE("CD-BU"),
HAUT_UELE("CD-HU"),
ITURI("CD-IT"),
TSHOPO("CD-TU"),
BAS_CONGO("CD-BC"),
KWANGO("CD-KG"),
KWILU("CD-KL"),
MAI_NDOMBE("CD-MA"),
KINSHASA("CD-KN"),
KONGO_CENTRAL("CD-KC"),
KASAI("CD-KS"),
KASAI_CENTRAL("CD-KC"),
KASAI_ORIENTAL("CD-KE"),
LOMAMI("CD-LO"),
SANKURU("CD-SA"),
HAUT_LOMAMI("CD-HL"),
LUALABA("CD-LU"),
TANGANYIKA("CD-TA"),
HAUT_KATANGA("CD-HK"),
ITURI_NORTH("CD-IN"),
ITURI_SOUTH("CD-IS"),
MANIEMA("CD-MN"),
NORTH_KIVU("CD-NK"),
SOUTH_KIVU("CD-SK"),
MONGALA("CD-MO"),
EQUATEUR("CD-EQ");
private final String code;
DRCProvince(String code) {
this.code = code;
}
public String getCode() {
return code;
}
}
🗃️ SQL Table and Insert Statements
sql
CREATE TABLE drc_provinces (
id SERIAL PRIMARY KEY,
name VARCHAR(64) NOT NULL,
code VARCHAR(8) NOT NULL UNIQUE
);
INSERT INTO drc_provinces (name, code) VALUES
('Bas-Uele', 'CD-BU'),
('Haut-Uele', 'CD-HU'),
('Ituri', 'CD-IT'),
('Tshopo', 'CD-TU'),
('Bas-Congo (Kongo-Central)', 'CD-BC'),
('Kwango', 'CD-KG'),
('Kwilu', 'CD-KL'),
('Mai-Ndombe', 'CD-MA'),
('Kinshasa', 'CD-KN'),
('Kongo-Central', 'CD-KC'),
('Kasaï', 'CD-KS'),
('Kasaï-Central', 'CD-KC'),
('Kasaï-Oriental', 'CD-KE'),
('Lomami', 'CD-LO'),
('Sankuru', 'CD-SA'),
('Haut-Lomami', 'CD-HL'),
('Lualaba', 'CD-LU'),
('Tanganyika', 'CD-TA'),
('Haut-Katanga', 'CD-HK'),
('Maniema', 'CD-MN'),
('Nord-Kivu', 'CD-NK'),
('Sud-Kivu', 'CD-SK'),
('Mongala', 'CD-MO'),
('Équateur', 'CD-EQ');
✅ Summary
This Java enum and SQL setup provides a standardized way to work with the 26 provinces of the DRC, using official ISO 3166-2:CD codes. It's useful for geographic filtering, database normalization, and back-end region management.