SchemaSpy - Table slot9.WORLD.TSTA.WARRANT_CHARGES

This table stores the charges added to a warrant in the application

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

EWAR_WARRANT_ID

number

0

E_WARRANTS.WARRANT_ID

WCHG_EWAR_FK C

Warrant ID Number

CHA_CODE

varchar2

30

CHARGE_CODES.CODE

WCHG_CHA_FK R

CREATOR_ID

varchar2

100

√

null

Created by Oracle USER ID

CREATOR_DATE

date

7

√

null

Creation Date

UPDATOR_ID

varchar2

100

√

null

Updated by Oracle USER ID

UPDATOR_DATE

date

7

√

null

Updated Date

CSAU_CSAU_CODE

varchar2

2

√

null

CSAU_CODES.CSAU_CODE

WCHG_CSAU_FK R

CHARGE_COUNT

number

5

√

null

DISPO_DATE

date

7

√

null

REMARK

varchar2

1024

√

null

WCDCD_CODE

varchar2

1

√

null

WARRANT_CHG_DISPO_CODES.CODE

WCHG_WCDCD_FK R

WARRANT_CHARGE_ID

number

12

WARRANT_CHARGE_NARRATIVES.WARRANT_CHARGE_ID

WARCHGNAR_WCHG_FK C

REC_ID

number

0

√

null

DISPLAY_INDEX

number

38

CHARGE_CATEGORY_CODE

varchar2

2

√

null

CHARGE_CATEGORY_CODES.CHARGE_CATEGORY_CODE

WCHG_CCC_FK R

CHARGE_CLASS_CODE

varchar2

2

√

null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):

Constraint	Constraint Name
"CHA_CODE" IS NOT NULL	WCHG_CHA_CODE_NN
"DISPLAY_INDEX" IS NOT NULL	WCHG_DISPLAY_IND_NN
"EWAR_WARRANT_ID" IS NOT NULL	WCHG_EWAR_WARRANT_ID_NN
"WARRANT_CHARGE_ID" IS NOT NULL	WCHG_WARRANT_CHARGE_ID_NN

Indexes:

Column(s)	Type	Sort	Constraint Name
WARRANT_CHARGE_ID	Primary key	Asc	WCHG_PK
CHARGE_CATEGORY_CODE	Performance	Asc	WCHG_CCC_FK_I
CHA_CODE	Performance	Asc	WCHG_CHA_FK_I
CSAU_CSAU_CODE	Performance	Asc	WCHG_CSAU_FK_I
EWAR_WARRANT_ID	Performance	Asc	WCHG_EWAR_FK_I
WCDCD_CODE	Performance	Asc	WCHG_WCDCD_FK_I