Table slot9.WORLD.TSTA.WARRANT_FREETEXT_CHARGES
This table stores free text charges (i.e. one-off 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
FREETEXT_CHARGE_ID number 38
WARRANT_ID number 38
E_WARRANTS.WARRANT_ID WFTC_EWAR_FK R
WARRANT_CHARGE varchar2 1000  √  null
DISPLAY_INDEX number 38
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
REC_ID number 0  √  null
CHARGE_CATEGORY_CODE varchar2 2  √  null
CHARGE_CATEGORY_CODES.CHARGE_CATEGORY_CODE WFTC_CCC_FK R
CHARGE_CLASS_CODE varchar2 2  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"FREETEXT_CHARGE_ID" IS NOT NULL WFTC_CHARGE_ID_NN
"DISPLAY_INDEX" IS NOT NULL WFTC_DISPLAY_IND_NN
"WARRANT_ID" IS NOT NULL WFTC_WARRANT_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
FREETEXT_CHARGE_ID Primary key Asc WFTC_PK
CHARGE_CATEGORY_CODE Performance Asc WFTC_CCC_FK_I
WARRANT_ID Performance Asc WFTC_EWAR_FK_I

Close relationships  within of separation: