-- Create Table Statement for 'Sedra Fraud Transaction'
DROP TABLE IF EXISTS `SEDRA_FRAUD_TRANSACTION`;
CREATE TABLE `SEDRA_FRAUD_TRANSACTION` (
ID bigint(20) NOT NULL,
MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
CHARGE_TRANSACTION_FK bigint(20),
SYSTEM_NAME varchar,
TRANSACTION_COUNTRY_CODE varchar,
TRANSACTION_CURRENCY_CODE varchar,
TRANSACTION_AMOUNT varchar,
TRANSACTION_DATE varchar,
RESPONSE_REQUEST_ID varchar,
RESPONSE_REQUEST_STATUS varchar,
RESPONSE_TRNX_ID varchar,
RESPONSE_REQUEST_STATUS_DESCRIPTION varchar,
RESPONSE_REASON_OF_REJECTION varchar,
TRANSACTION_ID varchar,
RECEIVER_ACCOUNT_REFERENCE_NUMBER varchar,
RECEIVER_CUSTOMER_REFERENCE_NUMBER varchar,
CARD_NUMBER varchar,
PRIMARY KEY (ID)
) ENGINE=InnoDB;