-- Create Table Statement for 'UniPay Chargeback Transaction'
DROP TABLE IF EXISTS `UNI_PAY_CHARGEBACK_TRANSACTION`;
CREATE TABLE `UNI_PAY_CHARGEBACK_TRANSACTION` (
	ID bigint(20) NOT NULL,
	PROVIDER_MERCHANT_ACCOUNT_CODE varchar,
	ACCOUNT_NUMBER_MASKED varchar,
	ACCOUNT_ACCESSORY varchar,
	ACCOUNT_TYPE varchar,
	TRANSACTION_CODE varchar,
	TRANSACTION_INTERNAL_CODE varchar,
	TRANSACTION_DATE varchar,
	TRANSACTION_TYPE varchar,
	SUBMISSION_CODE varchar,
	REFERENCE_NUMBER varchar,
	ORIGINAL_REFERENCE_NUMBER varchar,
	ORIGINAL_TRANSACTION_CODE varchar,
	ORIGINAL_TRANSACTION_DATE varchar,
	APPROVAL_CODE varchar,
	IS_REBILL_ENABLED varchar,
	TOKEN varchar,
	AMOUNT int(11),
	HOLDER_NAME varchar,
	SEQUENCE_NUMBER varchar,
	RETRY_FEE_AMOUNT int(11),
	EXPECTED_EFFECTIVE_DATE varchar,
	PROCESSED_AMOUNT int(11),
	RESPONSE_CODE varchar,
	RESPONSE_MESSAGE varchar,
	PROVIDER_RESPONSE_CODE varchar,
	WARNING_CODE varchar,
	PROVIDER_RESPONSE_MESSAGE varchar,
	AVS_RESPONSE_CODE varchar,
	PROVIDER_AVS_RESPONSE_CODE varchar,
	ACCOUNT_TYPE_UPDATED varchar,
	HOLDER_NAME_UPDATED varchar,
	TOKEN_UPDATED varchar,
	AGGREGATE_REFERENCE_NUMBER varchar,
	AGGREGATE_TRANSACTION_CODE varchar,
	AGGREGATE_TRANSACTION_INTERNAL_CODE varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	RESPONSE_CODE varchar,
	RESPONSE_CODE varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;