🇬🇶 Java Enum: Equatorial Guinea’s Provinces
Equatorial Guinea is divided into 8 provinces, each identified by an ISO 3166-2 code prefixed with GQ-. Here is the Java enum:
java
public enum EquatorialGuineaProvince {
ANNOBON("GQ-AN"),
BIOKO_NORTE("GQ-BN"),
BIOKO_SUR("GQ-BS"),
CENTRO_SUR("GQ-CS"),
KIÉ_NTEM("GQ-KN"),
LITORAL("GQ-LI"),
WELE_NZAS("GQ-WN"),
DJIBLOHO("GQ-DJ");
private final String code;
EquatorialGuineaProvince(String code) {
this.code = code;
}
public String getCode() {
return code;
}
}
🗃️ SQL Table and Insert Statements
sql
CREATE TABLE equatorial_guinea_provinces (
id SERIAL PRIMARY KEY,
name VARCHAR(64) NOT NULL,
code VARCHAR(8) NOT NULL UNIQUE
);
INSERT INTO equatorial_guinea_provinces (name, code) VALUES
('Annobón', 'GQ-AN'),
('Bioko Norte', 'GQ-BN'),
('Bioko Sur', 'GQ-BS'),
('Centro Sur', 'GQ-CS'),
('Kié-Ntem', 'GQ-KN'),
('Litoral', 'GQ-LI'),
('Wele-Nzas', 'GQ-WN'),
('Djibloho', 'GQ-DJ');
✅ Summary
This setup covers all 8 provinces of Equatorial Guinea using ISO 3166-2:GQ codes, ideal for use in international applications, region-based databases, or Java-based APIs.