WI ERD

Tables (24)

CUBE_ACT_ITEM_MSTR (Untitled)

  • ACT_ID(PK) (Key2) — Primary key — NOT NULL
  • UNI_NM(PK) (Key3) — Primary key — NOT NULL
  • CUBE_ID(PK) (Key4) — Foreign key → CUBE_MSTR.CUBE_ID(PK) — NOT NULL
  • DS_VIEW_ID(PK) (Key22) — Foreign key → CUBE_MSTR.DS_VIEW_ID(PK) — NOT NULL
  • ITEM_TYPE (Field)

CUBE_ACT_MSTR (Untitled2)

  • CUBE_ID(PK) (Key) — Primary key — NOT NULL
  • ACT_ID(PK) (Key2) — Primary key — NOT NULL
  • CUBE_ID(PK) (Key3) — Foreign key → CUBE_MSTR.CUBE_ID(PK) — NOT NULL
  • DS_VIEW_ID(PK) (Key22) — Foreign key → CUBE_MSTR.DS_VIEW_ID(PK) — NOT NULL
  • ACT_NM (Field)
  • MEA_GRP_UNI_NM (Field2)
  • MAX_ROWS (Field3)
  • ACT_DESC (Field4)

CUBE_ACT_RTN_ITEM (Untitled5)

  • ACT_ID(PK) (Key2) — Primary key — NOT NULL
  • UNI_NM(PK) (Key3) — Primary key — NOT NULL
  • RTN_ITEM_UNI_NM(PK) (Key4) — Primary key — NOT NULL
  • CUBE_ID(PK) (Key5) — Foreign key → CUBE_MSTR.CUBE_ID(PK) — NOT NULL
  • DS_VIEW_ID(PK) (Key22) — Foreign key → CUBE_MSTR.DS_VIEW_ID(PK) — NOT NULL
  • ORDINAL (Field)

CUBE_DIM_MSTR (Untitled4)

  • DIM_UNI_NM(PK) (Key2) — Primary key — NOT NULL
  • CUBE_ID(PK) (Key3) — Foreign key → CUBE_MSTR.CUBE_ID(PK) — NOT NULL
  • DS_VIEW_ID(PK) (Key22) — Foreign key → CUBE_MSTR.DS_VIEW_ID(PK) — NOT NULL
  • DIM_CAPTION (Field)
  • DIM_ORDINAL (Field2)
  • DIM_IS_VISIBLE (Field3)
  • DIM_DIM_UNI_NM (Field4)

CUBE_HIE_LVL_MSTR (Untitled3)

  • DIM_UNI_NM(PK) (Key2) — Primary key — NOT NULL
  • HIE_UNI_NM(PK) (Key3) — Primary key — NOT NULL
  • LVL_UNI_NM(PK) (Key4) — Primary key — NOT NULL
  • CUBE_ID(PK) (Key) — Foreign key → CUBE_MSTR.CUBE_ID(PK) — NOT NULL
  • DS_VIEW_ID(PK) (Key22) — Foreign key → CUBE_MSTR.DS_VIEW_ID(PK) — NOT NULL
  • LVL_CAPTION (Field)
  • LVL (Field2)

CUBE_HIE_MSTR (Untitled6)

  • HIE_UNI_NM(PK) (Key2) — Primary key — NOT NULL
  • DIM_UNI_NM(PK) (Key3) — Primary key — NOT NULL
  • CUBE_ID(PK) (Key4) — Foreign key → CUBE_MSTR.CUBE_ID(PK) — NOT NULL
  • DS_VIEW_ID(PK) (Key22) — Foreign key → CUBE_MSTR.DS_VIEW_ID(PK) — NOT NULL
  • HIE_CAPTION (Field)
  • HIE_ORDINAL (Field2)
  • HIE_IS_VISIBLE (Field3)
  • DIM_DIM_UNI_NM (Field4)
  • HIE_HIE_UNI_NM (Field5)
  • HIE_FORMAT_STR (Field6)

CUBE_MEA_GRP_MSTR (Untitled7)

  • MEA_GRP_UNI_NM(PK) (Key2) — Primary key — NOT NULL
  • CUBE_ID(PK) (Key3) — Foreign key → CUBE_MSTR.CUBE_ID(PK) — NOT NULL
  • DS_VIEW_ID(PK) (Key22) — Foreign key → CUBE_MSTR.DS_VIEW_ID(PK) — NOT NULL
  • MEA_GRP_CAPTION (Field)
  • TBL_NM (Field2)
  • IS_VISIBLE (Field3)
  • MEA_GRP_ORDINAL (Field4)

CUBE_MEA_MSTR (Untitled8)

  • MEA_GRP_UNI_NM(PK) (Key2) — Primary key — NOT NULL
  • MEA_UNI_NM(PK) (Key3) — Primary key — NOT NULL
  • CUBE_ID(PK) (Key4) — Foreign key → CUBE_MSTR.CUBE_ID(PK) — NOT NULL
  • DS_VIEW_ID(PK) (Key22) — Foreign key → CUBE_MSTR.DS_VIEW_ID(PK) — NOT NULL
  • MEA_CAPTION (Field)
  • MEA_AGG (Field2)
  • MEA_DESC (Field3)
  • MEA_IS_VISIBLE (Field4)
  • MEA_TBL_NM (Field5)
  • MEA_COL_NM (Field6)
  • MEA_DSP_FLD (Field7)
  • MEA_FORMAT_STR (Field8)
  • MEA_ORDINAL (Field9)
  • REG_USER_NO (Field10)
  • REG_DT (Field11)
  • UPD_USER_NO (Field12)
  • UPD_DT (Field13)

CUBE_MSTR (Untitled9)

  • CUBE_ID(PK) (Key) — Primary key — NOT NULL
  • DS_VIEW_ID(PK) (Key2) — Foreign key → DS_VIEW_MSTR.DS_VIEW_ID(PK) — NOT NULL
  • CUBE_NM (Field2)
  • CUBE_DESC (Field3)
  • CUBE_ORDINAL (Field4)

CUBE_REL_MSTR (Untitled10)

  • CONST_NM (Key2) — Primary key — NOT NULL
  • CUBE_ID(PK) (Key) — Foreign key → CUBE_MSTR.CUBE_ID(PK) — NOT NULL
  • DS_VIEW_ID(PK) (Key22) — Foreign key → CUBE_MSTR.DS_VIEW_ID(PK) — NOT NULL
  • FK_TBL_NM (Field)
  • FK_COL_NM (Field2)
  • PK_TBL_NM (Field3)
  • PK_COL_NM (Field4)
  • JOIN_TYPE (Field5)
  • JOIN_SET_OWNER (Field6)
  • REL_CONST_NM (Field7)
  • DIM_UNI_NM (Field8)
  • MEA_GRP_UNI_NM (Field9)

CUBE_SNOWFLAKE_MSTR (Untitled11)

  • CUBE_ID(PK) (Key) — Foreign key → CUBE_MSTR.CUBE_ID(PK) — NOT NULL
  • DS_VIEW_ID(PK) (Key2) — Foreign key → CUBE_MSTR.DS_VIEW_ID(PK) — NOT NULL
  • TBL_CAPTION (Field)
  • TBL_NM (Field2)
  • DIM_UNI_NM (Field3)
  • DIM_CAPTION (Field4)
  • KEY_TBL_NM (Field5)
  • PARENT_TBL_NM (Field6)
  • PARENT_TBL_CAPTION (Field7)

DATASET_FLD_MSTR (Untitled12)

  • FLD_ID(PK) (Key) — Primary key — NOT NULL
  • FLD_NM (Field)
  • PARENT_FLD_ID (Field2)
  • FLD_ORDINAL (Field3)

DATASET_MSTR (Untitled13)

  • DATASET_ID(PK) (Key) — Primary key — NOT NULL
  • DATASET_NM (Key2) — Primary key — NOT NULL
  • DATASRC_ID (Key3) — Primary key — NOT NULL
  • DATASRC_TYPE (Key4) — Primary key — NOT NULL
  • FLD_ID(PK) (Key5) — Foreign key → DATASET_FLD_MSTR.FLD_ID(PK) — NOT NULL
  • DATASET_TYPE (Field2)
  • SQL_XML (Field3)
  • SQL_QUERY (Field4)
  • DATASET_DESC (Field5)
  • DATASET_ORDINAL (Field6)
  • REG_USER_NO (Field7)
  • REG_DT (Field8)
  • MOD_USER_NO (Field9)
  • MOD_DT (Field10)

DS_MSTR (Untitled14)

  • DS_ID (Key) — Primary key — NOT NULL
  • DS_NM (Field)
  • DB_NM (Field2)
  • IP (Field3)
  • USER_ID (Field4)
  • PASSWD (Field5)
  • PORT (Field6)
  • DBMS_TYPE (Field7)
  • OWNER_NM (Field8)
  • DS_DESC (Field9)
  • DS_CONNSTR (Field10)
  • REG_DT (Field11)
  • REG_USER_NO (Field12)
  • UPD_DT (Field13)
  • UPD_USER_NO (Field14)
  • RACIP (Field15)
  • RACPORT (Field16)
  • WF_YN (Field17)
  • USER_AREA_YN8 (Field18)
  • CONN_TYPE (Field19)

DS_VIEW_COL_MSTR (Untitled15)

  • COL_NM(PK) (Key3) — Primary key — NOT NULL
  • DIM_UNI_NM(PK) (Key32) — Foreign key → DS_VIEW_DIM_TBL_MSTR.DIM_UNI_NM(PK) — NOT NULL
  • TBL_NM(PK) (Key) — Foreign key → DS_VIEW_DIM_TBL_MSTR.TBL_NM(PK) — NOT NULL
  • DS_VIEW_ID(PK) (Key322) — Foreign key → DS_VIEW_DIM_TBL_MSTR.DS_VIEW_ID(PK) — NOT NULL
  • COL_CAPTION (Field)
  • DATA_TYPE (Field2)
  • LENGTH (Field3)
  • PK_YN (Field4)
  • COL_DESC (Field5)
  • COL_EXPRESS (Field6)
  • ALLOW_NULL (Field7)
  • COL_ID (Field8)
  • REG_USER_NO (Field9)
  • REG_DT (Field10)
  • UPD_USER_NO (Field11)
  • UPD_DT (Field12)
  • POPUP (Field13)

DS_VIEW_DIG_MSTR (Untitled16)

  • DS_VIEW_ID(PK) (Key) — Primary key — NOT NULL
  • DIG_ID(PK) (Key2) — Primary key — NOT NULL
  • DIG_NM (Key3) — Primary key — NOT NULL
  • DS_VIEW_ID(PK) (Key5) — Foreign key → DS_VIEW_LVL_MSTR.DS_VIEW_ID(PK) — NOT NULL
  • DIG_ORDINAL (Field)

DS_VIEW_DIG_TBL_MSTR (Untitled17)

  • DS_VIEW_ID(PK) (Key) — Primary key — NOT NULL
  • DIG_ID(PK) (Key2) — Primary key — NOT NULL
  • TBL_NM(PK) (Key3) — Primary key — NOT NULL

DS_VIEW_DIM_MSTR (Untitled18)

  • DIM_UNI_NM(PK) (Key3) — Foreign key → DS_VIEW_DIM_TBL_MSTR.DIM_UNI_NM(PK) — NOT NULL
  • TBL_NM(PK) (Key) — Foreign key → DS_VIEW_DIM_TBL_MSTR.TBL_NM(PK) — NOT NULL
  • DS_VIEW_ID(PK) (Key32) — Foreign key → DS_VIEW_DIM_TBL_MSTR.DS_VIEW_ID(PK) — NOT NULL
  • DIM_CAPTION (Field)
  • DIM_ORDINAL (Field2)
  • DIM_DESC (Field3)
  • TBL_NM (Field4)
  • REG_USER_NO (Field5)
  • REG_DT (Field6)
  • UPD_USER_NO (Field7)
  • UPD_DT (Field8)

DS_VIEW_DIM_TBL_MSTR (Untitled19)

  • DIM_UNI_NM(PK) (Key3) — Primary key — NOT NULL
  • TBL_NM(PK) (Key) — Foreign key → DS_VIEW_TBL_MSTR.TBL_NM(PK) — NOT NULL
  • DS_VIEW_ID(PK) (Key32) — Foreign key → DS_VIEW_TBL_MSTR.DS_VIEW_ID(PK) — NOT NULL
  • TOP_LVL (Field)

DS_VIEW_HIE_MSTR (Untitled20)

  • DIM_UNI_NM(PK) (Key22) — Foreign key → DS_VIEW_LVL_MSTR.DIM_UNI_NM(PK) — NOT NULL
  • HIE_UNI_NM(PK) (Key32) — Foreign key → DS_VIEW_LVL_MSTR.HIE_UNI_NM(PK) — NOT NULL
  • DS_VIEW_ID(PK) (Key5) — Foreign key → DS_VIEW_LVL_MSTR.DS_VIEW_ID(PK) — NOT NULL
  • HIE_CAPTION (Field)
  • HIE_DESC (Field2)
  • HIE_ORDINAL (Field3)
  • HIE_DSP_FLD (Field4)
  • TBL_NM (Field5)
  • KEY_COL (Field6)
  • NAME_COL (Field7)
  • IS_AUTH (Field8)
  • IS_DATEKEY (Field9)
  • IS_NOLOADING (Field10)
  • ORDER_BY (Field11)
  • LVL_TAG (Field12)
  • REG_USER_NO (Field13)
  • REG_DT (Field14)
  • UPD_UER_NO (Field15)
  • UPD_DT (Field16)

DS_VIEW_LVL_MSTR (Untitled21)

  • DIM_UNI_NM(PK) (Key2) — Primary key — NOT NULL
  • HIE_UNI_NM(PK) (Key3) — Primary key — NOT NULL
  • LVL_UNI_NM(PK) (Key4) — Primary key — NOT NULL
  • DS_VIEW_ID(PK) (Key5) — Foreign key → DS_VIEW_MSTR.DS_VIEW_ID(PK) — NOT NULL
  • LVL_CAPTION (Field)
  • LVL (Field2)

DS_VIEW_MSTR (Untitled22)

  • DS_VIEW_ID(PK) (Key) — Primary key — NOT NULL
  • DS_ID (Key2) — Foreign key → DS_MSTR.DS_ID — NOT NULL
  • DS_VIEW_NM (Field2)
  • DS_VIEW_DESC (Field3)

DS_VIEW_REL_MSTR (Untitled23)

  • DS_VIEW_ID(PK) (Key) — Foreign key → DS_VIEW_MSTR.DS_VIEW_ID(PK) — NOT NULL
  • CONST_NM (Field2)
  • FK_TBL_NM (Field3)
  • FK_COL_NM (Field4)
  • PK_TBL_NM (Field5)
  • PK_COL_NM (Field6)
  • JOIN_TYPE (Field7)
  • JOIN_SET_OWNER (Field8)

DS_VIEW_TBL_MSTR (Untitled24)

  • TBL_NM(PK) (Key) — Primary key — NOT NULL
  • DS_VIEW_ID(PK) (Key3) — Foreign key → DS_VIEW_MSTR.DS_VIEW_ID(PK) — NOT NULL
  • TBL_CAPTION (Field)
  • TBL_DESC (Field2)
  • TBL_TYPE (Field3)
  • TBL_GRP_NM (Field4)
  • QUERY_DEFINITION (Field5)
  • REG_USER_NO (Field6)
  • REG_DT (Field7)
  • UPD_USER_NO (Field8)
  • UPD_DT (Field9)