🇬🇳 Java Enum: Guinea’s Regions
Guinea is divided into 8 administrative regions. Here’s the Java enum using ISO 3166-2:GN codes:
java
public enum GuineaRegion {
BOKE("GN-BK"),
CONAKRY("GN-C"),
FOUTA_DJALON("GN-FD"),
KINDIA("GN-KD"),
KOUROUSSA("GN-KR"),
LABE("GN-L"),
MACENTA("GN-MC"),
N'ZEREKORE("GN-NZ");
private final String code;
GuineaRegion(String code) {
this.code = code;
}
public String getCode() {
return code;
}
}
🗃️ SQL Table and Insert Statements
sql
CREATE TABLE guinea_regions (
id SERIAL PRIMARY KEY,
name VARCHAR(64) NOT NULL,
code VARCHAR(8) NOT NULL UNIQUE
);
INSERT INTO guinea_regions (name, code) VALUES
('Boke', 'GN-BK'),
('Conakry', 'GN-C'),
('Fouta Djalon', 'GN-FD'),
('Kindia', 'GN-KD'),
('Kouroussa', 'GN-KR'),
('Labe', 'GN-L'),
('Macenta', 'GN-MC'),
('N\'Zerekore', 'GN-NZ');
✅ Summary
This setup covers all 8 regions of Guinea using ISO 3166-2:GN codes, ideal for backend services, Java applications, and SQL databases.