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)