-- Create Table Statement for 'Front Gateway Transaction'
DROP TABLE IF EXISTS `FRONT_GATEWAY_TRANSACTION`;
CREATE TABLE `FRONT_GATEWAY_TRANSACTION` (
	MESSAGE varchar,
	RESPONSE_CODE varchar,
	RESPONSE_ID varchar,
	NOTIFICATION_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	MERCHANT_ACCOUNT_CODE int(11),
	SERVICE_ID varchar,
	FROM_ID varchar,
	RESPONSE_DESCRIPTION varchar,
	ID bigint(20) NOT NULL,
	PHONE varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;