流程历史数据表
JBPM4_HIST_ACTINST 活动实例历史表
DBID_ | NUMBER(19) |
|
CLASS_ | VARCHAR2(255) |
|
DBVERSION_ | NUMBER(10) |
|
HPROCI_ | NUMBER(19) |
|
TYPE_ | VARCHAR2(255) |
|
EXECUTION_ | VARCHAR2(255) |
|
ACTIVITY_NAME_ | VARCHAR2(255) |
|
START_ | DATE |
|
END_ | DATE |
|
DURATION_ | NUMBER(19) |
|
TRANSITION_ | VARCHAR2(255) |
|
NEXTIDX_ | NUMBER(10) |
|
HTASK_ | NUMBER(19) |
|
JBPM4_HIST_PROCINST 进程实例历史表
DBID_ | NUMBER(19) |
|
DBVERSION_ | NUMBER(10) |
|
ID_ | VARCHAR2(255) |
|
PROCDEFID_ | VARCHAR2(255) |
|
KEY_ | VARCHAR2(255) |
|
START_ | DATE |
|
END_ | DATE |
|
DURATION_ | NUMBER(19) |
|
STATE_ | VARCHAR2(255) |
|
ENDACTIVITY_ | VARCHAR2(255) |
|
NEXTIDX_ | NUMBER(10) |
|
JBPM4_HIST_VAR 历史变量
DBID_ | NUMBER(19) |
|
DBVERSION_ | NUMBER(10) |
|
PROCINSTID_ | VARCHAR2(255) |
|
EXECUTIONID_ | VARCHAR2(255) |
|
VARNAME_ | VARCHAR2(255) |
|
VALUE_ | VARCHAR2(255) |
|
HPROCI_ | NUMBER(19) |
|
HTASK_ | NUMBER(19) |
|
JBPM4_HIST_DETAIL 详细信息记录
DBID_ | NUMBER(19) |
|
CLASS_ | VARCHAR2(255) |
|
DBVERSION_ | NUMBER(10) |
|
USERID_ | VARCHAR2(255) |
|
TIME_ | DATE |
|
HPROCI_ | NUMBER(19) |
|
HPROCIIDX_ | NUMBER(10) |
|
HACTI_ | NUMBER(19) |
|
HACTIIDX_ | NUMBER(10) |
|
HTASK_ | NUMBER(19) |
|
HTASKIDX_ | NUMBER(10) |
|
HVAR_ | NUMBER(19) |
|
HVARIDX_ | NUMBER(10) |
|
MESSAGE_ | CLOB |
|
OLD_STR_ | VARCHAR2(255) |
|
NEW_STR_ | VARCHAR2(255) |
|
OLD_INT_ | NUMBER(10) |
|
NEW_INT_ | NUMBER(10) |
|
OLD_TIME_ | DATE |
|
NEW_TIME_ | DATE |
|
PARENT_ | NUMBER(19) |
|
PARENT_IDX_ | NUMBER(10) |
|
JBPM4_HIST_TASK 历史任务
DBID_ | NUMBER(19) |
|
DBVERSION_ | NUMBER(10) |
|
EXECUTION_ | VARCHAR2(255) |
|
OUTCOME_ | VARCHAR2(255) |
|
ASSIGNEE_ | VARCHAR2(255) |
|
PRIORITY_ | NUMBER(10) |
|
STATE_ | VARCHAR2(255) |
|
CREATE_ | DATE |
|
END_ | DATE |
|
DURATION_ | NUMBER(19) |
|
NEXTIDX_ | NUMBER(10) |
|
SUPERTASK_ | NUMBER(19) |
|
身份认证表结构
JBPM4_ID_USER 用户表
DBID_ | NUMBER(19) |
|
DBVERSION_ | NUMBER(10) |
|
ID_ | VARCHAR2(255) |
|
PASSWORD_ | VARCHAR2(255) |
|
GIVENNAME_ | VARCHAR2(255) |
|
FAMILYNAME_ | VARCHAR2(255) |
|
BUSINESSEMAIL_ | VARCHAR2(255) |
|
JBPM4_ID_GROUP 组别表
DBID_ | NUMBER(19) |
|
DBVERSION_ | NUMBER(10) |
|
ID_ | VARCHAR2(255) |
|
NAME_ | VARCHAR2(255) |
|
TYPE_ | VARCHAR2(255) |
|
PARENT_ | NUMBER(19) |
|
JBPM4_ID_MEMBERSHIP 关系表
DBID_ | NUMBER(19) |
|
DBVERSION_ | NUMBER(10) |
|
USER_ | NUMBER(19) |
|
GROUP_ | NUMBER(19) |
|
NAME_ | VARCHAR2(255) |
|