-- Create Table Statement for 'PayFacto Chargeback Transaction'
DROP TABLE IF EXISTS `PAYFACTO_CHARGEBACK_TRANSACTION`;
CREATE TABLE `PAYFACTO_CHARGEBACK_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ID varchar,
	DOING_BUSINESS_AS varchar,
	LEGAL_NAME varchar,
	CB_REF varchar,
	CB_TYPE varchar,
	CB_TYPE_DESC varchar,
	TXN_DATE varchar,
	CB_DATE varchar,
	CARD_MASKED varchar,
	AMOUNT_CARD_CURRENCY varchar,
	CHARGEBACK_AMOUNT varchar,
	SETTLEMENT_DATE varchar,
	ACQUIRER_REFERENCE_NUMBER varchar,
	TXN_ID varchar,
	MERCHANT_TRAN_ID varchar,
	CB_CODE varchar,
	ISSUER_MESSAGE varchar,
	SETTLEMENT_AUTH_CODE varchar,
	ADDRESS_VERIFICATION_RESPONSE varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	MERCHANT_ACCOUNT_CODE int(11),
	PAYFACTO_CHARGEBACK_BATCH_FK bigint(20),
	AMOUNT_CARD_CURRENCY_INT int(11),
	ID bigint(20) NOT NULL,
	ID bigint(20) NOT NULL,
	PRIMARY KEY (ID, ID, ID)
) ENGINE=InnoDB;