-- Create Table Statement for 'Account Update Subscription Transaction'
DROP TABLE IF EXISTS `ACCOUNT_UPDATE_SUBSCRIPTION_TRANSACTION`;
CREATE TABLE `ACCOUNT_UPDATE_SUBSCRIPTION_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CREATE_DATE datetime,
	LAST_UPDATE_DATE datetime,
	STATUS_CL varchar,
	ACTION_CL varchar,
	RESPONSE_CODE varchar,
	RESPONSE_MESSAGE varchar,
	CUSTOMER_ACCOUNT_CODE varchar,
	CUSTOMER_ACCOUNT_INTERNAL_CODE varchar,
	TRANSACTION_CODE varchar,
	TRANSACTION_INTERNAL_CODE varchar,
	ACCOUNT_NUMBER varchar,
	ACCOUNT_ACCESSORY varchar,
	TOKEN varchar,
	TOKEN_CODE varchar,
	ACCOUNT_NUMBER_MASKED varchar,
	ACCOUNT_NUMBER_UPDATED varchar,
	ACCOUNT_ACCESSORY_UPDATED varchar,
	TOKEN_UPDATED varchar,
	TOKEN_CODE_UPDATED varchar,
	ACCOUNT_NUMBER_UPDATE_MASKED varchar,
	ACCOUNT_NUMBER_HASH varchar,
	SUB_BATCH_FK bigint(20),
	BATCH_FK bigint(20),
	DATA_HASH bigint(20),
	DUPLICATE_CODE bigint(20),
	ACCOUNT_UPDATE_TRANSACTION_FK bigint(20),
	BANK_INFO_FK int(11),
	MEMO varchar,
	MEMO varchar,
	RESPONSE_CODE varchar,
	RESPONSE_CODE varchar,
	MEMO varchar,
	MEMO varchar,
	MEMO varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;