Table slot9.WORLD.TSTA.EJS_CODES_EXTRN_MULTI_LINKS
This table can join ejs codes (codes in EJS_CODES) to codes in other code tables
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
MULTI_LINK_ID varchar2 30 Primary key of the relationship between the EXTERNAL TABLE and the EJS_CODES VIRTUAL TABLE
TABLE_NAME varchar2 40  √  null
APPLICATION_TABLES.TABLE_NAME EXTRNML_APP_TABLES_FK R
Foreign Key to the APPLICATION_TABLES table to determine the primary key name and format
EJS_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE EXTRNML_EJS_CODE_FK R
Foreign key to the EJS_CODES table to join the EXTERNAL CODE TABLE to the EJS_CODES
EJS_CODE varchar2 30  √  null
EJS_CODES.CODE EXTRNML_EJS_CODE_FK R
Foreing key to the EJS_CODES table to join the EXTERNAL CODE TABLE to the EJS_CODES.
TABLE_CODE varchar2 30  √  null Used to join the EJS_CODES table to the EXTERNAL TABLE Identified by TABLE_NAME.
TABLE_CODE_ALT number 38  √  null Also used to join the EJS_CODES table to the EXTERNAL TABLE Identified by TABLE_NAME.
CREATOR_ID varchar2 100  √  null USER ID for the initial record creation.
CREATOR_DATE date 7  √  null Date record was created.
UPDATOR_ID varchar2 100  √  null USER ID for the last record update.
UPDATOR_DATE date 7  √  null Date record was last updated.

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"MULTI_LINK_ID" IS NOT NULL EXTRNML_MULTI_LINK_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
MULTI_LINK_ID Primary key Asc EXTRNML_PK
TABLE_NAME Performance Asc EXTRNML_APP_TABLES_FK_I
EJS_CODE_TYPE + EJS_CODE Performance Asc/Asc EXTRNML_EJS_CODE_FK_I

Close relationships  within of separation: