"W_USER_UGRP_LIST to W_ACTION_RIGHTS" |
RelationshipType | Non-Identifying |
Relationship Name | F00007 |
Relationship Business Name | |
Parent Table | W_USER_UGRP_LIST |
Child Table | W_ACTION_RIGHTS |
Existence | Mandatory |
"W_USER_UGRP_LIST to W_ACTION_RIGHTS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_USER_UGRP_LIST to W_ACTION_RIGHTS" Foreign Keys |
Parent Key | Child Key |
SEC_OBJ_ID | SEC_OBJ_ID |
"W_USER_UGRP_LIST to W_APP_RIGHTS" |
RelationshipType | Non-Identifying |
Relationship Name | F00008 |
Relationship Business Name | |
Parent Table | W_USER_UGRP_LIST |
Child Table | W_APP_RIGHTS |
Existence | Mandatory |
"W_USER_UGRP_LIST to W_APP_RIGHTS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_USER_UGRP_LIST to W_APP_RIGHTS" Foreign Keys |
Parent Key | Child Key |
SEC_OBJ_ID | SEC_OBJ_ID |
"W_SYS_SETTINGS to W_FILE_UPLD_CFG" |
RelationshipType | Non-Identifying |
Relationship Name | F00009 |
Relationship Business Name | |
Parent Table | W_SYS_SETTINGS |
Child Table | W_FILE_UPLD_CFG |
Existence | Mandatory |
"W_SYS_SETTINGS to W_FILE_UPLD_CFG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_SYS_SETTINGS to W_FILE_UPLD_CFG" Foreign Keys |
Parent Key | Child Key |
COMPANY_ID | COMPANY_ID |
"W_LOCATION_LIST to W_LOC_USER_LINKS" |
RelationshipType | Non-Identifying |
Relationship Name | F00010 |
Relationship Business Name | |
Parent Table | W_LOCATION_LIST |
Child Table | W_LOC_USER_LINKS |
Existence | Mandatory |
"W_LOCATION_LIST to W_LOC_USER_LINKS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_LOCATION_LIST to W_LOC_USER_LINKS" Foreign Keys |
Parent Key | Child Key |
LOCATION_ID | LOCATION_ID |
"W_USER_UGRP_LIST to W_LOC_USER_LINKS" |
RelationshipType | Non-Identifying |
Relationship Name | F00011 |
Relationship Business Name | |
Parent Table | W_USER_UGRP_LIST |
Child Table | W_LOC_USER_LINKS |
Existence | Mandatory |
"W_USER_UGRP_LIST to W_LOC_USER_LINKS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_USER_UGRP_LIST to W_LOC_USER_LINKS" Foreign Keys |
Parent Key | Child Key |
SEC_OBJ_ID | SEC_OBJ_ID |
"W_USER_UGRP_LIST to W_MENU_APP_RIGHTS" |
RelationshipType | Non-Identifying |
Relationship Name | F00012 |
Relationship Business Name | |
Parent Table | W_USER_UGRP_LIST |
Child Table | W_MENU_APP_RIGHTS |
Existence | Mandatory |
"W_USER_UGRP_LIST to W_MENU_APP_RIGHTS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_USER_UGRP_LIST to W_MENU_APP_RIGHTS" Foreign Keys |
Parent Key | Child Key |
SEC_OBJ_ID | USER_ID |
"W_USER_UGRP_LIST to W_MODULE_RIGHTS" |
RelationshipType | Non-Identifying |
Relationship Name | F00013 |
Relationship Business Name | |
Parent Table | W_USER_UGRP_LIST |
Child Table | W_MODULE_RIGHTS |
Existence | Mandatory |
"W_USER_UGRP_LIST to W_MODULE_RIGHTS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_USER_UGRP_LIST to W_MODULE_RIGHTS" Foreign Keys |
Parent Key | Child Key |
SEC_OBJ_ID | SEC_OBJ_ID |
"W_RPT_CATGR to W_PRN_RPTCT_LINKS" |
RelationshipType | Non-Identifying |
Relationship Name | F00014 |
Relationship Business Name | |
Parent Table | W_RPT_CATGR |
Child Table | W_PRN_RPTCT_LINKS |
Existence | Mandatory |
"W_RPT_CATGR to W_PRN_RPTCT_LINKS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_RPT_CATGR to W_PRN_RPTCT_LINKS" Foreign Keys |
Parent Key | Child Key |
CATGR_CD | CATGR_CD |
"W_PRINTER_LIST to W_PRN_RPTCT_LINKS" |
RelationshipType | Non-Identifying |
Relationship Name | F00015 |
Relationship Business Name | |
Parent Table | W_PRINTER_LIST |
Child Table | W_PRN_RPTCT_LINKS |
Existence | Mandatory |
"W_PRINTER_LIST to W_PRN_RPTCT_LINKS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_PRINTER_LIST to W_PRN_RPTCT_LINKS" Foreign Keys |
Parent Key | Child Key |
ID | PRINTER_ID |
"W_PRINTER_LIST to W_PRN_USER_LINKS" |
RelationshipType | Non-Identifying |
Relationship Name | F00016 |
Relationship Business Name | |
Parent Table | W_PRINTER_LIST |
Child Table | W_PRN_USER_LINKS |
Existence | Mandatory |
"W_PRINTER_LIST to W_PRN_USER_LINKS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_PRINTER_LIST to W_PRN_USER_LINKS" Foreign Keys |
Parent Key | Child Key |
ID | PRINTER_ID |
"W_USER_UGRP_LIST to W_PRN_USER_LINKS" |
RelationshipType | Non-Identifying |
Relationship Name | F00017 |
Relationship Business Name | |
Parent Table | W_USER_UGRP_LIST |
Child Table | W_PRN_USER_LINKS |
Existence | Mandatory |
"W_USER_UGRP_LIST to W_PRN_USER_LINKS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_USER_UGRP_LIST to W_PRN_USER_LINKS" Foreign Keys |
Parent Key | Child Key |
SEC_OBJ_ID | SEC_OBJ_ID |
"W_USER_UGRP_LIST to W_RPT_ARCH_RIGHTS" |
RelationshipType | Non-Identifying |
Relationship Name | F00018 |
Relationship Business Name | |
Parent Table | W_USER_UGRP_LIST |
Child Table | W_RPT_ARCH_RIGHTS |
Existence | Mandatory |
"W_USER_UGRP_LIST to W_RPT_ARCH_RIGHTS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_USER_UGRP_LIST to W_RPT_ARCH_RIGHTS" Foreign Keys |
Parent Key | Child Key |
SEC_OBJ_ID | SEC_OBJ_ID |
"W_RPT_GROUP_LIST to W_RPT_GROUP_LINKS" |
RelationshipType | Non-Identifying |
Relationship Name | F00019 |
Relationship Business Name | |
Parent Table | W_RPT_GROUP_LIST |
Child Table | W_RPT_GROUP_LINKS |
Existence | Mandatory |
"W_RPT_GROUP_LIST to W_RPT_GROUP_LINKS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_RPT_GROUP_LIST to W_RPT_GROUP_LINKS" Foreign Keys |
Parent Key | Child Key |
GRP_ID | GRP_ID |
"W_USER_UGRP_LIST to W_RPT_RIGHTS" |
RelationshipType | Non-Identifying |
Relationship Name | F00020 |
Relationship Business Name | |
Parent Table | W_USER_UGRP_LIST |
Child Table | W_RPT_RIGHTS |
Existence | Mandatory |
"W_USER_UGRP_LIST to W_RPT_RIGHTS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_USER_UGRP_LIST to W_RPT_RIGHTS" Foreign Keys |
Parent Key | Child Key |
SEC_OBJ_ID | SEC_OBJ_ID |
"W_USER_UGRP_LIST to W_RS_RIGHTS" |
RelationshipType | Non-Identifying |
Relationship Name | F00021 |
Relationship Business Name | |
Parent Table | W_USER_UGRP_LIST |
Child Table | W_RS_RIGHTS |
Existence | Mandatory |
"W_USER_UGRP_LIST to W_RS_RIGHTS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_USER_UGRP_LIST to W_RS_RIGHTS" Foreign Keys |
Parent Key | Child Key |
SEC_OBJ_ID | SEC_OBJ_ID |
"W_SYS_SETTINGS to W_SYS_LOGOS" |
RelationshipType | Non-Identifying |
Relationship Name | F00022 |
Relationship Business Name | |
Parent Table | W_SYS_SETTINGS |
Child Table | W_SYS_LOGOS |
Existence | Mandatory |
"W_SYS_SETTINGS to W_SYS_LOGOS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_SYS_SETTINGS to W_SYS_LOGOS" Foreign Keys |
Parent Key | Child Key |
COMPANY_ID | COMPANY_ID |
"W_USER_UGRP_LIST to W_USER_COMPANY" |
RelationshipType | Non-Identifying |
Relationship Name | F00023 |
Relationship Business Name | |
Parent Table | W_USER_UGRP_LIST |
Child Table | W_USER_COMPANY |
Existence | Mandatory |
"W_USER_UGRP_LIST to W_USER_COMPANY" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_USER_UGRP_LIST to W_USER_COMPANY" Foreign Keys |
Parent Key | Child Key |
SEC_OBJ_ID | USER_ID |
"W_USER_UGRP_LIST to W_USER_GRP_USERS" |
RelationshipType | Non-Identifying |
Relationship Name | F00024 |
Relationship Business Name | |
Parent Table | W_USER_UGRP_LIST |
Child Table | W_USER_GRP_USERS |
Existence | Mandatory |
"W_USER_UGRP_LIST to W_USER_GRP_USERS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_USER_UGRP_LIST to W_USER_GRP_USERS" Foreign Keys |
Parent Key | Child Key |
SEC_OBJ_ID | USER_ID |
"W_USER_UGRP_LIST to W_USER_GRP_USERS" |
RelationshipType | Non-Identifying |
Relationship Name | F00025 |
Relationship Business Name | |
Parent Table | W_USER_UGRP_LIST |
Child Table | W_USER_GRP_USERS |
Existence | Mandatory |
"W_USER_UGRP_LIST to W_USER_GRP_USERS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_USER_UGRP_LIST to W_USER_GRP_USERS" Foreign Keys |
Parent Key | Child Key |
SEC_OBJ_ID | SEC_OBJ_ID |
"W_USER_UGRP_LIST to W_USER_PSWD_HS" |
RelationshipType | Non-Identifying |
Relationship Name | F00026 |
Relationship Business Name | |
Parent Table | W_USER_UGRP_LIST |
Child Table | W_USER_PSWD_HS |
Existence | Mandatory |
"W_USER_UGRP_LIST to W_USER_PSWD_HS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_USER_UGRP_LIST to W_USER_PSWD_HS" Foreign Keys |
Parent Key | Child Key |
SEC_OBJ_ID | USER_ID |
"W_APP_CONF_TYPE to W_APP_CONFLICTS" |
RelationshipType | Non-Identifying |
Relationship Name | F00029 |
Relationship Business Name | |
Parent Table | W_APP_CONF_TYPE |
Child Table | W_APP_CONFLICTS |
Existence | Optional |
"W_APP_CONF_TYPE to W_APP_CONFLICTS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_APP_CONF_TYPE to W_APP_CONFLICTS" Foreign Keys |
Parent Key | Child Key |
APP_CNF_TYPE_CD | APP_CNF_TYPE_CD |
"W_USER_UGRP_LIST to W_USER_QUERY" |
RelationshipType | Identifying |
Relationship Name | F00030 |
Relationship Business Name | |
Parent Table | W_USER_UGRP_LIST |
Child Table | W_USER_QUERY |
Existence | Mandatory |
"W_USER_UGRP_LIST to W_USER_QUERY" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_USER_UGRP_LIST to W_USER_QUERY" Foreign Keys |
Parent Key | Child Key |
SEC_OBJ_ID | USER_ID |
"W_EXT_PROJ_LIST to W_EXT_UNIT_LIST" |
RelationshipType | Non-Identifying |
Relationship Name | F00031 |
Relationship Business Name | |
Parent Table | W_EXT_PROJ_LIST |
Child Table | W_EXT_UNIT_LIST |
Existence | Mandatory |
"W_EXT_PROJ_LIST to W_EXT_UNIT_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_EXT_PROJ_LIST to W_EXT_UNIT_LIST" Foreign Keys |
Parent Key | Child Key |
EXT_PROJ_ID | EXT_PROJ_ID |
"W_EXT_METHOD_LIST to W_EXT_METHOD_PARMS" |
RelationshipType | Non-Identifying |
Relationship Name | F00032 |
Relationship Business Name | |
Parent Table | W_EXT_METHOD_LIST |
Child Table | W_EXT_METHOD_PARMS |
Existence | Mandatory |
"W_EXT_METHOD_LIST to W_EXT_METHOD_PARMS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_EXT_METHOD_LIST to W_EXT_METHOD_PARMS" Foreign Keys |
Parent Key | Child Key |
EXT_UNIT_ID, OBJ_TYPE, OBJ_ID, WHEN_CD, METHOD_KEY | EXT_UNIT_ID, OBJ_TYPE, OBJ_ID, WHEN_CD, METHOD_KEY |
"W_RS_LIST to W_RS_DESC" |
RelationshipType | Non-Identifying |
Relationship Name | F00033 |
Relationship Business Name | |
Parent Table | W_RS_LIST |
Child Table | W_RS_DESC |
Existence | Mandatory |
"W_RS_LIST to W_RS_DESC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_RS_LIST to W_RS_DESC" Foreign Keys |
Parent Key | Child Key |
RS_ID, EXT_UNIT_ID | RS_ID, EXT_UNIT_ID |
"W_RS_LIST to W_RS_PRESENTATION" |
RelationshipType | Non-Identifying |
Relationship Name | F00034 |
Relationship Business Name | |
Parent Table | W_RS_LIST |
Child Table | W_RS_PRESENTATION |
Existence | Mandatory |
"W_RS_LIST to W_RS_PRESENTATION" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_RS_LIST to W_RS_PRESENTATION" Foreign Keys |
Parent Key | Child Key |
RS_ID, EXT_UNIT_ID | RS_ID, EXT_UNIT_ID |
"W_EXT_UNIT_LIST to W_RS_LIST" |
RelationshipType | Identifying |
Relationship Name | F00035 |
Relationship Business Name | |
Parent Table | W_EXT_UNIT_LIST |
Child Table | W_RS_LIST |
Existence | Mandatory |
"W_EXT_UNIT_LIST to W_RS_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_EXT_UNIT_LIST to W_RS_LIST" Foreign Keys |
Parent Key | Child Key |
EXT_UNIT_ID | EXT_UNIT_ID |
"W_EXT_UNIT_LIST to W_EXT_METHOD_LIST" |
RelationshipType | Identifying |
Relationship Name | F00036 |
Relationship Business Name | |
Parent Table | W_EXT_UNIT_LIST |
Child Table | W_EXT_METHOD_LIST |
Existence | Mandatory |
"W_EXT_UNIT_LIST to W_EXT_METHOD_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_EXT_UNIT_LIST to W_EXT_METHOD_LIST" Foreign Keys |
Parent Key | Child Key |
EXT_UNIT_ID | EXT_UNIT_ID |
"W_EXT_UNIT_LIST to W_RS_HTML" |
RelationshipType | Non-Identifying |
Relationship Name | F00037 |
Relationship Business Name | |
Parent Table | W_EXT_UNIT_LIST |
Child Table | W_RS_HTML |
Existence | Optional |
"W_EXT_UNIT_LIST to W_RS_HTML" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_EXT_UNIT_LIST to W_RS_HTML" Foreign Keys |
Parent Key | Child Key |
EXT_UNIT_ID | EXT_UNIT_ID |
"W_EXT_UNIT_LIST to W_RESOURCE_LIB" |
RelationshipType | Non-Identifying |
Relationship Name | F00038 |
Relationship Business Name | |
Parent Table | W_EXT_UNIT_LIST |
Child Table | W_RESOURCE_LIB |
Existence | Mandatory |
"W_EXT_UNIT_LIST to W_RESOURCE_LIB" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_EXT_UNIT_LIST to W_RESOURCE_LIB" Foreign Keys |
Parent Key | Child Key |
EXT_UNIT_ID | EXT_UNIT_ID |
"W_EXT_UNIT_LIST to W_CONST_LIST" |
RelationshipType | Non-Identifying |
Relationship Name | F00039 |
Relationship Business Name | |
Parent Table | W_EXT_UNIT_LIST |
Child Table | W_CONST_LIST |
Existence | Mandatory |
"W_EXT_UNIT_LIST to W_CONST_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_EXT_UNIT_LIST to W_CONST_LIST" Foreign Keys |
Parent Key | Child Key |
EXT_UNIT_ID | EXT_UNIT_ID |
"W_EXT_UNIT_LIST to W_APP_LIST" |
RelationshipType | Identifying |
Relationship Name | F00040 |
Relationship Business Name | |
Parent Table | W_EXT_UNIT_LIST |
Child Table | W_APP_LIST |
Existence | Mandatory |
"W_EXT_UNIT_LIST to W_APP_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_EXT_UNIT_LIST to W_APP_LIST" Foreign Keys |
Parent Key | Child Key |
EXT_UNIT_ID | EXT_UNIT_ID |
"W_EXT_UNIT_LIST to W_ACTION_LIST" |
RelationshipType | Identifying |
Relationship Name | F00041 |
Relationship Business Name | |
Parent Table | W_EXT_UNIT_LIST |
Child Table | W_ACTION_LIST |
Existence | Mandatory |
"W_EXT_UNIT_LIST to W_ACTION_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_EXT_UNIT_LIST to W_ACTION_LIST" Foreign Keys |
Parent Key | Child Key |
EXT_UNIT_ID | EXT_UNIT_ID |
"W_EXT_UNIT_LIST to W_MOD_APP_LINKS" |
RelationshipType | Non-Identifying |
Relationship Name | F00042 |
Relationship Business Name | |
Parent Table | W_EXT_UNIT_LIST |
Child Table | W_MOD_APP_LINKS |
Existence | Mandatory |
"W_EXT_UNIT_LIST to W_MOD_APP_LINKS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_EXT_UNIT_LIST to W_MOD_APP_LINKS" Foreign Keys |
Parent Key | Child Key |
EXT_UNIT_ID | EXT_UNIT_ID |
"W_RPT_LIST to W_RPT_DATA_SRC" |
RelationshipType | Identifying |
Relationship Name | F00043 |
Relationship Business Name | |
Parent Table | W_RPT_LIST |
Child Table | W_RPT_DATA_SRC |
Existence | Mandatory |
"W_RPT_LIST to W_RPT_DATA_SRC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_RPT_LIST to W_RPT_DATA_SRC" Foreign Keys |
Parent Key | Child Key |
RPT_ID, EXT_UNIT_ID | RPT_ID, EXT_UNIT_ID |
"W_RPT_LIST to W_RPT_DS_VARS" |
RelationshipType | Non-Identifying |
Relationship Name | F00044 |
Relationship Business Name | |
Parent Table | W_RPT_LIST |
Child Table | W_RPT_DS_VARS |
Existence | Mandatory |
"W_RPT_LIST to W_RPT_DS_VARS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_RPT_LIST to W_RPT_DS_VARS" Foreign Keys |
Parent Key | Child Key |
RPT_ID, EXT_UNIT_ID | RPT_ID, EXT_UNIT_ID |
"W_RPT_LIST to W_RPT_DS_RS_SRC" |
RelationshipType | Non-Identifying |
Relationship Name | F00045 |
Relationship Business Name | |
Parent Table | W_RPT_LIST |
Child Table | W_RPT_DS_RS_SRC |
Existence | Mandatory |
"W_RPT_LIST to W_RPT_DS_RS_SRC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_RPT_LIST to W_RPT_DS_RS_SRC" Foreign Keys |
Parent Key | Child Key |
RPT_ID, EXT_UNIT_ID | RPT_ID, EXT_UNIT_ID |
"W_USER_UGRP_LIST to W_USER_CONFIG" |
RelationshipType | Identifying |
Relationship Name | F00046 |
Relationship Business Name | |
Parent Table | W_USER_UGRP_LIST |
Child Table | W_USER_CONFIG |
Existence | Mandatory |
"W_USER_UGRP_LIST to W_USER_CONFIG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_USER_UGRP_LIST to W_USER_CONFIG" Foreign Keys |
Parent Key | Child Key |
SEC_OBJ_ID | USER_ID |
"W_USER_CONFIG to W_USER_CONFIG_RS" |
RelationshipType | Non-Identifying |
Relationship Name | F00047 |
Relationship Business Name | |
Parent Table | W_USER_CONFIG |
Child Table | W_USER_CONFIG_RS |
Existence | Mandatory |
"W_USER_CONFIG to W_USER_CONFIG_RS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_USER_CONFIG to W_USER_CONFIG_RS" Foreign Keys |
Parent Key | Child Key |
USER_ID, S_CONFIG_TYPE, CONFIG_SCOPE | USER_ID, S_CONFIG_TYPE, APP_ID |
"W_UI_PROF to W_UI_PROF_USERS" |
RelationshipType | Identifying |
Relationship Name | F00048 |
Relationship Business Name | |
Parent Table | W_UI_PROF |
Child Table | W_UI_PROF_USERS |
Existence | Mandatory |
"W_UI_PROF to W_UI_PROF_USERS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_UI_PROF to W_UI_PROF_USERS" Foreign Keys |
Parent Key | Child Key |
PROFILE_ID | PROFILE_ID |
"W_USER_UGRP_LIST to W_UI_PROF_USERS" |
RelationshipType | Identifying |
Relationship Name | F00049 |
Relationship Business Name | |
Parent Table | W_USER_UGRP_LIST |
Child Table | W_UI_PROF_USERS |
Existence | Mandatory |
"W_USER_UGRP_LIST to W_UI_PROF_USERS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_USER_UGRP_LIST to W_UI_PROF_USERS" Foreign Keys |
Parent Key | Child Key |
SEC_OBJ_ID | SEC_OBJ_ID |
"W_UI_PROF to W_UI_PROF_DESC" |
RelationshipType | Identifying |
Relationship Name | F00050 |
Relationship Business Name | |
Parent Table | W_UI_PROF |
Child Table | W_UI_PROF_DESC |
Existence | Mandatory |
"W_UI_PROF to W_UI_PROF_DESC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_UI_PROF to W_UI_PROF_DESC" Foreign Keys |
Parent Key | Child Key |
PROFILE_ID | PROFILE_ID |
"W_UI_PROF_DESC to W_UI_PROF_RS_CSTM" |
RelationshipType | Non-Identifying |
Relationship Name | F00051 |
Relationship Business Name | |
Parent Table | W_UI_PROF_DESC |
Child Table | W_UI_PROF_RS_CSTM |
Existence | Mandatory |
"W_UI_PROF_DESC to W_UI_PROF_RS_CSTM" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_UI_PROF_DESC to W_UI_PROF_RS_CSTM" Foreign Keys |
Parent Key | Child Key |
PROFILE_ID, S_PROFILE_TYPE, PROFILE_SCOPE | PROFILE_ID, S_PROFILE_TYPE, APP_ID |
"W_UI_PROF to W_UI_PROF_MYMENU" |
RelationshipType | Non-Identifying |
Relationship Name | F00052 |
Relationship Business Name | |
Parent Table | W_UI_PROF |
Child Table | W_UI_PROF_MYMENU |
Existence | Mandatory |
"W_UI_PROF to W_UI_PROF_MYMENU" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_UI_PROF to W_UI_PROF_MYMENU" Foreign Keys |
Parent Key | Child Key |
PROFILE_ID | PROFILE_ID |
"W_UI_PROF to W_UI_PROF_EXT_UNITS" |
RelationshipType | Identifying |
Relationship Name | F00053 |
Relationship Business Name | |
Parent Table | W_UI_PROF |
Child Table | W_UI_PROF_EXT_UNITS |
Existence | Mandatory |
"W_UI_PROF to W_UI_PROF_EXT_UNITS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_UI_PROF to W_UI_PROF_EXT_UNITS" Foreign Keys |
Parent Key | Child Key |
PROFILE_ID | PROFILE_ID |
"W_RS_LIST to W_RS_EXT_PK_MAP" |
RelationshipType | Identifying |
Relationship Name | F00054 |
Relationship Business Name | |
Parent Table | W_RS_LIST |
Child Table | W_RS_EXT_PK_MAP |
Existence | Mandatory |
"W_RS_LIST to W_RS_EXT_PK_MAP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_RS_LIST to W_RS_EXT_PK_MAP" Foreign Keys |
Parent Key | Child Key |
RS_ID, EXT_UNIT_ID | RS_ID, EXT_UNIT_ID |
"W_EXT_UNIT_LIST to W_RPT_LIST" |
RelationshipType | Identifying |
Relationship Name | F00055 |
Relationship Business Name | |
Parent Table | W_EXT_UNIT_LIST |
Child Table | W_RPT_LIST |
Existence | Mandatory |
"W_EXT_UNIT_LIST to W_RPT_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_EXT_UNIT_LIST to W_RPT_LIST" Foreign Keys |
Parent Key | Child Key |
EXT_UNIT_ID | EXT_UNIT_ID |
"W_EXT_UNIT_LIST to W_RS_RPT_LINKS" |
RelationshipType | Non-Identifying |
Relationship Name | F00056 |
Relationship Business Name | |
Parent Table | W_EXT_UNIT_LIST |
Child Table | W_RS_RPT_LINKS |
Existence | Mandatory |
"W_EXT_UNIT_LIST to W_RS_RPT_LINKS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_EXT_UNIT_LIST to W_RS_RPT_LINKS" Foreign Keys |
Parent Key | Child Key |
EXT_UNIT_ID | EXT_UNIT_ID |
"CMI_CONTENT_TYPE to CMI_CONTENT_LINK" |
RelationshipType | Identifying |
Relationship Name | F00057 |
Relationship Business Name | |
Parent Table | CMI_CONTENT_TYPE |
Child Table | CMI_CONTENT_LINK |
Existence | Mandatory |
"CMI_CONTENT_TYPE to CMI_CONTENT_LINK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CMI_CONTENT_TYPE to CMI_CONTENT_LINK" Foreign Keys |
Parent Key | Child Key |
CTYPE_ID | CTYPE_ID |
"CMI_CONTENT_LINK to CMI_CONT_LINK_FLD" |
RelationshipType | Identifying |
Relationship Name | F00058 |
Relationship Business Name | |
Parent Table | CMI_CONTENT_LINK |
Child Table | CMI_CONT_LINK_FLD |
Existence | Mandatory |
"CMI_CONTENT_LINK to CMI_CONT_LINK_FLD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CMI_CONTENT_LINK to CMI_CONT_LINK_FLD" Foreign Keys |
Parent Key | Child Key |
APP_ID, RS_ID, CTYPE_ID | APP_ID, RS_ID, CTYPE_ID |
"CMI_CONTENT_TYPE to CMI_CONT_TYPE_FLD" |
RelationshipType | Identifying |
Relationship Name | F00059 |
Relationship Business Name | |
Parent Table | CMI_CONTENT_TYPE |
Child Table | CMI_CONT_TYPE_FLD |
Existence | Mandatory |
"CMI_CONTENT_TYPE to CMI_CONT_TYPE_FLD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CMI_CONTENT_TYPE to CMI_CONT_TYPE_FLD" Foreign Keys |
Parent Key | Child Key |
CTYPE_ID | CTYPE_ID |
"CMI_CONTENT_TYPE to CMI_CONT_TYPE_LOC" |
RelationshipType | Identifying |
Relationship Name | F00060 |
Relationship Business Name | |
Parent Table | CMI_CONTENT_TYPE |
Child Table | CMI_CONT_TYPE_LOC |
Existence | Mandatory |
"CMI_CONTENT_TYPE to CMI_CONT_TYPE_LOC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CMI_CONTENT_TYPE to CMI_CONT_TYPE_LOC" Foreign Keys |
Parent Key | Child Key |
CTYPE_ID | CTYPE_ID |
"CMI_CONT_TYPE_LOC to CMI_CONT_TYPE_USER" |
RelationshipType | Identifying |
Relationship Name | F00061 |
Relationship Business Name | |
Parent Table | CMI_CONT_TYPE_LOC |
Child Table | CMI_CONT_TYPE_USER |
Existence | Mandatory |
"CMI_CONT_TYPE_LOC to CMI_CONT_TYPE_USER" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CMI_CONT_TYPE_LOC to CMI_CONT_TYPE_USER" Foreign Keys |
Parent Key | Child Key |
CTYPE_ID, CTYPE_LOC_ID | CTYPE_ID, CTYPE_LOC_ID |
"MB_MBOARD to MB_MBOARD_APPRF" |
RelationshipType | Identifying |
Relationship Name | FK_MB_MBOARD_APPRF_MB_IDX |
Relationship Business Name | |
Parent Table | MB_MBOARD |
Child Table | MB_MBOARD_APPRF |
Existence | Mandatory |
"MB_MBOARD to MB_MBOARD_APPRF" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MB_MBOARD to MB_MBOARD_APPRF" Foreign Keys |
Parent Key | Child Key |
MBOARD_NAME | MBOARD_NAME |
"MB_MBOARD to MB_MBOARD_FIELDS" |
RelationshipType | Identifying |
Relationship Name | FK_MB_MBOARD_FIELDS_MB_IDX |
Relationship Business Name | |
Parent Table | MB_MBOARD |
Child Table | MB_MBOARD_FIELDS |
Existence | Mandatory |
"MB_MBOARD to MB_MBOARD_FIELDS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MB_MBOARD to MB_MBOARD_FIELDS" Foreign Keys |
Parent Key | Child Key |
MBOARD_NAME | MBOARD_NAME |
"MB_MBOARD_FOLDER to MB_MBOARD_FLDPERM" |
RelationshipType | Identifying |
Relationship Name | FK_MB_MBOARD_FLDPERM_MBTO_IDX |
Relationship Business Name | |
Parent Table | MB_MBOARD_FOLDER |
Child Table | MB_MBOARD_FLDPERM |
Existence | Mandatory |
"MB_MBOARD_FOLDER to MB_MBOARD_FLDPERM" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MB_MBOARD_FOLDER to MB_MBOARD_FLDPERM" Foreign Keys |
Parent Key | Child Key |
MBOARD_NAME, TOPIC_ID | MBOARD_NAME, TOPIC_ID |
"MB_MBOARD to MB_MBOARD_FOLDER" |
RelationshipType | Identifying |
Relationship Name | FK_MB_MBOARD_FOLDER_MB_IDX |
Relationship Business Name | |
Parent Table | MB_MBOARD |
Child Table | MB_MBOARD_FOLDER |
Existence | Mandatory |
"MB_MBOARD to MB_MBOARD_FOLDER" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MB_MBOARD to MB_MBOARD_FOLDER" Foreign Keys |
Parent Key | Child Key |
MBOARD_NAME | MBOARD_NAME |
"MB_MBOARD to MB_MBOARD_RS" |
RelationshipType | Identifying |
Relationship Name | FK_MB_MBOARD_RS_MB_IDX |
Relationship Business Name | |
Parent Table | MB_MBOARD |
Child Table | MB_MBOARD_RS |
Existence | Mandatory |
"MB_MBOARD to MB_MBOARD_RS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MB_MBOARD to MB_MBOARD_RS" Foreign Keys |
Parent Key | Child Key |
MBOARD_NAME | MBOARD_NAME |
"MB_MBOARD to MB_MBOARD_SUBSCR" |
RelationshipType | Identifying |
Relationship Name | FK_MB_MBOARD_SUBSCR_MB_IDX |
Relationship Business Name | |
Parent Table | MB_MBOARD |
Child Table | MB_MBOARD_SUBSCR |
Existence | Mandatory |
"MB_MBOARD to MB_MBOARD_SUBSCR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MB_MBOARD to MB_MBOARD_SUBSCR" Foreign Keys |
Parent Key | Child Key |
MBOARD_NAME | MBOARD_NAME |
"W_USER_UGRP_LIST to MB_MBOARD_SUBSCR" |
RelationshipType | Identifying |
Relationship Name | FK_MB_MBOARD_SUBSCR_US_IDX |
Relationship Business Name | |
Parent Table | W_USER_UGRP_LIST |
Child Table | MB_MBOARD_SUBSCR |
Existence | Mandatory |
"W_USER_UGRP_LIST to MB_MBOARD_SUBSCR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_USER_UGRP_LIST to MB_MBOARD_SUBSCR" Foreign Keys |
Parent Key | Child Key |
SEC_OBJ_ID | USER_ID |
"MB_MBOARD_FOLDER to MB_MBOARD_USER" |
RelationshipType | Identifying |
Relationship Name | FK_MB_MBOARD_USER_MBTO_IDX |
Relationship Business Name | |
Parent Table | MB_MBOARD_FOLDER |
Child Table | MB_MBOARD_USER |
Existence | Mandatory |
"MB_MBOARD_FOLDER to MB_MBOARD_USER" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MB_MBOARD_FOLDER to MB_MBOARD_USER" Foreign Keys |
Parent Key | Child Key |
MBOARD_NAME, TOPIC_ID | MBOARD_NAME, TOPIC_ID |
"W_USER_UGRP_LIST to MB_MBOARD_USER" |
RelationshipType | Identifying |
Relationship Name | FK_MB_MBOARD_USER_SE_IDX |
Relationship Business Name | |
Parent Table | W_USER_UGRP_LIST |
Child Table | MB_MBOARD_USER |
Existence | Mandatory |
"W_USER_UGRP_LIST to MB_MBOARD_USER" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_USER_UGRP_LIST to MB_MBOARD_USER" Foreign Keys |
Parent Key | Child Key |
SEC_OBJ_ID | SEC_OBJ_ID |
"SYS_MESSAGES to SYS_MESSAGES_APP" |
RelationshipType | Identifying |
Relationship Name | FK_SYS_MESSAGES_APP_ID_IDX |
Relationship Business Name | |
Parent Table | SYS_MESSAGES |
Child Table | SYS_MESSAGES_APP |
Existence | Mandatory |
"SYS_MESSAGES to SYS_MESSAGES_APP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SYS_MESSAGES to SYS_MESSAGES_APP" Foreign Keys |
Parent Key | Child Key |
ID | ID |
"SYS_MESSAGES to SYS_MESSAGES_HS" |
RelationshipType | Non-Identifying |
Relationship Name | FK_SYS_MESSAGES_HS_ID_IDX |
Relationship Business Name | |
Parent Table | SYS_MESSAGES |
Child Table | SYS_MESSAGES_HS |
Existence | Mandatory |
"SYS_MESSAGES to SYS_MESSAGES_HS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SYS_MESSAGES to SYS_MESSAGES_HS" Foreign Keys |
Parent Key | Child Key |
ID | ID |
"SYS_MESSAGES to SYS_MESSAGES_USER" |
RelationshipType | Identifying |
Relationship Name | FK_SYS_MESSAGES_USER_ID_IDX |
Relationship Business Name | |
Parent Table | SYS_MESSAGES |
Child Table | SYS_MESSAGES_USER |
Existence | Mandatory |
"SYS_MESSAGES to SYS_MESSAGES_USER" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SYS_MESSAGES to SYS_MESSAGES_USER" Foreign Keys |
Parent Key | Child Key |
ID | ID |
"W_EXT_UNIT_LIST to W_APP_RS_LINKS" |
RelationshipType | Non-Identifying |
Relationship Name | FK_W_APP_RS_LINKS_EX_IDX |
Relationship Business Name | |
Parent Table | W_EXT_UNIT_LIST |
Child Table | W_APP_RS_LINKS |
Existence | Mandatory |
"W_EXT_UNIT_LIST to W_APP_RS_LINKS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_EXT_UNIT_LIST to W_APP_RS_LINKS" Foreign Keys |
Parent Key | Child Key |
EXT_UNIT_ID | EXT_UNIT_ID |
"W_USER_UGRP_LIST to W_CAPABILITY_URL" |
RelationshipType | Non-Identifying |
Relationship Name | FK_W_CAPABILITY_URL_US_IDX |
Relationship Business Name | |
Parent Table | W_USER_UGRP_LIST |
Child Table | W_CAPABILITY_URL |
Existence | Mandatory |
"W_USER_UGRP_LIST to W_CAPABILITY_URL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_USER_UGRP_LIST to W_CAPABILITY_URL" Foreign Keys |
Parent Key | Child Key |
SEC_OBJ_ID | USER_ID |
"W_DIGIT_DOC_TYPE_LINKS to W_DIGIT_DOC_FIELD_LINKS" |
RelationshipType | Identifying |
Relationship Name | FK_W_DIG_DOC_FLD_LNK_DOAP_IDX |
Relationship Business Name | |
Parent Table | W_DIGIT_DOC_TYPE_LINKS |
Child Table | W_DIGIT_DOC_FIELD_LINKS |
Existence | Mandatory |
"W_DIGIT_DOC_TYPE_LINKS to W_DIGIT_DOC_FIELD_LINKS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_DIGIT_DOC_TYPE_LINKS to W_DIGIT_DOC_FIELD_LINKS" Foreign Keys |
Parent Key | Child Key |
DOC_TYPE_ID, APP_ID | DOC_TYPE_ID, APP_ID |
"W_DIGIT_DOC_TYPE_LINKS to W_DIGIT_DOC_FIELD_UPDATE" |
RelationshipType | Identifying |
Relationship Name | FK_W_DIG_DOC_FLD_UPD_DOAP_IDX |
Relationship Business Name | |
Parent Table | W_DIGIT_DOC_TYPE_LINKS |
Child Table | W_DIGIT_DOC_FIELD_UPDATE |
Existence | Mandatory |
"W_DIGIT_DOC_TYPE_LINKS to W_DIGIT_DOC_FIELD_UPDATE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_DIGIT_DOC_TYPE_LINKS to W_DIGIT_DOC_FIELD_UPDATE" Foreign Keys |
Parent Key | Child Key |
DOC_TYPE_ID, APP_ID | DOC_TYPE_ID, APP_ID |
"W_DIGIT_DOC_TYPES to W_DIGIT_DOC_FIELDS" |
RelationshipType | Identifying |
Relationship Name | FK_W_DIGIT_DOC_FIELDS_DO_IDX |
Relationship Business Name | |
Parent Table | W_DIGIT_DOC_TYPES |
Child Table | W_DIGIT_DOC_FIELDS |
Existence | Mandatory |
"W_DIGIT_DOC_TYPES to W_DIGIT_DOC_FIELDS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_DIGIT_DOC_TYPES to W_DIGIT_DOC_FIELDS" Foreign Keys |
Parent Key | Child Key |
DOC_TYPE_ID | DOC_TYPE_ID |
"W_EXT_UNIT_LIST to W_EXT_LIMIT_APPS" |
RelationshipType | Identifying |
Relationship Name | FK_W_EXT_LIMIT_APPS_EX_IDX |
Relationship Business Name | |
Parent Table | W_EXT_UNIT_LIST |
Child Table | W_EXT_LIMIT_APPS |
Existence | Mandatory |
"W_EXT_UNIT_LIST to W_EXT_LIMIT_APPS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_EXT_UNIT_LIST to W_EXT_LIMIT_APPS" Foreign Keys |
Parent Key | Child Key |
EXT_UNIT_ID | EXT_UNIT_ID |
"W_INT_METHOD_LIST to W_INT_METHOD_META" |
RelationshipType | Non-Identifying |
Relationship Name | FK_W_INT_METHOD_META_IDX_1 |
Relationship Business Name | |
Parent Table | W_INT_METHOD_LIST |
Child Table | W_INT_METHOD_META |
Existence | Mandatory |
"W_INT_METHOD_LIST to W_INT_METHOD_META" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_INT_METHOD_LIST to W_INT_METHOD_META" Foreign Keys |
Parent Key | Child Key |
METHOD_ID | METHOD_ID |
"W_INT_METHOD_LIST to W_INTE_METHOD_META" |
RelationshipType | Non-Identifying |
Relationship Name | FK_W_INTE_METHOD_META_IDX_1 |
Relationship Business Name | |
Parent Table | W_INT_METHOD_LIST |
Child Table | W_INTE_METHOD_META |
Existence | Mandatory |
"W_INT_METHOD_LIST to W_INTE_METHOD_META" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_INT_METHOD_LIST to W_INTE_METHOD_META" Foreign Keys |
Parent Key | Child Key |
METHOD_ID | METHOD_ID |
"W_APP_LIST to W_MENU_APPS" |
RelationshipType | Identifying |
Relationship Name | FK_W_MENU_APPS_EXWA_IDX |
Relationship Business Name | |
Parent Table | W_APP_LIST |
Child Table | W_MENU_APPS |
Existence | Mandatory |
"W_APP_LIST to W_MENU_APPS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_APP_LIST to W_MENU_APPS" Foreign Keys |
Parent Key | Child Key |
APP_ID, EXT_UNIT_ID | W_APP_ID, EXT_UNIT_ID |
"W_USER_UGRP_LIST to W_MFA_FIDO_KEYS" |
RelationshipType | Non-Identifying |
Relationship Name | FK_W_MFA_FIDO_KEYS_US_IDX |
Relationship Business Name | |
Parent Table | W_USER_UGRP_LIST |
Child Table | W_MFA_FIDO_KEYS |
Existence | Mandatory |
"W_USER_UGRP_LIST to W_MFA_FIDO_KEYS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_USER_UGRP_LIST to W_MFA_FIDO_KEYS" Foreign Keys |
Parent Key | Child Key |
SEC_OBJ_ID | USER_ID |
"W_USER_UGRP_LIST to W_MFA_HS2" |
RelationshipType | Non-Identifying |
Relationship Name | FK_W_MFA_HS2_US_IDX |
Relationship Business Name | |
Parent Table | W_USER_UGRP_LIST |
Child Table | W_MFA_HS2 |
Existence | Mandatory |
"W_USER_UGRP_LIST to W_MFA_HS2" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_USER_UGRP_LIST to W_MFA_HS2" Foreign Keys |
Parent Key | Child Key |
SEC_OBJ_ID | USER_ID |
"W_USER_UGRP_LIST to W_MFA_HS" |
RelationshipType | Non-Identifying |
Relationship Name | FK_W_MFA_HS_US_IDX |
Relationship Business Name | |
Parent Table | W_USER_UGRP_LIST |
Child Table | W_MFA_HS |
Existence | Mandatory |
"W_USER_UGRP_LIST to W_MFA_HS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_USER_UGRP_LIST to W_MFA_HS" Foreign Keys |
Parent Key | Child Key |
SEC_OBJ_ID | USER_ID |
"W_USER_UGRP_LIST to W_NOTIFICATION_OVERRIDE" |
RelationshipType | Identifying |
Relationship Name | FK_W_NOTIFICATION_OVRRD_SE_IDX |
Relationship Business Name | |
Parent Table | W_USER_UGRP_LIST |
Child Table | W_NOTIFICATION_OVERRIDE |
Existence | Mandatory |
"W_USER_UGRP_LIST to W_NOTIFICATION_OVERRIDE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_USER_UGRP_LIST to W_NOTIFICATION_OVERRIDE" Foreign Keys |
Parent Key | Child Key |
SEC_OBJ_ID | SEC_OBJ_ID |
"W_EXT_UNIT_LIST to W_RS_ACTION_LINKS" |
RelationshipType | Non-Identifying |
Relationship Name | FK_W_RS_ACTION_LINKS_EX_IDX |
Relationship Business Name | |
Parent Table | W_EXT_UNIT_LIST |
Child Table | W_RS_ACTION_LINKS |
Existence | Mandatory |
"W_EXT_UNIT_LIST to W_RS_ACTION_LINKS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_EXT_UNIT_LIST to W_RS_ACTION_LINKS" Foreign Keys |
Parent Key | Child Key |
EXT_UNIT_ID | EXT_UNIT_ID |
"W_RS_LIST to W_RS_ALT_PRES" |
RelationshipType | Identifying |
Relationship Name | FK_W_RS_ALT_PRES_RE_IDX |
Relationship Business Name | |
Parent Table | W_RS_LIST |
Child Table | W_RS_ALT_PRES |
Existence | Mandatory |
"W_RS_LIST to W_RS_ALT_PRES" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_RS_LIST to W_RS_ALT_PRES" Foreign Keys |
Parent Key | Child Key |
RS_ID, EXT_UNIT_ID | RS_ID, EXT_UNIT_ID |
"W_EXT_UNIT_LIST to W_RS_LINKS" |
RelationshipType | Identifying |
Relationship Name | FK_W_RS_LINKS_EX_IDX |
Relationship Business Name | |
Parent Table | W_EXT_UNIT_LIST |
Child Table | W_RS_LINKS |
Existence | Mandatory |
"W_EXT_UNIT_LIST to W_RS_LINKS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_EXT_UNIT_LIST to W_RS_LINKS" Foreign Keys |
Parent Key | Child Key |
EXT_UNIT_ID | EXT_UNIT_ID |
"W_EXT_UNIT_LIST to W_TREE_LIST" |
RelationshipType | Non-Identifying |
Relationship Name | FK_W_TREE_LIST_EX_IDX |
Relationship Business Name | |
Parent Table | W_EXT_UNIT_LIST |
Child Table | W_TREE_LIST |
Existence | Mandatory |
"W_EXT_UNIT_LIST to W_TREE_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_EXT_UNIT_LIST to W_TREE_LIST" Foreign Keys |
Parent Key | Child Key |
EXT_UNIT_ID | EXT_UNIT_ID |
"W_UI_PROF to W_UI_PROF_QUERY" |
RelationshipType | Identifying |
Relationship Name | FK_W_UI_PROF_QUERY_PR_IDX |
Relationship Business Name | |
Parent Table | W_UI_PROF |
Child Table | W_UI_PROF_QUERY |
Existence | Mandatory |
"W_UI_PROF to W_UI_PROF_QUERY" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_UI_PROF to W_UI_PROF_QUERY" Foreign Keys |
Parent Key | Child Key |
PROFILE_ID | PROFILE_ID |
"W_USER_UGRP_LIST to W_USER_FAVORITES" |
RelationshipType | Non-Identifying |
Relationship Name | FK_W_USER_FAVORITES_USCOAP_IDX |
Relationship Business Name | |
Parent Table | W_USER_UGRP_LIST |
Child Table | W_USER_FAVORITES |
Existence | Mandatory |
"W_USER_UGRP_LIST to W_USER_FAVORITES" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_USER_UGRP_LIST to W_USER_FAVORITES" Foreign Keys |
Parent Key | Child Key |
SEC_OBJ_ID | USER_ID |
"WFA_WF to WFA_ACTIVITY_STRUC" |
RelationshipType | Identifying |
Relationship Name | FK_WFA_ACTIVITY_STRUC_WFRE_IDX |
Relationship Business Name | |
Parent Table | WFA_WF |
Child Table | WFA_ACTIVITY_STRUC |
Existence | Mandatory |
"WFA_WF to WFA_ACTIVITY_STRUC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"WFA_WF to WFA_ACTIVITY_STRUC" Foreign Keys |
Parent Key | Child Key |
WF_KEY, REV_KEY | WF_KEY, REV_KEY |
"WFA_WF to WFA_ACTIVITY" |
RelationshipType | Identifying |
Relationship Name | FK_WFA_ACTIVITY_WFRE_IDX |
Relationship Business Name | |
Parent Table | WFA_WF |
Child Table | WFA_ACTIVITY |
Existence | Mandatory |
"WFA_WF to WFA_ACTIVITY" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"WFA_WF to WFA_ACTIVITY" Foreign Keys |
Parent Key | Child Key |
WF_KEY, REV_KEY | WF_KEY, REV_KEY |
"WFA_WF to WFA_NODE" |
RelationshipType | Identifying |
Relationship Name | FK_WFA_NODE_WFRE_IDX |
Relationship Business Name | |
Parent Table | WFA_WF |
Child Table | WFA_NODE |
Existence | Mandatory |
"WFA_WF to WFA_NODE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"WFA_WF to WFA_NODE" Foreign Keys |
Parent Key | Child Key |
WF_KEY, REV_KEY | WF_KEY, REV_KEY |
"WFA_WF to WFA_OWNER" |
RelationshipType | Identifying |
Relationship Name | FK_WFA_OWNER_WFRE_IDX |
Relationship Business Name | |
Parent Table | WFA_WF |
Child Table | WFA_OWNER |
Existence | Mandatory |
"WFA_WF to WFA_OWNER" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"WFA_WF to WFA_OWNER" Foreign Keys |
Parent Key | Child Key |
WF_KEY, REV_KEY | WF_KEY, REV_KEY |
"WFA_ROLE_FILTER to WFA_ROLE_USER_COND" |
RelationshipType | Non-Identifying |
Relationship Name | FK_WFA_ROLE_USER_FI_IDX |
Relationship Business Name | |
Parent Table | WFA_ROLE_FILTER |
Child Table | WFA_ROLE_USER_COND |
Existence | Mandatory |
"WFA_ROLE_FILTER to WFA_ROLE_USER_COND" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"WFA_ROLE_FILTER to WFA_ROLE_USER_COND" Foreign Keys |
Parent Key | Child Key |
FIELD_ID | FIELD_ID |
"WFA_ROLE to WFA_ROLE_USER" |
RelationshipType | Identifying |
Relationship Name | FK_WFA_ROLE_USER_RO_IDX |
Relationship Business Name | |
Parent Table | WFA_ROLE |
Child Table | WFA_ROLE_USER |
Existence | Mandatory |
"WFA_ROLE to WFA_ROLE_USER" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"WFA_ROLE to WFA_ROLE_USER" Foreign Keys |
Parent Key | Child Key |
ROLE_CD | ROLE_CD |
"WFA_ROLE_USER to WFA_ROLE_USER_COND" |
RelationshipType | Identifying |
Relationship Name | FK_WFA_ROLE_USER_ROUS_IDX |
Relationship Business Name | |
Parent Table | WFA_ROLE_USER |
Child Table | WFA_ROLE_USER_COND |
Existence | Mandatory |
"WFA_ROLE_USER to WFA_ROLE_USER_COND" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"WFA_ROLE_USER to WFA_ROLE_USER_COND" Foreign Keys |
Parent Key | Child Key |
ROLE_CD, USER_ID | ROLE_CD, USER_ID |
"W_USER_UGRP_LIST to WFA_ROLE_USER" |
RelationshipType | Identifying |
Relationship Name | FK_WFA_ROLE_USER_US_IDX |
Relationship Business Name | |
Parent Table | W_USER_UGRP_LIST |
Child Table | WFA_ROLE_USER |
Existence | Mandatory |
"W_USER_UGRP_LIST to WFA_ROLE_USER" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"W_USER_UGRP_LIST to WFA_ROLE_USER" Foreign Keys |
Parent Key | Child Key |
SEC_OBJ_ID | USER_ID |
"WFA_WF to WFA_WF_APPRS" |
RelationshipType | Identifying |
Relationship Name | FK_WFA_WF_APPRS_WFRE_IDX |
Relationship Business Name | |
Parent Table | WFA_WF |
Child Table | WFA_WF_APPRS |
Existence | Mandatory |
"WFA_WF to WFA_WF_APPRS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"WFA_WF to WFA_WF_APPRS" Foreign Keys |
Parent Key | Child Key |
WF_KEY, REV_KEY | WF_KEY, REV_KEY |
"WFA_ROLE_FILTER to WFA_WF_ENTITY" |
RelationshipType | Non-Identifying |
Relationship Name | FK_WFA_WF_ENTITY_FI_IDX |
Relationship Business Name | |
Parent Table | WFA_ROLE_FILTER |
Child Table | WFA_WF_ENTITY |
Existence | Optional |
"WFA_ROLE_FILTER to WFA_WF_ENTITY" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"WFA_ROLE_FILTER to WFA_WF_ENTITY" Foreign Keys |
Parent Key | Child Key |
FIELD_ID | FILTER_FIELD_ID |
"WFA_WF to WFA_WF_ENTITY" |
RelationshipType | Identifying |
Relationship Name | FK_WFA_WF_ENTITY_WFRE_IDX |
Relationship Business Name | |
Parent Table | WFA_WF |
Child Table | WFA_WF_ENTITY |
Existence | Mandatory |
"WFA_WF to WFA_WF_ENTITY" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"WFA_WF to WFA_WF_ENTITY" Foreign Keys |
Parent Key | Child Key |
WF_KEY, REV_KEY | WF_KEY, REV_KEY |
"WFA_WF_APPRS to WFA_WF_FIELD" |
RelationshipType | Identifying |
Relationship Name | FK_WFA_WF_FIELD_WFREAPRS_IDX |
Relationship Business Name | |
Parent Table | WFA_WF_APPRS |
Child Table | WFA_WF_FIELD |
Existence | Mandatory |
"WFA_WF_APPRS to WFA_WF_FIELD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"WFA_WF_APPRS to WFA_WF_FIELD" Foreign Keys |
Parent Key | Child Key |
WF_KEY, REV_KEY, APP_ID, RS_ID | WF_KEY, REV_KEY, APP_ID, RS_ID |
"WFA_REJECT_CD to WFA_WF_RJCT_CD" |
RelationshipType | Identifying |
Relationship Name | FK_WFA_WF_RJCT_CD_RE_IDX |
Relationship Business Name | |
Parent Table | WFA_REJECT_CD |
Child Table | WFA_WF_RJCT_CD |
Existence | Mandatory |
"WFA_REJECT_CD to WFA_WF_RJCT_CD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"WFA_REJECT_CD to WFA_WF_RJCT_CD" Foreign Keys |
Parent Key | Child Key |
REJECT_CD | REJECT_CD |
"WFA_WF to WFA_WF_RJCT_CD" |
RelationshipType | Identifying |
Relationship Name | FK_WFA_WF_RJCT_CD_WFRE_IDX |
Relationship Business Name | |
Parent Table | WFA_WF |
Child Table | WFA_WF_RJCT_CD |
Existence | Mandatory |
"WFA_WF to WFA_WF_RJCT_CD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"WFA_WF to WFA_WF_RJCT_CD" Foreign Keys |
Parent Key | Child Key |
WF_KEY, REV_KEY | WF_KEY, REV_KEY |
"WFA_ROLE to WFA_WF" |
RelationshipType | Non-Identifying |
Relationship Name | FK_WFA_WF_RO_IDX |
Relationship Business Name | |
Parent Table | WFA_ROLE |
Child Table | WFA_WF |
Existence | Optional |
"WFA_ROLE to WFA_WF" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"WFA_ROLE to WFA_WF" Foreign Keys |
Parent Key | Child Key |
ROLE_CD | ROLE_CD |