ALTER TABLE `transaction` ADD `customerDocumentStatus` VARCHAR(50) NULL DEFAULT NULL AFTER `privyDocumentStatus`; 
ALTER TABLE `transaction` ADD `investorDocumentStatus` VARCHAR(50) NULL DEFAULT NULL AFTER `privyInvestorDocumentStatus`; 

CREATE TABLE IF NOT EXISTS `investorBalanceMutation` (
	`id` BIGINT(20) NOT NULL AUTO_INCREMENT,
	`investorId` BIGINT(20) NULL DEFAULT NULL, 
	`balanceOld` DECIMAL(18, 4) NULL DEFAULT NULL, 
	`mutationAmount` DECIMAL(18, 4) NULL DEFAULT NULL, 
	`balanceNew` DECIMAL(18, 4) NULL DEFAULT NULL, 
	`remark` TEXT NULL DEFAULT NULL, 
	`recordedAt` DATETIME 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`)
);
