Activiti给表的字段添加备注
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
版权声明：本文为JavaHxm原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。