Table slot9.WORLD.TSTA.EXT_SEARCH_AGENCIES
This table is not currently used
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
EXT_AGENCY_CODE varchar2 20
EXT_SEARCH_TYPES_FOR_AGENCY.EXT_AGENCY_CODE EXSAT_EXTSA_FK C
SEARCH_AGENCIES.EXT_AGENCY_CODE ESA_EXTAC_FK R
Code/Acronymn for External Agency
DESCRIPTION varchar2 80 Description of External Agency
CREATOR_ID varchar2 100  √  null Record Creator USER ID
CREATOR_DATE date 7  √  null Date Record was Created
UPDATOR_ID varchar2 100  √  null Record last updated by USER ID
UPDATOR_DATE date 7  √  null Record last updated date
SERVICE_NAME varchar2 80  √  null
EJS_WEB_SERVICES.SERVICE_NAME EXTSA_EWS_FK R
The name of the Web Service.
DOC_CATEGORY_CODE varchar2 3  √  null
XML_DOCUMENT_CATEGORY_CODES.DOC_CATEGORY_CODE EXTSA_DCC_FK R
The code used to identify the type of XML document being processed.
SSN_REQUIRED varchar2 1  √  'N' Flag indicating if the search agency requires the user''s Social Security Number to perform a records query.
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"DESCRIPTION" IS NOT NULL EXTSA_DESCRIPTION_NN
"EXT_AGENCY_CODE" IS NOT NULL EXTSA_EXT_AGENCY_CODE_NN

Indexes:
Column(s) Type Sort Constraint Name
EXT_AGENCY_CODE Primary key Asc EXTSA_PK
DOC_CATEGORY_CODE Performance Asc EXTSA_DCC_FK_I
SERVICE_NAME Performance Asc EXTSA_EWS_FK_I

Close relationships  within of separation: