Activiti添加数据库表注释(oracle)

33omaw9na9

　　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';