-- Add employment_status column to loans table (snake_case)
ALTER TABLE loans ADD COLUMN IF NOT EXISTS "employment_status" VARCHAR(255);

-- Add monthly_income column to loans table (snake_case)
ALTER TABLE loans ADD COLUMN IF NOT EXISTS "monthly_income" DECIMAL(12,2);

-- Verify the columns were added
SELECT column_name, data_type 
FROM information_schema.columns 
WHERE table_name = 'loans' 
AND column_name IN ('employment_status', 'monthly_income')
ORDER BY column_name; 