Table slot9.WORLD.TSTA.EXPORT_FILES
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
FILE_ID number 0
EJS_IMPORT_VW.FILE_ID Implied Constraint R
EXPORT_DESTINATIONS.FILE_ID EXP_DEST_EXP_FILE_FK R
EXPORT_RECORDS.FILE_ID EXP_REC_EXP_FILE_FK C
IMPORT_FILES.FILE_ID IMP_FILE_EXP_FILE_FK C
MICR_INCIDENT_HEADER_VW.FILE_ID Implied Constraint R
TRANSACTION_NAME varchar2 64
NIST_FLAG varchar2 1  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
TRANSACTION_CODE varchar2 30
EJS_CODES.CODE EXP_FILE_TRANSACTI_EJS_CODE_FK R
TRANSACTION_CODE_TYPE varchar2 30  √  'EXPORT_TRANSACTION_CODES'
EJS_CODES.CODE_TYPE EXP_FILE_TRANSACTI_EJS_CODE_FK R
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
NIST_FLAG IN ('Y', 'N') CK_EXP_FILE_NIST_FLAG
"FILE_ID" IS NOT NULL EXP_FILE_FILE_ID_NN
"TRANSACTION_CODE" IS NOT NULL EXP_FILE_TRANSACTION_CODE_NN
"TRANSACTION_NAME" IS NOT NULL EXP_FILE_TRANSACTION_NAME_NN

Indexes:
Column(s) Type Sort Constraint Name
FILE_ID Primary key Asc EXP_FILE_PK
TRANSACTION_CODE Performance Asc EXP_FILE_EXP_TRANCD_FK_I
TRANSACTION_CODE_TYPE + TRANSACTION_CODE Performance Asc/Asc EXP_FILE_TRANSACTI_EJS_CODE_I

Close relationships  within of separation: