BEA Home | Events | Solutions | Partners | Products | Services | Download | Developer Center | WebSUPPORT
http://www.oracle.com/technology/documentation/index.html | Site Map | Search | PDF Files | Contact
WebLogic Process Integrator Documentation | Programming Client Applications | Previous Topic | Next Topic | Contents | Index
Database Schema
The following table describes the WebLogic Process Integrator database schema entities.
Table D-1 WebLogic Process Integrator 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
Table D-1 WebLogic Process Integrator Database Schema Entities
Entity Name
Attribute Name
Attribute Definitions
Column Data Type
Column Name
ACLENTRIES
PRINCIPAL
VARCHAR(254)
A_PRINCIPAL
NAME
A_NAME
PERMISSION
A_PERMISSION
ADDRESSEDMESSAGE
KEYVALUE
EXPIRY
DATE
VALIDATED
BOOLEAN
Boolean
MESSAGE
LARGE BINARY
MESSAGEID
VARCHAR(20)
BUSINESSCALENDAR
TIMEZONE
VARCHAR(50)
DATA
BUSINESSCALENDARID
ID
BUSINESSOPERATION
DESCRIPTION
LASTCHANGED
Datetime
DEFINITION
BUSINESSOPERATIONID
EVENTKEY
PLUGIN
EXPRESSION
TEXT
EVENTDESCRIPTOR
VARCHAR(192)
FIELDID
INTEGER
CONTENTTYPE
VARCHAR(128)
EVENTWATCH
CONDITION
TEMPLATEID
NODEID
TEMPLATEDEFINITIONID
STARTORG
INSTANCEID
GROUPMEMBER
GROUPID
GROUPMEMBERID
IDGENERATOR
MAXKEY
TABLENAME
VARCHAR(30)
INSTANCE
STARTED
COMPLETED
INITIATOR
ORGID
ORG
PARENTID
IDSTRING
STATE
ATTACHMENTS
WORKFLOWCOMMENT
MESSAGERECIPIENT
RECIPIENTTYPE
CREATED
RECIPIENTID
ORGMEMBER
USERID
U_NAME
CONFIG
STARTMODE
VERSION
REROUTE
ROUTETYPE
EFFECTIVE
ROUTETO
ROUTEFROM
REROUTEID
STATS
TASKID
ISROLE
ASSIGNEE
TASK
MODIFIABLE
UNMARKDONE
REASSIGNMENT
DOITIFDONE
PRIORITY
DONEWITHOUTDOIT
WORKFLOWID
Id
TASKCOMMENT
WORKFLOW
DUE
TEMPLATE
TEMPLATEDEFINITION
ACTIVE
MANUAL
CALLED
TEMPLATEORG
TIMEDEVENT
TRIGGERTIME
TRANSACTIONINFO
RESULTOBJECT
COMPLETEDTIME
TRANSACTIONID
VARCHAR(40)
USERMEMBER
WLSGROUP
WLSUSER
PASSWORD
U_PASSWORD
WORKFLOWROLE
ROLEID
WORKFLOWUSER
FULL_NAME
DEFAULTORGID
EMAILADDRESS
VARCHAR(100)
Copyright © 2001 BEA Systems, Inc. All rights reserved. Required browser: Netscape 4.0 or higher, or Microsoft Internet Explorer 4.0 or higher.