Table slot9.WORLD.TSTA.EXTERNAL_INFO_RESPONSES
This table is used for external searches. This table is not used at this time
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
REQUEST_ID number 0
EXTERNAL_INFO_RESPONSE_IMAGES.REQUEST_ID EXTINFRSPI_EXTINFRSP_FK R
EXTERNAL_INFO_REQUESTS.REQUEST_ID EXTINFRSP_EXTINFRQ_FK R
RESPONSE_ID number 0
EXTERNAL_INFO_RESPONSE_IMAGES.RESPONSE_ID EXTINFRSPI_EXTINFRSP_FK R
RESPONSE_DATE date 7
FORMATTED_FLG varchar2 1  √  'N'
RAW_RESPONSE blob 4000  √  null
REC_ID number 0  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
EXT_RESPONSE_DATE date 7  √  null
EXT_TIME_ZONE varchar2 100  √  null
EXT_PRIORITY varchar2 100  √  null
EXT_PRIORITY_MSG varchar2 500  √  null
EXT_TYPE varchar2 500  √  null
EXT_TYPE_ID varchar2 100  √  null
FORMATTED_RESPONSE blob 4000  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
FORMATTED_FLG IN ('Y', 'N') CK_EXTINFRSP_FRMTFLG
"REQUEST_ID" IS NOT NULL EXTINFRSP_REQUEST_ID_NN
"RESPONSE_ID" IS NOT NULL EXTINFRSP_RESP_ID_NN
"RESPONSE_DATE" IS NOT NULL EXTINFRSP_RESPDT_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
REQUEST_ID + RESPONSE_ID Primary key Asc/Asc EXTINFRSP_PK
REQUEST_ID Performance Asc EXTINFRSP_EXTINFRQ_FK_I

Close relationships  within of separation: