Table slot9.WORLD.TSTA.SEARCH_INTERFACES
This table defines the different types of searches available
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
INTERFACE_ID number 38
AGENCY_SEARCH_INTERFACES.INTERFACE_ID AGSRCHINT_SRCHINT_FK R
EXTERNAL_INFO_REQUESTS.INTERFACE_ID Implied Constraint R
SEARCH_INT_FORM_TYPES.INTERFACE_ID SRCHINTFT_SRCHINT_FK R
SEARCH_INTERFACE_GROUPS.INTERFACE_ID SIG_SRCHINT_FK R
SEARCH_INTERFACE_RESULTS.INTERFACE_ID SI_RESULT_SRCHINT_FK R
USER_SEARCH_INTERFACES.INTERFACE_ID USRSRCHINT_SRCHINT_FK R
EXTERNAL_ID varchar2 30
NAME varchar2 100  √  null
SHORT_NAME varchar2 100  √  null
CLASS_PATH varchar2 200
TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE SRCHINT_TYPE_CODE_FK R
TYPE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE SRCHINT_TYPE_CODE_FK R
DESCRIPTION varchar2 500  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
REC_ID number 0  √  null
ACTIVE_FLAG varchar2 1 'Y'
EXTERNAL_SEARCH_FLAG varchar2 1 'Y'
SCREEN_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE SRCHINT_EJSCD_SCREEN_CODE_FK R
SCREEN_CODE varchar2 30  √  null
EJS_CODES.CODE SRCHINT_EJSCD_SCREEN_CODE_FK R
RESULT_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE SRCHINT_EJSCD_RESULT_CODE_FK R
RESULT_CODE varchar2 30  √  null
EJS_CODES.CODE SRCHINT_EJSCD_RESULT_CODE_FK R
EXTERNAL_SERVER_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE SRCHINT_EJSCD_EXTSVR_CODE_FK R
EXTERNAL_SERVER_CODE varchar2 30  √  null
EJS_CODES.CODE SRCHINT_EJSCD_EXTSVR_CODE_FK R
AUTO_QUERY_FLAG varchar2 1  √  'Y'

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
ACTIVE_FLAG IN ( 'Y' , 'N' ) CK_SRCHINT_ACTIVE_FLAG
EXTERNAL_SEARCH_FLAG IN ( 'Y' , 'N' ) CK_SRCHINT_EXTERNAL_SRCH_FLG
"ACTIVE_FLAG" IS NOT NULL SRCHINT_ACTFLG_NN
"CLASS_PATH" IS NOT NULL SRCHINT_CP_NN
"EXTERNAL_ID" IS NOT NULL SRCHINT_EXT_ID_NN
"EXTERNAL_SEARCH_FLAG" IS NOT NULL SRCHINT_EXTSRCHFLG_NN
"INTERFACE_ID" IS NOT NULL SRCHINT_INT_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
INTERFACE_ID Primary key Asc SRCHINT_PK
EXTERNAL_SERVER_TYPE + EXTERNAL_SERVER_CODE Performance Asc/Asc SRCHINT_EJSCD_EXTSVR_CODE_FK_I
RESULT_TYPE + RESULT_CODE Performance Asc/Asc SRCHINT_EJSCD_RESULT_CODE_FK_I
SCREEN_TYPE + SCREEN_CODE Performance Asc/Asc SRCHINT_EJSCD_SCREEN_CODE_FK_I
TYPE_CODE_TYPE + TYPE_CODE Performance Asc/Asc SRCHINT_TYPE_CODE_FK_I

Close relationships  within of separation: