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_BYTEARRAYadd constraint ACT_FK_BYTEARR_DEPLforeign key (DEPLOYMENT_ID_)references ACT_RE_DEPLOYMENT (ID_);alter table ACT_RE_PROCDEFadd constraint ACT_UNIQ_PROCDEFunique (KEY_,VERSION_, TENANT_ID_);create index ACT_IDX_EXE_PROCINST on ACT_RU_EXECUTION(PROC_INST_ID_);
alter table ACT_RU_EXECUTIONadd constraint ACT_FK_EXE_PROCINSTforeign 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_EXECUTIONadd constraint ACT_FK_EXE_PARENTforeign key (PARENT_ID_)references ACT_RU_EXECUTION (ID_);create index ACT_IDX_EXE_SUPER on ACT_RU_EXECUTION(SUPER_EXEC_);
alter table ACT_RU_EXECUTIONadd constraint ACT_FK_EXE_SUPERforeign 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_EXECUTIONadd constraint ACT_FK_EXE_PROCDEFforeign 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_IDENTITYLINKadd constraint ACT_FK_TSKASS_TASKforeign 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_IDENTITYLINKadd constraint ACT_FK_ATHRZ_PROCEDEFforeign 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_IDENTITYLINKadd constraint ACT_FK_IDL_PROCINSTforeign 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_TASKadd constraint ACT_FK_TASK_EXEforeign 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_TASKadd constraint ACT_FK_TASK_PROCINSTforeign 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_TASKadd constraint ACT_FK_TASK_PROCDEFforeign 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_VARIABLEadd constraint ACT_FK_VAR_EXEforeign 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_VARIABLEadd constraint ACT_FK_VAR_PROCINSTforeign 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_VARIABLEadd constraint ACT_FK_VAR_BYTEARRAYforeign 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_JOBadd constraint ACT_FK_JOB_EXECUTIONforeign 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_JOBadd constraint ACT_FK_JOB_PROCESS_INSTANCEforeign 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_JOBadd constraint ACT_FK_JOB_PROC_DEFforeign 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_JOBadd constraint ACT_FK_JOB_EXCEPTIONforeign 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_JOBadd constraint ACT_FK_TJOB_EXECUTIONforeign 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_JOBadd constraint ACT_FK_TJOB_PROCESS_INSTANCEforeign 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_JOBadd constraint ACT_FK_TJOB_PROC_DEFforeign 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_JOBadd constraint ACT_FK_TJOB_EXCEPTIONforeign 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_JOBadd constraint ACT_FK_SJOB_EXECUTIONforeign 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_JOBadd constraint ACT_FK_SJOB_PROCESS_INSTANCEforeign 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_JOBadd constraint ACT_FK_SJOB_PROC_DEFforeign 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_JOBadd constraint ACT_FK_SJOB_EXCEPTIONforeign 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_JOBadd constraint ACT_FK_DJOB_EXECUTIONforeign 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_JOBadd constraint ACT_FK_DJOB_PROCESS_INSTANCEforeign 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_JOBadd constraint ACT_FK_DJOB_PROC_DEFforeign 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_JOBadd constraint ACT_FK_DJOB_EXCEPTIONforeign 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_SUBSCRadd constraint ACT_FK_EVENT_EXECforeign 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_MODELadd constraint ACT_FK_MODEL_SOURCEforeign 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_MODELadd constraint ACT_FK_MODEL_SOURCE_EXTRAforeign 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_MODELadd constraint ACT_FK_MODEL_DEPLOYMENTforeign 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_INFOadd constraint ACT_FK_INFO_JSON_BAforeign 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_INFOadd constraint ACT_FK_INFO_PROCDEFforeign key (PROC_DEF_ID_)references ACT_RE_PROCDEF (ID_);alter table ACT_PROCDEF_INFOadd constraint ACT_UNIQ_INFO_PROCDEFunique (PROC_DEF_ID_);alter table ACT_RU_INTEGRATIONadd constraint ACT_FK_INT_EXECUTIONforeign key (EXECUTION_ID_)references ACT_RU_EXECUTION (ID_)on delete cascade;alter table ACT_RU_INTEGRATIONadd constraint ACT_FK_INT_PROC_INSTforeign key (PROCESS_INSTANCE_ID_)references ACT_RU_EXECUTION (ID_);alter table ACT_RU_INTEGRATIONadd constraint ACT_FK_INT_PROC_DEFforeign 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_);