USE csc_management;

ALTER TABLE transactions
ADD COLUMN payment_method VARCHAR(40) NULL AFTER amount;

CREATE INDEX idx_app_due ON applications(due_amount);
CREATE INDEX idx_app_date ON applications(application_date);
CREATE INDEX idx_txn_date ON transactions(transaction_date);