-- Create Table Statement for 'Job Object'
DROP TABLE IF EXISTS `IAPP_JOB_OBJECT`;
CREATE TABLE `IAPP_JOB_OBJECT` (
	IS_ACTIVE tinyint(1) NOT NULL,
	ID bigint(20) NOT NULL,
	OBJECT_CL varchar NOT NULL,
	APPLICATION varchar,
	GROUP varchar,
	NAME varchar,
	FULL_NAME varchar NOT NULL,
	EXPRESSION varchar,
	CONSUMER_COUNT int(11),
	IS_ACTIVE_DEFAULT tinyint(1) NOT NULL,
	CONSUMER_COUNT int(11),
	FULL_NAME varchar NOT NULL,
	IS_ACTIVE tinyint(1) NOT NULL,
	ID bigint(20) NOT NULL,
	OBJECT_CL varchar NOT NULL,
	APPLICATION varchar,
	GROUP varchar,
	NAME varchar,
	EXPRESSION varchar,
	IS_ACTIVE_DEFAULT tinyint(1) NOT NULL,
	CONSUMER_COUNT int(11),
	FULL_NAME varchar NOT NULL,
	IS_ACTIVE tinyint(1) NOT NULL,
	ID bigint(20) NOT NULL,
	OBJECT_CL varchar NOT NULL,
	APPLICATION varchar,
	GROUP varchar,
	NAME varchar,
	EXPRESSION varchar,
	IS_ACTIVE_DEFAULT tinyint(1) NOT NULL,
	IS_VISIBLE tinyint(1),
	IS_VISIBLE tinyint(1),
	IS_VISIBLE tinyint(1),
	PRIMARY KEY (ID, ID, ID)
) ENGINE=InnoDB;