🇲🇬 Java Enum: Madagascar’s Provinces
Madagascar is officially divided into 6 provinces according to ISO 3166-2:MG. Here's a Java enum representation:
java
public enum MadagascarProvince {
ANTANANARIVO("MG-T"),
FIANARANTSOA("MG-F"),
MAHAJANGA("MG-M"),
TOAMASINA("MG-A"),
TOLIARA("MG-U"),
ANTSIRANANA("MG-D");
private final String code;
MadagascarProvince(String code) {
this.code = code;
}
public String getCode() {
return code;
}
}
🗃️ SQL Table and Insert Statements
sql
CREATE TABLE madagascar_provinces (
id SERIAL PRIMARY KEY,
name VARCHAR(64) NOT NULL,
code VARCHAR(8) NOT NULL UNIQUE
);
INSERT INTO madagascar_provinces (name, code) VALUES
('Antananarivo', 'MG-T'),
('Fianarantsoa', 'MG-F'),
('Mahajanga', 'MG-M'),
('Toamasina', 'MG-A'),
('Toliara', 'MG-U'),
('Antsiranana', 'MG-D');
✅ Summary
This setup includes all 6 ISO-defined provinces of Madagascar, which is ideal for regional data models in Java backends and SQL databases.