🇧🇪 Java Enum: Belgium’s Regions and Provinces
Belgium is divided into 3 regions and 10 provinces. Here’s the Java enum using the ISO 3166-2:BE codes.
java
public enum BelgiumRegion {
BRUSSELS_CAPITAL("BE-BRU"),
FLANDERS("BE-VLG"),
WALLONIA("BE-WAL");
private final String code;
BelgiumRegion(String code) {
this.code = code;
}
public String getCode() {
return code;
}
}
public enum BelgiumProvince {
ANTWERPEN("BE-AAN"),
WEST_FLANDERS("BE-VWV"),
EAST_FLANDERS("BE-VOV"),
LIMBURG("BE-VLI"),
HAINAUT("BE-WHT"),
LUXEMBOURG("BE-WLX"),
NAMUR("BE-WNA"),
BRABANT_WALLON("BE-WBR"),
FLEMISH_BRABANT("BE-VBR"),
LIEGE("BE-WLG");
private final String code;
BelgiumProvince(String code) {
this.code = code;
}
public String getCode() {
return code;
}
}
🗃️ SQL Table and Insert Statements
sql
CREATE TABLE belgium_regions (
id SERIAL PRIMARY KEY,
name VARCHAR(64) NOT NULL,
code VARCHAR(8) NOT NULL UNIQUE
);
INSERT INTO belgium_regions (name, code) VALUES
('Brussels-Capital', 'BE-BRU'),
('Flanders', 'BE-VLG'),
('Wallonia', 'BE-WAL');
CREATE TABLE belgium_provinces (
id SERIAL PRIMARY KEY,
name VARCHAR(64) NOT NULL,
code VARCHAR(8) NOT NULL UNIQUE
);
INSERT INTO belgium_provinces (name, code) VALUES
('Antwerpen', 'BE-AAN'),
('West Flanders', 'BE-VWV'),
('East Flanders', 'BE-VOV'),
('Limburg', 'BE-VLI'),
('Hainaut', 'BE-WHT'),
('Luxembourg', 'BE-WLX'),
('Namur', 'BE-WNA'),
('Brabant Wallon', 'BE-WBR'),
('Flemish Brabant', 'BE-VBR'),
('Liège', 'BE-WLG');
✅ Summary
This setup represents Belgium’s 3 regions and 10 provinces using the ISO 3166-2:BE codes. It’s useful for applications that require management of regional and provincial data, geographical processing, or location-based operations.