Table slot9.WORLD.TSTA.EXPORT_FIELDS
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
EXP_PARM_PARAMETER_NUMBER number 0
EXPORT_PARAMETERS.PARAMETER_NUMBER EXP_FLD_EXP_PARM_FK R
FIELD_ID number 0
EXPORT_FIELD_DESTINATIONS.FIELD_ID EXP_FD_EXP_FLD_FK C
PROCEDURE_NAME varchar2 64
FIELD_DESCRIPTION varchar2 128
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_FIELD_DESTINATIONS.RECORD_ID EXP_FD_EXP_FLD_FK C
EXPORT_RECORDS.RECORD_ID EXP_FLD_EXP_REC_FK C
IMPORT_TABLE varchar2 64  √  null
IMPORT_PARAMETERS.IMPORT_TABLE EXP_FLD_IMP_PARAM_FK R
IMPORT_COLUMN varchar2 64  √  null
IMPORT_PARAMETERS.IMPORT_COLUMN EXP_FLD_IMP_PARAM_FK R
EXP_PARM_PARAMETER_NUMBER2 number 0  √  null
EXPORT_PARAMETERS.PARAMETER_NUMBER EXP_FLD_EXP_PARM2_FK R
ARCHIVE_FLAG varchar2 1  √  null Yes or No to flag if the field should be archived or not.
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
ARCHIVE_FLAG IN ('N', 'Y', 'U') CK_EXP_FLD_ARCHIVE_FLAG
"EXP_PARM_PARAMETER_NUMBER" IS NOT NULL EXP_FLD_EXP_PARM_PARAMETER__NN
"FIELD_DESCRIPTION" IS NOT NULL EXP_FLD_FIELD_DESCRIPTION_NN
"FIELD_ID" IS NOT NULL EXP_FLD_FIELD_ID_NN
"PROCEDURE_NAME" IS NOT NULL EXP_FLD_PROCEDURE_NAME_NN
"RECORD_ID" IS NOT NULL EXP_FLD_RECORD_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
FIELD_ID + RECORD_ID Primary key Asc/Asc EXP_FLD_PK
EXP_PARM_PARAMETER_NUMBER2 Performance Asc EXP_FLD_EXP_PARM2_FK_I
EXP_PARM_PARAMETER_NUMBER Performance Asc EXP_FLD_EXP_PARM_FK_I
RECORD_ID Performance Asc EXP_FLD_EXP_REC_FK_I
IMPORT_TABLE + IMPORT_COLUMN Performance Asc/Asc EXP_FLD_IMP_PARAM_FK_I

Close relationships  within of separation: