🇦🇩 Java Enum: Andorra’s Parishes (Parròquies)
Andorra is divided into 7 parishes. Here's a Java enum using ISO 3166-2:AD codes:
java
public enum AndorraParish {
CANILLO("AD-02"),
ENCAMP("AD-03"),
ORDINO("AD-04"),
LA_MASSANA("AD-05"),
ANDORRA_LA_VELLA("AD-07"),
SANT_JULIA_DE_LORIA("AD-06"),
ESCALDES_ENGORDANY("AD-08");
private final String code;
AndorraParish(String code) {
this.code = code;
}
public String getCode() {
return code;
}
}
🗃️ SQL Table and Insert Statements
sql
CREATE TABLE andorra_parishes (
id SERIAL PRIMARY KEY,
name VARCHAR(64) NOT NULL,
code VARCHAR(6) NOT NULL UNIQUE
);
INSERT INTO andorra_parishes (name, code) VALUES
('Canillo', 'AD-02'),
('Encamp', 'AD-03'),
('Ordino', 'AD-04'),
('La Massana', 'AD-05'),
('Sant Julià de Lòria', 'AD-06'),
('Andorra la Vella', 'AD-07'),
('Escaldes-Engordany', 'AD-08');
✅ Summary
This setup covers all 7 official parishes of Andorra using ISO 3166-2:AD codes. Perfect for location-based logic, address validation, or administrative filtering in apps and databases.