Table slot9.WORLD.TSTA.SEARCH_INTERFACE_RESULTS
This table stores raw results of external system searches for the purpose of caching these results
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
ID number 0
COURT_CASE_DELETE.ID Implied Constraint R
Unique id for search results
INTERFACE_ID number 0
SEARCH_INTERFACES.INTERFACE_ID SI_RESULT_SRCHINT_FK R
FK to SEARCH_INTERFACES to identify the external search performed
QUERY_AGENCY varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE SI_RESULT_AGNCY_CD_FK R
FK to AGENCY_CODES to identify the agency of the user performing the original query
QUERY_USER varchar2 100  √  null
IJIS_USER_PROFILES.LOGIN_ID SI_RESULT_IUP_FK R
FK to IJIS_USER_PROFILES to identify the user performing the original query
QUERY_STRING varchar2 4000  √  null A string containing the external search query. Used to search for existing cached result.
QUERY_RESPONSE clob 4000  √  null Raw results of the original query
QUERY_DATE date 7  √  null Date the original query was performed
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ID" IS NOT NULL SI_RESULT_ID_NN
"INTERFACE_ID" IS NOT NULL SI_RESULT_INT_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc SI_RESULT_PK
QUERY_AGENCY Performance Asc SI_RESULT_AGNCY_CD_FK_I
QUERY_USER Performance Asc SI_RESULT_IUP_FK_I
QUERY_STRING Performance Asc SI_RESULT_QUERY_I
INTERFACE_ID Performance Asc SI_RESULT_SRCHINT_FK_I

Close relationships  within of separation: