View slot9.WORLD.TSTA.UFI_INCIDENTS_OFFENSE_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
DISPLAY varchar2 288  √  null
VAL_1 varchar2 30
VAL_2 varchar2 0  √  null
VAL_3 varchar2 0  √  null
VAL_4 varchar2 0  √  null
VAL_5 varchar2 0  √  null
KEY_VAL_1 number 0
KEY_VAL_2 number 5
KEY_VAL_3 varchar2 0  √  null
KEY_VAL_4 varchar2 0  √  null
KEY_VAL_5 varchar2 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT OC.OFFENSE_CODE || ' - ' || OC.OFFENSE_DESC, OC.OFFENSE_CODE AS VAL_1, NULL AS VAL_2, NULL AS VAL_3, NULL AS VAL_4, NULL AS VAL_5, O.INC_INCIDENT_ID AS KEY_VAL_1, O.SUPP_SEQ AS KEY_VAL_2, NULL AS KEY_VAL_3, NULL AS KEY_VAL_4, NULL AS KEY_VAL_5 FROM INCIDENTS I INNER JOIN OFFENSES O ON I.INCIDENT_ID = O.INC_INCIDENT_ID INNER JOIN OFFENSE_CODES OC ON O.OFFNS_CD_OFFENSE_CODE = OC.OFFENSE_CODE
 
Possibly Referenced Tables/Views:
INCIDENTS OFFENSE_CODES OFFENSES