CREATE TABLE `ptp_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shareholder_no` varchar(145) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `loan_no` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `emi_amt` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT '0.0',
  `ptp_amount` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT '0.00',
  `ptp_date` date DEFAULT NULL,
  `emi_no` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT 'pending',
  `remarks` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `created_by` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `actual_paid_amount` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT '0.00',
  `actual_payment_date` date DEFAULT NULL,
  `ptp_created` tinyint(1) NOT NULL DEFAULT '0',
  `branch_id` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;