Table slot9.WORLD.TSTA.PHYSICAL_DESCRIPTIONS
This tables stores the physical description entered for a MASTER PERSON 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
PER_PERSON_ID number 0
PEOPLE.PERSON_ID PHY_PER_FK C
Person ID number
DATE_OF_INFO date 7  √  null Date information was received.
BLD_CD_BUILD_CODE varchar2 30  √  null
EJS_CODES.CODE PHY_BLD_CD_BUILD_C_EJS_CODE_FK R
build code (key)
EYE_CD_EYE_CODE varchar2 30  √  null
EJS_CODES.CODE PHY_EYE_CD_EYE_COD_EJS_CODE_FK R
Eye color code
HAIR_LNGTH_HAIR_LENGTH_CODE varchar2 30  √  null
EJS_CODES.CODE PHY_HAIR_LNGTH_HAI_EJS_CODE_FK R
code for length - "B"ald, "S"ort, "M"edium, "L"ong, "U"nknown.
SKN_CD_SKIN_CODE varchar2 30  √  null
EJS_CODES.CODE PHY_SKN_CD_SKIN_CO_EJS_CODE_FK R
Skin tone code
FACE_HR_FACIAL_HAIR varchar2 30  √  null
EJS_CODES.CODE PHY_FACE_HR_FACIAL_EJS_CODE_FK R
Code for type of facial hair
HAIR_CD_HAIR_CODE varchar2 30  √  null
EJS_CODES.CODE PHY_HAIR_CD_HAIR_C_EJS_CODE_FK R
Code for hair color
HEIGHT varchar2 3  √  null Person"s height.
WEIGHT varchar2 3  √  null Person"s weight
GLASSES varchar2 1  √  'N' Does the Person Where Glasses
CREATOR_ID varchar2 100  √  null Person creating the record
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
PHYS_DESC_ID number 8
ARREST_LIVESCAN_VW.PHYS_DESC_ID Implied Constraint R
JS_BASE64_IMAGES_VW.PHYS_DESC_ID Implied Constraint R
PEOPLE_COMBO_VW.PHYS_DESC_ID Implied Constraint R
PEOPLE_PHYS_DESC_VW.PHYS_DESC_ID Implied Constraint R
PERSON_IMAGES.PHY_PHYS_DESC_ID PI_PHY_FK R
AGE number 3  √  null
BLD_CD_BUILD_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE PHY_BLD_CD_BUILD_C_EJS_CODE_FK R
EYE_CD_EYE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE PHY_EYE_CD_EYE_COD_EJS_CODE_FK R
FACE_HR_FACIAL_HAIR_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE PHY_FACE_HR_FACIAL_EJS_CODE_FK R
HAIR_CD_HAIR_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE PHY_HAIR_CD_HAIR_C_EJS_CODE_FK R
HAIR_LNGTH_HAIR_LENGTH_CO_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE PHY_HAIR_LNGTH_HAI_EJS_CODE_FK R
SKN_CD_SKIN_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE PHY_SKN_CD_SKIN_CO_EJS_CODE_FK R
REC_ID number 0  √  null
HAIR_STYLE_CODE varchar2 30  √  null
EJS_CODES.CODE PHY_HAIRSTY_EJS_CODES_FK R
HAIR_STYLE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE PHY_HAIRSTY_EJS_CODES_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
glasses IN ( 'Y' , 'N' ) CK_PHY_GLASSES
"PER_PERSON_ID" IS NOT NULL PHY_PER_PERSON_ID_NN
"PHYS_DESC_ID" IS NOT NULL PHY_PHYS_DESC_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
PHYS_DESC_ID Primary key Asc PHY_PK
BLD_CD_BUILD_CODE_TYPE + BLD_CD_BUILD_CODE Performance Asc/Asc PHY_BLD_CD_BUILD_C_EJS_CODE_I
BLD_CD_BUILD_CODE Performance Asc PHY_BLD_CD_FK_I
EYE_CD_EYE_CODE_TYPE + EYE_CD_EYE_CODE Performance Asc/Asc PHY_EYE_CD_EYE_COD_EJS_CODE_I
EYE_CD_EYE_CODE Performance Asc PHY_EYE_CD_FK_I
FACE_HR_FACIAL_HAIR_TYPE + FACE_HR_FACIAL_HAIR Performance Asc/Asc PHY_FACE_HR_FACIAL_EJS_CODE_I
FACE_HR_FACIAL_HAIR Performance Asc PHY_FACE_HR_FK_I
HAIR_CD_HAIR_CODE Performance Asc PHY_HAIR_CD_FK_I
HAIR_CD_HAIR_CODE_TYPE + HAIR_CD_HAIR_CODE Performance Asc/Asc PHY_HAIR_CD_HAIR_C_EJS_CODE_I
HAIR_LNGTH_HAIR_LENGTH_CODE Performance Asc PHY_HAIR_LNGTH_FK_I
HAIR_LNGTH_HAIR_LENGTH_CO_TYPE + HAIR_LNGTH_HAIR_LENGTH_CODE Performance Asc/Asc PHY_HAIR_LNGTH_HAI_EJS_CODE_I
HAIR_STYLE_TYPE + HAIR_STYLE_CODE Performance Asc/Asc PHY_HAIRSTY_EJS_CODES_FK_I
PER_PERSON_ID Performance Asc PHY_PER_FK_I
SKN_CD_SKIN_CODE Performance Asc PHY_SKN_CD_FK_I
SKN_CD_SKIN_CODE_TYPE + SKN_CD_SKIN_CODE Performance Asc/Asc PHY_SKN_CD_SKIN_CO_EJS_CODE_I

Close relationships  within of separation: