Save Transactions

CREATE TABLE `banking_transactions` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `receiver_identifier` VARCHAR(255) NOT NULL,
  `receiver_name` VARCHAR(255) NOT NULL,
  `sender_identifier` VARCHAR(255) NOT NULL,
  `sender_name` VARCHAR(255) NOT NULL,
  `transaction_date` DATE NOT NULL,
  `transaction_time` TIME NOT NULL,
  `amount` BIGINT UNSIGNED NOT NULL,
  `transaction_type` VARCHAR(50) NOT NULL,
  PRIMARY KEY (`id`),
  INDEX `idx_sender_identifier` (`sender_identifier`),
  INDEX `idx_receiver_identifier` (`receiver_identifier`)
);