Activiti添加数据库表注释(oracle)
-- Add comments to the table comment on table ACT_GE_BYTEARRAY is '二进制数据表'; -- Add comments to the columns comment on column ACT_GE_BYTEARRAY.id_ is '主键ID'; comment on column ACT_GE_BYTEARRAY.rev_ is 'Version(版本)'; comment on column ACT_GE_BYTEARRAY.name_ is '部署的文件名称,如:mail.bpmn、mail.png 、mail.bpmn20.xml'; comment on column ACT_GE_BYTEARRAY.deployment_id_ is '部署表ID'; comment on column ACT_GE_BYTEARRAY.bytes_ is '部署文件'; comment on column ACT_GE_BYTEARRAY.generated_ is '0为用户生成 1为Activiti生成'; -- Add comments to the table comment on table ACT_GE_PROPERTY is '属性数据表'; -- Add comments to the columns comment on column ACT_GE_PROPERTY.name_ is 'schema.version schema.history next.dbid'; comment on column ACT_GE_PROPERTY.value_ is '5.* create(5.*)'; comment on column ACT_GE_PROPERTY.rev_ is 'version'; -- Add comments to the table comment on table ACT_HI_ACTINST is '历史节点表'; -- Add comments to the columns 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 '节点类型'; 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 '耗时'; -- Add comments to the table comment on table ACT_HI_ATTACHMENT is '历史附件表'; -- Add comments to the columns 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.content_id_ is '字节表的ID'; -- Add comments to the table comment on table ACT_HI_COMMENT is '历史意见表'; -- Add comments to the columns comment on column ACT_HI_COMMENT.type_ is '类型'; comment on column ACT_HI_COMMENT.time_ is '填写时间'; comment on column ACT_HI_COMMENT.user_id_ is '填写人'; 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 '行为类型'; comment on column ACT_HI_COMMENT.message_ is '用于存放流程产生的信息,比如审批意见'; comment on column ACT_HI_COMMENT.full_msg_ is '全部内容'; -- Add comments to the table comment on table ACT_HI_DETAIL is '历史详情表'; -- Add comments to the columns comment on column ACT_HI_DETAIL.type_ is '类型'; 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 '参数类型'; 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 '字节表ID ACT_GE_BYTEARRAY表的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'; -- Add comments to the table comment on table ACT_HI_IDENTITYLINK is '历史流程人员表'; -- Add comments to the columns comment on column ACT_HI_IDENTITYLINK.group_id_ is '组ID'; comment on column ACT_HI_IDENTITYLINK.type_ is '类型'; 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'; -- Add comments to the table comment on table ACT_HI_PROCINST is '历史流程实例表'; -- Add comments to the columns comment on column ACT_HI_PROCINST.proc_inst_id_ is '流程实例ID'; comment on column ACT_HI_PROCINST.business_key_ is '业务主键'; 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'; comment on column ACT_HI_PROCINST.end_act_id_ is '结束节点ID'; comment on column ACT_HI_PROCINST.super_process_instance_id_ is '父流程实例ID'; comment on column ACT_HI_PROCINST.delete_reason_ is '删除原因'; -- Add comments to the table comment on table ACT_HI_TASKINST is '历史任务实例表'; -- Add comments to the columns 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 '节点名称'; comment on column ACT_HI_TASKINST.name_ is '父节点实例ID'; 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 '节点定义的 formkey'; -- Add comments to the table comment on table ACT_HI_VARINST is '历史变量表'; -- Add comments to the columns 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 '参数类型'; comment on column ACT_HI_VARINST.rev_ is '乐观锁'; comment on column ACT_HI_VARINST.bytearray_id_ is '字节表ID ACT_GE_BYTEARRAY表的主键'; comment on column ACT_HI_VARINST.double_ is '存储DoubleType类型的数据'; comment on column ACT_HI_VARINST.long_ is '存储LongType类型的数据'; comment on column ACT_HI_VARINST.text2_ is '此处存储的是JPA持久化对象时,才会有值。此值为对象ID'; -- Add comments to the table comment on table ACT_ID_GROUP is '用户组信息表'; -- Add comments to the columns comment on column ACT_ID_GROUP.rev_ is '乐观锁'; comment on column ACT_ID_GROUP.name_ is '节点名称'; comment on column ACT_ID_GROUP.type_ is '节点类型'; -- Add comments to the table comment on table ACT_ID_INFO is '用户扩展信息表'; -- Add comments to the columns comment on column ACT_ID_INFO.rev_ is '乐观锁'; comment on column ACT_ID_INFO.user_id_ is '用户ID'; comment on column ACT_ID_INFO.type_ is '节点类型'; -- Add comments to the table comment on table ACT_ID_MEMBERSHIP is '用户与分组对应信息表'; -- Add comments to the columns comment on column ACT_ID_MEMBERSHIP.user_id_ is '用户ID'; comment on column ACT_ID_MEMBERSHIP.group_id_ is '用户组ID'; -- Add comments to the table comment on table ACT_ID_USER is '用户信息表'; -- Add comments to the columns comment on column ACT_ID_USER.rev_ is '乐观锁'; comment on column ACT_ID_USER.first_ is '姓'; comment on column ACT_ID_USER.last_ is '名'; comment on column ACT_ID_USER.email_ is 'EMAIL_'; comment on column ACT_ID_USER.pwd_ is '密码'; comment on column ACT_ID_USER.picture_id_ is '图片ID'; -- Add comments to the table comment on table ACT_RE_DEPLOYMENT is '部署信息表'; -- Add comments to the columns comment on column ACT_RE_DEPLOYMENT.name_ is '部署名称'; comment on column ACT_RE_DEPLOYMENT.category_ is '分类'; comment on column ACT_RE_DEPLOYMENT.deploy_time_ is '部署时间'; -- Add comments to the table comment on table ACT_RE_MODEL is '流程设计模型部署表'; -- Add comments to the columns 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.category_ is '分类'; 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 '以json格式保存流程定义的信息'; comment on column ACT_RE_MODEL.deployment_id_ is '部署ID'; -- Add comments to the table comment on table ACT_RE_PROCDEF is '流程定义数据表'; -- Add comments to the columns comment on column ACT_RE_PROCDEF.rev_ is '乐观锁'; comment on column ACT_RE_PROCDEF.category_ is '分类'; comment on column ACT_RE_PROCDEF.name_ is '名称'; comment on column ACT_RE_PROCDEF.key_ is '定义的KEY'; 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 'bpmn文件名称'; comment on column ACT_RE_PROCDEF.dgrm_resource_name_ is 'png图片名称'; comment on column ACT_RE_PROCDEF.description_ is '描述'; comment on column ACT_RE_PROCDEF.has_start_form_key_ is '是否存在开始节点formKey'; comment on column ACT_RE_PROCDEF.suspension_state_ is '是否挂起 1 激活 2挂起'; -- Add comments to the columns 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'; comment on column ACT_RU_EVENT_SUBSCR.proc_inst_id_ is '流程实例ID'; comment on column ACT_RU_EVENT_SUBSCR.activity_id_ is '活动实例ID'; comment on column ACT_RU_EVENT_SUBSCR.configuration_ is '配置'; comment on column ACT_RU_EVENT_SUBSCR.created_ is '是否创建'; comment on column ACT_RU_EVENT_SUBSCR.proc_def_id_ is '流程定义ID'; -- Add comments to the table comment on table ACT_RU_EXECUTION is '运行时流程执行实例表'; -- Add comments to the columns 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 'SUPER_EXEC_'; comment on column ACT_RU_EXECUTION.act_id_ is '节点实例ID'; comment on column ACT_RU_EXECUTION.is_active_ is '是否激活'; comment on column ACT_RU_EXECUTION.is_concurrent_ is '是否并行'; comment on column ACT_RU_EXECUTION.suspension_state_ is '是否挂起'; -- Add comments to the table comment on table ACT_RU_IDENTITYLINK is '运行时流程人员表'; -- Add comments to the columns 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 '类型'; 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'; -- Add comments to the table comment on table ACT_RU_JOB is '运行时定时任务数据表'; -- Add comments to the columns 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.execution_id_ is '执行实例ID'; comment on column ACT_RU_JOB.process_instance_id_ is '流程实例ID'; comment on column ACT_RU_JOB.proc_def_id_ is '流程定义ID'; 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 '标识'; -- Add comments to the table comment on table ACT_RU_TASK is '运行时任务节点表'; -- Add comments to the columns comment on column ACT_RU_TASK.rev_ is '乐观锁'; comment on column ACT_RU_TASK.execution_id_ is '执行实例ID'; comment on column ACT_RU_TASK.proc_inst_id_ is '流程实例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.parent_task_id_ is '父节点实例ID'; comment on column ACT_RU_TASK.description_ is '节点定义描述'; comment on column ACT_RU_TASK.task_def_key_ is '节点定义的KEY'; comment on column ACT_RU_TASK.owner_ is '拥有者(一般情况下为空,只有在委托时才有值)'; comment on column ACT_RU_TASK.assignee_ is '签收人或委托人'; comment on column ACT_RU_TASK.delegation_ is '委托类型'; comment on column ACT_RU_TASK.priority_ is '优先级别'; comment on column ACT_RU_TASK.create_time_ is '创建时间'; comment on column ACT_RU_TASK.due_date_ is '过期时间'; comment on column ACT_RU_TASK.suspension_state_ is '是否挂起 1代表激活 2代表挂起'; -- Add comments to the table comment on table ACT_RU_VARIABLE is '运行时流程变量数据表'; -- Add comments to the columns comment on column ACT_RU_VARIABLE.rev_ is '乐观锁'; comment on column ACT_RU_VARIABLE.type_ is '类型'; 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 '字节表ID';
相关推荐
activiti5.8数据库表结构图activiti5.8数据库表结构图
Activiti 5.22.0数据库表结构添加中文注释MySQL脚本,内含3个脚本,分别是: 1、21张表全部表和字段中文注释和取值说明建表脚本(单SQL文件) 2、21张表全部表和字段中文注释和取值说明添加注释脚本(单SQL文件) 3...
Activiti6.0 数据库表说明文档1
activiti5数据库表结构,activiti5数据库表结构activiti5数据库表结构
Activiti创建数据库表demo
整理了activiti6的表注释字段注释。
简单概括了activiti的数据库表结构,对于初入activiti的同学来说,会增进你对activiti的了解
首先创建 mysql 数据库 activiti(名字任意): org.activiti.engine.impl.db.DbSchemaCreate.mian方法建表
Activiti工作流数据库表结构。更新至6.0.0版本。 对应表注释和字段注释已添加。对关键的表和特性描述有补充
Activiti-5.21数据库表结构详解(共25张表) 工作流的应用越来越广泛,而activiti是公认的现阶段最好的工作流框架之一,详细了解activiti的库表结构有助于您更好的掌握学习工作流框架,共享本资源以供广大编程从业人员...
Activiti创建数据库表 通过流程引擎、通过xml文件
Activiti工作流总共包含23张数据表,所有的表名默认以“ACT_”开头。 并且表名的第二部分用两个字母表明表的用例,而这个用例也基本上跟Service API匹配。
1.2.1 Activiti数据表清单: 3 1.2.2 表名:ACT_GE_BYTEARRAY (通用的流程定义和流程资源) 3 1.2.4 表名:ACT_HI_ACTINST (历史节点表) 5 1.2.3 表名:ACT_GE_PROPERTY (系统相关属性) 4 1.2.5 表名:ACT_HI_...
Activiti7数据库表的建立,其中包含了17张以上的数据表,这些数据表原本是可以通过Activiti7自行创建,但是Activiti7还不持直接通过MySQL8.0的数据库来创建表,所以通过这个文件手动创建
activiti6适配达梦数据库教程
activiti的数据库模型 activiti的数据库模型activiti的数据库模型
网络上找到的资料都没有排版,看起来特别乱,花了两天的时间,精心整理的《Activiti数据库表结构(整理后)》,收藏以便于以后使用。
activiti 5.22 表及中文注释
Activiti 6 mysql5.7初始化数据库
Activiti工作流数据库表结构[定义].pdf