Table slot9.WORLD.TSTA.SOLR_LOG
Administrative table for logging solr searches
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
SOLR_LOG_ID number 0
DOMAIN_TYPE varchar2 100  √  null
DOMAIN_ID varchar2 100  √  null
SESSION_ID varchar2 100  √  null
URL varchar2 500  √  null
ACTION varchar2 4000  √  null
DATETIME_SENT timestamp(6) 11,6  √  null
REQUEST clob 4000  √  null
RESPONSE clob 4000  √  null
STATUS_CODE varchar2 100  √  null
STATUS_TEXT varchar2 4000  √  null
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"SOLR_LOG_ID" IS NOT NULL SOLRLG_SOLR_LOG_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
SOLR_LOG_ID Primary key Asc SOLRLG_PK
DOMAIN_TYPE + DOMAIN_ID Performance Asc/Asc SOLRLG_DMN_TYP_ID_I
SESSION_ID Performance Asc SOLRLG_SESSION_ID_I