Table slot9.WORLD.TSTA.EXPORT_FIELD_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
FIELD_NUMBER varchar2 8
FIELD_CODE varchar2 8
MAX_FIELD_SIZE number 0
MAX_OCCURRENCES number 0
EXTENSION number 0  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
RECORD_ID number 0
EXPORT_FIELDS.RECORD_ID EXP_FD_EXP_FLD_FK C
FIELD_ID number 0
EXPORT_FIELDS.FIELD_ID EXP_FD_EXP_FLD_FK C
DESTINATION_ID number 0
EXPORT_DESTINATIONS.DESTINATION_ID EXP_FD_EXP_DEST_FK C
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"DESTINATION_ID" IS NOT NULL EXP_FD_DESTINATION_ID_NN
"FIELD_CODE" IS NOT NULL EXP_FD_FIELD_CODE_NN
"FIELD_ID" IS NOT NULL EXP_FD_FIELD_ID_NN
"FIELD_NUMBER" IS NOT NULL EXP_FD_FIELD_NUMBER_NN
"MAX_FIELD_SIZE" IS NOT NULL EXP_FD_MAX_FIELD_SIZE_NN
"MAX_OCCURRENCES" IS NOT NULL EXP_FD_MAX_OCCURRENCES_NN
"RECORD_ID" IS NOT NULL EXP_FD_RECORD_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
RECORD_ID + FIELD_ID + DESTINATION_ID Primary key Asc/Asc/Asc EXP_FD_PK
DESTINATION_ID Performance Asc EXP_FD_EXP_DEST_FK_I
FIELD_ID + RECORD_ID Performance Asc/Asc EXP_FD_EXP_FLD_FK_I

Close relationships  within of separation: