bea.com | products | dev2dev | support | askBEA

Download Docs | Site Map | Glossary
Search

Programming BPM Client Apps

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