Table slot9.WORLD.TSTA.PERSON_IMAGES
This table stores the link to images added to a MASTER PERSON in the application. The image itself is stored in IMAGES
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 PI_PER_FK C
Person ID number
IMA_IMAGE_ID number 0 Unique ID for Image
IMAGE_DATE date 7  √  null Date of the image
IMAGE_DESC varchar2 2000  √  null Description of the image
CREATOR_ID varchar2 100  √  null Person creating the record
CREATOR_DATE date 7  √  null Date of record creation
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
MC1_MUGSHOT_CODE varchar2 30  √  null
EJS_CODES.CODE PI_MC1_MUGSHOT_COD_EJS_CODE_FK R
PHY_PHYS_DESC_ID number 8  √  null
PHYSICAL_DESCRIPTIONS.PHYS_DESC_ID PI_PHY_FK R
MC1_MUGSHOT_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE PI_MC1_MUGSHOT_COD_EJS_CODE_FK R
REC_ID number 0  √  null
PRIMARY_FLAG varchar2 1  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"PER_PERSON_ID" IS NOT NULL PI_PER_PERSON_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
PER_PERSON_ID + IMA_IMAGE_ID Primary key Asc/Asc PI_PK
MC1_MUGSHOT_CODE Performance Asc PI_MC1_FK_I
MC1_MUGSHOT_CODE_TYPE + MC1_MUGSHOT_CODE Performance Asc/Asc PI_MC1_MUGSHOT_COD_EJS_CODE_I
PER_PERSON_ID Performance Asc PI_PER_FK_I
PHY_PHYS_DESC_ID Performance Asc PI_PHY_FK_I

Close relationships  within of separation: