Table slot9.WORLD.TSTA.BLOOD_TYPE_CODES
THis table defines the valid blood types for MASTER PEOPLE
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 30
AGENCY_SUBSCRIPTIONS_VW.CODE Implied Constraint R
ARREST_CHARGE_VW.CODE Implied Constraint R
CHARGE_CODES.CODE Implied Constraint R
CHARGE_OFFENSE_VW.CODE Implied Constraint R
EJS_CODES.CODE Implied Constraint R
EMPLOYEES.BLOOD_CODE EMP1_BLOOD_CD_FK R
OFFENSE_ANSWER.CODE Implied Constraint R
OFFENSE_ANSWER1.CODE Implied Constraint R
OFFENSE_COND_QANSCHOICES_VW.CODE Implied Constraint R
UF_QUERY_CHARGE_VW.CODE Implied Constraint R
VICTIM_INJURY_CODES_VW.CODE Implied Constraint R
VICTIM_RELATION_CODES_VW.CODE Implied Constraint R
VICTIM_TYPE_CODES_VW.CODE Implied Constraint R
ZZ_CHARGE_CODES.CODE Implied Constraint R
ZZ_EJS_CODE_NIBRS_MAPPINGS.CODE Implied Constraint R
ZZ_EJS_CODES.CODE Implied Constraint R
ZZ_NIBRS_CODE_EJS_MAPPINGS.CODE Implied Constraint R
ZZ_NIBRS_PROP_MAPPINGS.CODE Implied Constraint R
ZZC1_CHARGE_CODES.CODE Implied Constraint R
ZZC1_EJS_CODE_NIBRS_MAPPINGS.CODE Implied Constraint R
ZZC1_EJS_CODES.CODE Implied Constraint R
ZZC1_NIBRS_CODE_EJS_MAPPINGS.CODE Implied Constraint R
ZZC1_NIBRS_PROP_MAPPINGS.CODE Implied Constraint R
ZZV1_CHARGE_CODES.CODE Implied Constraint R
ZZV1_EJS_CODE_NIBRS_MAPPINGS.CODE Implied Constraint R
ZZV1_EJS_CODES.CODE Implied Constraint R
ZZV1_NIBRS_CODE_EJS_MAPPINGS.CODE Implied Constraint R
ZZV1_NIBRS_PROP_MAPPINGS.CODE Implied Constraint R
BLOOD_DESC varchar2 40  √  null
ACTIVE varchar2 1  √  null
ACTIVE_DATE date 7  √  null
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"CODE" IS NOT NULL BLOOD_CD_CODE_NN

Indexes:
Column(s) Type Sort Constraint Name
CODE Primary key Asc BLOOD_CD_PK

Close relationships  within of separation: