-- Create Table Statement for 'Action'
DROP TABLE IF EXISTS `ACTION`;
CREATE TABLE `ACTION` (
	REASON_CODE varchar,
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CREATE_DATE datetime,
	CREATOR_CODE varchar,
	OWNER_CODE varchar NOT NULL,
	LEAD_CASE_FK bigint(20),
	LEAD_FK bigint(20) NOT NULL,
	ACTIVITY_FK bigint(20),
	ACTION_CL varchar NOT NULL,
	NOTES varchar,
	SCHEDULED_ACTIVITY_FK bigint(20),
	SUBJECT varchar,
	TEMPLATE_CODE varchar,
	CONTACT_ORIGIN_NAME varchar,
	CONTACT_ORIGIN_VALUE varchar,
	ACTION_CONTENT_FK bigint(20),
	STATUS_CODE varchar,
	DESCRIPTION varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;