Table slot9.WORLD.TSTA.EXPORT_RECORDS
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
RECORD_ID number 0
EXPORT_FIELDS.RECORD_ID EXP_FLD_EXP_REC_FK C
PERSON_GEO_VW.RECORD_ID Implied Constraint R
USER_PINNED_RECORDS.RECORD_ID Implied Constraint R
RECORD_NAME varchar2 64
RECORD_NUMBER number 0
MAX_OCCURRENCES number 0
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
FILE_ID number 0
EXPORT_FILES.FILE_ID EXP_REC_EXP_FILE_FK C
SUFFIX varchar2 2  √  null
HEADER_PROCEDURE varchar2 64  √  null
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"FILE_ID" IS NOT NULL EXP_REC_FILE_ID_NN
"MAX_OCCURRENCES" IS NOT NULL EXP_REC_MAX_OCCURRENCES_NN
"RECORD_ID" IS NOT NULL EXP_REC_RECORD_ID_NN
"RECORD_NAME" IS NOT NULL EXP_REC_RECORD_NAME_NN
"RECORD_NUMBER" IS NOT NULL EXP_REC_RECORD_NUMBER_NN

Indexes:
Column(s) Type Sort Constraint Name
RECORD_ID Primary key Asc EXP_REC_PK
FILE_ID Performance Asc EXP_REC_EXP_FILE_FK_I

Close relationships  within of separation: