SchemaSpy - Table slot9.WORLD.TSTA.WARRANT_CHG_DISPO

This table stores the disposition code 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

CODE

varchar2

WARRANT_CHARGES.WCDCD_CODE

WCHG_WCDCD_FK R

Warrant Charge Disposition Code

DISPO_DESCRIPTION

varchar2

Warrant Charge Disposition Description

DISPLAY_ON_WARRANT

varchar2

Display Charges with this disposition on warrant

REC_ID

number

√

null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):

Constraint	Constraint Name
display_on_warrant IN ( 'Y' , 'N' )	CK_WCDCD_DISPLAY_ON_WARRANT
"CODE" IS NOT NULL	WCDCD_CODE_NN
"DISPLAY_ON_WARRANT" IS NOT NULL	WCDCD_DISPLAY_ON_WARRANT_NN
"DISPO_DESCRIPTION" IS NOT NULL	WCDCD_DISPO_DESCRIPTION_NN

Indexes:

Column(s)	Type	Sort	Constraint Name
CODE	Primary key	Asc	WCDCD_PK