Activiti 7建表语句及注释

Activiti数据库表Oracle兼容DM建表语句及字段注释。
附件下载版地址点这里

--通用属性表
create table ACT_GE_PROPERTY (
    NAME_ NVARCHAR2(64),
    VALUE_ NVARCHAR2(300),
    REV_ INTEGER,
    primary key (NAME_)
);

COMMENT ON TABLE ACT_GE_PROPERTY IS '通用属性表';

COMMENT ON COLUMN ACT_GE_PROPERTY.NAME_ IS '属性名称';
COMMENT ON COLUMN ACT_GE_PROPERTY.VALUE_ IS '属性值';
COMMENT ON COLUMN ACT_GE_PROPERTY.REV_ IS '版本号';

insert into ACT_GE_PROPERTY
values ('schema.version', '7.0.0.0', 1);

insert into ACT_GE_PROPERTY
values ('schema.history', 'create(7.0.0.0)', 1);

insert into ACT_GE_PROPERTY
values ('next.dbid', '1', 1);

--通用流程信息表
create table ACT_GE_BYTEARRAY (
    ID_ NVARCHAR2(64),
    REV_ INTEGER,
    NAME_ NVARCHAR2(255),
    DEPLOYMENT_ID_ NVARCHAR2(64),
    BYTES_ BLOB,
    GENERATED_ NUMBER(1,0) CHECK (GENERATED_ IN (1,0)),
    primary key (ID_)
);

COMMENT ON TABLE ACT_GE_BYTEARRAY IS '通用流程信息表';

COMMENT ON COLUMN ACT_GE_BYTEARRAY.ID_ IS '主键ID';
COMMENT ON COLUMN ACT_GE_BYTEARRAY.REV_ IS '版本号';
COMMENT ON COLUMN ACT_GE_BYTEARRAY.NAME_ IS '资源名称';
COMMENT ON COLUMN ACT_GE_BYTEARRAY.DEPLOYMENT_ID_ IS '关联部署表act_re_deployment主键ID';
COMMENT ON COLUMN ACT_GE_BYTEARRAY.BYTES_ IS '资源内容';
COMMENT ON COLUMN ACT_GE_BYTEARRAY.GENERATED_ IS '标识是否由系统生成(0-否，1-是)';

--流程部署信息表
create table ACT_RE_DEPLOYMENT (
    ID_ NVARCHAR2(64),
    NAME_ NVARCHAR2(255),
    CATEGORY_ NVARCHAR2(255),
    KEY_ NVARCHAR2(255),
    TENANT_ID_ NVARCHAR2(255) DEFAULT '',
    DEPLOY_TIME_ TIMESTAMP(6),
    ENGINE_VERSION_ NVARCHAR2(255),
    VERSION_ INTEGER DEFAULT 1,
    PROJECT_RELEASE_VERSION_ NVARCHAR2(255),
    primary key (ID_)
);

COMMENT ON TABLE ACT_RE_DEPLOYMENT IS '流程部署信息表';

COMMENT ON COLUMN ACT_RE_DEPLOYMENT.ID_ IS '主键ID';
COMMENT ON COLUMN ACT_RE_DEPLOYMENT.NAME_ IS '部署名称';
COMMENT ON COLUMN ACT_RE_DEPLOYMENT.CATEGORY_ IS '分类';
COMMENT ON COLUMN ACT_RE_DEPLOYMENT.KEY_ IS '标志key';
COMMENT ON COLUMN ACT_RE_DEPLOYMENT.TENANT_ID_ IS '多租户ID';
COMMENT ON COLUMN ACT_RE_DEPLOYMENT.DEPLOY_TIME_ IS '部署时间';
COMMENT ON COLUMN ACT_RE_DEPLOYMENT.ENGINE_VERSION_ IS '引擎版本';
COMMENT ON COLUMN ACT_RE_DEPLOYMENT.VERSION_ IS '版本号';
COMMENT ON COLUMN ACT_RE_DEPLOYMENT.PROJECT_RELEASE_VERSION_ IS '发布版本';

--流程设计模型表
create table ACT_RE_MODEL (
    ID_ NVARCHAR2(64) not null,
    REV_ INTEGER,
    NAME_ NVARCHAR2(255),
    KEY_ NVARCHAR2(255),
    CATEGORY_ NVARCHAR2(255),
    CREATE_TIME_ TIMESTAMP(6),
    LAST_UPDATE_TIME_ TIMESTAMP(6),
    VERSION_ INTEGER,
    META_INFO_ NVARCHAR2(2000),
    DEPLOYMENT_ID_ NVARCHAR2(64),
    EDITOR_SOURCE_VALUE_ID_ NVARCHAR2(64),
    EDITOR_SOURCE_EXTRA_VALUE_ID_ NVARCHAR2(64),
    TENANT_ID_ NVARCHAR2(255) DEFAULT '',
    primary key (ID_)
);

COMMENT ON TABLE ACT_RE_MODEL IS '流程设计模型表';

COMMENT ON COLUMN ACT_RE_MODEL.ID_ IS '主键ID';
COMMENT ON COLUMN ACT_RE_MODEL.REV_ IS '版本号';
COMMENT ON COLUMN ACT_RE_MODEL.NAME_ IS '流程名称';
COMMENT ON COLUMN ACT_RE_MODEL.KEY_ IS '标志key';
COMMENT ON COLUMN ACT_RE_MODEL.CREATE_TIME_ IS '分类';
COMMENT ON COLUMN ACT_RE_MODEL.LAST_UPDATE_TIME_ IS '创建时间';
COMMENT ON COLUMN ACT_RE_MODEL.VERSION_ IS '流程版本';
COMMENT ON COLUMN ACT_RE_MODEL.META_INFO_ IS '元数据信息';
COMMENT ON COLUMN ACT_RE_MODEL.DEPLOYMENT_ID_ IS '关联流程部署信息表ID';
COMMENT ON COLUMN ACT_RE_MODEL.EDITOR_SOURCE_VALUE_ID_ IS '关联通用流程信息表ID（流程XML资源ID）';
COMMENT ON COLUMN ACT_RE_MODEL.EDITOR_SOURCE_EXTRA_VALUE_ID_ IS '关联通用流程信息表ID（流程图资源ID）';
COMMENT ON COLUMN ACT_RE_MODEL.TENANT_ID_ IS '多租户ID';

--运行时流程执行实例表
create table ACT_RU_EXECUTION (
    ID_ NVARCHAR2(64),
    REV_ INTEGER,
    PROC_INST_ID_ NVARCHAR2(64),
    BUSINESS_KEY_ NVARCHAR2(255),
    PARENT_ID_ NVARCHAR2(64),
    PROC_DEF_ID_ NVARCHAR2(64),
    SUPER_EXEC_ NVARCHAR2(64),
    ROOT_PROC_INST_ID_ NVARCHAR2(64),
    ACT_ID_ NVARCHAR2(255),
    IS_ACTIVE_ NUMBER(1,0) CHECK (IS_ACTIVE_ IN (1,0)),
    IS_CONCURRENT_ NUMBER(1,0) CHECK (IS_CONCURRENT_ IN (1,0)),
    IS_SCOPE_ NUMBER(1,0) CHECK (IS_SCOPE_ IN (1,0)),
    IS_EVENT_SCOPE_ NUMBER(1,0) CHECK (IS_EVENT_SCOPE_ IN (1,0)),
    IS_MI_ROOT_ NUMBER(1,0) CHECK (IS_MI_ROOT_ IN (1,0)),
    SUSPENSION_STATE_ INTEGER,
    CACHED_ENT_STATE_ INTEGER,
    TENANT_ID_ NVARCHAR2(255) DEFAULT '',
    NAME_ NVARCHAR2(255),
    START_TIME_ TIMESTAMP(6),
    START_USER_ID_ NVARCHAR2(255),
    LOCK_TIME_ TIMESTAMP(6),
    IS_COUNT_ENABLED_ NUMBER(1,0) CHECK (IS_COUNT_ENABLED_ IN (1,0)),
    EVT_SUBSCR_COUNT_ INTEGER,
    TASK_COUNT_ INTEGER,
    JOB_COUNT_ INTEGER,
    TIMER_JOB_COUNT_ INTEGER,
    SUSP_JOB_COUNT_ INTEGER,
    DEADLETTER_JOB_COUNT_ INTEGER,
    VAR_COUNT_ INTEGER,
    ID_LINK_COUNT_ INTEGER,
    APP_VERSION_ INTEGER,
    primary key (ID_)
);

COMMENT ON TABLE ACT_RU_EXECUTION IS '运行时流程执行实例表';

COMMENT ON COLUMN ACT_RU_EXECUTION.ID_ IS '主键ID';
COMMENT ON COLUMN ACT_RU_EXECUTION.REV_ IS '版本号';
COMMENT ON COLUMN ACT_RU_EXECUTION.PROC_INST_ID_ IS '流程实例ID';
COMMENT ON COLUMN ACT_RU_EXECUTION.BUSINESS_KEY_ IS '业务主键ID';
COMMENT ON COLUMN ACT_RU_EXECUTION.PARENT_ID_ IS '父执行流ID';
COMMENT ON COLUMN ACT_RU_EXECUTION.PROC_DEF_ID_ IS '流程定义ID，关联流程定义表';
COMMENT ON COLUMN ACT_RU_EXECUTION.SUPER_EXEC_ IS '外部子流程记录对应的主流程的主键ID';
COMMENT ON COLUMN ACT_RU_EXECUTION.ROOT_PROC_INST_ID_ IS '父流程实例ID';
COMMENT ON COLUMN ACT_RU_EXECUTION.ACT_ID_ IS '当前执行流行为ID';
COMMENT ON COLUMN ACT_RU_EXECUTION.IS_ACTIVE_ IS '执行流是否活跃标识。0-非活动，1-活动';
COMMENT ON COLUMN ACT_RU_EXECUTION.IS_CONCURRENT_ IS '执行流是否正在并行。0-非并行，1-并行';
COMMENT ON COLUMN ACT_RU_EXECUTION.IS_SCOPE_ IS '是否全局流程执行';
COMMENT ON COLUMN ACT_RU_EXECUTION.IS_EVENT_SCOPE_ IS '是否激活状态';
COMMENT ON COLUMN ACT_RU_EXECUTION.IS_MI_ROOT_ IS '是否多实例根节点';
COMMENT ON COLUMN ACT_RU_EXECUTION.SUSPENSION_STATE_ IS '标识流程的中断状态。1-激活，2-挂起';
COMMENT ON COLUMN ACT_RU_EXECUTION.CACHED_ENT_STATE_ IS '缓存的实体状态';
COMMENT ON COLUMN ACT_RU_EXECUTION.TENANT_ID_ IS '多租户ID';
COMMENT ON COLUMN ACT_RU_EXECUTION.NAME_ IS '名称';
COMMENT ON COLUMN ACT_RU_EXECUTION.START_TIME_ IS '开始时间';
COMMENT ON COLUMN ACT_RU_EXECUTION.START_USER_ID_ IS '开始的用户ID';
COMMENT ON COLUMN ACT_RU_EXECUTION.LOCK_TIME_ IS '锁定时间';
COMMENT ON COLUMN ACT_RU_EXECUTION.IS_COUNT_ENABLED_ IS '是否启用计数';
COMMENT ON COLUMN ACT_RU_EXECUTION.EVT_SUBSCR_COUNT_ IS '事件关联信息数据条数';
COMMENT ON COLUMN ACT_RU_EXECUTION.TASK_COUNT_ IS '任务个数';
COMMENT ON COLUMN ACT_RU_EXECUTION.JOB_COUNT_ IS '异步任务个数';
COMMENT ON COLUMN ACT_RU_EXECUTION.TIMER_JOB_COUNT_ IS '定时任务个数';
COMMENT ON COLUMN ACT_RU_EXECUTION.SUSP_JOB_COUNT_ IS '中断任务个数';
COMMENT ON COLUMN ACT_RU_EXECUTION.DEADLETTER_JOB_COUNT_ IS '无法执行任务个数';
COMMENT ON COLUMN ACT_RU_EXECUTION.VAR_COUNT_ IS '变量个数';
COMMENT ON COLUMN ACT_RU_EXECUTION.ID_LINK_COUNT_ IS '关联用户或用户组个数';
COMMENT ON COLUMN ACT_RU_EXECUTION.APP_VERSION_ IS 'APP版本号';

--一般工作数据表
create table ACT_RU_JOB (
    ID_ NVARCHAR2(64) NOT NULL,
    REV_ INTEGER,
    TYPE_ NVARCHAR2(255) NOT NULL,
    LOCK_EXP_TIME_ TIMESTAMP(6),
    LOCK_OWNER_ NVARCHAR2(255),
    EXCLUSIVE_ NUMBER(1,0) CHECK (EXCLUSIVE_ IN (1,0)),
    EXECUTION_ID_ NVARCHAR2(64),
    PROCESS_INSTANCE_ID_ NVARCHAR2(64),
    PROC_DEF_ID_ NVARCHAR2(64),
    RETRIES_ INTEGER,
    EXCEPTION_STACK_ID_ NVARCHAR2(64),
    EXCEPTION_MSG_ NVARCHAR2(2000),
    DUEDATE_ TIMESTAMP(6),
    REPEAT_ NVARCHAR2(255),
    HANDLER_TYPE_ NVARCHAR2(255),
    HANDLER_CFG_ NVARCHAR2(2000),
    TENANT_ID_ NVARCHAR2(255) DEFAULT '',
    primary key (ID_)
);

COMMENT ON TABLE ACT_RU_JOB IS '运行时流程执行实例表';

COMMENT ON COLUMN ACT_RU_JOB.ID_ IS '主键ID';
COMMENT ON COLUMN ACT_RU_JOB.REV_ IS '版本号';
COMMENT ON COLUMN ACT_RU_JOB.TYPE_ IS '类型';
COMMENT ON COLUMN ACT_RU_JOB.LOCK_EXP_TIME_ IS '锁定释放时间';
COMMENT ON COLUMN ACT_RU_JOB.LOCK_OWNER_ IS '挂起者';
COMMENT ON COLUMN ACT_RU_JOB.EXCLUSIVE_ IS '是否独占执行，1表示是，0表示否';
COMMENT ON COLUMN ACT_RU_JOB.EXECUTION_ID_ IS '执行流ID，关联act_ru_execution表';
COMMENT ON COLUMN ACT_RU_JOB.PROCESS_INSTANCE_ID_ IS '流程实例ID，关联act_ru_execution表';
COMMENT ON COLUMN ACT_RU_JOB.PROC_DEF_ID_ IS '对应流程定义数据的ID';
COMMENT ON COLUMN ACT_RU_JOB.RETRIES_ IS '剩余重试次数';
COMMENT ON COLUMN ACT_RU_JOB.EXCEPTION_STACK_ID_ IS '异常信息ID';
COMMENT ON COLUMN ACT_RU_JOB.EXCEPTION_MSG_ IS '异常信息';
COMMENT ON COLUMN ACT_RU_JOB.DUEDATE_ IS '到期时间';
COMMENT ON COLUMN ACT_RU_JOB.REPEAT_ IS '重复';
COMMENT ON COLUMN ACT_RU_JOB.HANDLER_TYPE_ IS '处理类型';
COMMENT ON COLUMN ACT_RU_JOB.HANDLER_CFG_ IS '处理标识';
COMMENT ON COLUMN ACT_RU_JOB.TENANT_ID_ IS '多租户ID';

--运行时定时器表
create table ACT_RU_TIMER_JOB (
    ID_ NVARCHAR2(64) NOT NULL,
    REV_ INTEGER,
    TYPE_ NVARCHAR2(255) NOT NULL,
    LOCK_EXP_TIME_ TIMESTAMP(6),
    LOCK_OWNER_ NVARCHAR2(255),
    EXCLUSIVE_ NUMBER(1,0) CHECK (EXCLUSIVE_ IN (1,0)),
    EXECUTION_ID_ NVARCHAR2(64),
    PROCESS_INSTANCE_ID_ NVARCHAR2(64),
    PROC_DEF_ID_ NVARCHAR2(64),
    RETRIES_ INTEGER,
    EXCEPTION_STACK_ID_ NVARCHAR2(64),
    EXCEPTION_MSG_ NVARCHAR2(2000),
    DUEDATE_ TIMESTAMP(6),
    REPEAT_ NVARCHAR2(255),
    HANDLER_TYPE_ NVARCHAR2(255),
    HANDLER_CFG_ NVARCHAR2(2000),
    TENANT_ID_ NVARCHAR2(255) DEFAULT '',
    primary key (ID_)
);

COMMENT ON TABLE ACT_RU_TIMER_JOB IS '运行时定时器表';

COMMENT ON COLUMN ACT_RU_TIMER_JOB.ID_ IS '主键ID';
COMMENT ON COLUMN ACT_RU_TIMER_JOB.REV_ IS '版本号';
COMMENT ON COLUMN ACT_RU_TIMER_JOB.TYPE_ IS '作业类型';
COMMENT ON COLUMN ACT_RU_TIMER_JOB.LOCK_EXP_TIME_ IS '锁定过期时间';
COMMENT ON COLUMN ACT_RU_TIMER_JOB.LOCK_OWNER_ IS '锁定所有者';
COMMENT ON COLUMN ACT_RU_TIMER_JOB.EXCLUSIVE_ IS '是否独占执行(1表示是，0表示否)';
COMMENT ON COLUMN ACT_RU_TIMER_JOB.EXECUTION_ID_ IS '执行实例ID';
COMMENT ON COLUMN ACT_RU_TIMER_JOB.PROCESS_INSTANCE_ID_ IS '流程实例ID';
COMMENT ON COLUMN ACT_RU_TIMER_JOB.PROC_DEF_ID_ IS '流程定义ID';
COMMENT ON COLUMN ACT_RU_TIMER_JOB.RETRIES_ IS '剩余重试次数';
COMMENT ON COLUMN ACT_RU_TIMER_JOB.EXCEPTION_STACK_ID_ IS '异常堆栈ID';
COMMENT ON COLUMN ACT_RU_TIMER_JOB.EXCEPTION_MSG_ IS '异常消息';
COMMENT ON COLUMN ACT_RU_TIMER_JOB.DUEDATE_ IS '作业到期时间';
COMMENT ON COLUMN ACT_RU_TIMER_JOB.REPEAT_ IS '重复执行配置';
COMMENT ON COLUMN ACT_RU_TIMER_JOB.HANDLER_TYPE_ IS '处理器类型';
COMMENT ON COLUMN ACT_RU_TIMER_JOB.HANDLER_CFG_ IS '处理器配置';
COMMENT ON COLUMN ACT_RU_TIMER_JOB.TENANT_ID_ IS '多租户ID';

--运行时作业暂停表
create table ACT_RU_SUSPENDED_JOB (
    ID_ NVARCHAR2(64) NOT NULL,
    REV_ INTEGER,
    TYPE_ NVARCHAR2(255) NOT NULL,
    EXCLUSIVE_ NUMBER(1,0) CHECK (EXCLUSIVE_ IN (1,0)),
    EXECUTION_ID_ NVARCHAR2(64),
    PROCESS_INSTANCE_ID_ NVARCHAR2(64),
    PROC_DEF_ID_ NVARCHAR2(64),
    RETRIES_ INTEGER,
    EXCEPTION_STACK_ID_ NVARCHAR2(64),
    EXCEPTION_MSG_ NVARCHAR2(2000),
    DUEDATE_ TIMESTAMP(6),
    REPEAT_ NVARCHAR2(255),
    HANDLER_TYPE_ NVARCHAR2(255),
    HANDLER_CFG_ NVARCHAR2(2000),
    TENANT_ID_ NVARCHAR2(255) DEFAULT '',
    primary key (ID_)
);

COMMENT ON TABLE ACT_RU_SUSPENDED_JOB IS '运行时作业暂停表';

COMMENT ON COLUMN ACT_RU_SUSPENDED_JOB.ID_ IS '主键ID';
COMMENT ON COLUMN ACT_RU_SUSPENDED_JOB.REV_ IS '版本号';
COMMENT ON COLUMN ACT_RU_SUSPENDED_JOB.TYPE_ IS '作业类型';
COMMENT ON COLUMN ACT_RU_SUSPENDED_JOB.EXCLUSIVE_ IS '是否独占执行(1表示是，0表示否)';
COMMENT ON COLUMN ACT_RU_SUSPENDED_JOB.EXECUTION_ID_ IS '执行实例ID';
COMMENT ON COLUMN ACT_RU_SUSPENDED_JOB.PROCESS_INSTANCE_ID_ IS '流程实例ID';
COMMENT ON COLUMN ACT_RU_SUSPENDED_JOB.PROC_DEF_ID_ IS '流程定义ID';
COMMENT ON COLUMN ACT_RU_SUSPENDED_JOB.RETRIES_ IS '剩余重试次数';
COMMENT ON COLUMN ACT_RU_SUSPENDED_JOB.EXCEPTION_STACK_ID_ IS '异常堆栈ID';
COMMENT ON COLUMN ACT_RU_SUSPENDED_JOB.EXCEPTION_MSG_ IS '异常消息';
COMMENT ON COLUMN ACT_RU_SUSPENDED_JOB.DUEDATE_ IS '作业到期时间';
COMMENT ON COLUMN ACT_RU_SUSPENDED_JOB.REPEAT_ IS '重复执行配置';
COMMENT ON COLUMN ACT_RU_SUSPENDED_JOB.HANDLER_TYPE_ IS '处理器类型';
COMMENT ON COLUMN ACT_RU_SUSPENDED_JOB.HANDLER_CFG_ IS '处理器配置';
COMMENT ON COLUMN ACT_RU_SUSPENDED_JOB.TENANT_ID_ IS '多租户ID';

--运行时作业失败表
create table ACT_RU_DEADLETTER_JOB (
    ID_ NVARCHAR2(64) NOT NULL,
    REV_ INTEGER,
    TYPE_ NVARCHAR2(255) NOT NULL,
    EXCLUSIVE_ NUMBER(1,0) CHECK (EXCLUSIVE_ IN (1,0)),
    EXECUTION_ID_ NVARCHAR2(64),
    PROCESS_INSTANCE_ID_ NVARCHAR2(64),
    PROC_DEF_ID_ NVARCHAR2(64),
    EXCEPTION_STACK_ID_ NVARCHAR2(64),
    EXCEPTION_MSG_ NVARCHAR2(2000),
    DUEDATE_ TIMESTAMP(6),
    REPEAT_ NVARCHAR2(255),
    HANDLER_TYPE_ NVARCHAR2(255),
    HANDLER_CFG_ NVARCHAR2(2000),
    TENANT_ID_ NVARCHAR2(255) DEFAULT '',
    primary key (ID_)
);
COMMENT ON TABLE ACT_RU_DEADLETTER_JOB IS '运行时作业失败表';

COMMENT ON COLUMN ACT_RU_DEADLETTER_JOB.ID_ IS '主键ID';
COMMENT ON COLUMN ACT_RU_DEADLETTER_JOB.REV_ IS '版本号';
COMMENT ON COLUMN ACT_RU_DEADLETTER_JOB.TYPE_ IS '作业类型';
COMMENT ON COLUMN ACT_RU_DEADLETTER_JOB.EXCLUSIVE_ IS '是否独占执行(1表示是，0表示否)';
COMMENT ON COLUMN ACT_RU_DEADLETTER_JOB.EXECUTION_ID_ IS '执行实例ID';
COMMENT ON COLUMN ACT_RU_DEADLETTER_JOB.PROCESS_INSTANCE_ID_ IS '流程实例ID';
COMMENT ON COLUMN ACT_RU_DEADLETTER_JOB.PROC_DEF_ID_ IS '流程定义ID';
COMMENT ON COLUMN ACT_RU_DEADLETTER_JOB.EXCEPTION_STACK_ID_ IS '异常堆栈ID';
COMMENT ON COLUMN ACT_RU_DEADLETTER_JOB.EXCEPTION_MSG_ IS '异常消息';
COMMENT ON COLUMN ACT_RU_DEADLETTER_JOB.DUEDATE_ IS '作业到期时间';
COMMENT ON COLUMN ACT_RU_DEADLETTER_JOB.REPEAT_ IS '重复执行配置';
COMMENT ON COLUMN ACT_RU_DEADLETTER_JOB.HANDLER_TYPE_ IS '处理器类型';
COMMENT ON COLUMN ACT_RU_DEADLETTER_JOB.HANDLER_CFG_ IS '处理器配置';
COMMENT ON COLUMN ACT_RU_DEADLETTER_JOB.TENANT_ID_ IS '多租户ID';

--流程定义表
create table ACT_RE_PROCDEF (
    ID_ NVARCHAR2(64) NOT NULL,
    REV_ INTEGER,
    CATEGORY_ NVARCHAR2(255),
    NAME_ NVARCHAR2(255),
    KEY_ NVARCHAR2(255) NOT NULL,
    VERSION_ INTEGER NOT NULL,
    DEPLOYMENT_ID_ NVARCHAR2(64),
    RESOURCE_NAME_ NVARCHAR2(2000),
    DGRM_RESOURCE_NAME_ varchar(4000),
    DESCRIPTION_ NVARCHAR2(2000),
    HAS_START_FORM_KEY_ NUMBER(1,0) CHECK (HAS_START_FORM_KEY_ IN (1,0)),
    HAS_GRAPHICAL_NOTATION_ NUMBER(1,0) CHECK (HAS_GRAPHICAL_NOTATION_ IN (1,0)),
    SUSPENSION_STATE_ INTEGER,
    TENANT_ID_ NVARCHAR2(255) DEFAULT '',
    ENGINE_VERSION_ NVARCHAR2(255),
    APP_VERSION_ INTEGER,
    primary key (ID_)
);
COMMENT ON TABLE ACT_RE_PROCDEF IS '流程定义表';

COMMENT ON COLUMN ACT_RE_PROCDEF.ID_ IS '主键ID';
COMMENT ON COLUMN ACT_RE_PROCDEF.REV_ IS '版本号';
COMMENT ON COLUMN ACT_RE_PROCDEF.CATEGORY_ IS '流程定义的分类，流程XML文件中targetNamespace值';
COMMENT ON COLUMN ACT_RE_PROCDEF.NAME_ IS '流程定义名称，流程XML文件中process元素的name属性';
COMMENT ON COLUMN ACT_RE_PROCDEF.KEY_ IS '流程定义的key，流程XML文件中process元素的id属性';
COMMENT ON COLUMN ACT_RE_PROCDEF.VERSION_ IS '流程版本';
COMMENT ON COLUMN ACT_RE_PROCDEF.DEPLOYMENT_ID_ IS '关联流程部署信息表主键ID';
COMMENT ON COLUMN ACT_RE_PROCDEF.RESOURCE_NAME_ IS '流程定义资源名称';
COMMENT ON COLUMN ACT_RE_PROCDEF.DGRM_RESOURCE_NAME_ IS '流程图片资源名称';
COMMENT ON COLUMN ACT_RE_PROCDEF.DESCRIPTION_ IS '描述信息';
COMMENT ON COLUMN ACT_RE_PROCDEF.HAS_START_FORM_KEY_ IS '是否存在开始表单标志，0-不存在，1-存在';
COMMENT ON COLUMN ACT_RE_PROCDEF.HAS_GRAPHICAL_NOTATION_ IS '是否存在图形信息，0-不存在，1-存在';
COMMENT ON COLUMN ACT_RE_PROCDEF.SUSPENSION_STATE_ IS '挂起状态，1-激活，2-挂起';
COMMENT ON COLUMN ACT_RE_PROCDEF.TENANT_ID_ IS '多租户ID';
COMMENT ON COLUMN ACT_RE_PROCDEF.ENGINE_VERSION_ IS '引擎版本';
COMMENT ON COLUMN ACT_RE_PROCDEF.APP_VERSION_ IS 'APP版本';

--运行时流程任务表
create table ACT_RU_TASK (
    ID_ NVARCHAR2(64),
    REV_ INTEGER,
    EXECUTION_ID_ NVARCHAR2(64),
    PROC_INST_ID_ NVARCHAR2(64),
    PROC_DEF_ID_ NVARCHAR2(64),
    NAME_ NVARCHAR2(255),
    BUSINESS_KEY_ varchar(255),
    PARENT_TASK_ID_ NVARCHAR2(64),
    DESCRIPTION_ NVARCHAR2(2000),
    TASK_DEF_KEY_ NVARCHAR2(255),
    OWNER_ NVARCHAR2(255),
    ASSIGNEE_ NVARCHAR2(255),
    DELEGATION_ NVARCHAR2(64),
    PRIORITY_ INTEGER,
    CREATE_TIME_ TIMESTAMP(6),
    DUE_DATE_ TIMESTAMP(6),
    CATEGORY_ NVARCHAR2(255),
    SUSPENSION_STATE_ INTEGER,
    TENANT_ID_ NVARCHAR2(255) DEFAULT '',
    FORM_KEY_ NVARCHAR2(255),
    CLAIM_TIME_ TIMESTAMP(6),
    APP_VERSION_ INTEGER,
    primary key (ID_)
);
COMMENT ON TABLE ACT_RU_TASK IS '运行时流程任务表';

COMMENT ON COLUMN ACT_RU_TASK.ID_ is '主键ID';
COMMENT ON COLUMN ACT_RU_TASK.REV_ is '版本号';
COMMENT ON COLUMN ACT_RU_TASK.EXECUTION_ID_ is '任务所在的执行流ID，关联流程实例表ID';
COMMENT ON COLUMN ACT_RU_TASK.PROC_INST_ID_ is '对应的流程实例ID，关联流程实例表ID';
COMMENT ON COLUMN ACT_RU_TASK.PROC_DEF_ID_ is '对应流程定义数据的ID';
COMMENT ON COLUMN ACT_RU_TASK.NAME_ is '任务名称，在流程文件中定义';
COMMENT ON COLUMN ACT_RU_TASK.BUSINESS_KEY_ is '业务主键ID';
COMMENT ON COLUMN ACT_RU_TASK.PARENT_TASK_ID_ is '父节点任务ID';
COMMENT ON COLUMN ACT_RU_TASK.DESCRIPTION_ is '节点定义描述信息';
COMMENT ON COLUMN ACT_RU_TASK.TASK_DEF_KEY_ is '任务定义的ID';
COMMENT ON COLUMN ACT_RU_TASK.OWNER_ is '任务拥有者（一般情况下为空，只有在委托时才有值）';
COMMENT ON COLUMN ACT_RU_TASK.ASSIGNEE_ is '签收人或委托人（被指派执行该任务的人）';
COMMENT ON COLUMN ACT_RU_TASK.DELEGATION_ is '委托类型。分为两种：PENDING，RESOLVED，如无委托则为空';
COMMENT ON COLUMN ACT_RU_TASK.PRIORITY_ is '优先级别，默认为：50';
COMMENT ON COLUMN ACT_RU_TASK.CREATE_TIME_ is '创建时间';
COMMENT ON COLUMN ACT_RU_TASK.DUE_DATE_ is '过期时间';
COMMENT ON COLUMN ACT_RU_TASK.CATEGORY_ is '类别';
COMMENT ON COLUMN ACT_RU_TASK.SUSPENSION_STATE_ is '是否挂起。1-激活，2-挂起';
COMMENT ON COLUMN ACT_RU_TASK.TENANT_ID_ is '多租户ID';
COMMENT ON COLUMN ACT_RU_TASK.FORM_KEY_ is '表单Key';
COMMENT ON COLUMN ACT_RU_TASK.CLAIM_TIME_ is '提醒时间';
COMMENT ON COLUMN ACT_RU_TASK.APP_VERSION_ is 'APP版本';

--运行时流程与身份关系表
create table ACT_RU_IDENTITYLINK (
    ID_ NVARCHAR2(64),
    REV_ INTEGER,
    GROUP_ID_ NVARCHAR2(255),
    TYPE_ NVARCHAR2(255),
    USER_ID_ NVARCHAR2(255),
    TASK_ID_ NVARCHAR2(64),
    PROC_INST_ID_ NVARCHAR2(64),
    PROC_DEF_ID_ NVARCHAR2(64),
    primary key (ID_)
);
COMMENT ON TABLE ACT_RU_IDENTITYLINK IS '运行时流程与身份关系表';

COMMENT ON COLUMN ACT_RU_IDENTITYLINK.ID_ is '主键ID';
COMMENT ON COLUMN ACT_RU_IDENTITYLINK.REV_ is '版本号';
COMMENT ON COLUMN ACT_RU_IDENTITYLINK.GROUP_ID_ is '用户组主键ID';
COMMENT ON COLUMN ACT_RU_IDENTITYLINK.TYPE_ is '类型，assignee、candidate、owner、starter、participant';
COMMENT ON COLUMN ACT_RU_IDENTITYLINK.USER_ID_ is '关联用户ID';
COMMENT ON COLUMN ACT_RU_IDENTITYLINK.TASK_ID_ is '关联流程任务表ID';
COMMENT ON COLUMN ACT_RU_IDENTITYLINK.PROC_INST_ID_ is '关联流程实例ID';
COMMENT ON COLUMN ACT_RU_IDENTITYLINK.PROC_DEF_ID_ is '关联流程定义ID';

--运行时流程参数表
create table ACT_RU_VARIABLE (
    ID_ NVARCHAR2(64) not null,
    REV_ INTEGER,
    TYPE_ NVARCHAR2(255) not null,
    NAME_ NVARCHAR2(255) not null,
    EXECUTION_ID_ NVARCHAR2(64),
    PROC_INST_ID_ NVARCHAR2(64),
    TASK_ID_ NVARCHAR2(64),
    BYTEARRAY_ID_ NVARCHAR2(64),
    DOUBLE_ NUMBER(*,10),
    LONG_ NUMBER(19,0),
    TEXT_ NVARCHAR2(2000),
    TEXT2_ NVARCHAR2(2000),
    primary key (ID_)
);
COMMENT ON TABLE ACT_RU_VARIABLE IS '运行时流程参数表';

COMMENT ON COLUMN ACT_RU_VARIABLE.ID_ is '主键ID';
COMMENT ON COLUMN ACT_RU_VARIABLE.REV_ is '版本号';
COMMENT ON COLUMN ACT_RU_VARIABLE.TYPE_ is '参数类型，例如：boolean、bytes、serializable、date、double、integer、jpa-entity、long、null、short、string。还可以扩展自定义参数类型';
COMMENT ON COLUMN ACT_RU_VARIABLE.NAME_ is '参数名称';
COMMENT ON COLUMN ACT_RU_VARIABLE.EXECUTION_ID_ is '该参数对应的执行ID';
COMMENT ON COLUMN ACT_RU_VARIABLE.PROC_INST_ID_ is '该参数对应的流程实例ID';
COMMENT ON COLUMN ACT_RU_VARIABLE.TASK_ID_ is '该参数对应的任务ID';
COMMENT ON COLUMN ACT_RU_VARIABLE.BYTEARRAY_ID_ is '如果参数值是序列化对象，会将该对象作为资源保存到通用资源表中，并将主键值保存到该字段中';
COMMENT ON COLUMN ACT_RU_VARIABLE.DOUBLE_ is '参数类型为double类型时，值保存到该字段中';
COMMENT ON COLUMN ACT_RU_VARIABLE.LONG_ is '参数类型为long类型时，值保存到该字段中';
COMMENT ON COLUMN ACT_RU_VARIABLE.TEXT_ is '保存文本类型的参数值（存储持久化对象时，值为JPA对象的class）';
COMMENT ON COLUMN ACT_RU_VARIABLE.TEXT2_ is '保存文本类型的参数值（JPA持久化对象时，此字段才有值，值为对象ID）';

--运行时事件监听表
create table ACT_RU_EVENT_SUBSCR (
    ID_ NVARCHAR2(64) not null,
    REV_ integer,
    EVENT_TYPE_ NVARCHAR2(255) not null,
    EVENT_NAME_ NVARCHAR2(255),
    EXECUTION_ID_ NVARCHAR2(64),
    PROC_INST_ID_ NVARCHAR2(64),
    ACTIVITY_ID_ NVARCHAR2(64),
    CONFIGURATION_ NVARCHAR2(255),
    CREATED_ TIMESTAMP(6) not null,
    PROC_DEF_ID_ NVARCHAR2(64),
    TENANT_ID_ NVARCHAR2(255) DEFAULT '',
    primary key (ID_)
);
COMMENT ON TABLE ACT_RU_EVENT_SUBSCR IS '运行时事件监听表';

COMMENT ON COLUMN ACT_RU_EVENT_SUBSCR.ID_ is '主键ID';
COMMENT ON COLUMN ACT_RU_EVENT_SUBSCR.REV_ is '版本号';
COMMENT ON COLUMN ACT_RU_EVENT_SUBSCR.EVENT_TYPE_ is '事件类型';
COMMENT ON COLUMN ACT_RU_EVENT_SUBSCR.EVENT_NAME_ is '事件名称';
COMMENT ON COLUMN ACT_RU_EVENT_SUBSCR.EXECUTION_ID_ is '执行流ID，关联act_ru_execution表';
COMMENT ON COLUMN ACT_RU_EVENT_SUBSCR.PROC_INST_ID_ is '流程实例ID，关联act_ru_execution表';
COMMENT ON COLUMN ACT_RU_EVENT_SUBSCR.ACTIVITY_ID_ is '活动实例ID';
COMMENT ON COLUMN ACT_RU_EVENT_SUBSCR.CONFIGURATION_ is '配置，流程XML中的Namespace';
COMMENT ON COLUMN ACT_RU_EVENT_SUBSCR.CREATED_ is '创建时间，默认系统时间戳';
COMMENT ON COLUMN ACT_RU_EVENT_SUBSCR.PROC_DEF_ID_ is '对应流程定义数据的ID';
COMMENT ON COLUMN ACT_RU_EVENT_SUBSCR.TENANT_ID_ is '多租户ID';

--事件日志表
create table ACT_EVT_LOG (
    LOG_NR_ NUMBER(19),
    TYPE_ NVARCHAR2(64),
    PROC_DEF_ID_ NVARCHAR2(64),
    PROC_INST_ID_ NVARCHAR2(64),
    EXECUTION_ID_ NVARCHAR2(64),
    TASK_ID_ NVARCHAR2(64),
    TIME_STAMP_ TIMESTAMP(6) not null,
    USER_ID_ NVARCHAR2(255),
    DATA_ BLOB,
    LOCK_OWNER_ NVARCHAR2(255),
    LOCK_TIME_ TIMESTAMP(6) null,
    IS_PROCESSED_ NUMBER(3) default 0,
    primary key (LOG_NR_)
);
COMMENT ON TABLE ACT_EVT_LOG IS '事件日志表';

COMMENT ON COLUMN ACT_EVT_LOG.LOG_NR_ is '主键ID';
COMMENT ON COLUMN ACT_EVT_LOG.TYPE_ is '日志类型';
COMMENT ON COLUMN ACT_EVT_LOG.PROC_DEF_ID_ is '流程定义ID';
COMMENT ON COLUMN ACT_EVT_LOG.PROC_INST_ID_ is '流程实例ID';
COMMENT ON COLUMN ACT_EVT_LOG.EXECUTION_ID_ is '执行实例ID';
COMMENT ON COLUMN ACT_EVT_LOG.TASK_ID_ is '任务ID';
COMMENT ON COLUMN ACT_EVT_LOG.TIME_STAMP_ is '发生时间戳';
COMMENT ON COLUMN ACT_EVT_LOG.USER_ID_ is '用户ID';
COMMENT ON COLUMN ACT_EVT_LOG.DATA_ is '事件数据';
COMMENT ON COLUMN ACT_EVT_LOG.LOCK_OWNER_ is '锁定拥有者的ID';
COMMENT ON COLUMN ACT_EVT_LOG.LOCK_TIME_ is '锁定时间';
COMMENT ON COLUMN ACT_EVT_LOG.IS_PROCESSED_ is '事件是否已被处理';

create sequence act_evt_log_seq;

--流程定义的动态变更信息表
create table ACT_PROCDEF_INFO (
    ID_ NVARCHAR2(64) not null,
    PROC_DEF_ID_ NVARCHAR2(64) not null,
    REV_ integer,
    INFO_JSON_ID_ NVARCHAR2(64),
    primary key (ID_)
);
COMMENT ON TABLE ACT_PROCDEF_INFO IS '流程定义的动态变更信息表';

COMMENT ON COLUMN ACT_PROCDEF_INFO.ID_ is '主键ID';
COMMENT ON COLUMN ACT_PROCDEF_INFO.PROC_DEF_ID_ is '流程定义ID';
COMMENT ON COLUMN ACT_PROCDEF_INFO.REV_ is '版本号';
COMMENT ON COLUMN ACT_PROCDEF_INFO.INFO_JSON_ID_ is 'json数据ID';

--运行时综合表
create table ACT_RU_INTEGRATION (
    ID_ NVARCHAR2(64) not null,
    EXECUTION_ID_ NVARCHAR2(64),
    PROCESS_INSTANCE_ID_ NVARCHAR2(64),
    PROC_DEF_ID_ NVARCHAR2(64),
    FLOW_NODE_ID_ NVARCHAR2(64),
    CREATED_DATE_ TIMESTAMP(6),
    primary key (ID_)
);
COMMENT ON TABLE ACT_RU_INTEGRATION IS '运行时综合表';

COMMENT ON COLUMN ACT_RU_INTEGRATION.ID_ is '主键ID';
COMMENT ON COLUMN ACT_RU_INTEGRATION.EXECUTION_ID_ is '执行实例ID';
COMMENT ON COLUMN ACT_RU_INTEGRATION.PROCESS_INSTANCE_ID_ is '流程实例ID';
COMMENT ON COLUMN ACT_RU_INTEGRATION.PROC_DEF_ID_ is '流程定义ID';
COMMENT ON COLUMN ACT_RU_INTEGRATION.FLOW_NODE_ID_ is '流程节点ID';
COMMENT ON COLUMN ACT_RU_INTEGRATION.CREATED_DATE_ is '创建时间';

create index ACT_IDX_EXEC_BUSKEY on ACT_RU_EXECUTION(BUSINESS_KEY_);
create index ACT_IDX_EXEC_ROOT on ACT_RU_EXECUTION(ROOT_PROC_INST_ID_);
create index ACT_IDX_TASK_CREATE on ACT_RU_TASK(CREATE_TIME_);
create index ACT_IDX_IDENT_LNK_USER on ACT_RU_IDENTITYLINK(USER_ID_);
create index ACT_IDX_IDENT_LNK_GROUP on ACT_RU_IDENTITYLINK(GROUP_ID_);
create index ACT_IDX_EVENT_SUBSCR_CONFIG_ on ACT_RU_EVENT_SUBSCR(CONFIGURATION_);
create index ACT_IDX_VARIABLE_TASK_ID on ACT_RU_VARIABLE(TASK_ID_);

create index ACT_IDX_BYTEAR_DEPL on ACT_GE_BYTEARRAY(DEPLOYMENT_ID_);
alter table ACT_GE_BYTEARRAY
    add constraint ACT_FK_BYTEARR_DEPL
    foreign key (DEPLOYMENT_ID_)
    references ACT_RE_DEPLOYMENT (ID_);

alter table ACT_RE_PROCDEF
    add constraint ACT_UNIQ_PROCDEF
    unique (KEY_,VERSION_, TENANT_ID_);

create index ACT_IDX_EXE_PROCINST on ACT_RU_EXECUTION(PROC_INST_ID_);
alter table ACT_RU_EXECUTION
    add constraint ACT_FK_EXE_PROCINST
    foreign key (PROC_INST_ID_)
    references ACT_RU_EXECUTION (ID_);

create index ACT_IDX_EXE_PARENT on ACT_RU_EXECUTION(PARENT_ID_);
alter table ACT_RU_EXECUTION
    add constraint ACT_FK_EXE_PARENT
    foreign key (PARENT_ID_)
    references ACT_RU_EXECUTION (ID_);

create index ACT_IDX_EXE_SUPER on ACT_RU_EXECUTION(SUPER_EXEC_);
alter table ACT_RU_EXECUTION
    add constraint ACT_FK_EXE_SUPER
    foreign key (SUPER_EXEC_)
    references ACT_RU_EXECUTION (ID_);

create index ACT_IDX_EXE_PROCDEF on ACT_RU_EXECUTION(PROC_DEF_ID_);
alter table ACT_RU_EXECUTION
    add constraint ACT_FK_EXE_PROCDEF
    foreign key (PROC_DEF_ID_)
    references ACT_RE_PROCDEF (ID_);

create index ACT_IDX_TSKASS_TASK on ACT_RU_IDENTITYLINK(TASK_ID_);
alter table ACT_RU_IDENTITYLINK
    add constraint ACT_FK_TSKASS_TASK
    foreign key (TASK_ID_)
    references ACT_RU_TASK (ID_);

create index ACT_IDX_ATHRZ_PROCEDEF  on ACT_RU_IDENTITYLINK(PROC_DEF_ID_);
alter table ACT_RU_IDENTITYLINK
    add constraint ACT_FK_ATHRZ_PROCEDEF
    foreign key (PROC_DEF_ID_)
    references ACT_RE_PROCDEF (ID_);

create index ACT_IDX_IDL_PROCINST on ACT_RU_IDENTITYLINK(PROC_INST_ID_);
alter table ACT_RU_IDENTITYLINK
    add constraint ACT_FK_IDL_PROCINST
    foreign key (PROC_INST_ID_)
    references ACT_RU_EXECUTION (ID_);

create index ACT_IDX_TASK_EXEC on ACT_RU_TASK(EXECUTION_ID_);
alter table ACT_RU_TASK
    add constraint ACT_FK_TASK_EXE
    foreign key (EXECUTION_ID_)
    references ACT_RU_EXECUTION (ID_);

create index ACT_IDX_TASK_PROCINST on ACT_RU_TASK(PROC_INST_ID_);
alter table ACT_RU_TASK
    add constraint ACT_FK_TASK_PROCINST
    foreign key (PROC_INST_ID_)
    references ACT_RU_EXECUTION (ID_);

create index ACT_IDX_TASK_PROCDEF on ACT_RU_TASK(PROC_DEF_ID_);
alter table ACT_RU_TASK
  add constraint ACT_FK_TASK_PROCDEF
  foreign key (PROC_DEF_ID_)
  references ACT_RE_PROCDEF (ID_);

create index ACT_IDX_VAR_EXE on ACT_RU_VARIABLE(EXECUTION_ID_);
alter table ACT_RU_VARIABLE
    add constraint ACT_FK_VAR_EXE
    foreign key (EXECUTION_ID_)
    references ACT_RU_EXECUTION (ID_);

create index ACT_IDX_VAR_PROCINST on ACT_RU_VARIABLE(PROC_INST_ID_);
alter table ACT_RU_VARIABLE
    add constraint ACT_FK_VAR_PROCINST
    foreign key (PROC_INST_ID_)
    references ACT_RU_EXECUTION(ID_);

create index ACT_IDX_VAR_BYTEARRAY on ACT_RU_VARIABLE(BYTEARRAY_ID_);
alter table ACT_RU_VARIABLE
    add constraint ACT_FK_VAR_BYTEARRAY
    foreign key (BYTEARRAY_ID_)
    references ACT_GE_BYTEARRAY (ID_);

create index ACT_IDX_JOB_EXECUTION_ID on ACT_RU_JOB(EXECUTION_ID_);
alter table ACT_RU_JOB
    add constraint ACT_FK_JOB_EXECUTION
    foreign key (EXECUTION_ID_)
    references ACT_RU_EXECUTION (ID_);

create index ACT_IDX_JOB_PROC_INST_ID on ACT_RU_JOB(PROCESS_INSTANCE_ID_);
alter table ACT_RU_JOB
    add constraint ACT_FK_JOB_PROCESS_INSTANCE
    foreign key (PROCESS_INSTANCE_ID_)
    references ACT_RU_EXECUTION (ID_);

create index ACT_IDX_JOB_PROC_DEF_ID on ACT_RU_JOB(PROC_DEF_ID_);
alter table ACT_RU_JOB
    add constraint ACT_FK_JOB_PROC_DEF
    foreign key (PROC_DEF_ID_)
    references ACT_RE_PROCDEF (ID_);

create index ACT_IDX_JOB_EXCEPTION on ACT_RU_JOB(EXCEPTION_STACK_ID_);
alter table ACT_RU_JOB
    add constraint ACT_FK_JOB_EXCEPTION
    foreign key (EXCEPTION_STACK_ID_)
    references ACT_GE_BYTEARRAY (ID_);

create index ACT_IDX_TJOB_EXECUTION_ID on ACT_RU_TIMER_JOB(EXECUTION_ID_);
alter table ACT_RU_TIMER_JOB
    add constraint ACT_FK_TJOB_EXECUTION
    foreign key (EXECUTION_ID_)
    references ACT_RU_EXECUTION (ID_);

create index ACT_IDX_TJOB_PROC_INST_ID on ACT_RU_TIMER_JOB(PROCESS_INSTANCE_ID_);
alter table ACT_RU_TIMER_JOB
    add constraint ACT_FK_TJOB_PROCESS_INSTANCE
    foreign key (PROCESS_INSTANCE_ID_)
    references ACT_RU_EXECUTION (ID_);

create index ACT_IDX_TJOB_PROC_DEF_ID on ACT_RU_TIMER_JOB(PROC_DEF_ID_);
alter table ACT_RU_TIMER_JOB
    add constraint ACT_FK_TJOB_PROC_DEF
    foreign key (PROC_DEF_ID_)
    references ACT_RE_PROCDEF (ID_);

create index ACT_IDX_TJOB_EXCEPTION on ACT_RU_TIMER_JOB(EXCEPTION_STACK_ID_);
alter table ACT_RU_TIMER_JOB
    add constraint ACT_FK_TJOB_EXCEPTION
    foreign key (EXCEPTION_STACK_ID_)
    references ACT_GE_BYTEARRAY (ID_);

create index ACT_IDX_SJOB_EXECUTION_ID on ACT_RU_SUSPENDED_JOB(EXECUTION_ID_);
alter table ACT_RU_SUSPENDED_JOB
    add constraint ACT_FK_SJOB_EXECUTION
    foreign key (EXECUTION_ID_)
    references ACT_RU_EXECUTION (ID_);

create index ACT_IDX_SJOB_PROC_INST_ID on ACT_RU_SUSPENDED_JOB(PROCESS_INSTANCE_ID_);
alter table ACT_RU_SUSPENDED_JOB
    add constraint ACT_FK_SJOB_PROCESS_INSTANCE
    foreign key (PROCESS_INSTANCE_ID_)
    references ACT_RU_EXECUTION (ID_);

create index ACT_IDX_SJOB_PROC_DEF_ID on ACT_RU_SUSPENDED_JOB(PROC_DEF_ID_);
alter table ACT_RU_SUSPENDED_JOB
    add constraint ACT_FK_SJOB_PROC_DEF
    foreign key (PROC_DEF_ID_)
    references ACT_RE_PROCDEF (ID_);

create index ACT_IDX_SJOB_EXCEPTION on ACT_RU_SUSPENDED_JOB(EXCEPTION_STACK_ID_);
alter table ACT_RU_SUSPENDED_JOB
    add constraint ACT_FK_SJOB_EXCEPTION
    foreign key (EXCEPTION_STACK_ID_)
    references ACT_GE_BYTEARRAY (ID_);

create index ACT_IDX_DJOB_EXECUTION_ID on ACT_RU_DEADLETTER_JOB(EXECUTION_ID_);
alter table ACT_RU_DEADLETTER_JOB
    add constraint ACT_FK_DJOB_EXECUTION
    foreign key (EXECUTION_ID_)
    references ACT_RU_EXECUTION (ID_);

create index ACT_IDX_DJOB_PROC_INST_ID on ACT_RU_DEADLETTER_JOB(PROCESS_INSTANCE_ID_);
alter table ACT_RU_DEADLETTER_JOB
    add constraint ACT_FK_DJOB_PROCESS_INSTANCE
    foreign key (PROCESS_INSTANCE_ID_)
    references ACT_RU_EXECUTION (ID_);

create index ACT_IDX_DJOB_PROC_DEF_ID on ACT_RU_DEADLETTER_JOB(PROC_DEF_ID_);
alter table ACT_RU_DEADLETTER_JOB
    add constraint ACT_FK_DJOB_PROC_DEF
    foreign key (PROC_DEF_ID_)
    references ACT_RE_PROCDEF (ID_);

create index ACT_IDX_DJOB_EXCEPTION on ACT_RU_DEADLETTER_JOB(EXCEPTION_STACK_ID_);
alter table ACT_RU_DEADLETTER_JOB
    add constraint ACT_FK_DJOB_EXCEPTION
    foreign key (EXCEPTION_STACK_ID_)
    references ACT_GE_BYTEARRAY (ID_);

create index ACT_IDX_EVENT_SUBSCR on ACT_RU_EVENT_SUBSCR(EXECUTION_ID_);
alter table ACT_RU_EVENT_SUBSCR
    add constraint ACT_FK_EVENT_EXEC
    foreign key (EXECUTION_ID_)
    references ACT_RU_EXECUTION(ID_);

create index ACT_IDX_MODEL_SOURCE on ACT_RE_MODEL(EDITOR_SOURCE_VALUE_ID_);
alter table ACT_RE_MODEL
    add constraint ACT_FK_MODEL_SOURCE
    foreign key (EDITOR_SOURCE_VALUE_ID_)
    references ACT_GE_BYTEARRAY (ID_);

create index ACT_IDX_MODEL_SOURCE_EXTRA on ACT_RE_MODEL(EDITOR_SOURCE_EXTRA_VALUE_ID_);
alter table ACT_RE_MODEL
    add constraint ACT_FK_MODEL_SOURCE_EXTRA
    foreign key (EDITOR_SOURCE_EXTRA_VALUE_ID_)
    references ACT_GE_BYTEARRAY (ID_);

create index ACT_IDX_MODEL_DEPLOYMENT on ACT_RE_MODEL(DEPLOYMENT_ID_);
alter table ACT_RE_MODEL
    add constraint ACT_FK_MODEL_DEPLOYMENT
    foreign key (DEPLOYMENT_ID_)
    references ACT_RE_DEPLOYMENT (ID_);

create index ACT_IDX_PROCDEF_INFO_JSON on ACT_PROCDEF_INFO(INFO_JSON_ID_);
alter table ACT_PROCDEF_INFO
    add constraint ACT_FK_INFO_JSON_BA
    foreign key (INFO_JSON_ID_)
    references ACT_GE_BYTEARRAY (ID_);

create index ACT_IDX_PROCDEF_INFO_PROC on ACT_PROCDEF_INFO(PROC_DEF_ID_);
alter table ACT_PROCDEF_INFO
    add constraint ACT_FK_INFO_PROCDEF
    foreign key (PROC_DEF_ID_)
    references ACT_RE_PROCDEF (ID_);

alter table ACT_PROCDEF_INFO
    add constraint ACT_UNIQ_INFO_PROCDEF
    unique (PROC_DEF_ID_);

alter table ACT_RU_INTEGRATION
    add constraint ACT_FK_INT_EXECUTION
    foreign key (EXECUTION_ID_)
    references ACT_RU_EXECUTION (ID_)
    on delete cascade;

alter table ACT_RU_INTEGRATION
    add constraint ACT_FK_INT_PROC_INST
    foreign key (PROCESS_INSTANCE_ID_)
    references ACT_RU_EXECUTION (ID_);

alter table ACT_RU_INTEGRATION
    add constraint ACT_FK_INT_PROC_DEF
    foreign key (PROC_DEF_ID_)
    references ACT_RE_PROCDEF (ID_);

--历史流程实例表
create table ACT_HI_PROCINST (
    ID_ NVARCHAR2(64) not null,
    PROC_INST_ID_ NVARCHAR2(64) not null,
    BUSINESS_KEY_ NVARCHAR2(255),
    PROC_DEF_ID_ NVARCHAR2(64) not null,
    START_TIME_ TIMESTAMP(6) not null,
    END_TIME_ TIMESTAMP(6),
    DURATION_ NUMBER(19,0),
    START_USER_ID_ NVARCHAR2(255),
    START_ACT_ID_ NVARCHAR2(255),
    END_ACT_ID_ NVARCHAR2(255),
    SUPER_PROCESS_INSTANCE_ID_ NVARCHAR2(64),
    DELETE_REASON_ NVARCHAR2(2000),
    TENANT_ID_ NVARCHAR2(255) default '',
    NAME_ NVARCHAR2(255),
    primary key (ID_),
    unique (PROC_INST_ID_)
);
COMMENT ON TABLE ACT_HI_PROCINST IS '历史流程实例表';

COMMENT ON COLUMN ACT_HI_PROCINST.ID_ is '主键ID';
COMMENT ON COLUMN ACT_HI_PROCINST.PROC_INST_ID_ is '流程实例ID';
COMMENT ON COLUMN ACT_HI_PROCINST.BUSINESS_KEY_ is '业务主键ID';
COMMENT ON COLUMN ACT_HI_PROCINST.PROC_DEF_ID_ is '流程定义ID';
COMMENT ON COLUMN ACT_HI_PROCINST.START_TIME_ is '开始时间';
COMMENT ON COLUMN ACT_HI_PROCINST.END_TIME_ is '结束时间';
COMMENT ON COLUMN ACT_HI_PROCINST.DURATION_ is '耗时';
COMMENT ON COLUMN ACT_HI_PROCINST.START_USER_ID_ is '起草人';
COMMENT ON COLUMN ACT_HI_PROCINST.START_ACT_ID_ is '开始环节ID，一般是流程开始事件的ID';
COMMENT ON COLUMN ACT_HI_PROCINST.END_ACT_ID_ is '结束环节ID，一般是流程结束事件的ID';
COMMENT ON COLUMN ACT_HI_PROCINST.SUPER_PROCESS_INSTANCE_ID_ is '父流程实例ID';
COMMENT ON COLUMN ACT_HI_PROCINST.DELETE_REASON_ is '流程实例被删除原因';
COMMENT ON COLUMN ACT_HI_PROCINST.TENANT_ID_ is '多租户ID';
COMMENT ON COLUMN ACT_HI_PROCINST.NAME_ is '名称';

--历史行为节点表
create table ACT_HI_ACTINST (
    ID_ NVARCHAR2(64) not null,
    PROC_DEF_ID_ NVARCHAR2(64) not null,
    PROC_INST_ID_ NVARCHAR2(64) not null,
    EXECUTION_ID_ NVARCHAR2(64) not null,
    ACT_ID_ NVARCHAR2(255) not null,
    TASK_ID_ NVARCHAR2(64),
    CALL_PROC_INST_ID_ NVARCHAR2(64),
    ACT_NAME_ NVARCHAR2(255),
    ACT_TYPE_ NVARCHAR2(255) not null,
    ASSIGNEE_ NVARCHAR2(255),
    START_TIME_ TIMESTAMP(6) not null,
    END_TIME_ TIMESTAMP(6),
    DURATION_ NUMBER(19,0),
    DELETE_REASON_ NVARCHAR2(2000),
    TENANT_ID_ NVARCHAR2(255) default '',
    primary key (ID_)
);
COMMENT ON TABLE ACT_HI_ACTINST IS '历史行为节点表';

COMMENT ON COLUMN ACT_HI_ACTINST.ID_ is '主键ID';
COMMENT ON COLUMN ACT_HI_ACTINST.PROC_DEF_ID_ is '流程定义ID';
COMMENT ON COLUMN ACT_HI_ACTINST.PROC_INST_ID_ is '流程实例ID';
COMMENT ON COLUMN ACT_HI_ACTINST.EXECUTION_ID_ is '执行流ID';
COMMENT ON COLUMN ACT_HI_ACTINST.ACT_ID_ is '节点定义ID';
COMMENT ON COLUMN ACT_HI_ACTINST.TASK_ID_ is '任务节点实例ID';
COMMENT ON COLUMN ACT_HI_ACTINST.CALL_PROC_INST_ID_ is '调用外部的流程实例ID';
COMMENT ON COLUMN ACT_HI_ACTINST.ACT_NAME_ is '节点名称';
COMMENT ON COLUMN ACT_HI_ACTINST.ACT_TYPE_ is '节点类型，如startEvent、userTask';
COMMENT ON COLUMN ACT_HI_ACTINST.ASSIGNEE_ is '签收人';
COMMENT ON COLUMN ACT_HI_ACTINST.START_TIME_ is '开始时间';
COMMENT ON COLUMN ACT_HI_ACTINST.END_TIME_ is '结束时间';
COMMENT ON COLUMN ACT_HI_ACTINST.DURATION_ is '耗时';
COMMENT ON COLUMN ACT_HI_ACTINST.DELETE_REASON_ is '删除原因或完成原因';
COMMENT ON COLUMN ACT_HI_ACTINST.TENANT_ID_ is '多租户ID';

--历史任务表
create table ACT_HI_TASKINST (
    ID_ NVARCHAR2(64) not null,
    PROC_DEF_ID_ NVARCHAR2(64),
    TASK_DEF_KEY_ NVARCHAR2(255),
    PROC_INST_ID_ NVARCHAR2(64),
    EXECUTION_ID_ NVARCHAR2(64),
    PARENT_TASK_ID_ NVARCHAR2(64),
    NAME_ NVARCHAR2(255),
    DESCRIPTION_ NVARCHAR2(2000),
    OWNER_ NVARCHAR2(255),
    ASSIGNEE_ NVARCHAR2(255),
    START_TIME_ TIMESTAMP(6) not null,
    CLAIM_TIME_ TIMESTAMP(6),
    END_TIME_ TIMESTAMP(6),
    DURATION_ NUMBER(19,0),
    DELETE_REASON_ NVARCHAR2(2000),
    PRIORITY_ INTEGER,
    DUE_DATE_ TIMESTAMP(6),
    FORM_KEY_ NVARCHAR2(255),
    CATEGORY_ NVARCHAR2(255),
    TENANT_ID_ NVARCHAR2(255) default '',
    primary key (ID_)
);
COMMENT ON TABLE ACT_HI_TASKINST IS '历史任务表';

COMMENT ON COLUMN ACT_HI_TASKINST.ID_ is '主键ID';
COMMENT ON COLUMN ACT_HI_TASKINST.PROC_DEF_ID_ is '流程定义ID';
COMMENT ON COLUMN ACT_HI_TASKINST.TASK_DEF_KEY_ is '任务节点定义ID';
COMMENT ON COLUMN ACT_HI_TASKINST.PROC_INST_ID_ is '流程实例ID';
COMMENT ON COLUMN ACT_HI_TASKINST.EXECUTION_ID_ is '执行流ID';
COMMENT ON COLUMN ACT_HI_TASKINST.PARENT_TASK_ID_ is '父任务节点实例ID';
COMMENT ON COLUMN ACT_HI_TASKINST.NAME_ is '名称';
COMMENT ON COLUMN ACT_HI_TASKINST.DESCRIPTION_ is '描述';
COMMENT ON COLUMN ACT_HI_TASKINST.OWNER_ is '实际签收人，任务的拥有者（被委托时才会有值）';
COMMENT ON COLUMN ACT_HI_TASKINST.ASSIGNEE_ is '签收人或被委托';
COMMENT ON COLUMN ACT_HI_TASKINST.START_TIME_ is '开始时间';
COMMENT ON COLUMN ACT_HI_TASKINST.CLAIM_TIME_ is '提醒时间';
COMMENT ON COLUMN ACT_HI_TASKINST.END_TIME_ is '结束时间';
COMMENT ON COLUMN ACT_HI_TASKINST.DURATION_ is '耗时';
COMMENT ON COLUMN ACT_HI_TASKINST.DELETE_REASON_ is '删除原因或完成原因';
COMMENT ON COLUMN ACT_HI_TASKINST.PRIORITY_ is '优先级别';
COMMENT ON COLUMN ACT_HI_TASKINST.DUE_DATE_ is '过期时间';
COMMENT ON COLUMN ACT_HI_TASKINST.FORM_KEY_ is '表单KEY';
COMMENT ON COLUMN ACT_HI_TASKINST.CATEGORY_ is '类别';
COMMENT ON COLUMN ACT_HI_TASKINST.TENANT_ID_ is '多租户ID';

--历史流程变量表
create table ACT_HI_VARINST (
    ID_ NVARCHAR2(64) not null,
    PROC_INST_ID_ NVARCHAR2(64),
    EXECUTION_ID_ NVARCHAR2(64),
    TASK_ID_ NVARCHAR2(64),
    NAME_ NVARCHAR2(255) not null,
    VAR_TYPE_ NVARCHAR2(100),
    REV_ INTEGER,
    BYTEARRAY_ID_ NVARCHAR2(64),
    DOUBLE_ NUMBER(*,10),
    LONG_ NUMBER(19,0),
    TEXT_ NVARCHAR2(2000),
    TEXT2_ NVARCHAR2(2000),
    CREATE_TIME_ TIMESTAMP(6),
    LAST_UPDATED_TIME_ TIMESTAMP(6),
    primary key (ID_)
);
COMMENT ON TABLE ACT_HI_VARINST IS '历史流程变量表';

COMMENT ON COLUMN ACT_HI_VARINST.ID_ is '主键ID';
COMMENT ON COLUMN ACT_HI_VARINST.PROC_INST_ID_ is '流程实例ID';
COMMENT ON COLUMN ACT_HI_VARINST.EXECUTION_ID_ is '执行流ID';
COMMENT ON COLUMN ACT_HI_VARINST.TASK_ID_ is '任务实例ID';
COMMENT ON COLUMN ACT_HI_VARINST.NAME_ is '名称';
COMMENT ON COLUMN ACT_HI_VARINST.VAR_TYPE_ is '参数类型。jpa-entity、boolean、bytes、serializable、自定义type、CustomVariableType、date、double、integer、jpa-entity、long、null、short、string';
COMMENT ON COLUMN ACT_HI_VARINST.REV_ is '版本号';
COMMENT ON COLUMN ACT_HI_VARINST.BYTEARRAY_ID_ is 'ACT_GE_BYTEARRAY表的主键ID';
COMMENT ON COLUMN ACT_HI_VARINST.DOUBLE_ is '存储Double类型数据';
COMMENT ON COLUMN ACT_HI_VARINST.LONG_ is '存储Long类型数据';
COMMENT ON COLUMN ACT_HI_VARINST.TEXT_ is '存储变量值类型为String，如此处存储持久化对象时，值jpa对象的class';
COMMENT ON COLUMN ACT_HI_VARINST.TEXT2_ is '此处存储的是JPA持久化对象时，才会有值。此值为对象ID';
COMMENT ON COLUMN ACT_HI_VARINST.CREATE_TIME_ is '创建时间';
COMMENT ON COLUMN ACT_HI_VARINST.LAST_UPDATED_TIME_ is '最新更改时间';

--历史流程明细详情表
create table ACT_HI_DETAIL (
    ID_ NVARCHAR2(64) not null,
    TYPE_ NVARCHAR2(255) not null,
    PROC_INST_ID_ NVARCHAR2(64),
    EXECUTION_ID_ NVARCHAR2(64),
    TASK_ID_ NVARCHAR2(64),
    ACT_INST_ID_ NVARCHAR2(64),
    NAME_ NVARCHAR2(255) not null,
    VAR_TYPE_ NVARCHAR2(64),
    REV_ INTEGER,
    TIME_ TIMESTAMP(6) not null,
    BYTEARRAY_ID_ NVARCHAR2(64),
    DOUBLE_ NUMBER(*,10),
    LONG_ NUMBER(19,0),
    TEXT_ NVARCHAR2(2000),
    TEXT2_ NVARCHAR2(2000),
    primary key (ID_)
);
COMMENT ON TABLE ACT_HI_DETAIL IS '历史流程明细详情表';

COMMENT ON COLUMN ACT_HI_DETAIL.ID_ is '主键ID';
COMMENT ON COLUMN ACT_HI_DETAIL.TYPE_ is '默认值 NULL，表单：FormProperty，参数：VariableUpdate';
COMMENT ON COLUMN ACT_HI_DETAIL.PROC_INST_ID_ is '流程实例ID';
COMMENT ON COLUMN ACT_HI_DETAIL.EXECUTION_ID_ is '执行流ID';
COMMENT ON COLUMN ACT_HI_DETAIL.TASK_ID_ is '任务ID';
COMMENT ON COLUMN ACT_HI_DETAIL.ACT_INST_ID_ is '节点实例ID';
COMMENT ON COLUMN ACT_HI_DETAIL.NAME_ is '名称';
COMMENT ON COLUMN ACT_HI_DETAIL.VAR_TYPE_ is '参数类型。默认值 NULL， jpa-entity、boolean、bytes、serializable(可序列化)、自定义type、CustomVariableType、date、double、integer、long、null、short、string';
COMMENT ON COLUMN ACT_HI_DETAIL.REV_ is '版本号';
COMMENT ON COLUMN ACT_HI_DETAIL.TIME_ is '创建时间';
COMMENT ON COLUMN ACT_HI_DETAIL.BYTEARRAY_ID_ is '关联ACT_GE_BYTEARRAY表主键ID，通用资源数据ID';
COMMENT ON COLUMN ACT_HI_DETAIL.DOUBLE_ is '存储变量类型为Double的值';
COMMENT ON COLUMN ACT_HI_DETAIL.LONG_ is '存储变量类型为long的值';
COMMENT ON COLUMN ACT_HI_DETAIL.TEXT_ is '存储变量值类型为String的值';
COMMENT ON COLUMN ACT_HI_DETAIL.TEXT2_ is '存储的是JPA持久化对象时，才会有值。此值为对象ID';

--历史意见表
create table ACT_HI_COMMENT (
    ID_ NVARCHAR2(64) not null,
    TYPE_ NVARCHAR2(255),
    TIME_ TIMESTAMP(6) not null,
    USER_ID_ NVARCHAR2(255),
    TASK_ID_ NVARCHAR2(64),
    PROC_INST_ID_ NVARCHAR2(64),
    ACTION_ NVARCHAR2(255),
    MESSAGE_ NVARCHAR2(2000),
    FULL_MSG_ BLOB,
    primary key (ID_)
);
COMMENT ON TABLE ACT_HI_COMMENT IS '历史意见表';

COMMENT ON COLUMN ACT_HI_COMMENT.ID_ is '主键ID';
COMMENT ON COLUMN ACT_HI_COMMENT.TYPE_ is '类型，event（事件）、comment（意见）';
COMMENT ON COLUMN ACT_HI_COMMENT.TIME_ is '填写时间';
COMMENT ON COLUMN ACT_HI_COMMENT.USER_ID_ is '用户ID';
COMMENT ON COLUMN ACT_HI_COMMENT.TASK_ID_ is '任务实例ID';
COMMENT ON COLUMN ACT_HI_COMMENT.PROC_INST_ID_ is '流程实例ID';
COMMENT ON COLUMN ACT_HI_COMMENT.ACTION_ is '行为类型，值为下列内容中的一种：AddUserLink、DeleteUserLink、AddGroupLink、DeleteGroupLink、AddComment、AddAttachment、DeleteAttachment';
COMMENT ON COLUMN ACT_HI_COMMENT.MESSAGE_ is '基本内容，用于存放流程产生的信息，比如审批意见';
COMMENT ON COLUMN ACT_HI_COMMENT.FULL_MSG_ is '全部内容';

--历史附件表
create table ACT_HI_ATTACHMENT (
    ID_ NVARCHAR2(64) not null,
    REV_ INTEGER,
    USER_ID_ NVARCHAR2(255),
    NAME_ NVARCHAR2(255),
    DESCRIPTION_ NVARCHAR2(2000),
    TYPE_ NVARCHAR2(255),
    TASK_ID_ NVARCHAR2(64),
    PROC_INST_ID_ NVARCHAR2(64),
    URL_ NVARCHAR2(2000),
    CONTENT_ID_ NVARCHAR2(64),
    TIME_ TIMESTAMP(6),
    primary key (ID_)
);
COMMENT ON TABLE ACT_HI_ATTACHMENT IS '历史附件表';

COMMENT ON COLUMN ACT_HI_ATTACHMENT.ID_ is '主键ID';
COMMENT ON COLUMN ACT_HI_ATTACHMENT.REV_ is '版本号';
COMMENT ON COLUMN ACT_HI_ATTACHMENT.USER_ID_ is '用户ID';
COMMENT ON COLUMN ACT_HI_ATTACHMENT.NAME_ is '名称';
COMMENT ON COLUMN ACT_HI_ATTACHMENT.DESCRIPTION_ is '描述';
COMMENT ON COLUMN ACT_HI_ATTACHMENT.TYPE_ is '附件类型';
COMMENT ON COLUMN ACT_HI_ATTACHMENT.TASK_ID_ is '任务节点ID';
COMMENT ON COLUMN ACT_HI_ATTACHMENT.PROC_INST_ID_ is '流程实例ID';
COMMENT ON COLUMN ACT_HI_ATTACHMENT.URL_ is '附件URL地址';
COMMENT ON COLUMN ACT_HI_ATTACHMENT.CONTENT_ID_ is 'ACT_GE_BYTEARRAY的ID，附件如果存入通用资源表';
COMMENT ON COLUMN ACT_HI_ATTACHMENT.TIME_ is '创建时间';

--历史流程人员信息表
create table ACT_HI_IDENTITYLINK (
    ID_ NVARCHAR2(64),
    GROUP_ID_ NVARCHAR2(255),
    TYPE_ NVARCHAR2(255),
    USER_ID_ NVARCHAR2(255),
    TASK_ID_ NVARCHAR2(64),
    PROC_INST_ID_ NVARCHAR2(64),
    primary key (ID_)
);
COMMENT ON TABLE ACT_HI_IDENTITYLINK IS '历史流程人员信息表';

COMMENT ON COLUMN ACT_HI_IDENTITYLINK.ID_ is '主键ID';
COMMENT ON COLUMN ACT_HI_IDENTITYLINK.GROUP_ID_ is '用户组ID';
COMMENT ON COLUMN ACT_HI_IDENTITYLINK.TYPE_ is '类型，assignee、candidate、owner、starter、participant';
COMMENT ON COLUMN ACT_HI_IDENTITYLINK.USER_ID_ is '用户ID';
COMMENT ON COLUMN ACT_HI_IDENTITYLINK.TASK_ID_ is '任务节点ID';
COMMENT ON COLUMN ACT_HI_IDENTITYLINK.PROC_INST_ID_ is '流程实例ID';


create index ACT_IDX_HI_PRO_INST_END on ACT_HI_PROCINST(END_TIME_);
create index ACT_IDX_HI_PRO_I_BUSKEY on ACT_HI_PROCINST(BUSINESS_KEY_);
create index ACT_IDX_HI_ACT_INST_START on ACT_HI_ACTINST(START_TIME_);
create index ACT_IDX_HI_ACT_INST_END on ACT_HI_ACTINST(END_TIME_);
create index ACT_IDX_HI_DETAIL_PROC_INST on ACT_HI_DETAIL(PROC_INST_ID_);
create index ACT_IDX_HI_DETAIL_ACT_INST on ACT_HI_DETAIL(ACT_INST_ID_);
create index ACT_IDX_HI_DETAIL_TIME on ACT_HI_DETAIL(TIME_);
create index ACT_IDX_HI_DETAIL_NAME on ACT_HI_DETAIL(NAME_);
create index ACT_IDX_HI_DETAIL_TASK_ID on ACT_HI_DETAIL(TASK_ID_);
create index ACT_IDX_HI_PROCVAR_PROC_INST on ACT_HI_VARINST(PROC_INST_ID_);
create index ACT_IDX_HI_PROCVAR_NAME_TYPE on ACT_HI_VARINST(NAME_, VAR_TYPE_);
create index ACT_IDX_HI_PROCVAR_TASK_ID on ACT_HI_VARINST(TASK_ID_);
create index ACT_IDX_HI_IDENT_LNK_USER on ACT_HI_IDENTITYLINK(USER_ID_);
create index ACT_IDX_HI_IDENT_LNK_TASK on ACT_HI_IDENTITYLINK(TASK_ID_);
create index ACT_IDX_HI_IDENT_LNK_PROCINST on ACT_HI_IDENTITYLINK(PROC_INST_ID_);

create index ACT_IDX_HI_ACT_INST_PROCINST on ACT_HI_ACTINST(PROC_INST_ID_, ACT_ID_);
create index ACT_IDX_HI_ACT_INST_EXEC on ACT_HI_ACTINST(EXECUTION_ID_, ACT_ID_);
create index ACT_IDX_HI_TASK_INST_PROCINST on ACT_HI_TASKINST(PROC_INST_ID_);