---C 字符型 --varchar2
---N 数字型 --number
---B 二进制型 --blob
---T 大文本型 --clob
-----------------------------------------------------
jbpm4 建表语句 oracle
create table JBPM4_DEPLOYMENT (
DBID_ number(19,0) not null,
NAME_ varchar(255),
TIMESTAMP_ number(19,0),
STATE_ varchar(255),
primary key (DBID_)
);
create table JBPM4_DEPLOYPROP (
DBID_ number(19,0) not null,
DEPLOYMENT_ number(19,0),
OBJNAME_ varchar(255),
KEY_ varchar(255),
STRINGVAL_ varchar(255),
LONGVAL_ number(19,0),
primary key (DBID_)
);
create table JBPM4_EXECUTION (
DBID_ number(19,0) not null,
CLASS_ varchar(255) not null,
DBVERSION_ number(10,0) not null,
ACTIVITYNAME_ varchar(255),
PROCDEFID_ varchar(255),
HASVARS_ number(1,0),
NAME_ varchar(255),
KEY_ varchar(255),
ID_ varchar(255) unique,
STATE_ varchar(255),
SUSPHISTSTATE_ varchar(255),
PRIORITY_ number(10,0),
HISACTINST_ number(19,0),
PARENT_ number(19,0),
INSTANCE_ number(19,0),
SUPEREXEC_ number(19,0),
SUBPROCINST_ number(19,0),
PARENT_IDX_ number(10,0),
primary key (DBID_)
);
create table JBPM4_HIST_ACTINST (
DBID_ number(19,0) not null,
CLASS_ varchar(255) not null,
DBVERSION_ number(10,0) not null,
HPROCI_ number(19,0),
TYPE_ varchar(255),
EXECUTION_ varchar(255),
ACTIVITY_NAME_ varchar(255),
START_ date,
END_ date,
DURATION_ number(19,0),
TRANSITION_ varchar(255),
NEXTIDX_ number(10,0),
HTASK_ number(19,0),
primary key (DBID_)
);
create table JBPM4_HIST_DETAIL (
DBID_ number(19,0) not null,
CLASS_ varchar(255) not null,
DBVERSION_ number(10,0) not null,
USERID_ varchar(255),
TIME_ date,
HPROCI_ number(19,0),
HPROCIIDX_ number(10,0),
HACTI_ number(19,0),
HACTIIDX_ number(10,0),
HTASK_ number(19,0),
HTASKIDX_ number(10,0),
HVAR_ number(19,0),
HVARIDX_ number(10,0),
MESSAGE_ varchar(255),
OLD_STR_ varchar(255),
NEW_STR_ varchar(255),
OLD_INT_ number(10,0),
NEW_INT_ number(10,0),
OLD_TIME_ date,
NEW_TIME_ date,
PARENT_ number(19,0),
PARENT_IDX_ number(10,0),
primary key (DBID_)
);
create table JBPM4_HIST_PROCINST (
DBID_ number(19,0) not null,
DBVERSION_ number(10,0) not null,
ID_ varchar(255),
PROCDEFID_ varchar(255),
KEY_ varchar(255),
START_ date,
END_ date,
DURATION_ number(19,0),
STATE_ varchar(255),
ENDACTIVITY_ varchar(255),
NEXTIDX_ number(10,0),
primary key (DBID_)
);
create table JBPM4_HIST_TASK (
DBID_ number(19,0) not null,
DBVERSION_ number(10,0) not null,
EXECUTION_ varchar(255),
OUTCOME_ varchar(255),
ASSIGNEE_ varchar(255),
PRIORITY_ number(10,0),
STATE_ varchar(255),
CREATE_ date,
END_ date,
DURATION_ number(19,0),
NEXTIDX_ number(10,0),
SUPERTASK_ number(19,0),
primary key (DBID_)
);
create table JBPM4_HIST_VAR (
DBID_ number(19,0) not null,
DBVERSION_ number(10,0) not null,
PROCINSTID_ varchar(255),
EXECUTIONID_ varchar(255),
VARNAME_ varchar(255),
VALUE_ varchar(255),
HPROCI_ number(19,0),
HTASK_ number(19,0),
primary key (DBID_)
);
create table JBPM4_ID_GROUP (
DBID_ number(19,0) not null,
DBVERSION_ number(10,0) not null,
ID_ varchar(255),
NAME_ varchar(255),
TYPE_ varchar(255),
PARENT_ number(19,0),
primary key (DBID_)
);
create table JBPM4_ID_MEMBERSHIP (
DBID_ number(19,0) not null,
DBVERSION_ number(10,0) not null,
USER_ number(19,0),
GROUP_ number(19,0),
NAME_ varchar(255),
primary key (DBID_)
);
create table JBPM4_ID_USER (
DBID_ number(19,0) not null,
DBVERSION_ number(10,0) not null,
ID_ varchar(255),
PASSWORD_ varchar(255),
GIVENNAME_ varchar(255),
FAMILYNAME_ varchar(255),
BUSINESSEMAIL_ varchar(255),
primary key (DBID_)
);
create table JBPM4_JOB (
DBID_ number(19,0) not null,
CLASS_ varchar(255) not null,
DBVERSION_ number(10,0) not null,
DUEDATE_ date,
STATE_ varchar(255),
ISEXCLUSIVE_ number(1,0),
LOCKOWNER_ varchar(255),
LOCKEXPTIME_ date,
EXCEPTION_ clob,
RETRIES_ number(10,0),
PROCESSINSTANCE_ number(19,0),
EXECUTION_ number(19,0),
CFG_ number(19,0),
SIGNAL_ varchar(255),
EVENT_ varchar(255),
REPEAT_ varchar(255),
primary key (DBID_)
);
create table JBPM4_LOB (
DBID_ number(19,0) not null,
DBVERSION_ number(10,0) not null,
BLOB_VALUE_ blob,
DEPLOYMENT_ number(19,0),
NAME_ clob,
primary key (DBID_)
);
create table JBPM4_PARTICIPATION (
DBID_ number(19,0) not null,
DBVERSION_ number(10,0) not null,
GROUPID_ varchar(255),
USERID_ varchar(255),
TYPE_ varchar(255),
TASK_ number(19,0),
SWIMLANE_ number(19,0),
primary key (DBID_)
);
create table JBPM4_PROPERTY (
KEY_ varchar(255) not null,
VERSION_ number(10,0) not null,
VALUE_ varchar(255),
primary key (KEY_)
);
create table JBPM4_SWIMLANE (
DBID_ number(19,0) not null,
DBVERSION_ number(10,0) not null,
NAME_ varchar(255),
ASSIGNEE_ varchar(255),
EXECUTION_ number(19,0),
primary key (DBID_)
);
create table JBPM4_TASK (
DBID_ number(19,0) not null,
CLASS_ char(1) not null,
DBVERSION_ number(10,0) not null,
NAME_ varchar(255),
DESCR_ clob,
STATE_ varchar(255),
SUSPHISTSTATE_ varchar(255),
ASSIGNEE_ varchar(255),
FORM_ varchar(255),
PRIORITY_ number(10,0),
CREATE_ date,
DUEDATE_ date,
PROGRESS_ number(10,0),
SIGNALLING_ number(1,0),
EXECUTION_ID_ varchar(255),
ACTIVITY_NAME_ varchar(255),
HASVARS_ number(1,0),
SUPERTASK_ number(19,0),
EXECUTION_ number(19,0),
PROCINST_ number(19,0),
SWIMLANE_ number(19,0),
TASKDEFNAME_ varchar(255),
primary key (DBID_)
);
create table JBPM4_VARIABLE (
DBID_ number(19,0) not null,
CLASS_ varchar(255) not null,
DBVERSION_ number(10,0) not null,
KEY_ varchar(255),
CONVERTER_ varchar(255),
HIST_ number(1,0),
EXECUTION_ number(19,0),
TASK_ number(19,0),
LOB_ number(19,0),
DATE_VALUE_ date,
DOUBLE_VALUE_ double precision,
CLASSNAME_ varchar(255),
LONG_VALUE_ number(19,0),
STRING_VALUE_ varchar(255),
TEXT_VALUE_ clob,
EXESYS_ number(19,0),
primary key (DBID_)
);
create index IDX_DEPLPROP_DEPL on JBPM4_DEPLOYPROP (DEPLOYMENT_);
---------------------------------------------------------------------------------------------------------------------
jbpm建表语句mysql
create table JBPM4_DEPLOYMENT (
DBID_ numeric(19,0) not null,
NAME_ varchar(255),
TIMESTAMP_ numeric(19,0),
STATE_ varchar(255),
primary key (DBID_)
);
create table JBPM4_DEPLOYPROP (
DBID_ numeric(19,0) not null,
DEPLOYMENT_ numeric(19,0),
OBJNAME_ varchar(255),
KEY_ varchar(255),
STRINGVAL_ varchar(255),
LONGVAL_ numeric(19,0),
primary key (DBID_)
);
create table JBPM4_EXECUTION (
DBID_ numeric(19,0) not null,
CLASS_ varchar(255) not null,
DBVERSION_ numeric(10,0) not null,
ACTIVITYNAME_ varchar(255),
PROCDEFID_ varchar(255),
HASVARS_ numeric(1,0),
NAME_ varchar(255),
KEY_ varchar(255),
ID_ varchar(255) unique,
STATE_ varchar(255),
SUSPHISTSTATE_ varchar(255),
PRIORITY_ numeric(10,0),
HISACTINST_ numeric(19,0),
PARENT_ numeric(19,0),
INSTANCE_ numeric(19,0),
SUPEREXEC_ numeric(19,0),
SUBPROCINST_ numeric(19,0),
PARENT_IDX_ numeric(10,0),
primary key (DBID_)
);
create table JBPM4_HIST_ACTINST (
DBID_ numeric(19,0) not null,
CLASS_ varchar(255) not null,
DBVERSION_ numeric(10,0) not null,
HPROCI_ numeric(19,0),
TYPE_ varchar(255),
EXECUTION_ varchar(255),
ACTIVITY_NAME_ varchar(255),
START_ datetime,
END_ datetime,
DURATION_ numeric(19,0),
TRANSITION_ varchar(255),
NEXTIDX_ numeric(10,0),
HTASK_ numeric(19,0),
primary key (DBID_)
);
create table JBPM4_HIST_DETAIL (
DBID_ numeric(19,0) not null,
CLASS_ varchar(255) not null,
DBVERSION_ numeric(10,0) not null,
USERID_ varchar(255),
TIME_ datetime,
HPROCI_ numeric(19,0),
HPROCIIDX_ numeric(10,0),
HACTI_ numeric(19,0),
HACTIIDX_ numeric(10,0),
HTASK_ numeric(19,0),
HTASKIDX_ numeric(10,0),
HVAR_ numeric(19,0),
HVARIDX_ numeric(10,0),
MESSAGE_ varchar(255),
OLD_STR_ varchar(255),
NEW_STR_ varchar(255),
OLD_INT_ numeric(10,0),
NEW_INT_ numeric(10,0),
OLD_TIME_ datetime,
NEW_TIME_ datetime,
PARENT_ numeric(19,0),
PARENT_IDX_ numeric(10,0),
primary key (DBID_)
);
create table JBPM4_HIST_PROCINST (
DBID_ numeric(19,0) not null,
DBVERSION_ numeric(10,0) not null,
ID_ varchar(255),
PROCDEFID_ varchar(255),
KEY_ varchar(255),
START_ datetime,
END_ datetime,
DURATION_ numeric(19,0),
STATE_ varchar(255),
ENDACTIVITY_ varchar(255),
NEXTIDX_ numeric(10,0),
primary key (DBID_)
);
create table JBPM4_HIST_TASK (
DBID_ numeric(19,0) not null,
DBVERSION_ numeric(10,0) not null,
EXECUTION_ varchar(255),
OUTCOME_ varchar(255),
ASSIGNEE_ varchar(255),
PRIORITY_ numeric(10,0),
STATE_ varchar(255),
CREATE_ datetime,
END_ datetime,
DURATION_ numeric(19,0),
NEXTIDX_ numeric(10,0),
SUPERTASK_ numeric(19,0),
primary key (DBID_)
);
create table JBPM4_HIST_VAR (
DBID_ numeric(19,0) not null,
DBVERSION_ numeric(10,0) not null,
PROCINSTID_ varchar(255),
EXECUTIONID_ varchar(255),
VARNAME_ varchar(255),
VALUE_ varchar(255),
HPROCI_ numeric(19,0),
HTASK_ numeric(19,0),
primary key (DBID_)
);
create table JBPM4_ID_GROUP (
DBID_ numeric(19,0) not null,
DBVERSION_ numeric(10,0) not null,
ID_ varchar(255),
NAME_ varchar(255),
TYPE_ varchar(255),
PARENT_ numeric(19,0),
primary key (DBID_)
);
create table JBPM4_ID_MEMBERSHIP (
DBID_ numeric(19,0) not null,
DBVERSION_ numeric(10,0) not null,
USER_ numeric(19,0),
GROUP_ numeric(19,0),
NAME_ varchar(255),
primary key (DBID_)
);
create table JBPM4_ID_USER (
DBID_ numeric(19,0) not null,
DBVERSION_ numeric(10,0) not null,
ID_ varchar(255),
PASSWORD_ varchar(255),
GIVENNAME_ varchar(255),
FAMILYNAME_ varchar(255),
BUSINESSEMAIL_ varchar(255),
primary key (DBID_)
);
create table JBPM4_JOB (
DBID_ numeric(19,0) not null,
CLASS_ varchar(255) not null,
DBVERSION_ numeric(10,0) not null,
DUEDATE_ datetime,
STATE_ varchar(255),
ISEXCLUSIVE_ numeric(1,0),
LOCKOWNER_ varchar(255),
LOCKEXPTIME_ datetime,
EXCEPTION_ text,
RETRIES_ numeric(10,0),
PROCESSINSTANCE_ numeric(19,0),
EXECUTION_ numeric(19,0),
CFG_ numeric(19,0),
SIGNAL_ varchar(255),
EVENT_ varchar(255),
REPEAT_ varchar(255),
primary key (DBID_)
);
create table JBPM4_LOB (
DBID_ numeric(19,0) not null,
DBVERSION_ numeric(10,0) not null,
BLOB_VALUE_ image,
DEPLOYMENT_ numeric(19,0),
NAME_ text,
primary key (DBID_)
);
create table JBPM4_PARTICIPATION (
DBID_ numeric(19,0) not null,
DBVERSION_ numeric(10,0) not null,
GROUPID_ varchar(255),
USERID_ varchar(255),
TYPE_ varchar(255),
TASK_ numeric(19,0),
SWIMLANE_ numeric(19,0),
primary key (DBID_)
);
create table JBPM4_PROPERTY (
KEY_ varchar(255) not null,
VERSION_ numeric(10,0) not null,
VALUE_ varchar(255),
primary key (KEY_)
);
create table JBPM4_SWIMLANE (
DBID_ numeric(19,0) not null,
DBVERSION_ numeric(10,0) not null,
NAME_ varchar(255),
ASSIGNEE_ varchar(255),
EXECUTION_ numeric(19,0),
primary key (DBID_)
);
create table JBPM4_TASK (
DBID_ numeric(19,0) not null,
CLASS_ char(1) not null,
DBVERSION_ numeric(10,0) not null,
NAME_ varchar(255),
DESCR_ text,
STATE_ varchar(255),
SUSPHISTSTATE_ varchar(255),
ASSIGNEE_ varchar(255),
FORM_ varchar(255),
PRIORITY_ numeric(10,0),
CREATE_ datetime,
DUEDATE_ datetime,
PROGRESS_ numeric(10,0),
SIGNALLING_ numeric(1,0),
EXECUTION_ID_ varchar(255),
ACTIVITY_NAME_ varchar(255),
HASVARS_ numeric(1,0),
SUPERTASK_ numeric(19,0),
EXECUTION_ numeric(19,0),
PROCINST_ numeric(19,0),
SWIMLANE_ numeric(19,0),
TASKDEFNAME_ varchar(255),
primary key (DBID_)
);
create table JBPM4_VARIABLE (
DBID_ numeric(19,0) not null,
CLASS_ varchar(255) not null,
DBVERSION_ numeric(10,0) not null,
KEY_ varchar(255),
CONVERTER_ varchar(255),
HIST_ numeric(1,0),
EXECUTION_ numeric(19,0),
TASK_ numeric(19,0),
LOB_ numeric(19,0),
DATE_VALUE_ datetime,
DOUBLE_VALUE_ double precision,
CLASSNAME_ varchar(255),
LONG_VALUE_ numeric(19,0),
STRING_VALUE_ varchar(255),
TEXT_VALUE_ text,
EXESYS_ numeric(19,0),
primary key (DBID_)
);
create index IDX_DEPLPROP_DEPL on JBPM4_DEPLOYPROP (DEPLOYMENT_);