Table slot9.WORLD.TSTA.JT_WEB_SERVICES
This Table Defines the Jail Tracker Web Service Settings. It can be defined at the schema, Agency or Sub Agency Level
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
JT_WEB_SERVICE_ID number 0 Unique Web Service ID - Defined by JT_WEBSERVICES_ID_SEQ
WEBSERVICE_NAME varchar2 80 Web Service Name
DESCRIPTION varchar2 255  √  null Description of Web Service
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE JT_WS_AGNCY_CD_FK R
Agency or Sub Agency Code using Web Service
WEBSERVICE_URL varchar2 255  √  null Exact URL Used by Web Service
USERNAME varchar2 40  √  null User Name for Web Service Authentication
PASSWORD varchar2 40  √  null User Password for Web Service Authentication
SEARCH_TYPE varchar2 40  √  null Type of Search, Passed as a parameter to the JT Web Service
CREATOR_DATE date 7  √  null Date Record was created
CREATOR_ID varchar2 100  √  null User Id Creating Record
UPDATOR_DATE date 7  √  null Date Record was last Updated
UPDATOR_ID varchar2 100  √  null
REC_ID number 0  √  null
API_KEY varchar2 500  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"JT_WEB_SERVICE_ID" IS NOT NULL JT_WS_WEB_SERVICE_ID_NN
"WEBSERVICE_NAME" IS NOT NULL JT_WS_WEBSERV_NAME_NN

Indexes:
Column(s) Type Sort Constraint Name
JT_WEB_SERVICE_ID Primary key Asc JT_WS_PK
AGENCY_CODE Performance Asc JT_WS_AGNCY_CD_FK_I

Close relationships  within of separation: