CREATE TABLE IF NOT EXISTS `investorRepayment` (
	`id` BIGINT(20) NOT NULL AUTO_INCREMENT,
	`investorId` BIGINT(20) NULL DEFAULT NULL, 
	`customerDetailId` BIGINT(20) NULL DEFAULT NULL, 
	`transactionId` BIGINT(20) NULL DEFAULT NULL, 
	`billingId` BIGINT(20) NULL DEFAULT NULL, 
	`repaymentDate` DATETIME NULL DEFAULT NULL, 
	`orderGrandTotal` DECIMAL(18, 4) NULL DEFAULT NULL, 
	`investorMarginAmount` DECIMAL(18, 4) NULL DEFAULT NULL, 
	`remark` TEXT NULL DEFAULT NULL, 
	`status` VARCHAR(50) NULL DEFAULT NULL,
	`createdAt` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
	`createdBy` BIGINT(20) NOT NULL DEFAULT 0,
	`updatedAt` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
	`updatedBy` BIGINT(20) NOT NULL DEFAULT 0,
	`deletedAt` DATETIME DEFAULT NULL,
	`deletedBy` BIGINT(20) DEFAULT NULL,
	PRIMARY KEY (`id`)
);
