-- Create Table Statement for 'EFT GETI Retail Transaction'
DROP TABLE IF EXISTS `EFT_GETI_RETAIL_TRANSACTION`;
CREATE TABLE `EFT_GETI_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	IS_TEST_MODE tinyint(1),
	REQUEST_ID bigint(20),
	TRANSACTION_ID varchar,
	TERMINAL_ID varchar,
	IDENTIFIER varchar,
	CHECK_NUMBER varchar,
	ACCOUNT_TYPE varchar,
	FIRST_NAME varchar,
	LAST_NAME varchar,
	ADDRESS1 varchar,
	CITY varchar,
	STATE varchar,
	ZIP varchar,
	PHONE_NUMBER varchar,
	CHECK_AMOUNT varchar,
	CUSTOM1 varchar,
	CUSTOM2 varchar,
	CUSTOM3 varchar,
	CUSTOM4 varchar,
	RESPONSE_TYPE varchar,
	RESPONSE_TYPE_TEXT varchar,
	RESULT_CODE varchar,
	TYPE_CODE varchar,
	CODE varchar,
	MESSAGE varchar,
	VALIDATION_MESSAGE_RESULT varchar,
	VALIDATION_ERROR_MESSAGE varchar,
	EXCEPTION_MESSAGE varchar,
	COMPANY_NAME varchar,
	DL_STATE varchar,
	DL_NUMBER varchar,
	SSN4 varchar,
	DOB_YEAR varchar,
	IMAGE_FRONT_SIZE int(11),
	IMAGE_BACK_SIZE int(11),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHECK_IMAGE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;