Table slot9.WORLD.TSTA.BOND_TYPE_CODES
This table defines the valid bond types for charges on an ARREST

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
BOND_TYPE varchar2 2
ARREST_CHARGES.BOND_TYPE_CODE AC_BTC_FK R
ARREST_WARRANTS.BOND_TYPE ARRWAR_BTC_FK R
ARRESTS.BOND_TYPE ARR_BTC_FK R
CHARGE_CLASS_CODES.BOND_TYPE Implied Constraint R
CHARGE_CODES.BOND_TYPE Implied Constraint R
CITATION_ADDRESS_VW.BOND_TYPE Implied Constraint R
CITATION_BUSINESS_VW.BOND_TYPE Implied Constraint R
CITATION_EMPLOYEE_VW.BOND_TYPE Implied Constraint R
CITATION_PERSON_VW.BOND_TYPE Implied Constraint R
CITATION_RACIAL_PROFILE_VW.BOND_TYPE Implied Constraint R
CITATION_VEHICLE_VW.BOND_TYPE Implied Constraint R
CITATION_VW.BOND_TYPE Implied Constraint R
CITATIONS.BOND_TYPE CITATION_BND_TYP_CD_FK R
E_WARRANTS.BND_TYP_CD_BOND_TYPE EWAR_BND_TYP_CD_FK R
JS_CITATION_VW.BOND_TYPE Implied Constraint R
JS_FIELD_ARREST_CHARGE_VW.BOND_TYPE Implied Constraint R
JS_FIELD_ARREST_VW.BOND_TYPE Implied Constraint R
JS_WARRANT_OFFENSE_CHARGE_VW.BOND_TYPE Implied Constraint R
JS_WARRANT_VW.BOND_TYPE Implied Constraint R
TDEX_RMS_WARRANT_CHARGES_VW.BOND_TYPE Implied Constraint R
TDEX_RMS_WARRANT_VW.BOND_TYPE Implied Constraint R
WARRANT_OFFENSE_CHARGE_VW.BOND_TYPE Implied Constraint R
WARRANT_PERSON_ADDR_VW.BOND_TYPE Implied Constraint R
WARRANTS_VW.BOND_TYPE Implied Constraint R
Type of Bond
DESCRIPTION varchar2 40 Description of Bond Type
FACTOR number 5,2  √  null
REC_ID number 0  √  null
AMOUNT_REQUIRED_FLAG varchar2 1  √  'N'
ACTIVE_FLAG varchar2 1  √  'Y'

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"BOND_TYPE" IS NOT NULL BTC_BOND_TYPE_NN
"DESCRIPTION" IS NOT NULL BTC_DESCRIPTION_NN
ACTIVE_FLAG IN ('Y', 'N') CK_BTC_ACT_FLG_YN
AMOUNT_REQUIRED_FLAG IN ('Y', 'N') CK_BTC_AMT_REQ_YN

Indexes:
Column(s) Type Sort Constraint Name
BOND_TYPE Primary key Asc BTC_PK

Close relationships  within of separation: