Table slot9.WORLD.TSTA.EXPORT_DESTINATIONS
This table is used to define export formats. This table is not used at this time
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
DESTINATION_ID number 0
EJS_IMPORT_VW.DESTINATION_ID Implied Constraint R
EXPORT_FIELD_DESTINATIONS.DESTINATION_ID EXP_FD_EXP_DEST_FK C
IMPORT_FILES.DESTINATION_ID IMP_FILE_EXP_DEST_FK C
DESTINATION_PATH varchar2 240
VERIFICATION_FILE varchar2 240  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE EXP_DEST_AGNCY_CD_FK R
FILE_ID number 0  √  null
EXPORT_FILES.FILE_ID EXP_DEST_EXP_FILE_FK R
FTP_ID number 0  √  null
EJS_FTP.FTP_ID EXP_DEST_EJS_FTP_FK R
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"AGENCY_CODE" IS NOT NULL EXP_DEST_AGENCY_CODE_NN
"DESTINATION_ID" IS NOT NULL EXP_DEST_DESTINATION_ID_NN
"DESTINATION_PATH" IS NOT NULL EXP_DEST_DESTINATION_PATH_NN

Indexes:
Column(s) Type Sort Constraint Name
DESTINATION_ID Primary key Asc EXP_DEST_PK
AGENCY_CODE Performance Asc EXP_DEST_AGNCY_CD_FK_I
FILE_ID Performance Asc EXP_DEST_EXP_FILE_FK_I
FTP_ID Performance Asc EXP_DEST_EXP_FTP_FK_I

Close relationships  within of separation: