Table slot9.WORLD.TSTA.EJS_WEB_SERVICES
Setup information for calling a SOAP or REST web service using HTTP.
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
SERVICE_NAME varchar2 80
ATTACHMENT_INTERFACES.SERVICE_NAME Implied Constraint R
EJS_WEB_SERVICE_AGENCIES.SERVICE_NAME EWSA_EWS_FK R
EXT_SEARCH_AGENCIES.SERVICE_NAME EXTSA_EWS_FK R
XML_DOC_DESTINATIONS.SERVICE_NAME XMLDD_EWS_FK R
A unique name for the Web Service.
SERVICE_URL varchar2 2000 The Web service complete URL.
SERVICE_METHOD varchar2 80  √  null The method to be performed. For REST, probably POST or GET.
SOAP_MESSAGE varchar2 2000  √  null The XML-based SOAP protocol message envelope, header and body token.
DESCRIPTION varchar2 255  √  null Description of the Web Service.
ACTIVE varchar2 1  √  null Used to flag the Web Service as Active or Inactive.
CREATOR_ID varchar2 100  √  null Record Created By.
CREATOR_DATE date 7  √  null Date Record was created.
UPDATOR_ID varchar2 100  √  null Record updated by User ID.
UPDATOR_DATE date 7  √  null Date Record was last updated.
REC_ID number 0  √  null
CONTENT_TYPE varchar2 100  √  null HTTP Header content type.
HTTP_VERSION varchar2 100  √  null HTTP version.
ACCEPT_HDR varchar2 100  √  null HTTP Header value for ACCEPT.
AUTHORIZATION_HDR varchar2 100  √  null HTTP Header value for AUTHORIZATION.
PROXY varchar2 200  √  null Proxy server, if needed.
TRNSFR_TIMEOUT_SECS varchar2 20  √  null Number of seconds for HTTP transfer timeout.
ENC_AUTH_USER_ID raw 64  √  null Web service authorization user id (encrypted).
ENC_AUTH_PASSWORD raw 64  √  null Web service authorization password (encrypted).
AGENCY_AUTH_FLAG varchar2 1  √  'N'
WEB_SERVICE_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE EWS_EJSCD_TYPE_FK R
Type of Web Service (Camera, Fingerprint Reader etc.)
WEB_SERVICE_TYPE_CODE_TYPE varchar2 30  √  'WEB_SERVICE_TYPE_CODES'
EJS_CODES.CODE_TYPE EWS_EJSCD_TYPE_FK R
EJS_CODES Code Type for Web Service Type Code
SYSTEM_REQUIRED varchar2 1  √  'N'

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"SERVICE_NAME" IS NOT NULL EWS_SERVICE_NAME_NN
"SERVICE_URL" IS NOT NULL EWS_SERVICE_URL_NN

Indexes:
Column(s) Type Sort Constraint Name
SERVICE_NAME Primary key Asc EWS_PK
WEB_SERVICE_TYPE_CODE_TYPE + WEB_SERVICE_TYPE_CODE Performance Asc/Asc EWS_EJSCD_TYPE_FK_I

Close relationships  within of separation: