SchemaSpy - Table slot9.WORLD.TSTA.SUB_AGENCIES

This table defines sub agencies for an agency

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

AGENCY_CODE

varchar2

30

AGENCY_CODES.AGENCY_CODE

SA1_AGNCY_CD_FK C

Agency involved

SUB_AGENCY_TYPE

varchar2

30

EJS_CODES.CODE

SA1_SUB_AGENCY_TYP_EJS_CODE_FK R

SUB_AGENCY_CODE

varchar2

30

AGENCY_CODES.AGENCY_CODE

SA1_AGNCY_CD_SUB_FK R

Agency involved

SUB_AGENCY_TYPE_TYPE

varchar2

30

√

'SUB_AGENCY_TYPE_CODES'

EJS_CODES.CODE_TYPE

SA1_SUB_AGENCY_TYP_EJS_CODE_FK R

REC_ID

number

0

√

null

PRIMARY_FLAG

varchar2

1

√

'N'

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):

Constraint	Constraint Name
PRIMARY_FLAG IN ('Y','N')	CK_PRIMARY_FLG
"AGENCY_CODE" IS NOT NULL	SA1_AGENCY_CODE_NN
"SUB_AGENCY_CODE" IS NOT NULL	SA1_SUB_AGENCY_CODE_NN
"SUB_AGENCY_TYPE" IS NOT NULL	SA1_SUB_AGENCY_TYPE_NN

Indexes:

Column(s)	Type	Sort	Constraint Name
AGENCY_CODE + SUB_AGENCY_CODE + SUB_AGENCY_TYPE	Primary key	Asc/Asc/Asc	SA1_PK
SUB_AGENCY_CODE	Performance	Asc	SA1_AGNCY_CD_CODED_BY_FK_I
AGENCY_CODE	Performance	Asc	SA1_AGNCY_CD_FK_I
SUB_AGENCY_TYPE	Performance	Asc	SA1_SATC_FK_I
SUB_AGENCY_TYPE_TYPE + SUB_AGENCY_TYPE	Performance	Asc/Asc	SA1_SUB_AGENCY_TYP_EJS_CODE_I