-- Create Table Statement for 'Scheduled Activity'
DROP TABLE IF EXISTS `SCHEDULED_ACTIVITY`;
CREATE TABLE `SCHEDULED_ACTIVITY` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CREATE_DATE datetime,
	IS_ACTIVE tinyint(1),
	ACTION_CL varchar NOT NULL,
	CREATOR_CODE varchar NOT NULL,
	CASE_STATE_CODE varchar,
	CASE_REMINDER_CODE varchar,
	AGE int(11),
	TEMPLATE_CODE varchar,
	CONTACT_ORIGIN_FK bigint(20),
	SUBJECT varchar,
	SCHEDULED_ACTIVITY_CONTENT_FK bigint(20),
	ACTIVITY_REASON_CODE varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;