SchemaSpy - Table slot9.WORLD.TSTA.CHARGE_CLASS_CODES

This table defines the valid classes for charges

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

CHARGE_CATEGORY_CODE

varchar2

2

ARREST_CHARGES.CHARGE_CATEGORY_CODE	AC_CCC1_FK R
CHARGE_CODES.CHARGE_CATEGORY_CODE	CHA_CCC1_FK R

CHARGE_CATEGORY_CODES.CHARGE_CATEGORY_CODE

CCC1_CCC_FK R

CHARGE_CLASS_CODE

varchar2

1

ARREST_CHARGES.CHARGE_CLASS_CODE	AC_CCC1_FK R
CHARGE_CODES.CHARGE_CLASS_CODE	CHA_CCC1_FK R

JAILABLE

varchar2

1

Yes or No Fields

DESCRIPTION

varchar2

30

√

null

STATUTORY_BOND_AMOUNT

number

9,2

√

null

SEND_LIVESCAN

varchar2

1

DISPLAY_FLAG

varchar2

1

REC_ID

number

0

√

null

BOND_TYPE

varchar2

2

√

null

BOND_TYPE_CODES.BOND_TYPE

Implied Constraint R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):

Constraint	Constraint Name
"CHARGE_CATEGORY_CODE" IS NOT NULL	CCC1_CHARGE_CATEGORY_CODE_NN
"CHARGE_CLASS_CODE" IS NOT NULL	CCC1_CHARGE_CLASS_CODE_NN
"DISPLAY_FLAG" IS NOT NULL	CCC1_DISPLAY_FLAG_NN
"JAILABLE" IS NOT NULL	CCC1_JAILABLE_NN
"SEND_LIVESCAN" IS NOT NULL	CCC1_SEND_LIVESCAN_NN
jailable IN ( 'Y' , 'N' )	CK_CCC1_JAILABLE

Indexes:

Column(s)	Type	Sort	Constraint Name
CHARGE_CLASS_CODE + CHARGE_CATEGORY_CODE	Primary key	Asc/Asc	CCC1_PK
CHARGE_CATEGORY_CODE	Performance	Asc	CCC1_CCC_FK_I