-- Create Table Statement for 'Notification Transaction'
DROP TABLE IF EXISTS `NOTIFICATION_TRANSACTION`;
CREATE TABLE `NOTIFICATION_TRANSACTION` (
	ID bigint(20) NOT NULL,
	CREATE_DATE datetime,
	MERCHANT_ACCOUNT_CODE int(11),
	RESELLER_CODE int(11),
	PORTFOLIO_CODE int(11),
	OWNER_CODE int(11),
	OWNER_CL varchar,
	TEMPLATE_CODE varchar,
	PROCESSED_DATE datetime,
	SUBJECT_CONTENT varchar,
	FROM_EMAIL varchar,
	TO_EMAIL varchar,
	CC_EMAIL varchar,
	CONTEXT_OBJECT_NAME varchar,
	CONTEXT_OBJECT_CODE bigint(20),
	OBJECT_ALIAS varchar,
	REPORT_KEY varchar,
	STATUS_CL varchar,
	NOTIFICATION_TRANSACTION_CONTENT_FK bigint(20),
	EMAIL_TEMPLATE_FK bigint(20),
	NOTIFICATION_CODE varchar,
	RESPONSE_MESSAGE varchar,
	LOCALE_CL varchar,
	PHONE varchar,
	MEDIUM_CL varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	PHONE varchar,
	MEDIUM_CL varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	ATTEMPT_COUNT int(11),
	DUE_DATE datetime,
	NOTIFICATION_WEBHOOK_FK bigint(20),
	REPLY_TO_EMAIL varchar,
	EXCEPTION_EVENT_ID varchar,
	PHONE varchar,
	MEDIUM_CL varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	ATTEMPT_COUNT int(11),
	DUE_DATE datetime,
	NOTIFICATION_WEBHOOK_FK bigint(20),
	EXCEPTION_EVENT_ID varchar,
	REPLY_TO_EMAIL varchar,
	ATTEMPT_COUNT int(11),
	DUE_DATE datetime,
	NOTIFICATION_WEBHOOK_FK bigint(20),
	EXCEPTION_EVENT_ID varchar,
	REPLY_TO_EMAIL varchar,
	PHONE varchar,
	PHONE varchar,
	PHONE varchar,
	CONTEXT_OBJECT_REF_CODE varchar,
	CONTEXT_OBJECT_REF_CODE varchar,
	JOB_MESSAGE_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;