-- Create Table Statement for 'Front Gateway Transaction'
DROP TABLE IF EXISTS `FRONT_GATEWAY_TRANSACTION`;
CREATE TABLE `FRONT_GATEWAY_TRANSACTION` (
PHONE varchar,
PHONE varchar,
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,
PHONE varchar,
PRIMARY KEY (ID)
) ENGINE=InnoDB;