天天看点

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