SchemaSpy - Table slot9.WORLD.TSTA.DS_ICR_HEADER

This table stores the Data submission Header Files Information

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

number

COURT_CASE_DELETE.ID

Implied Constraint R

HEADERID

number

DS_ICR_HEADERS.HEADERID

DSICRHF_DSICRHD_FK C

EXT_SYS_CODE

varchar2

EXTERNAL_SYSTEM_CODES.CODE

DSICRHF_EXSYS_FK R

FILE_ID

number

ATTACHMENTS.ID

DSICRHF_ATT_FILE_FK R

ERROR_FILE_ID

number

√

null

ATTACHMENTS.ID

DSICRHF_ATT_ERR_FK R

RESPONSE_FILE_ID

number

√

null

ATTACHMENTS.ID

DSICRHF_ATT_RESP_FK R

SUBMITTED_BY

varchar2

100

√

null

IJIS_USER_PROFILES.LOGIN_ID

DSICRHF_IUP_FK R

DATE_GENERATED

date

√

null

DATE_SUBMITTED

date

√

null

RESPONSE_TYPE_CODE

varchar2

√

null

EJS_CODES.CODE

DSICRHF_EJSCD_RESP_FK R

RESPONSE_TYPE_CODE_TYPE

varchar2

√

'IBR_RESPONSE_TYPE_CODES'

EJS_CODES.CODE_TYPE

DSICRHF_EJSCD_RESP_FK R

CREATOR_ID

varchar2

100

√

null

CREATOR_DATE

date

√

null

UPDATOR_ID

varchar2

100

√

null

UPDATOR_DATE

date

√

null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):

Constraint	Constraint Name
"FILE_ID" IS NOT NULL	DSICRHF_FL_ID_NN
"HEADERID" IS NOT NULL	DSICRHF_HDR_ID_NN
"ID" IS NOT NULL	DSICRHF_ID_NN
"EXT_SYS_CODE" IS NOT NULL	DSICRHF_SYSCD_NN

Indexes:

Column(s)	Type	Sort	Constraint Name
ID	Primary key	Asc	DSICRHF_PK
ERROR_FILE_ID	Performance	Asc	DSICRHF_ATT_ERR_FK_I
FILE_ID	Performance	Asc	DSICRHF_ATT_FILE_FK_I
RESPONSE_FILE_ID	Performance	Asc	DSICRHF_ATT_RESP_FK_I
HEADERID	Performance	Asc	DSICRHF_DSICRHD_FK_I
RESPONSE_TYPE_CODE_TYPE + RESPONSE_TYPE_CODE	Performance	Asc/Asc	DSICRHF_EJSCD_RESP_FK_I
EXT_SYS_CODE	Performance	Asc	DSICRHF_EXSYS_FK_I
SUBMITTED_BY	Performance	Asc	DSICRHF_IUP_FK_I