Table slot9.WORLD.TSTA.ATTACHMENT_INTERFACES
This table define the external interfaces where attachements can be stored outside of the RMS database
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
INTERFACE_ID number 0
AGENCY_ATTACHMENT_INTERFACES.INTERFACE_ID AGATTINT_ATTINT_FK R
Unique identifier for this record. PK
SERVICE_NAME varchar2 80
EJS_WEB_SERVICES.SERVICE_NAME Implied Constraint R
Name for this external storage solution
INTERNAL_ID varchar2 200 Name used within RMS application to identify this service
DESCRIPTION varchar2 255  √  null Description of this external storage solution
SERVICE_URL varchar2 2000  √  null Base URL if this external storage solution uses a web service
ACTIVE_FLAG varchar2 1 'Y' Y/N flag to mark this interface as active
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ACTIVE_FLAG" IS NOT NULL ATTINT_ACTFLG_NN
"INTERFACE_ID" IS NOT NULL ATTINT_INT_ID_NN
"INTERNAL_ID" IS NOT NULL ATTINT_INTID_NN
"SERVICE_NAME" IS NOT NULL ATTINT_NAME_NN
ACTIVE_FLAG IN ( 'Y' , 'N' ) CK_ATTINT_ACTIVE_FLAG

Indexes:
Column(s) Type Sort Constraint Name
INTERFACE_ID Primary key Asc ATTINT_PK
INTERNAL_ID Performance Asc ATTINT_INTERNAL_ID_I
SERVICE_NAME Performance Asc ATTINT_SERVICE_NAME_I

Close relationships  within of separation: