CREATE TABLE obat (
    id_obat INT PRIMARY KEY AUTO_INCREMENT,
    nama_obat VARCHAR(255) NOT NULL,
    jenis_obat VARCHAR(100), -- Contoh: Tablet, Sirup, Salep
    stok INT NOT NULL,
    satuan VARCHAR(50) -- Contoh: box, strip, botol
);