Table slot9.WORLD.TSTA.PHOTO_LINEUP_IMAGES
This table is used to store Images that are a part of a photo lineup
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
PHOTO_LINEUP_IMAGE_ID number 0 Primary Key
PHOTO_LINEUP_ID number 0
PHOTO_LINEUP.PHOTO_LINEUP_ID PHTOLNUP_IMG_PHTOLNUP_FK R
Foreign key to PHOTO_LINEUP table
IMAGE_ID number 0
IMAGES.IMAGE_ID PHTOLNUP_IMG_IMA_FK R
Foreign key to IMAGES table
SUSPECT_FLAG varchar2 1  √  'N' Flag that marks this image as the suspect image
SORT_ORDER number 0
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
CREATOR_DATE date 7  √  null
CREATOR_ID varchar2 100  √  null
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
SUSPECT_FLAG IN ('Y','N') CK_PHTOLNUP_IMG_SUSP_FLG
"PHOTO_LINEUP_IMAGE_ID" IS NOT NULL PHTOLNUP_IMG_ID_NN
"IMAGE_ID" IS NOT NULL PHTOLNUP_IMG_IMGID_NN
"PHOTO_LINEUP_ID" IS NOT NULL PHTOLNUP_IMG_LNUP_ID_NN
"SORT_ORDER" IS NOT NULL PHTOLNUP_IMG_ORDER_NN

Indexes:
Column(s) Type Sort Constraint Name
PHOTO_LINEUP_IMAGE_ID Primary key Asc PHTOLNUP_IMG_PK
IMAGE_ID Performance Asc PHTOLNUP_IMG_IMA_FK_I
PHOTO_LINEUP_ID Performance Asc PHTOLNUP_IMG_PHTOLNUP_FK_I

Close relationships  within of separation: