org.flowable.entitylink.service.db.create.flowable.gbase8s.create.entitylink.history.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of db-migration-flowable

db-migration 使用 Liquibase 支持 Flowable 工作流。

There is a newer version: 7.0.1.1

create table ACT_HI_ENTITYLINK (
    ID_ VARCHAR(64),
    LINK_TYPE_ VARCHAR(255),
    CREATE_TIME_ TIMESTAMP(6),
    SCOPE_ID_ VARCHAR(255),
    SUB_SCOPE_ID_ VARCHAR(255),
    SCOPE_TYPE_ VARCHAR(255),
    SCOPE_DEFINITION_ID_ VARCHAR(255),
    PARENT_ELEMENT_ID_ VARCHAR(255),
    REF_SCOPE_ID_ VARCHAR(255),
    REF_SCOPE_TYPE_ VARCHAR(255),
    REF_SCOPE_DEFINITION_ID_ VARCHAR(255),
    ROOT_SCOPE_ID_ VARCHAR(255),
    ROOT_SCOPE_TYPE_ VARCHAR(255),
    HIERARCHY_TYPE_ VARCHAR(255),
    primary key (ID_)
);

create index ACT_IDX_HI_ENT_LNK_SCOPE on ACT_HI_ENTITYLINK(SCOPE_ID_, SCOPE_TYPE_, LINK_TYPE_);
create index ACT_IDX_HI_ENT_LNK_REF_SCOPE on ACT_HI_ENTITYLINK(REF_SCOPE_ID_, REF_SCOPE_TYPE_, LINK_TYPE_);
create index ACT_IDX_HI_ENT_LNK_ROOT_SCOPE on ACT_HI_ENTITYLINK(ROOT_SCOPE_ID_, ROOT_SCOPE_TYPE_, LINK_TYPE_);
create index ACT_IDX_HI_ENT_LNK_SCOPE_DEF on ACT_HI_ENTITYLINK(SCOPE_DEFINITION_ID_, SCOPE_TYPE_, LINK_TYPE_);