hi
with a number of development experience i'm sure i can be your help. share one/more tables so i could share results with you. i will also explain the process so next time you could do it yourself.
here's sample
CREATE TABLE IF NOT EXISTS `Expenses`.`Claim` (
`id` INT NOT NULL AUTO_INCREMENT COMMENT '',
`claimBatchId` INT NOT NULL COMMENT '',
`rowIndex` SMALLINT NOT NULL DEFAULT 0 COMMENT '',
`claimDate` DATETIME(6) NULL COMMENT '',
`locationId` INT NULL COMMENT '',
`expenseTypeId` INT NULL COMMENT '',
`qty` DECIMAL(18,2) NULL DEFAULT 0 COMMENT '',
`qtyOri` DECIMAL(18,2) NULL DEFAULT 0 COMMENT '',
`calculatedAmount` DECIMAL(18,2) NULL DEFAULT 0 COMMENT '',
`refoundValue` DECIMAL(18,2) NULL COMMENT '',
`note` LONGTEXT NULL DEFAULT '' COMMENT '',
`validationEmployeeId` INT NULL COMMENT '',
`prov` VARCHAR(3) NULL DEFAULT 'QC' COMMENT '',
PRIMARY KEY (`id`) COMMENT '',
CONSTRAINT `FK_Claim_ClaimBatch`
FOREIGN KEY (`claimBatchId`)
REFERENCES `Expenses`.`ClaimBatch` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `FK_Claim_Employee`
FOREIGN KEY (`validationEmployeeId`)
REFERENCES `Expenses`.`Employee` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `FK_Claim_ExpenseType`
FOREIGN KEY (`expenseTypeId`)
REFERENCES `Expenses`.`ExpenseType` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)