126 lines
3.3 KiB
PL/PgSQL
126 lines
3.3 KiB
PL/PgSQL
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;
|
|
|