Activiti给表的字段添加备注
Activiti添加数据库表注释(mysql):
注意:由于有的字段是有外键约束,所以无法进行添加备注,故将其注释
-- Add comments to the columns
-- ALTER TABLE ACT_GE_BYTEARRAY MODIFY COLUMN id_ VARCHAR ( 255 ) NOT NULL COMMENT \'主键ID\';
ALTER TABLE ACT_GE_BYTEARRAY MODIFY COLUMN rev_ VARCHAR ( 255 ) NOT NULL COMMENT \'Version(版本)\';
ALTER TABLE ACT_GE_BYTEARRAY MODIFY COLUMN name_ VARCHAR ( 255 ) NOT NULL COMMENT \'部署的文件名称，如：mail.bpmn、mail.png 、mail.bpmn20.xml\';
-- ALTER TABLE ACT_GE_BYTEARRAY MODIFY COLUMN deployment_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'部署表ID\';
-- ALTER TABLE ACT_GE_BYTEARRAY MODIFY COLUMN bytes_ VARCHAR ( 10000 ) NOT NULL COMMENT \'部署文件\';
-- ALTER TABLE ACT_GE_BYTEARRAY MODIFY COLUMN generated_ VARCHAR ( 255 ) NOT NULL COMMENT \'0为用户生成 1为Activiti生成\';
ALTER TABLE ACT_HI_ACTINST MODIFY COLUMN proc_def_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'流程定义ID\';
ALTER TABLE ACT_HI_ACTINST MODIFY COLUMN proc_inst_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'流程实例ID\';
ALTER TABLE ACT_HI_ACTINST MODIFY COLUMN execution_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'执行实例ID\';
ALTER TABLE ACT_HI_ACTINST MODIFY COLUMN act_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'节点ID\';
ALTER TABLE ACT_HI_ACTINST MODIFY COLUMN task_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'任务实例ID\';
ALTER TABLE ACT_HI_ACTINST MODIFY COLUMN call_proc_inst_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'调用外部的流程实例ID\';
ALTER TABLE ACT_HI_ACTINST MODIFY COLUMN act_name_ VARCHAR ( 255 ) NOT NULL COMMENT \'节点名称\';
ALTER TABLE ACT_HI_ACTINST MODIFY COLUMN act_type_ VARCHAR ( 255 ) NOT NULL COMMENT \'节点类型\';
ALTER TABLE ACT_HI_ACTINST MODIFY COLUMN assignee_ VARCHAR ( 255 ) NOT NULL COMMENT \'签收人\';
ALTER TABLE ACT_HI_ACTINST MODIFY COLUMN start_time_ VARCHAR ( 255 ) NOT NULL COMMENT \'开始时间\';
ALTER TABLE ACT_HI_ACTINST MODIFY COLUMN end_time_ VARCHAR ( 255 ) NOT NULL COMMENT \'结束时间\';
ALTER TABLE ACT_HI_ACTINST MODIFY COLUMN duration_ VARCHAR ( 255 ) NOT NULL COMMENT \'耗时\';-- Add comments to the s
ALTER TABLE ACT_HI_ATTACHMENT MODIFY COLUMN user_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'用户ID\';
ALTER TABLE ACT_HI_ATTACHMENT MODIFY COLUMN name_ VARCHAR ( 255 ) NOT NULL COMMENT \'名称\';
ALTER TABLE ACT_HI_ATTACHMENT MODIFY COLUMN description_ VARCHAR ( 255 ) NOT NULL COMMENT \'描述\';
ALTER TABLE ACT_HI_ATTACHMENT MODIFY COLUMN type_ VARCHAR ( 255 ) NOT NULL COMMENT \'类型\';
ALTER TABLE ACT_HI_ATTACHMENT MODIFY COLUMN task_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'任务实例ID\';
ALTER TABLE ACT_HI_ATTACHMENT MODIFY COLUMN proc_inst_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'流程实例ID\';
ALTER TABLE ACT_HI_ATTACHMENT MODIFY COLUMN content_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'字节表的ID\';-- Add comments to the table
ALTER TABLE ACT_HI_COMMENT MODIFY COLUMN type_ VARCHAR ( 255 ) NOT NULL COMMENT \'类型\';
ALTER TABLE ACT_HI_COMMENT MODIFY COLUMN time_ VARCHAR ( 255 ) NOT NULL COMMENT \'填写时间\';
ALTER TABLE ACT_HI_COMMENT MODIFY COLUMN user_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'填写人\';
ALTER TABLE ACT_HI_COMMENT MODIFY COLUMN task_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'节点实例ID\';
ALTER TABLE ACT_HI_COMMENT MODIFY COLUMN proc_inst_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'流程实例ID\';
ALTER TABLE ACT_HI_COMMENT MODIFY COLUMN action_ VARCHAR ( 255 ) NOT NULL COMMENT \'行为类型\';
ALTER TABLE ACT_HI_COMMENT MODIFY COLUMN message_ VARCHAR ( 255 ) NOT NULL COMMENT \'用于存放流程产生的信息，比如审批意见\';
ALTER TABLE ACT_HI_COMMENT MODIFY COLUMN full_msg_ VARCHAR ( 255 ) NOT NULL COMMENT \'全部内容\';-- Add comments to the table
ALTER TABLE ACT_HI_DETAIL MODIFY COLUMN type_ VARCHAR ( 255 ) NOT NULL COMMENT \'类型\';
ALTER TABLE ACT_HI_DETAIL MODIFY COLUMN proc_inst_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'流程实例ID\';
ALTER TABLE ACT_HI_DETAIL MODIFY COLUMN execution_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'执行实例ID\';
ALTER TABLE ACT_HI_DETAIL MODIFY COLUMN task_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'任务实例ID\';
ALTER TABLE ACT_HI_DETAIL MODIFY COLUMN act_inst_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'节点实例ID\';
ALTER TABLE ACT_HI_DETAIL MODIFY COLUMN name_ VARCHAR ( 255 ) NOT NULL COMMENT \'节点名称\';
ALTER TABLE ACT_HI_DETAIL MODIFY COLUMN var_type_ VARCHAR ( 255 ) NOT NULL COMMENT \'参数类型\';
ALTER TABLE ACT_HI_DETAIL MODIFY COLUMN rev_ VARCHAR ( 255 ) NOT NULL COMMENT \'乐观锁\';
ALTER TABLE ACT_HI_DETAIL MODIFY COLUMN time_ VARCHAR ( 255 ) NOT NULL COMMENT \'时间戳\';
ALTER TABLE ACT_HI_DETAIL MODIFY COLUMN bytearray_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'字节表ID ACT_GE_BYTEARRAY表的ID\';
ALTER TABLE ACT_HI_DETAIL MODIFY COLUMN double_ VARCHAR ( 255 ) NOT NULL COMMENT \'存储变量类型为Double\';
ALTER TABLE ACT_HI_DETAIL MODIFY COLUMN long_ VARCHAR ( 255 ) NOT NULL COMMENT \'存储变量类型为long\';
ALTER TABLE ACT_HI_DETAIL MODIFY COLUMN text_ VARCHAR ( 255 ) NOT NULL COMMENT \'存储变量值类型为String\';
ALTER TABLE ACT_HI_DETAIL MODIFY COLUMN text2_ VARCHAR ( 255 ) NOT NULL COMMENT \'此处存储的是JPA持久化对象时，才会有值。此值为对象ID\';-- Add comments to the table
ALTER TABLE ACT_HI_IDENTITYLINK MODIFY COLUMN group_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'组ID\';
ALTER TABLE ACT_HI_IDENTITYLINK MODIFY COLUMN type_ VARCHAR ( 255 ) NOT NULL COMMENT \'类型\';
ALTER TABLE ACT_HI_IDENTITYLINK MODIFY COLUMN user_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'用户ID\';
ALTER TABLE ACT_HI_IDENTITYLINK MODIFY COLUMN task_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'节点实例ID\';
ALTER TABLE ACT_HI_IDENTITYLINK MODIFY COLUMN proc_inst_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'流程实例ID\';-- Add comments to the table
ALTER TABLE ACT_HI_PROCINST MODIFY COLUMN proc_inst_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'流程实例ID\';
ALTER TABLE ACT_HI_PROCINST MODIFY COLUMN business_key_ VARCHAR ( 255 ) NOT NULL COMMENT \'业务主键\';
ALTER TABLE ACT_HI_PROCINST MODIFY COLUMN proc_def_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'流程定义ID\';
ALTER TABLE ACT_HI_PROCINST MODIFY COLUMN start_time_ VARCHAR ( 255 ) NOT NULL COMMENT \'开始时间\';
ALTER TABLE ACT_HI_PROCINST MODIFY COLUMN end_time_ VARCHAR ( 255 ) NOT NULL COMMENT \'结束时间\';
ALTER TABLE ACT_HI_PROCINST MODIFY COLUMN duration_ VARCHAR ( 255 ) NOT NULL COMMENT \'耗时\';
ALTER TABLE ACT_HI_PROCINST MODIFY COLUMN start_user_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'起草人\';
ALTER TABLE ACT_HI_PROCINST MODIFY COLUMN start_act_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'开始节点ID\';
ALTER TABLE ACT_HI_PROCINST MODIFY COLUMN end_act_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'结束节点ID\';
ALTER TABLE ACT_HI_PROCINST MODIFY COLUMN super_process_instance_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'父流程实例ID\';
ALTER TABLE ACT_HI_PROCINST MODIFY COLUMN delete_reason_ VARCHAR ( 255 ) NOT NULL COMMENT \'删除原因\';-- Add comments to the table
ALTER TABLE ACT_HI_TASKINST MODIFY COLUMN proc_def_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'流程定义ID\';
ALTER TABLE ACT_HI_TASKINST MODIFY COLUMN task_def_key_ VARCHAR ( 255 ) NOT NULL COMMENT \'节点定义ID\';
ALTER TABLE ACT_HI_TASKINST MODIFY COLUMN proc_inst_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'流程实例ID\';
ALTER TABLE ACT_HI_TASKINST MODIFY COLUMN execution_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'执行实例ID\';
ALTER TABLE ACT_HI_TASKINST MODIFY COLUMN parent_task_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'节点名称\';
ALTER TABLE ACT_HI_TASKINST MODIFY COLUMN name_ VARCHAR ( 255 ) NOT NULL COMMENT \'父节点实例ID\';
ALTER TABLE ACT_HI_TASKINST MODIFY COLUMN description_ VARCHAR ( 255 ) NOT NULL COMMENT \'描述\';
ALTER TABLE ACT_HI_TASKINST MODIFY COLUMN owner_ VARCHAR ( 255 ) NOT NULL COMMENT \'实际签收人 任务的拥有者\';
ALTER TABLE ACT_HI_TASKINST MODIFY COLUMN assignee_ VARCHAR ( 255 ) NOT NULL COMMENT \'签收人或被委托\';
ALTER TABLE ACT_HI_TASKINST MODIFY COLUMN start_time_ VARCHAR ( 255 ) NOT NULL COMMENT \'开始时间\';
ALTER TABLE ACT_HI_TASKINST MODIFY COLUMN claim_time_ VARCHAR ( 255 ) NOT NULL COMMENT \'提醒时间\';
ALTER TABLE ACT_HI_TASKINST MODIFY COLUMN end_time_ VARCHAR ( 255 ) NOT NULL COMMENT \'结束时间\';
ALTER TABLE ACT_HI_TASKINST MODIFY COLUMN duration_ VARCHAR ( 255 ) NOT NULL COMMENT \'耗时\';
ALTER TABLE ACT_HI_TASKINST MODIFY COLUMN delete_reason_ VARCHAR ( 255 ) NOT NULL COMMENT \'删除原因\';
ALTER TABLE ACT_HI_TASKINST MODIFY COLUMN priority_ VARCHAR ( 255 ) NOT NULL COMMENT \'优先级别\';
ALTER TABLE ACT_HI_TASKINST MODIFY COLUMN due_date_ VARCHAR ( 255 ) NOT NULL COMMENT \'过期时间\';
ALTER TABLE ACT_HI_TASKINST MODIFY COLUMN form_key_ VARCHAR ( 255 ) NOT NULL COMMENT \'节点定义的
formkey\';-- Add comments to the table
ALTER TABLE ACT_HI_VARINST MODIFY COLUMN proc_inst_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'流程实例ID\';
ALTER TABLE ACT_HI_VARINST MODIFY COLUMN execution_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'执行实例ID\';
ALTER TABLE ACT_HI_VARINST MODIFY COLUMN task_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'任务实例ID\';
ALTER TABLE ACT_HI_VARINST MODIFY COLUMN name_ VARCHAR ( 255 ) NOT NULL COMMENT \'节点名称\';
ALTER TABLE ACT_HI_VARINST MODIFY COLUMN var_type_ VARCHAR ( 255 ) NOT NULL COMMENT \'参数类型\';
ALTER TABLE ACT_HI_VARINST MODIFY COLUMN rev_ VARCHAR ( 255 ) NOT NULL COMMENT \'乐观锁\';
ALTER TABLE ACT_HI_VARINST MODIFY COLUMN bytearray_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'字节表ID ACT_GE_BYTEARRAY表的主键\';
ALTER TABLE ACT_HI_VARINST MODIFY COLUMN double_ VARCHAR ( 255 ) NOT NULL COMMENT \'存储DoubleType类型的数据\';
ALTER TABLE ACT_HI_VARINST MODIFY COLUMN long_ VARCHAR ( 255 ) NOT NULL COMMENT \'存储LongType类型的数据\';
ALTER TABLE ACT_HI_VARINST MODIFY COLUMN text2_ VARCHAR ( 255 ) NOT NULL COMMENT \'此处存储的是JPA持久化对象时，才会有值。此值为对象ID\';-- Add comments to the table
ALTER TABLE ACT_ID_GROUP MODIFY COLUMN rev_ VARCHAR ( 255 ) NOT NULL COMMENT \'乐观锁\';
ALTER TABLE ACT_ID_GROUP MODIFY COLUMN name_ VARCHAR ( 255 ) NOT NULL COMMENT \'节点名称\';
ALTER TABLE ACT_ID_GROUP MODIFY COLUMN type_ VARCHAR ( 255 ) NOT NULL COMMENT \'节点类型\';-- Add comments to the table
ALTER TABLE ACT_ID_INFO MODIFY COLUMN rev_ VARCHAR ( 255 ) NOT NULL COMMENT \'乐观锁\';
ALTER TABLE ACT_ID_INFO MODIFY COLUMN user_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'用户ID\';
ALTER TABLE ACT_ID_INFO MODIFY COLUMN type_ VARCHAR ( 255 ) NOT NULL COMMENT \'节点类型\';-- Add comments to the table
-- ALTER TABLE ACT_ID_MEMBERSHIP MODIFY COLUMN user_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'用户ID\';
-- ALTER TABLE ACT_ID_MEMBERSHIP MODIFY COLUMN group_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'用户组ID\';-- Add comments to the table
ALTER TABLE ACT_ID_USER MODIFY COLUMN rev_ VARCHAR ( 255 ) NOT NULL COMMENT \'乐观锁\';
ALTER TABLE ACT_ID_USER MODIFY COLUMN first_ VARCHAR ( 255 ) NOT NULL COMMENT \'姓\';
ALTER TABLE ACT_ID_USER MODIFY COLUMN last_ VARCHAR ( 255 ) NOT NULL COMMENT \'名\';
ALTER TABLE ACT_ID_USER MODIFY COLUMN email_ VARCHAR ( 255 ) NOT NULL COMMENT \'EMAIL_\';
ALTER TABLE ACT_ID_USER MODIFY COLUMN pwd_ VARCHAR ( 255 ) NOT NULL COMMENT \'密码\';
ALTER TABLE ACT_ID_USER MODIFY COLUMN picture_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'图片ID\';-- Add comments to the table
ALTER TABLE ACT_RE_DEPLOYMENT MODIFY COLUMN name_ VARCHAR ( 255 ) NOT NULL COMMENT \'部署名称\';
ALTER TABLE ACT_RE_DEPLOYMENT MODIFY COLUMN category_ VARCHAR ( 255 ) COMMENT \'分类\';
ALTER TABLE ACT_RE_DEPLOYMENT MODIFY COLUMN deploy_time_ VARCHAR ( 255 ) NOT NULL COMMENT \'部署时间\';-- Add comments to the table
ALTER TABLE ACT_RE_MODEL MODIFY COLUMN rev_ VARCHAR ( 255 ) NOT NULL COMMENT \'乐观锁\';
ALTER TABLE ACT_RE_MODEL MODIFY COLUMN name_ VARCHAR ( 255 ) NOT NULL COMMENT \'名称\';
ALTER TABLE ACT_RE_MODEL MODIFY COLUMN key_ VARCHAR ( 255 ) NOT NULL COMMENT \'KEY_\';
ALTER TABLE ACT_RE_MODEL MODIFY COLUMN category_ VARCHAR ( 255 ) NOT NULL COMMENT \'分类\';
ALTER TABLE ACT_RE_MODEL MODIFY COLUMN create_time_ VARCHAR ( 255 ) NOT NULL COMMENT \'创建时间\';
ALTER TABLE ACT_RE_MODEL MODIFY COLUMN last_update_time_ VARCHAR ( 255 ) NOT NULL COMMENT \'最新修改时间\';
ALTER TABLE ACT_RE_MODEL MODIFY COLUMN version_ VARCHAR ( 255 ) NOT NULL COMMENT \'版本\';
ALTER TABLE ACT_RE_MODEL MODIFY COLUMN meta_info_ VARCHAR ( 255 ) NOT NULL COMMENT \'以json格式保存流程定义的信息\';
-- ALTER TABLE ACT_RE_MODEL MODIFY COLUMN deployment_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'部署ID\';-- Add comments to the table
ALTER TABLE ACT_RE_PROCDEF MODIFY COLUMN rev_ VARCHAR ( 255 ) NOT NULL COMMENT \'乐观锁\';
ALTER TABLE ACT_RE_PROCDEF MODIFY COLUMN category_ VARCHAR ( 255 ) NOT NULL COMMENT \'分类\';
ALTER TABLE ACT_RE_PROCDEF MODIFY COLUMN name_ VARCHAR ( 255 ) NOT NULL COMMENT \'名称\';
ALTER TABLE ACT_RE_PROCDEF MODIFY COLUMN key_ VARCHAR ( 255 ) NOT NULL COMMENT \'定义的KEY\';
ALTER TABLE ACT_RE_PROCDEF MODIFY COLUMN version_ VARCHAR ( 255 ) NOT NULL COMMENT \'版本\';
ALTER TABLE ACT_RE_PROCDEF MODIFY COLUMN deployment_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'部署表ID\';
ALTER TABLE ACT_RE_PROCDEF MODIFY COLUMN resource_name_ VARCHAR ( 255 ) NOT NULL COMMENT \'bpmn文件名称\';
ALTER TABLE ACT_RE_PROCDEF MODIFY COLUMN dgrm_resource_name_ VARCHAR ( 255 ) NOT NULL COMMENT \'png图片名称\';
-- ALTER TABLE ACT_RE_PROCDEF MODIFY COLUMN description_ VARCHAR ( 255 ) NOT NULL COMMENT \'描述\';
ALTER TABLE ACT_RE_PROCDEF MODIFY COLUMN has_start_form_key_ VARCHAR ( 255 ) NOT NULL COMMENT \'是否存在开始节点formKey\';
ALTER TABLE ACT_RE_PROCDEF MODIFY COLUMN suspension_state_ VARCHAR ( 255 ) NOT NULL COMMENT \'是否挂起 1 激活 2挂起\';-- Add comments to the s
ALTER TABLE ACT_RU_EVENT_SUBSCR MODIFY COLUMN rev_ VARCHAR ( 255 ) NOT NULL COMMENT \'版本\';
ALTER TABLE ACT_RU_EVENT_SUBSCR MODIFY COLUMN event_type_ VARCHAR ( 255 ) NOT NULL COMMENT \'事件类型\';
ALTER TABLE ACT_RU_EVENT_SUBSCR MODIFY COLUMN event_name_ VARCHAR ( 255 ) NOT NULL COMMENT \'事件名称\';
-- ALTER TABLE ACT_RU_EVENT_SUBSCR MODIFY COLUMN execution_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'执行实例ID\';
ALTER TABLE ACT_RU_EVENT_SUBSCR MODIFY COLUMN proc_inst_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'流程实例ID\';
ALTER TABLE ACT_RU_EVENT_SUBSCR MODIFY COLUMN activity_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'活动实例ID\';
ALTER TABLE ACT_RU_EVENT_SUBSCR MODIFY COLUMN configuration_ VARCHAR ( 255 ) NOT NULL COMMENT \'配置\';
ALTER TABLE ACT_RU_EVENT_SUBSCR MODIFY COLUMN created_ VARCHAR ( 255 ) NOT NULL COMMENT \'是否创建\';
ALTER TABLE ACT_RU_EVENT_SUBSCR MODIFY COLUMN proc_def_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'流程定义ID\';-- Add comments to the table
ALTER TABLE ACT_RU_EXECUTION MODIFY COLUMN rev_ VARCHAR ( 255 ) NOT NULL COMMENT \'乐观锁\';
-- ALTER TABLE ACT_RU_EXECUTION MODIFY COLUMN proc_inst_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'流程实例ID\';
-- ALTER TABLE ACT_RU_EXECUTION MODIFY COLUMN business_key_ VARCHAR ( 255 ) NOT NULL COMMENT \'业务主键ID\';
-- ALTER TABLE ACT_RU_EXECUTION MODIFY COLUMN parent_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'父节点实例ID\';
-- ALTER TABLE ACT_RU_EXECUTION MODIFY COLUMN proc_def_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'流程定义ID\';
-- ALTER TABLE ACT_RU_EXECUTION MODIFY COLUMN super_exec_ VARCHAR ( 255 ) NOT NULL COMMENT \'SUPER_EXEC_\';
ALTER TABLE ACT_RU_EXECUTION MODIFY COLUMN act_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'节点实例ID\';
ALTER TABLE ACT_RU_EXECUTION MODIFY COLUMN IS_ACTIVE_ VARCHAR ( 255 ) NOT NULL COMMENT \'是否激活\';
ALTER TABLE ACT_RU_EXECUTION MODIFY COLUMN IS_CONCURRENT_ VARCHAR ( 255 ) NOT NULL COMMENT \'是否并行\';
ALTER TABLE ACT_RU_EXECUTION MODIFY COLUMN suspension_state_ VARCHAR ( 255 ) NOT NULL COMMENT \'是否挂起\';-- Add comments to the table
ALTER TABLE ACT_RU_IDENTITYLINK MODIFY COLUMN rev_ VARCHAR ( 255 ) NOT NULL COMMENT \'乐观锁\';
ALTER TABLE ACT_RU_IDENTITYLINK MODIFY COLUMN group_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'组ID\';
ALTER TABLE ACT_RU_IDENTITYLINK MODIFY COLUMN type_ VARCHAR ( 255 ) NOT NULL COMMENT \'类型\';
ALTER TABLE ACT_RU_IDENTITYLINK MODIFY COLUMN user_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'用户ID\';
-- ALTER TABLE ACT_RU_IDENTITYLINK MODIFY COLUMN task_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'节点实例ID\';
-- ALTER TABLE ACT_RU_IDENTITYLINK MODIFY COLUMN proc_inst_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'流程实例ID\';
-- ALTER TABLE ACT_RU_IDENTITYLINK MODIFY COLUMN proc_def_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'流程定义ID\';-- Add comments to the table
--
ALTER TABLE ACT_RU_JOB MODIFY COLUMN rev_ VARCHAR ( 255 ) NOT NULL COMMENT \'版本\';
ALTER TABLE ACT_RU_JOB MODIFY COLUMN type_ VARCHAR ( 255 ) NOT NULL COMMENT \'类型\';
ALTER TABLE ACT_RU_JOB MODIFY COLUMN lock_exp_time_ VARCHAR ( 255 ) NOT NULL COMMENT \'锁定释放时间\';
ALTER TABLE ACT_RU_JOB MODIFY COLUMN lock_owner_ VARCHAR ( 255 ) NOT NULL COMMENT \'挂起者\';
-- ALTER TABLE ACT_RU_JOB MODIFY COLUMN execution_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'执行实例ID\';
-- ALTER TABLE ACT_RU_JOB MODIFY COLUMN process_instance_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'流程实例ID\';
-- ALTER TABLE ACT_RU_JOB MODIFY COLUMN proc_def_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'流程定义ID\';
-- ALTER TABLE ACT_RU_JOB MODIFY COLUMN exception_stack_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'异常信息ID\';
ALTER TABLE ACT_RU_JOB MODIFY COLUMN exception_msg_ VARCHAR ( 255 ) NOT NULL COMMENT \'异常信息\';
ALTER TABLE ACT_RU_JOB MODIFY COLUMN duedate_ VARCHAR ( 255 ) NOT NULL COMMENT \'到期时间\';
ALTER TABLE ACT_RU_JOB MODIFY COLUMN repeat_ VARCHAR ( 255 ) NOT NULL COMMENT \'重复\';
ALTER TABLE ACT_RU_JOB MODIFY COLUMN handler_type_ VARCHAR ( 255 ) NOT NULL COMMENT \'处理类型\';
ALTER TABLE ACT_RU_JOB MODIFY COLUMN handler_cfg_ VARCHAR ( 255 ) NOT NULL COMMENT \'标识\';-- Add comments to the table
ALTER TABLE ACT_RU_TASK MODIFY COLUMN rev_ VARCHAR ( 255 ) NOT NULL COMMENT \'乐观锁\';
-- ALTER TABLE ACT_RU_TASK MODIFY COLUMN execution_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'执行实例ID\';
-- ALTER TABLE ACT_RU_TASK MODIFY COLUMN proc_inst_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'流程实例ID\';
-- ALTER TABLE ACT_RU_TASK MODIFY COLUMN proc_def_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'流程定义ID\';
ALTER TABLE ACT_RU_TASK MODIFY COLUMN name_ VARCHAR ( 255 ) NOT NULL COMMENT \'节点定义名称\';
ALTER TABLE ACT_RU_TASK MODIFY COLUMN parent_task_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'父节点实例ID\';
ALTER TABLE ACT_RU_TASK MODIFY COLUMN description_ VARCHAR ( 255 ) NOT NULL COMMENT \'节点定义描述\';
ALTER TABLE ACT_RU_TASK MODIFY COLUMN task_def_key_ VARCHAR ( 255 ) NOT NULL COMMENT \'节点定义的KEY\';
ALTER TABLE ACT_RU_TASK MODIFY COLUMN owner_ VARCHAR ( 255 ) NOT NULL COMMENT \'拥有者（一般情况下为空，只有在委托时才有值）\';
ALTER TABLE ACT_RU_TASK MODIFY COLUMN assignee_ VARCHAR ( 255 ) NOT NULL COMMENT \'签收人或委托人\';
ALTER TABLE ACT_RU_TASK MODIFY COLUMN delegation_ VARCHAR ( 255 ) NOT NULL COMMENT \'委托类型\';
ALTER TABLE ACT_RU_TASK MODIFY COLUMN priority_ VARCHAR ( 255 ) NOT NULL COMMENT \'优先级别\';
ALTER TABLE ACT_RU_TASK MODIFY COLUMN create_time_ VARCHAR ( 255 ) NOT NULL COMMENT \'创建时间\';
ALTER TABLE ACT_RU_TASK MODIFY COLUMN due_date_ VARCHAR ( 255 ) NOT NULL COMMENT \'过期时间\';
ALTER TABLE ACT_RU_TASK MODIFY COLUMN suspension_state_ VARCHAR ( 255 ) NOT NULL COMMENT \'是否挂起 1代表激活 2代表挂起\';-- Add comments to the table
ALTER TABLE ACT_RU_VARIABLE MODIFY COLUMN rev_ VARCHAR ( 255 ) NOT NULL COMMENT \'乐观锁\';
ALTER TABLE ACT_RU_VARIABLE MODIFY COLUMN type_ VARCHAR ( 255 ) NOT NULL COMMENT \'类型\';
ALTER TABLE ACT_RU_VARIABLE MODIFY COLUMN name_ VARCHAR ( 255 ) NOT NULL COMMENT \'名称\';
-- ALTER TABLE ACT_RU_VARIABLE MODIFY COLUMN execution_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'执行实例ID\';
-- ALTER TABLE ACT_RU_VARIABLE MODIFY COLUMN proc_inst_id_ VARCHAR ( 255 ) NOT NULL COMMENT \'流程实例ID\';
ALTER TABLE ACT_RU_VARIABLE MODIFY COLUMN task_id_ VARCHAR ( 30 ) NOT NULL COMMENT \'节点实例ID\';
-- ALTER TABLE ACT_RU_VARIABLE MODIFY COLUMN bytearray_id_ VARCHAR ( 30 ) NOT NULL COMMENT \'字节表ID\'; 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\';
原文链接：https://blog.csdn.net/White_BaiSmall/java/article/details/89315434
