SchemaSpy - Table slot9.WORLD.TSTA.ARREST_CHARGE_FLAGS

This table is not currently used

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

AC_ID

number

10

ARREST_CHARGES.AC_ID

ACF_AC_FK R

CHARGE_FLAG_CODE

varchar2

30

EJS_CODES.CODE

ACF_CHARGE_FLAG_CO_EJS_CODE_FK R

FLAG_VALUE

varchar2

1

√

'U'

CREATOR_ID

varchar2

100

√

null

CREATOR_DATE

date

7

√

null

UPDATOR_ID

varchar2

100

√

null

UPDATOR_DATE

date

7

√

null

CHARGE_FLAG_CODE_TYPE

varchar2

30

√

'CHARGE_FLAG_CODES'

EJS_CODES.CODE_TYPE

ACF_CHARGE_FLAG_CO_EJS_CODE_FK R

REC_ID

number

0

√

null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):

Constraint	Constraint Name
"AC_ID" IS NOT NULL	ACF_AC_ID_NN
"CHARGE_FLAG_CODE" IS NOT NULL	ACF_CHARGE_FLAG_CODE_NN

Indexes:

Column(s)	Type	Sort	Constraint Name
AC_ID + CHARGE_FLAG_CODE	Primary key	Asc/Asc	ACF_PK
AC_ID	Performance	Asc	ACF_AC_FK_I
CHARGE_FLAG_CODE	Performance	Asc	ACF_CFC_FK_I
CHARGE_FLAG_CODE_TYPE + CHARGE_FLAG_CODE	Performance	Asc/Asc	ACF_CHARGE_FLAG_CO_EJS_CODE_I