View slot9.WORLD.TSTA.ZZV1_NIBRS_CRIME_TARGETS
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
AUDIT_TIMESTAMP date 7  √  null
AUDIT_TRANSACTION_TYPE varchar2 1  √  null
AUDIT_USER_NAME varchar2 100  √  null
AUDIT_TRUE_NULLS varchar2 250  √  null
NIBRS_CODE varchar2 30  √  null
NIBRS_CODES.NIBRS_CODE Implied Constraint R
CRIME_AGAINST_CODE varchar2 30  √  null
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT ZZ1.AUDIT_TIMESTAMP AUDIT_TIMESTAMP, ZZ1.AUDIT_TRANSACTION_TYPE AUDIT_TRANSACTION_TYPE, ZZ1.AUDIT_USER_NAME AUDIT_USER_NAME, ZZ1.AUDIT_TRUE_NULLS AUDIT_TRUE_NULLS, ZZ1.NIBRS_CODE NIBRS_CODE, ZZ1.CRIME_AGAINST_CODE CRIME_AGAINST_CODE, ZZ1.REC_ID REC_ID FROM ZZ_NIBRS_CRIME_TARGETS ZZ1 union all select sysdate, 'C', null, null, ZZ2.NIBRS_CODE, ZZ2.CRIME_AGAINST_CODE, ZZ2.REC_ID FROM NIBRS_CRIME_TARGETS ZZ2 where exists ( select * from ZZ_NIBRS_CRIME_TARGETS where NIBRS_CODE= ZZ2.NIBRS_CODE AND CRIME_AGAINST_CODE= ZZ2.CRIME_AGAINST_CODE )
 
Possibly Referenced Tables/Views:


Close relationships: