Table slot9.WORLD.TSTA.QUICK_LINKS
This table defines the quick links that can be displayed on the home page of 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
QUICK_LINK_ID number 38
QUICK_LINK_USERS.QUICK_LINK_ID QLU_QL_FK R
Quick Link ID
QUICK_LINK_CODE_TYPE varchar2 30  √  'QUICK_LINK_CODES'
EJS_CODES.CODE_TYPE QL_EJS_CODES_FK R
Quick Link code type
QUICK_LINK_CODE varchar2 30  √  null
EJS_CODES.CODE QL_EJS_CODES_FK R
Quick Link code
QUICK_LINK_NAME varchar2 100  √  null Quick Link name on screen
QUICK_LINK_URL varchar2 255  √  null Quick Link value/URL
QUICK_LINK_USER_DELETE_YN varchar2 255 'Y' Can the user delete the Quick Link?
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
QUICK_LINK_CAT_CODE varchar2 30  √  null
EJS_CODES.CODE QUICK_LNK_CAT_CD_FK R
QUICK_LINK_CAT_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE QUICK_LNK_CAT_CD_FK R
ENABLE varchar2 1  √  null
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE AGNQL_AGNCY_CD_FK R
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"QUICK_LINK_USER_DELETE_YN" IS NOT NULL QL_QUICK_LINK_USER_DELETE_Y_NN
"QUICK_LINK_ID" IS NOT NULL QUICK_LINK_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
QUICK_LINK_ID Primary key Asc QL_PK
AGENCY_CODE Performance Asc QL_AGNCY_CD_FK_I
QUICK_LINK_CODE + QUICK_LINK_CODE_TYPE Performance Asc/Asc QL_EJS_CODES_FK_I
QUICK_LINK_CODE_TYPE + QUICK_LINK_CODE Performance Asc/Asc QL_EJS_CODES_I
QUICK_LINK_CAT_CODE_TYPE + QUICK_LINK_CAT_CODE Performance Asc/Asc QUICK_LNK_CAT_CD_FK_I

Close relationships  within of separation: