Programming & Development / April 12, 2025

Enum Representation of Provinces in Thailand and SQL Table for Storing Province Data

Enum Thailand Provinces Java SQL Bangkok Chiang Mai Phuket Thai Province Code Administrative Division

✅ 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.


Comments

No comments yet

Add a new Comment

NUHMAN.COM

Information Technology website for Programming & Development, Web Design & UX/UI, Startups & Innovation, Gadgets & Consumer Tech, Cloud Computing & Enterprise Tech, Cybersecurity, Artificial Intelligence (AI) & Machine Learning (ML), Gaming Technology, Mobile Development, Tech News & Trends, Open Source & Linux, Data Science & Analytics

Categories

Tags

©{" "} Nuhmans.com . All Rights Reserved. Designed by{" "} HTML Codex