天天看點

flowable 表名sql mysql和oracle

### 工作流相關表增加表注釋SQL

alter table act_evt_log comment '事件日志表–EventLogEntryEntityImpl';
alter table act_ge_bytearray comment '流程xml存儲表';
alter table act_ge_property comment '流程版本資訊,禁止私自修改';
alter table act_hi_actinst comment '曆史節點資訊表–HistoricActivityInstanceEntityImpl';
alter table act_hi_attachment comment '附件表–AttachmentEntityImpl';
alter table act_hi_comment comment '評論表–CommentEntityImpl';
alter table act_hi_detail comment '曆史的流程運作中的細節資訊–HistoricDetailEntityImpl';
alter table act_hi_identitylink comment '曆史參與者表–HistoricIdentityLinkEntityImpl';
alter table act_hi_procinst comment '曆史流程執行個體表–HistoricProcessInstanceEntityImpl';
alter table act_hi_taskinst comment '曆史任務表–HistoricTaskInstanceEntityImpl';
alter table act_hi_varinst comment '曆史變量–HistoricVariableInstanceEntityImpl';
alter table act_id_bytearray comment '二進制資料表(flowable)–';
alter table act_id_group comment '群組表(用于Web設計器)–GroupEntityImpl';
alter table act_id_info comment '使用者擴充表–IdentityInfoEntityImpl';
alter table act_id_membership comment '使用者與群主關系表–MemberShipEntityImpl';
alter table act_id_priv comment '權限表(flowable)–';
alter table act_id_priv_mapping comment '使用者或組權限關系表(flowable)–';
alter table act_id_property comment '屬性表(flowable)–';
alter table act_id_token comment '系統登入日志表(flowable)–';
alter table act_id_user comment '使用者基本資訊表–UserEntityImpl';
alter table act_procdef_info comment '流程定義動态改變資訊表–ProcessDefinitionInfoEntityImpl';
alter table act_re_deployment comment '流程部署表–DeploymentEntityImpl';
alter table act_re_model comment '流程設計基本資訊';
alter table act_re_procdef comment '流程定義資訊表–ProcessDefinitionEntityImpl';
alter table act_ru_actinst comment '運作時節點資訊表–ActivityInstanceEntityImpl';
alter table act_ru_deadletter_job comment '死信表–DeadLetterJobEntityImpl';
alter table act_ru_event_subscr comment '事件訂閱表–EventSubscriptionEntityImpl';
alter table act_ru_execution comment '流程執行個體與分支執行表–ExecutionEntityImpl';
alter table act_ru_history_job comment '曆史作業表(flowable)–';
alter table act_ru_identitylink comment '參與者相關資訊表–IdentityLinkEntityImpl';
alter table act_ru_job comment '作業表–JobEntityImpl';
alter table act_ru_suspended_job comment '暫停作業表–SuspendedJobEntityImpl';
alter table act_ru_task comment '使用者任務表–TaskEntityImpl';
alter table act_ru_timer_job comment '定時器表–TimerJobEntityImpl';
alter table act_ru_variable comment '變量資訊–VariableInstanceEntityImpl';      
### 工作流相關表增加表注釋SQL

COMMENT ON act_evt_log IS '事件日志表–EventLogEntryEntityImpl';
COMMENT ON act_ge_bytearray IS '流程xml存儲表';
COMMENT ON act_ge_property IS '流程版本資訊,禁止私自修改';
COMMENT ON act_hi_actinst IS '曆史節點資訊表–HistoricActivityInstanceEntityImpl';
COMMENT ON act_hi_attachment IS '附件表–AttachmentEntityImpl';
COMMENT ON act_hi_IS IS '評論表–CommentEntityImpl';
COMMENT ON act_hi_detail IS '曆史的流程運作中的細節資訊–HistoricDetailEntityImpl';
COMMENT ON act_hi_identitylink IS '曆史參與者表–HistoricIdentityLinkEntityImpl';
COMMENT ON act_hi_procinst IS '曆史流程執行個體表–HistoricProcessInstanceEntityImpl';
COMMENT ON act_hi_taskinst IS '曆史任務表–HistoricTaskInstanceEntityImpl';
COMMENT ON act_hi_varinst IS '曆史變量–HistoricVariableInstanceEntityImpl';
COMMENT ON act_id_bytearray IS '二進制資料表(flowable)–';
COMMENT ON act_id_group IS '群組表(用于Web設計器)–GroupEntityImpl';
COMMENT ON act_id_info IS '使用者擴充表–IdentityInfoEntityImpl';
COMMENT ON act_id_membership IS '使用者與群主關系表–MemberShipEntityImpl';
COMMENT ON act_id_priv IS '權限表(flowable)–';
COMMENT ON act_id_priv_mapping IS '使用者或組權限關系表(flowable)–';
COMMENT ON act_id_property IS '屬性表(flowable)–';
COMMENT ON act_id_token IS '系統登入日志表(flowable)–';
COMMENT ON act_id_user IS '使用者基本資訊表–UserEntityImpl';
COMMENT ON act_procdef_info IS '流程定義動态改變資訊表–ProcessDefinitionInfoEntityImpl';
COMMENT ON act_re_deployment IS '流程部署表–DeploymentEntityImpl';
COMMENT ON act_re_model IS '流程設計基本資訊';
COMMENT ON act_re_procdef IS '流程定義資訊表–ProcessDefinitionEntityImpl';
COMMENT ON act_ru_actinst IS '運作時節點資訊表–ActivityInstanceEntityImpl';
COMMENT ON act_ru_deadletter_job IS '死信表–DeadLetterJobEntityImpl';
COMMENT ON act_ru_event_subscr IS '事件訂閱表–EventSubscriptionEntityImpl';
COMMENT ON act_ru_execution IS '流程執行個體與分支執行表–ExecutionEntityImpl';
COMMENT ON act_ru_history_job IS '曆史作業表(flowable)–';
COMMENT ON act_ru_identitylink IS '參與者相關資訊表–IdentityLinkEntityImpl';
COMMENT ON act_ru_job IS '作業表–JobEntityImpl';
COMMENT ON act_ru_suspended_job IS '暫停作業表–SuspendedJobEntityImpl';
COMMENT ON act_ru_task IS '使用者任務表–TaskEntityImpl';
COMMENT ON act_ru_timer_job IS '定時器表–TimerJobEntityImpl';
COMMENT ON act_ru_variable IS '變量資訊–VariableInstanceEntityImpl';