SchemaSpy - Table slot9.WORLD.TSTA.INC_REVIEW_ROUTE_LEVELS

Describes a level of an incident review 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

ROUTE_LEVEL_ID

number

38

INC_REVIEW_ROUTE_INSTANCES.ROUTE_LEVEL_ID

Implied Constraint R

ROUTE_ID

number

38

INC_REVIEW_ROUTES.ROUTE_ID

INCRVWRTLVL_INCRVWRT_FK R

ROUTE_ORDER

number

38

ROLE_CODE

varchar2

30

ROLE_SECURITIES.ROLE_NAME

INCRVWRTLVL_RS_FK R

TEXT

varchar2

500

√

null

USER_CANCEL_FLAG

varchar2

1

√

'N'

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

INCRVWRTLVL_EJSCD_SRC_FK R

AGENCY_SOURCE_CODE_TYPE

varchar2

30

√

'ROUTE_AGENCY_SOURCE_CODES'

EJS_CODES.CODE_TYPE

INCRVWRTLVL_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
"ROUTE_LEVEL_ID" IS NOT NULL	INCRVWRTLVL_LVL_ID_NN
"ROUTE_ORDER" IS NOT NULL	INCRVWRTLVL_ORDER_NN
"ROLE_CODE" IS NOT NULL	INCRVWRTLVL_ROLE_NN
"ROUTE_ID" IS NOT NULL	INCRVWRTLVL_RT_ID_NN

Indexes:

Column(s)	Type	Sort	Constraint Name
ROUTE_LEVEL_ID	Primary key	Asc	INCRVWRTLVL_PK
AGENCY_SOURCE_CODE_TYPE + AGENCY_SOURCE_CODE	Performance	Asc/Asc	INCRVWRTLVL_EJSCD_SRC_FK_I
ROUTE_ID	Performance	Asc	INCRVWRTLVL_INCRVWRT_FK_I
ROLE_CODE	Performance	Asc	INCRVWRTLVL_RS_FK_I