Table slot9.WORLD.TSTA.EJS_FTP
This is an Interact Administration table
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
FTP_ID number 0
EXPORT_DESTINATIONS.FTP_ID EXP_DEST_EJS_FTP_FK R
EXTERNAL_SYSTEM_AGENCIES.FTP_ID EXSA_EJS_FTP_FK R
EXTERNAL_SYSTEM_AGENCIES_VW.FTP_ID Implied Constraint R
XML_DOCUMENT_CATEGORY_CODES.FTP_ID DCC_EJS_FTP_FK R
The sequence generated value for each FTP record.
FTP_HOST varchar2 80 The name or IP address of the FTP Host.
DESCRIPTION varchar2 255  √  null A description of the FTP Host.
LOGIN_ID varchar2 100
IJIS_USER_PROFILES.LOGIN_ID Implied Constraint R
The username used to access the FTP server.
PASSWD varchar2 80 The password used to access the FTP server.
DIRECTORY_PATH varchar2 255  √  null Used to specify a particular directory the FTP server.
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
FTP_PORT number 0  √  null The Port used to access the FTP site.
REC_ID number 0  √  null
FTP_METHOD_CODE varchar2 30  √  null
EJS_CODES.CODE EJS_FTP_FTP_METH_EJS_CODE_FK R
The method of FTP to be used.
FTP_METHOD_CODE_TYPE varchar2 30  √  'FTP_METHOD_CODES'
EJS_CODES.CODE_TYPE EJS_FTP_FTP_METH_EJS_CODE_FK R
PASSIVE_FLAG varchar2 1 'Y' Will the FTP use passive mode?

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"FTP_HOST" IS NOT NULL EJS_FTP_FTP_HOST_NN
"FTP_ID" IS NOT NULL EJS_FTP_FTP_ID_NN
"LOGIN_ID" IS NOT NULL EJS_FTP_LOGIN_ID_NN
PASSIVE_FLAG IN ('Y','N') EJS_FTP_PASSIVE_FLAG_CK
"PASSIVE_FLAG" IS NOT NULL EJS_FTP_PASSIVE_FLAG_NN
"PASSWD" IS NOT NULL EJS_FTP_PASSWD_NN

Indexes:
Column(s) Type Sort Constraint Name
FTP_ID Primary key Asc EJS_FTP_PK
FTP_METHOD_CODE_TYPE + FTP_METHOD_CODE Performance Asc/Asc EJS_FTP_FTP_METH_EJS_CODE_FK_I

Close relationships  within of separation: