-- Create Table Statement for 'Transient Transaction'
DROP TABLE IF EXISTS `TRANSIENT_TRANSACTION`;
CREATE TABLE `TRANSIENT_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	ACCOUNT_NUMBER_ENCODED varchar,
	TOKEN_CODE varchar,
	BIN int(11),
	SEQUENCE_NUMBER int(11),
	SUBMISSION_CODE bigint(20),
	BIN_CODE int(11),
	BANK_COUNTRY_CODE varchar,
	RESPONSE_CODE varchar,
	ACCOUNT_CL varchar,
	RESPONSE_MESSAGE varchar,
	TOKEN_SEQUENCE_NUMBER int(11),
	ACCOUNT_ACCESSORY varchar,
	ACCOUNT_ACCESSORY_ENCODED varchar,
	HOLDER_NAME varchar,
	IS_ORGANIZATION tinyint(1),
	STREET varchar,
	CITY varchar,
	ZIP_CODE varchar,
	STATE varchar,
	COUNTRY_CODE varchar,
	ACCOUNT_PROFILE_CODE bigint(20),
	IS_ACCOUNT_PROFILE_UPDATE tinyint(1),
	IS_BLACKLIST_APPLIED tinyint(1),
	ACCOUNT_TYPE varchar,
	SPID int(11),
	SUBSCRIPTION_CODE bigint(20),
	SUBSCRIPTION_TRANSACTION_CODE bigint(20),
	RESPONSE_CODE varchar,
	RESPONSE_CODE varchar,
	SPLIT_SCHEMA_CODE varchar,
	SPLIT_SCHEMA_ID bigint(20),
	SUM_SPLIT_AMOUNT int(11),
	AMOUNT int(11),
	SPLIT_SCHEMA_CODE varchar,
	SPLIT_SCHEMA_ID bigint(20),
	SUM_SPLIT_AMOUNT int(11),
	AMOUNT int(11),
	SPLIT_SCHEMA_CODE varchar,
	SPLIT_SCHEMA_ID bigint(20),
	SUM_SPLIT_AMOUNT int(11),
	AMOUNT int(11),
	PROVIDER_RESPONSE_CODE varchar,
	PROVIDER_RESPONSE_MESSAGE varchar,
	PROVIDER_RESPONSE_CODE varchar,
	PROVIDER_RESPONSE_MESSAGE varchar,
	PROVIDER_RESPONSE_CODE varchar,
	PROVIDER_RESPONSE_MESSAGE varchar,
	RESPONSE_MESSAGE varchar,
	RESPONSE_MESSAGE varchar,
	ACCOUNT_ACCESSORY_ENCRYPTED varchar,
	ACCOUNT_ACCESSORY_ENCRYPTED varchar,
	ACCOUNT_ACCESSORY_ENCRYPTED varchar,
	ACCOUNT_ACCESSORY_MASKED varchar,
	ACCOUNT_ACCESSORY_OPTIMIZED varchar,
	ACCOUNT_ACCESSORY_MASKED varchar,
	ACCOUNT_ACCESSORY_OPTIMIZED varchar,
	ACCOUNT_ACCESSORY_MASKED varchar,
	ACCOUNT_ACCESSORY_OPTIMIZED varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;