-- Migration: Add individual patient identification fields to portfolio table
-- Purpose: Support structured patient data entry (Nama, No. RM, Umur, Paritas, Alamat)

ALTER TABLE portfolio 
ADD COLUMN IF NOT EXISTS nama_pasien VARCHAR(255) DEFAULT NULL AFTER identifikasi_pasien,
ADD COLUMN IF NOT EXISTS nomor_rm VARCHAR(50) DEFAULT NULL AFTER nama_pasien,
ADD COLUMN IF NOT EXISTS umur INT DEFAULT NULL AFTER nomor_rm,
ADD COLUMN IF NOT EXISTS paritas VARCHAR(50) DEFAULT NULL AFTER umur,
ADD COLUMN IF NOT EXISTS alamat TEXT DEFAULT NULL AFTER paritas;
