Table slot9.WORLD.TSTA.DS_ICR_FILE_REFERENCES
This table stores relationships between a Data Set and its related Attachment File that is sent to the FBI, State
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
DATASETID number 38
DS_ICR_DATA_SETS.DATASETID DSICRFREF_DSICR_FK R
DATASET ID number (Part of Primary Key)
ATT_ID number 0
ATTACHMENTS.ID DSICRFREF_ATT_FK C
A unique Number used to create documents.
KEYWORD varchar2 80  √  null Keyword used to identify file
DATE_OF_INFO date 7  √  null Date of file or information
FILE_DESC varchar2 2000  √  null Detailed text description of file
FILE_CODE varchar2 30
EJS_CODES.CODE DSICRFREF_EJSCODES_FK R
Type of file (DSICRFILE/ERRORHTMLFILE/LOGFILE) references ejs_codes ds_icr_file_type_codes
FILE_CODE_TYPE varchar2 30 'DS_ICR_FILE_TYPE_CODES'
EJS_CODES.CODE_TYPE DSICRFREF_EJSCODES_FK R
Type of file (DSICRFILE/ERRORHTMLFILE/LOGFILE) references ejs_codes ds_icr_file_type_codes
CREATOR_ID varchar2 100  √  null Person creating the record
CREATOR_DATE date 7  √  null Date of creation
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
REC_ID number 0  √  null
EXTSYS_CODE varchar2 10  √  null
EXTERNAL_SYSTEM_CODES.CODE DSICRFREF_EXTSYS_FK R
FK to EXTERNAL_SYSTEM_CODES. External System the Submission File was created for

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ATT_ID" IS NOT NULL DSICRFREF_ATT_ID_NN
"DATASETID" IS NOT NULL DSICRFREF_DATASETID_NN
"FILE_CODE" IS NOT NULL DSICRFREF_FILE_CODE_NN
"FILE_CODE_TYPE" IS NOT NULL DSICRFREF_FILE_CODE_TYP_NN

Indexes:
Column(s) Type Sort Constraint Name
DATASETID + ATT_ID Primary key Asc/Asc DSICRFREF_PK
ATT_ID Performance Asc DSICRFREF_ATT_FK_I
DATASETID Performance Asc DSICRFREF_DSICR_FK_I
FILE_CODE_TYPE + FILE_CODE Performance Asc/Asc DSICRFREF_EJSCODES_FK_I
EXTSYS_CODE Performance Asc DSICRFREF_EXTSYS_FK_I

Close relationships  within of separation: