SET MODE MYSQL;
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- auto-generated definition
create table IDX_DIMENSION
(
    DIMENSION_ID          BIGINT auto_increment
        primary key,
    CREATE_BY             CHARACTER,
    CREATE_TIME           TIMESTAMP,
    UPDATE_BY             CHARACTER,
    UPDATE_TIME           TIMESTAMP,
    DIMENSION_CODE        CHARACTER,
    DIMENSION_DESCRIPTION CHARACTER,
    DIMENSION_NAME        CHARACTER,
    INDEX_DIMENSION       BOOLEAN,
    TIME_DIMENSION        BOOLEAN
);


create table IDX_DIMENSION_ATTRIBUTE
(
    DIMENSION_ATTRIBUTE_ID BIGINT auto_increment
        primary key,
    CREATE_BY              CHARACTER,
    CREATE_TIME            TIMESTAMP,
    UPDATE_BY              CHARACTER,
    UPDATE_TIME            TIMESTAMP,
    ATTRIBUTE_CODE         CHARACTER,
    ATTRIBUTE_DESCRIPTION  CHARACTER,
    ATTRIBUTE_NAME         CHARACTER,
    CODE_ATTRIBUTE         BOOLEAN,
    KEY_ATTRIBUTE          BOOLEAN,
    DIMENSION_ID           BIGINT,
    constraint FK3PC4BATJ2JBLUJNRUHGFIV63G
        foreign key (DIMENSION_ID) references IDX_DIMENSION
);

create table IDX_FACT
(
    FACT_ID          BIGINT auto_increment
        primary key,
    CREATE_BY        CHARACTER,
    CREATE_TIME      TIMESTAMP,
    UPDATE_BY        CHARACTER,
    UPDATE_TIME      TIMESTAMP,
    FACT_CODE        CHARACTER,
    FACT_DESCRIPTION CHARACTER,
    FACT_NAME        CHARACTER
);

create table IDX_FACT_ATTRIBUTE
(
    FACT_ATTRIBUTE_ID     BIGINT auto_increment
        primary key,
    CREATE_BY             CHARACTER,
    CREATE_TIME           TIMESTAMP,
    UPDATE_BY             CHARACTER,
    UPDATE_TIME           TIMESTAMP,
    ATTRIBUTE_CODE        CHARACTER,
    ATTRIBUTE_DESCRIPTION CHARACTER,
    ATTRIBUTE_NAME        CHARACTER,
    FACT_ID               BIGINT,
    constraint FKS9HIC1SGFVP7J0NTA5LIOECD3
        foreign key (FACT_ID) references IDX_FACT
);

create table IDX_INDEXES
(
    INDEX_ID           BIGINT auto_increment
        primary key,
    CREATE_BY          CHARACTER,
    CREATE_TIME        TIMESTAMP,
    UPDATE_BY          CHARACTER,
    UPDATE_TIME        TIMESTAMP,
    BASED              BOOLEAN,
    ENABLED            BOOLEAN,
    INDEX_CALCULE_TYPE CHARACTER,
    INDEX_CATEGORY     CHARACTER,
    INDEX_CODE         CHARACTER,
    INDEX_DESCRIPTION  CHARACTER,
    INDEX_FOLDER_ID    CHARACTER,
    INDEX_NAME         CHARACTER,
    INDEX_TYPE         CHARACTER
);

create table IDX_MEASURE
(
    MEASURE_ID          BIGINT auto_increment
        primary key,
    CREATE_BY           CHARACTER,
    CREATE_TIME         TIMESTAMP,
    UPDATE_BY           CHARACTER,
    UPDATE_TIME         TIMESTAMP,
    MEASURE_CODE        CHARACTER,
    MEASURE_DESCRIPTION CHARACTER,
    MEASURE_NAME        CHARACTER,
    MEASURE_TYPE        CHARACTER,
    FACT_ID             BIGINT,
    constraint FK5LVBNRVJGJLN15PQ2C37FLEYJ
        foreign key (FACT_ID) references IDX_FACT
);

create table IDX_MODEL
(
    DIMENSION_ID          BIGINT auto_increment
        primary key,
    CREATE_BY             CHARACTER,
    CREATE_TIME           TIMESTAMP,
    UPDATE_BY             CHARACTER,
    UPDATE_TIME           TIMESTAMP,
    DIMENSION_CODE        CHARACTER,
    DIMENSION_DESCRIPTION CHARACTER,
    DIMENSION_NAME        CHARACTER,
    INDEX_DIMENSION       BOOLEAN,
    TIME_DIMENSION        BOOLEAN
);



BEGIN;
COMMIT;
SET FOREIGN_KEY_CHECKS = 1;