✅ Enum Representation in Java
Thailand is divided into 77 provinces (changwat), including Bangkok, which holds special administrative status.
Here’s the Java enum
representing all 77 provinces along with commonly used two-letter codes:
java
public enum ThailandProvince {
AMNAT_CHAROEN("AC"),
ANG_THONG("AT"),
BANGKOK("BK"),
BUENG_KAN("BN"),
BURI_RAM("BR"),
CHACHOENGSAO("CC"),
CHAI_NAT("CN"),
CHAIYAPHUM("CP"),
CHANTHABURI("CT"),
CHIANG_MAI("CM"),
CHIANG_RAI("CR"),
CHONBURI("CB"),
CHUMPHON("CPN"),
KALASIN("KS"),
KAMPHAENG_PHET("KP"),
KANCHANABURI("KN"),
KHON_KAEN("KK"),
KRABI("KB"),
LAMPANG("LP"),
LAMPHUN("LN"),
LOEI("LE"),
LOP_BURI("LB"),
MAE_HONG_SON("MH"),
MAHA_SARAKHAM("MS"),
MUKDAHAN("MD"),
NAKHON_NAYOK("NY"),
NAKHON_PATHOM("NP"),
NAKHON_PHANOM("NPM"),
NAKHON_RATCHASIMA("NR"),
NAKHON_SAWAN("NS"),
NAKHON_SI_THAMMARAT("NST"),
NAN("NN"),
NARATHIWAT("NT"),
NONG_BUA_LAM_PHU("NBL"),
NONG_KHAI("NK"),
NONTHABURI("NB"),
PATHUM_THANI("PT"),
PATTANI("PN"),
PHANG_NGA("PG"),
PHATTHALUNG("PL"),
PHAYAO("PY"),
PHETCHABUN("PC"),
PHETCHABURI("PB"),
PHICHIT("PHC"),
PHITSANULOK("PLK"),
PHRA_NAKHON_SI_AYUTTHAYA("AY"),
PHRAE("PR"),
PHUKET("PK"),
PRACHIN_BURI("PCB"),
PRACHUAP_KHIRI_KHAN("PKK"),
RANONG("RN"),
RATCHABURI("RB"),
RAYONG("RY"),
ROI_ET("RE"),
SAE_KAEW("SK"),
SAKON_NAKHON("SN"),
SAMUT_PRAKAN("SP"),
SAMUT_SAKHON("SS"),
SAMUT_SONGKHRAM("SM"),
SARABURI("SR"),
SATUN("ST"),
SING_BURI("SB"),
SI_SA_KET("SSK"),
SONGKHLA("SG"),
Sukhothai("SU"),
SUPHAN_BURI("SPB"),
SURAT_THANI("SRN"),
SURIN("SRN"),
TAK("TK"),
TRANG("TG"),
TRAT("TT"),
UBON_RATCHATHANI("UB"),
UDON_THANI("UD"),
UTHAI_THANI("UT"),
UTTARADIT("UR"),
YALA("YL"),
YASOTHON("YS");
private final String code;
ThailandProvince(String code) {
this.code = code;
}
public String getCode() {
return this.code;
}
}
✅ SQL Representation for Storing Thailand’s Provinces
Here is the SQL table schema and INSERT
statements for the 77 provinces of Thailand:
sql
-- Table for Thailand provinces
CREATE TABLE thailand_provinces (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
code VARCHAR(5) NOT NULL
);
-- Sample insert statements (only first few shown for brevity)
INSERT INTO thailand_provinces (name, code) VALUES
('Amnat Charoen', 'AC'),
('Ang Thong', 'AT'),
('Bangkok', 'BK'),
('Bueng Kan', 'BN'),
('Buri Ram', 'BR'),
('Chachoengsao', 'CC'),
('Chai Nat', 'CN'),
('Chaiyaphum', 'CP'),
('Chanthaburi', 'CT'),
('Chiang Mai', 'CM'),
('Chiang Rai', 'CR'),
('Chonburi', 'CB'),
('Chumphon', 'CPN'),
('Kalasin', 'KS'),
('Kamphaeng Phet', 'KP'),
-- (Continue for all 77 provinces) ...
('Yala', 'YL'),
('Yasothon', 'YS');
This setup supports regional functionality in Thai government systems, logistics, travel apps, and administrative software.