Database Schema

The following table describes the BPM database schema entities.

Table E-1 BPM Database Schema Entities  

Entity Name	Attribute Name	Attribute Definitions
		Column Data Type	Column Name
ACLENTRIES	PRINCIPAL	VARCHAR(254)	A_PRINCIPAL
	NAME	VARCHAR(254)	A_NAME
	PERMISSION	VARCHAR(254)	A_PERMISSION
ADDRESSEDMESSAGE	KEYVALUE	VARCHAR(254)	KEYVALUE
	EXPIRY	DATE	EXPIRY
	VALIDATED	BOOLEAN	Boolean
	MESSAGE	LARGE BINARY	MESSAGE
	MESSAGEID	VARCHAR(20)	MESSAGEID
BUSINESSCALENDAR	TIMEZONE	VARCHAR(50)	TIMEZONE
	NAME	VARCHAR(50)	NAME
	DATA	LARGE BINARY	DATA
	BUSINESSCALENDARID	VARCHAR(20)	ID
BUSINESSOPERATION	DESCRIPTION	VARCHAR(50)	DESCRIPTION
	LASTCHANGED	DATE	Datetime
	DEFINITION	LARGE BINARY	DEFINITION
	BUSINESSOPERATIONID	VARCHAR(20)	ID
EVENTKEY	PLUGIN	VARCHAR(50)	PLUGIN
	EXPRESSION	TEXT	EXPRESSION
	LASTCHANGED	DATE	Datetime
	EVENTDESCRIPTOR	VARCHAR(192)	EVENTDESCRIPTOR
	FIELDID	INTEGER	FIELDID
	CONTENTTYPE	VARCHAR(128)	CONTENTTYPE
EVENTWATCH	KEYVALUE	VARCHAR(254)	KEYVALUE
	CONDITION	TEXT	CONDITION
	PLUGIN	VARCHAR(50)	PLUGIN
	EVENTDESCRIPTOR	VARCHAR(192)	EVENTDESCRIPTOR
	CONTENTTYPE	VARCHAR(128)	CONTENTTYPE
	VALIDATED	BOOLEAN	Boolean
	TEMPLATEID	VARCHAR(20)	ID
	NODEID	VARCHAR(20)	NODEID
	FIELDID	INTEGER	FIELDID
	TEMPLATEDEFINITIONID	VARCHAR(20)	TEMPLATEDEFINITIONID
	STARTORG	TEXT	STARTORG
	INSTANCEID	VARCHAR(20)	INSTANCEID
GROUPMEMBER	GROUPID	VARCHAR(20)	GROUPID
	GROUPMEMBERID	VARCHAR(20)	GROUPMEMBERID
IDGENERATOR	MAXKEY	VARCHAR(20)	MAXKEY
	TABLENAME	VARCHAR(30)	TABLENAME
INSTANCE	STARTED	DATE	STARTED
	COMPLETED	DATE	COMPLETED
	INITIATOR	VARCHAR(50)	INITIATOR
	TEMPLATEDEFINITIONID	VARCHAR(20)	ID
	NAME	VARCHAR(50)	NAME
	ORGID	VARCHAR(20)	ORG
	TEMPLATEID	VARCHAR(20)	ID
	PARENTID	VARCHAR(20)	PARENTID
	DATA	LARGE BINARY	DATA
	INSTANCEID	VARCHAR(20)	ID
	IDSTRING	VARCHAR(50)	IDSTRING
	STATE	INTEGER	STATE
	ATTACHMENTS	INTEGER	ATTACHMENTS
	WORKFLOWCOMMENT	VARCHAR(50)	WORKFLOWCOMMENT
MESSAGERECIPIENT	RECIPIENTTYPE	INTEGER	RECIPIENTTYPE
	CREATED	DATE	Datetime
	RECIPIENTID	VARCHAR(20)	RECIPIENTID
	MESSAGEID	VARCHAR(20)	MESSAGEID
ORG	DESCRIPTION	VARCHAR(254)	DESCRIPTION
	BUSINESSCALENDARID	VARCHAR(20)	ID
	ORGID	VARCHAR(20)	ORGID
ORGMEMBER	USERID	VARCHAR(20)	U_NAME
	ORGID	VARCHAR(20)	ORGID
PLUGIN	CONFIG	TEXT	CONFIG
	STARTMODE	INTEGER	STARTMODE
	VERSION	VARCHAR(20)	VERSION
	NAME	VARCHAR(50)	NAME
REROUTE	ROUTETYPE	INTEGER	ROUTETYPE
	EFFECTIVE	DATE	EFFECTIVE
	ROUTETO	VARCHAR(50)	ROUTETO
	ROUTEFROM	VARCHAR(50)	ROUTEFROM
	REROUTEID	VARCHAR(20)	ID
	EXPIRY	DATE	EXPIRY
	ORGID	VARCHAR(20)	ORGID
STATS	STARTED	DATE	STARTED
	COMPLETED	DATE	COMPLETED
	TASKID	VARCHAR(20)	TASKID
	TEMPLATEDEFINITIONID	VARCHAR(20)	TEMPLATEDEFINITIONID
	ISROLE	BOOLEAN	ISROLE
	ORGID	VARCHAR(20)	ORG
	ASSIGNEE	VARCHAR(20)	ASSIGNEE
TASK	MODIFIABLE	BOOLEAN	MODIFIABLE
	UNMARKDONE	BOOLEAN	UNMARKDONE
	REASSIGNMENT	BOOLEAN	REASSIGNMENT
	STARTED	DATE	STARTED
	COMPLETED	DATE	COMPLETED
	NAME	VARCHAR(50)	NAME
	DOITIFDONE	BOOLEAN	DOITIFDONE
	PRIORITY	INTEGER	PRIORITY
	DONEWITHOUTDOIT	BOOLEAN	DONEWITHOUTDOIT
	TEMPLATEID	VARCHAR(20)	ID
	TEMPLATEDEFINITIONID	VARCHAR(20)	ID
	WORKFLOWID	VARCHAR(50)	WORKFLOWID
	INSTANCEID	VARCHAR(20)	Id
	TASKID	VARCHAR(20)	TASKID
	TASKCOMMENT	VARCHAR(50)	TASKCOMMENT
	ASSIGNEE	VARCHAR(20)	ASSIGNEE
	ORGID	VARCHAR(20)	ORGID
	WORKFLOW	VARCHAR(50)	WORKFLOW
	ISROLE	BOOLEAN	ISROLE
	DUE	DATE	DUE
TEMPLATE	NAME	VARCHAR(50)	NAME
	LASTCHANGED	DATE	Datetime
	DATA	LARGE BINARY	DATA
	TEMPLATEID	VARCHAR(20)	ID
TEMPLATEDEFINITION	ACTIVE	BOOLEAN	ACTIVE
	MANUAL	BOOLEAN	MANUAL
	EXPIRY	DATE	EXPIRY
	EFFECTIVE	DATE	EFFECTIVE
	LASTCHANGED	DATE	Datetime
	TEMPLATEDEFINITIONID	VARCHAR(20)	ID
	CALLED	BOOLEAN	CALLED
	TEMPLATEID	VARCHAR(20)	ID
	DATA	LARGE BINARY	DATA
TEMPLATEORG	TEMPLATEID	VARCHAR(20)	ID
	ORGID	VARCHAR(20)	ORGID
TIMEDEVENT	INSTANCEID	VARCHAR(20)	ID
	TEMPLATEID	VARCHAR(20)	ID
	TRIGGERTIME	DATE	TRIGGERTIME
	TEMPLATEDEFINITIONID	VARCHAR(20)	ID
	NODEID	VARCHAR(20)	NODEID
	STARTORG	TEXT	STARTORG
TRANSACTIONINFO	RESULTOBJECT	LARGE BINARY	RESULTOBJECT
	COMPLETEDTIME	DATE	COMPLETEDTIME
	TRANSACTIONID	VARCHAR(40)	TRANSACTIONID
USERMEMBER	USERID	VARCHAR(20)	U_NAME
	GROUPID	VARCHAR(20)	GROUPID
WLSGROUP	GROUPID	VARCHAR(20)	GROUPID
WLSUSER	PASSWORD	VARCHAR(254)	U_PASSWORD
	USERID	VARCHAR(20)	U_NAME
WORKFLOWROLE	BUSINESSCALENDARID	VARCHAR(20)	ID
	GROUPID	VARCHAR(20)	GROUPID
	DESCRIPTION	VARCHAR(20)	DESCRIPTION
	ORGID	VARCHAR(20)	ORGID
	ROLEID	VARCHAR(20)	ROLEID
WORKFLOWUSER	FULL_NAME	VARCHAR(254)	FULL_NAME
	DEFAULTORGID	VARCHAR(20)	DEFAULTORGID
	EMAILADDRESS	VARCHAR(100)	EMAILADDRESS
	BUSINESSCALENDARID	VARCHAR(20)	ID
	USERID	VARCHAR(20)	U_NAME