/*
 Navicat Premium Data Transfer

 Source Server         : Secure Parking
 Source Server Type    : MySQL
 Source Server Version : 50562
 Source Host           : 192.168.1.220:3306
 Source Schema         : db_metro

 Target Server Type    : MySQL
 Target Server Version : 50562
 File Encoding         : 65001

 Date: 09/02/2024 10:23:14
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sps_paytm_txn
-- ----------------------------
DROP TABLE IF EXISTS `sps_paytm_txn`;
CREATE TABLE `sps_paytm_txn`  (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `txn_id` int(11) NOT NULL,
  `bank_txn_id` varchar(50)  NOT NULL,
  `status` varchar(50)  NOT NULL,
  `rrn` varchar(50)  NOT NULL,
  `card_no` varchar(50)  NOT NULL,
  `order_id` varchar(50)  NOT NULL,
  `auth_code` varchar(50)  NOT NULL,
  `pay_method` varchar(40)  NOT NULL,
  `amount` varchar(30)  NOT NULL,
  `card_type` varchar(30)  NOT NULL,
  `txn_date` varchar(100)  NOT NULL,
  `error_msg` varchar(100)  NOT NULL,
  `card_scheme` varchar(50)  NOT NULL,
  `issuing_bank` varchar(50)  NOT NULL,
  `tid` varchar(40)  NOT NULL,
  `aid` varchar(40)  NOT NULL,
  `bank_mid` varchar(40)  NOT NULL,
  `bank_tid` varchar(40)  NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 ROW_FORMAT = Compact;

-- ----------------------------
-- Records of sps_paytm_txn
-- ----------------------------
INSERT INTO `sps_paytm_txn` VALUES (1, 0, '20240206011640000961663971860109577', 'SUCCESS', '000014523260', '4316', '060224162908', '000214', 'DEBIT_CARD', '30.0', 'DEBIT', '06 Feb 2024, 04:29:20 PM', '', 'Visa Debit', 'South Indian Bank', '70000898', 'A0000000031010', '5PT000070027710', '6P700898', '2024-02-06 16:29:29', NULL);
INSERT INTO `sps_paytm_txn` VALUES (2, 2, '20240206011640000961664257685148604', 'SUCCESS', '000014523263', '4316', '060224163021', '000216', 'DEBIT_CARD', '30.0', 'DEBIT', '06 Feb 2024, 04:30:27 PM', '', 'Visa Debit', 'South Indian Bank', '70000898', 'A0000000031010', '5PT000070027710', '6P700898', '2024-02-06 16:30:35', NULL);
INSERT INTO `sps_paytm_txn` VALUES (3, 3, '20240206011640000961664356628774600', 'SUCCESS', '64565', '', '060224163047', '', 'UPI', '30.0', '', '06 Feb 2024, 04:30:49 PM', '', '', '', '70000898', '', '917777788888', '', '2024-02-06 16:31:09', NULL);

SET FOREIGN_KEY_CHECKS = 1;
