🇨🇷 Java Enum: Costa Rica’s Provinces
Costa Rica is divided into 7 provinces, each with an ISO 3166-2:CR code. Here's the Java enum:
java
public enum CostaRicaProvince {
ALAJUELA("CR-A"),
CARTAGO("CR-C"),
GUANACASTE("CR-G"),
HEREDIA("CR-H"),
LIMON("CR-L"),
PUNTARENAS("CR-P"),
SAN_JOSE("CR-SJ");
private final String code;
CostaRicaProvince(String code) {
this.code = code;
}
public String getCode() {
return code;
}
}
🗃️ SQL Table and Insert Statements
sql
CREATE TABLE costa_rica_provinces (
id SERIAL PRIMARY KEY,
name VARCHAR(64) NOT NULL,
code VARCHAR(8) NOT NULL UNIQUE
);
INSERT INTO costa_rica_provinces (name, code) VALUES
('Alajuela', 'CR-A'),
('Cartago', 'CR-C'),
('Guanacaste', 'CR-G'),
('Heredia', 'CR-H'),
('Limón', 'CR-L'),
('Puntarenas', 'CR-P'),
('San José', 'CR-SJ');
✅ Summary
This Java enum and SQL table setup models all 7 provinces of Costa Rica using their official ISO 3166-2:CR codes. It’s ideal for applications requiring geographic or administrative data normalization.