-- Create Table Statement for 'Giact Account Verification Transaction'
DROP TABLE IF EXISTS `GIACT_ACCOUNT_VERIFICATION_TRANSACTION`;
CREATE TABLE `GIACT_ACCOUNT_VERIFICATION_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11),
	CHARGE_TRANSACTION_FK bigint(20),
	API_USERNAME varchar,
	UNIQUE_ID varchar,
	ACCOUNT_TYPE varchar,
	ITEM_REFERENCE_ID varchar,
	CREATED_DATE varchar,
	VERIFICATION_RESPONSE varchar,
	ACCOUNT_RESPONSE_CODE varchar,
	BANK_NAME varchar,
	BANK_ACCOUNT_TYPE varchar,
	ACCOUNT_ADDED_DATE varchar,
	ACCOUNT_LAST_UPDATED_DATE varchar,
	ACCOUNT_CLOSED_DATE varchar,
	ERROR_MESSAGE varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;