View slot9.WORLD.TSTA.SUSPECT_QUERY_VW
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
IMA_IMAGE_ID number 0
PER_PERSON_ID number 0
MC1_MUGSHOT_CODE varchar2 30  √  null
IMAGE blob 4000  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT PI.IMA_IMAGE_ID , PI.PER_PERSON_ID , PI.MC1_MUGSHOT_CODE , I.IMAGE FROM PERSON_IMAGES PI, IMAGES I WHERE I.IMAGE_ID = PI.IMA_IMAGE_ID
 
Possibly Referenced Tables/Views:
IMAGES PERSON_IMAGES