Query

CREATE TABLE `peminjaman` (
  `nopinjaman` char(30) NOT NULL,
  `tglpinjaman` date DEFAULT NULL,
  `nikpinjaman` char(16) DEFAULT NULL,
  `idjmlpinjaman` int(11) DEFAULT NULL,
  `idtenorpinjaman` int(11) DEFAULT NULL,
  `jasapinjaman` double DEFAULT NULL,
  `jmlcicilan` double DEFAULT NULL,
  `sttapprove` enum('T','Y') DEFAULT 'T',
  `tglapprove` datetime DEFAULT NULL,
  `sttlunas` enum('B','L') DEFAULT 'B',
  `tgllunas` datetime DEFAULT NULL,
  `swafoto` varchar(100) DEFAULT NULL,
  `keterangan` varchar(200) DEFAULT '-',
  `sttrestrukturisasi` enum('T','Y') DEFAULT 'T',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`nopinjaman`),
  KEY `idjmlpinjaman` (`idjmlpinjaman`),
  KEY `idtenorpinjaman` (`idtenorpinjaman`),
  KEY `nikpinjaman` (`nikpinjaman`),
  CONSTRAINT `peminjaman_ibfk_1` FOREIGN KEY (`idjmlpinjaman`) REFERENCES `tbl_jmlpinjaman` (`idjml`) ON UPDATE CASCADE,
  CONSTRAINT `peminjaman_ibfk_2` FOREIGN KEY (`idtenorpinjaman`) REFERENCES `tbl_tenor` (`idtenor`) ON UPDATE CASCADE,
  CONSTRAINT `peminjaman_ibfk_3` FOREIGN KEY (`nikpinjaman`) REFERENCES `anggota` (`nik`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Data for the table `peminjaman` */

insert  into `peminjaman`(`nopinjaman`,`tglpinjaman`,`nikpinjaman`,`idjmlpinjaman`,`idtenorpinjaman`,`jasapinjaman`,`jmlcicilan`,`sttapprove`,`tglapprove`,`sttlunas`,`tgllunas`,`swafoto`,`keterangan`,`sttrestrukturisasi`,`created_at`,`updated_at`) values
('PJ040523028920001','2023-05-04','1371031411870004',7,1,100000,1100000,'Y','2023-05-04 19:22:21','L','2023-05-10 22:30:06','pj-1371031411870004.jpg',NULL,'T','2023-05-04 19:21:48','2023-05-10 22:30:06'),
('PJ060523876530001','2023-05-06','1312015903950005',13,1,140000,1540000,'Y','2023-05-06 22:41:28','L','2023-05-10 22:30:00','pj-1312015903950005.jpg',NULL,'T','2023-05-06 22:41:11','2023-05-10 22:30:00'),
('PJ060523915320002','2023-05-06','1312015903950005',13,4,140000,840000,'Y','2023-05-06 23:46:06','L','2023-05-10 23:28:24','pj-1312015903950005.jpg',NULL,'T','2023-05-06 23:45:51','2023-05-10 23:28:24'),
('PJ100523345620001','2023-05-10','1312015903950005',16,4,200000,1200000,'Y','2023-05-10 23:03:43','L','2023-05-20 13:24:14','pj-1312015903950005.jpg',NULL,'T','2023-05-10 23:03:13','2023-05-20 13:24:14'),
('PJ200523637480001','2023-05-20','1312015903950005',16,4,200000,1200000,'Y','2023-05-20 13:23:15','B',NULL,'pj-1312015903950005.jpg',NULL,'Y','2023-05-20 13:22:52','2023-06-13 23:18:31');


CREATE TABLE `tbl_jmlpinjaman` (
  `idjml` int(11) NOT NULL AUTO_INCREMENT,
  `jmluang` double DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`idjml`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4;

/*Data for the table `tbl_jmlpinjaman` */

insert  into `tbl_jmlpinjaman`(`idjml`,`jmluang`,`created_at`,`updated_at`) values
(1,2000000,'2023-04-14 00:26:44','2023-04-14 00:26:44'),
(2,2500000,'2023-04-14 00:27:09','2023-04-14 00:27:09'),
(3,3000000,'2023-04-14 00:27:55','2023-04-14 00:27:55'),
(4,3500000,'2023-04-14 00:28:04','2023-04-14 00:28:04'),
(5,4000000,'2023-04-14 00:28:59','2023-04-14 00:28:59'),
(6,4500000,'2023-04-14 00:30:00','2023-04-14 00:30:00'),
(7,5000000,'2023-04-14 00:30:58','2023-04-14 00:30:58'),
(8,5500000,'2023-04-14 00:31:11','2023-04-14 00:31:11'),
(11,6000000,'2023-04-15 23:31:05','2023-04-15 23:31:05'),
(12,6500000,'2023-04-15 23:31:13','2023-04-15 23:31:13'),
(13,7000000,'2023-04-15 23:31:20','2023-04-15 23:31:20'),
(14,8000000,'2023-05-10 23:02:25','2023-05-10 23:02:25'),
(15,9000000,'2023-05-10 23:02:31','2023-05-10 23:02:31'),
(16,10000000,'2023-05-10 23:02:36','2023-05-10 23:02:36'),
(17,20000000,'2023-06-27 01:43:46','2023-06-27 01:43:46');