Table slot9.WORLD.TSTA.IMAGES
This table stores images added to items such as ARRESTS, citations, etc. throughout 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
IMAGE_ID number 38
ADDRESS_IMAGES.IMAGE_ID ADDIM_IMA_FK R
AGENCY_CODES.IMAGE_ID AGNCY_CD_IMA_FK R
ARREST_IMAGES.IMAGE_ID ARRIMG_IMA_FK R
ARREST_PROPERTIES.RELEASE_SIGNATURE_ID ARP_IMA_FK R
ARREST_PROPERTIES_AUDIT.RELEASE_SIGNATURE_ID ARPA_IMA_FK R
BUSINESS_IMAGES.IMA_IMAGE_ID BIMG_IMA_FK R
CASE_IMAGES.IMAGE_ID CASIMG_IMA_FK R
CHAIN_OF_CUSTODIES.IMAGE_ID COC_IMG_ID_FK R
CITATION_IMAGES.IMAGE_ID CITIMG_IMA_FK R
COURSE_IMAGES.IMAGE_ID CRSIMG_IMA_FK R
COURSE_INST_EMP_IMAGES.IMAGE_ID CRSIEMPIMG_IMA_FK R
COURT_APPEARANCE_IMAGES.IMAGE_ID CRTAPPIMG_IMA_FK C
COURT_CASE_IMAGES.IMAGE_ID CRTCASEIMG_IMA_FK C
COURT_PAPER_IMAGES.IMAGE_ID CPAP_IMA_IMA_FK C
CRIMINAL_COMP_IMAGES.IMAGE_ID CCIMA_IMA_FK R
DISPATCH_EVENT_IMAGES.IMAGE_ID DISPIMA_IMA_FK C
DV_CRASH_IMAGES.IMAGE_ID CRASHIMG_IMA_FK R
DV_IMAGES.IMAGE_ID DVIMA_IMA_FK R
DV_REQUEST_IMAGES.IMAGE_ID DVREQIMA_IMA_FK R
DV_SERVICE_IMAGES.IMAGE_ID DVSERIMA_IMA_FK R
EMPLOYEE_IMAGES.IMA_IMAGE_ID EMP_IMA_IMA_FK R
EMPLOYEE_INFO_IMAGES.IMAGE_ID EIIMA_IMA_FK R
EXTERNAL_INFO_RESPONSE_IMAGES.IMAGE_ID EXTINFRSPI_IMA_FK R
FLDINT_IMAGES.IMAGE_ID FLDIM_IMA_FK C
GANG_IMAGES.IMAGE_ID GI_IMA_FK R
IMPOUND_IMAGES.IMAGE_ID IMPIMA_IMA_FK C
INCIDENT_IMAGES.IMA_IMAGE_ID II_IMA_FK R
JUDGES.SIG_IMAGE_ID JUD_IMA_FK R
K9_IMAGES.IMAGE_ID K9IMA_IMA_FK R
OFFICERS.SIG_IMAGE_ID OFF1_IMA_FK R
PAWN_TICKET_IMAGES.IMA_IMAGE_ID PTI_IMA_FK R
PERMIT_IMAGES.IMAGE_ID PRMTIMA_IMA_FK C
PERSON_FINGERPRINTS.IMAGE_ID PF_IMA_FK C
PERSON_FINGERPRINTS_VW.IMAGE_ID Implied Constraint R
PHOTO_LINEUP_IMAGES.IMAGE_ID PHTOLNUP_IMG_IMA_FK R
PHOTO_LINEUP_LIBRARY.IMAGE_ID PHLNLB_IMA_FK R
PROPERTY_HOLDS.DISPOSITION_SIG_IMAGE_ID PROPHO_IMA_FK R
PROPERTY_IMAGES.IMAGE_ID PROIMG_IMA_FK R
REPORT_IMAGES_REPO.IMAGE_ID RIREP_IMA_FK R
REPORT_UNIT_IMAGES.IMAGE_ID RUIMG_IMA_FK R
USER_FIELD_SIG_VALUES.IMAGE_ID UFSIGV_IMA_FK R
USI_IMAGES.IMAGE_ID USIIMA_IMA_FK C
VEHICLE_IMAGES.IMA_IMAGE_ID VIMG_IMA_FK R
WARRANT_IMAGES.IMAGE_ID WARIMG_IMA_FK R
ZZ_AGENCY_CODES.IMAGE_ID Implied Constraint R
ZZV1_AGENCY_CODES.IMAGE_ID Implied Constraint R
IMAGE_FILENAME varchar2 255  √  null
IMAGE blob 4000  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
REC_ID number 0  √  null
FILE_TYPE varchar2 6  √  null
THUMBNAIL blob 4000  √  null
AGENCY_ATTACHMENT_INT_ID number 0  √  null
AGENCY_ATTACHMENT_INTERFACES.ID IMA_AGATTINT_FK R
Use if attachment stored externally. FK to AGENCY_ATTACHMENT_INTERFACES specifies what external storage solution manages this attachment
EXT_IMAGE_ID varchar2 100  √  null Use if attachment stored externally. Unique identifier to external storage solution
FILE_PATH varchar2 260  √  null Use if attachment is stored on file system outside of database

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"IMAGE_ID" IS NOT NULL IMA_IMAGE_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
IMAGE_ID Primary key Asc IMA_PK
AGENCY_ATTACHMENT_INT_ID Performance Asc IMA_AGATTINT_FK_I

Close relationships  within of separation: