🇬🇩 Java Enum: Grenada’s Parishes
Grenada is divided into 6 parishes. Here’s the Java enum using ISO 3166-2:GD codes:
java
public enum GrenadaParish {
ST_GEORGE("GD-01"),
ST_ANDREW("GD-02"),
ST_PATRICK("GD-03"),
CARRIACOU("GD-04"),
ST_DAVID("GD-05"),
ST_JOHN("GD-06");
private final String code;
GrenadaParish(String code) {
this.code = code;
}
public String getCode() {
return code;
}
}
🗃️ SQL Table and Insert Statements
sql
CREATE TABLE grenada_parishes (
id SERIAL PRIMARY KEY,
name VARCHAR(64) NOT NULL,
code VARCHAR(8) NOT NULL UNIQUE
);
INSERT INTO grenada_parishes (name, code) VALUES
('St. George', 'GD-01'),
('St. Andrew', 'GD-02'),
('St. Patrick', 'GD-03'),
('Carriacou', 'GD-04'),
('St. David', 'GD-05'),
('St. John', 'GD-06');
✅ Summary
This setup covers all 6 parishes of Grenada using ISO 3166-2:GD codes, ideal for backend services, Java applications, and SQL databases.