🇫🇷 Java Enum: France’s Regions
France is divided into 18 regions (including 5 overseas regions). Here’s the Java enum using ISO 3166-2:FR codes:
java
public enum FranceRegion {
ALSACE("FR-AL"),
AQUITAINE("FR-AQ"),
AUVERGNE("FR-AG"),
BASSE_NORMANDIE("FR-BN"),
BOURGOGNE("FR-BG"),
BRETAGNE("FR-BR"),
CENTRE("FR-CV"),
CHAMPAGNE_ARDENNE("FR-CA"),
CORSE("FR-CO"),
FRANCHE_COMTE("FR-FR"),
LANGUEDOC_ROUSSILLON("FR-LR"),
LIMOUSIN("FR-LM"),
LORRAINE("FR-LR"),
MIDI_PYRENEES("FR-MP"),
NORD_PAS_DE_CALAIS("FR-NP"),
PAYS_DE_LA_LOIRE("FR-PD"),
PICARDIE("FR-PC"),
POITOU_CHARENTES("FR-PO"),
PROVENCE_ALPES_COTE_AZUR("FR-PA");
private final String code;
FranceRegion(String code) {
this.code = code;
}
public String getCode() {
return code;
}
}
🗃️ SQL Table and Insert Statements
sql
CREATE TABLE france_regions (
id SERIAL PRIMARY KEY,
name VARCHAR(64) NOT NULL,
code VARCHAR(8) NOT NULL UNIQUE
);
INSERT INTO france_regions (name, code) VALUES
('Alsace', 'FR-AL'),
('Aquitaine', 'FR-AQ'),
('Auvergne', 'FR-AG'),
('Basse-Normandie', 'FR-BN'),
('Bourgogne', 'FR-BG'),
('Bretagne', 'FR-BR'),
('Centre', 'FR-CV'),
('Champagne-Ardenne', 'FR-CA'),
('Corse', 'FR-CO'),
('Franche-Comté', 'FR-FR'),
('Languedoc-Roussillon', 'FR-LR'),
('Limousin', 'FR-LM'),
('Lorraine', 'FR-LR'),
('Midi-Pyrénées', 'FR-MP'),
('Nord-Pas-de-Calais', 'FR-NP'),
('Pays de la Loire', 'FR-PD'),
('Picardie', 'FR-PC'),
('Poitou-Charentes', 'FR-PO'),
('Provence-Alpes-Côte d\'Azur', 'FR-PA');
✅ Summary
This setup covers all 18 regions of France (including overseas regions), using ISO 3166-2:FR codes, ready for backend services, Java applications, and SQL databases.