Table slot9.WORLD.TSTA.EJS_CODES_RELATIONS
This table defines relationships between EJS_CODES used throughout the application
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
PARENT_CODE_TYPE varchar2 30
SEARCH_INTERFACE_FIELD_MAPS.FORM_TYPE SRCHINTFM_EJSCDR_FTP_FK R
EJS_CODES.CODE_TYPE EJS_CD_PARENT_FK R
PARENT_CODE varchar2 30
SEARCH_INTERFACE_FIELD_MAPS.FORM_CODE SRCHINTFM_EJSCDR_FTP_FK R
EJS_CODES.CODE EJS_CD_PARENT_FK R
CHILD_CODE_TYPE varchar2 30
SEARCH_INTERFACE_FIELD_MAPS.FORM_FIELD_TYPE SRCHINTFM_EJSCDR_FTP_FK R
EJS_CODES.CODE_TYPE EJS_CD_CHILD_FK R
CHILD_CODE varchar2 30
SEARCH_INTERFACE_FIELD_MAPS.FORM_FIELD_CODE SRCHINTFM_EJSCDR_FTP_FK R
EJS_CODES.CODE EJS_CD_CHILD_FK R
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Indexes:
Column(s) Type Sort Constraint Name
PARENT_CODE_TYPE + PARENT_CODE + CHILD_CODE_TYPE + CHILD_CODE Primary key Asc/Asc/Asc/Asc EJS_CD_REL_PK
CHILD_CODE_TYPE + CHILD_CODE Performance Asc/Asc EJS_CD_CHILD_FK_I

Close relationships  within of separation: