-- Test query to verify the Transaction schema matches the database
-- This should run without errors after the schema fix

SELECT 
    id, patient_name, uhid, charge_rate, email, mobile_no, processing_id, 
    provider_processing_id, uname, user_id, pay_mode, location_id, 
    transaction_location, credentials_user, credentials_key, version, 
    return_url, response_url, status, transaction_id, transaction_amount, 
    transaction_ref_number, m_ref_num, name, provider_id, device_id, 
    merchant_id, additional_data, payment_reference_id, payload, 
    settlement_date_time, refund_reference_id, provider_name, batch_number, 
    bank_user_id, settlement_id, settlement_status, merchant_tag, 
    inserted_at, updated_at
FROM shukria_transactions.transactions 
LIMIT 1;
