SchemaSpy - Table slot9.WORLD.TSTA.INC_REVIEW_ROUTE_INSTANCES

In instance of a level of an incident route

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

INSTANCE_ID

number

38

INCIDENT_DELETE.REVIEW_INSTANCE_ID	ID_INCRVWRTINST_FK R
ITEM_INSPECTION_ITEMS.INSTANCE_ID	Implied Constraint R
PROFILE_SCREEN_ITEMS.INSTANCE_ID	Implied Constraint R
USER_SCREEN_INSTANCES.INSTANCE_ID	Implied Constraint R
USI_CITATION_FIELDS.INSTANCE_ID	Implied Constraint R
USI_SEARCH_VW.INSTANCE_ID	Implied Constraint R

INSTANCE_SEQ_ID

number

38

INCIDENT_ID

number

38

INCIDENT_SUPPLEMENTS.INC_INCIDENT_ID

INCRVWRTINST_INCSUP_FK R

SUPP_SEQ

number

38

INCIDENT_SUPPLEMENTS.SUPP_SEQ

INCRVWRTINST_INCSUP_FK R

ROUTE_LEVEL_ID

number

38

INC_REVIEW_ROUTE_LEVELS.ROUTE_LEVEL_ID

Implied Constraint R

ROUTE_ORDER

number

38

ROUTE_NAME

varchar2

100

√

null

AGENCY_CODE

varchar2

30

AGENCY_CODES.AGENCY_CODE

INCRVWRTINST_AGNCY_CD_FK R

TEXT

varchar2

500

√

null

USER_CANCEL_FLAG

varchar2

1

√

null

ROLE_CODE

varchar2

30

ROLE_SECURITIES.ROLE_NAME

INCRVWRTINST_RS_FK R

USER_NAME

varchar2

100

√

null

IJIS_USER_PROFILES.LOGIN_ID

INCRVWRTINST_IUP_FK R

REVIEW_DATE

date

7

√

null

ACTION_CODE

varchar2

30

EJS_CODES.CODE

INCRVWRTINST_EJSCD_ACT_FK R

ACTION_CODE_TYPE

varchar2

30

'INC_RVW_ACTION_CODES'

EJS_CODES.CODE_TYPE

INCRVWRTINST_EJSCD_ACT_FK R

COMMENTS

varchar2

4000

√

null

CANCELLED_FLAG

varchar2

1

√

null

CREATOR_ID

varchar2

100

√

null

CREATOR_DATE

date

7

√

null

UPDATOR_ID

varchar2

100

√

null

UPDATOR_DATE

date

7

√

null

AGENCY_SOURCE_CODE

varchar2

30

√

null

EJS_CODES.CODE

INCRVWRTINST_EJSCD_SRC_FK R

AGENCY_SOURCE_CODE_TYPE

varchar2

30

√

'ROUTE_AGENCY_SOURCE_CODES'

EJS_CODES.CODE_TYPE

INCRVWRTINST_EJSCD_SRC_FK R

USER_CHANGE_AGENCY_FLAG

varchar2

1

√

'N'

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):

Constraint	Constraint Name
"ACTION_CODE" IS NOT NULL	INCRVWRTINST_ACCD_NN
"ACTION_CODE_TYPE" IS NOT NULL	INCRVWRTINST_ACCD_TYP_NN
"AGENCY_CODE" IS NOT NULL	INCRVWRTINST_AGNCY_CD_NN
"INCIDENT_ID" IS NOT NULL	INCRVWRTINST_INC_ID_NN
"INSTANCE_ID" IS NOT NULL	INCRVWRTINST_INST_ID_NN
"ROUTE_LEVEL_ID" IS NOT NULL	INCRVWRTINST_LVL_ID_NN
"ROUTE_ORDER" IS NOT NULL	INCRVWRTINST_ORDER_NN
"ROLE_CODE" IS NOT NULL	INCRVWRTINST_RC_NN
"INSTANCE_SEQ_ID" IS NOT NULL	INCRVWRTINST_SEQ_ID_NN
"SUPP_SEQ" IS NOT NULL	INCRVWRTINST_SUPP_SEQ_NN

Indexes:

Column(s)	Type	Sort	Constraint Name
INSTANCE_ID	Primary key	Asc	INCRVWRTINST_PK
AGENCY_CODE	Performance	Asc	INCRVWRTINST_AGNCY_CD_FK_I
ACTION_CODE_TYPE + ACTION_CODE	Performance	Asc/Asc	INCRVWRTINST_EJSCD_ACT_FK_I
AGENCY_SOURCE_CODE_TYPE + AGENCY_SOURCE_CODE	Performance	Asc/Asc	INCRVWRTINST_EJSCD_SRC_FK_I
INCIDENT_ID + SUPP_SEQ	Performance	Asc/Asc	INCRVWRTINST_INCSUP_FK_I
USER_NAME	Performance	Asc	INCRVWRTINST_IUP_FK_I
ROLE_CODE	Performance	Asc	INCRVWRTINST_RS_FK_I