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
