-- Create Table Statement for 'Paymentus Chargeback Transaction'
DROP TABLE IF EXISTS `PAYMENTUS_CHARGEBACK_TRANSACTION`;
CREATE TABLE `PAYMENTUS_CHARGEBACK_TRANSACTION` (
	ID bigint(20) NOT NULL,
	CONFIRMATION_NUMBER varchar,
	PAYMENT_AMOUNT int(11),
	CONVENIENCE_FEE varchar,
	TOTAL_AMOUNT varchar,
	PAYMENT_TYPE varchar,
	ACCOUNT_NUMBER varchar,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	PAYMENT_DATE_TIME varchar,
	PAYMENT_METHOD_TYPE varchar,
	PAYMENT_METHOD varchar,
	ORIGIN varchar,
	CHANNEL varchar,
	ORIGINATOR varchar,
	STATUS varchar,
	STATUS_DESCRIPTION varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RELATED_PAYMENT varchar,
	EXTERNAL_REFERENCE_NUMBER varchar,
	REASON_CODE varchar,
	RELATED_PAYMENT varchar,
	EXTERNAL_REFERENCE_NUMBER varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	PAYMENTUS_CHARGEBACK_BATCH_FK bigint(20),
	PAYMENTUS_CHARGEBACK_BATCH_FK bigint(20),
	PAYMENTUS_CHARGEBACK_BATCH_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;