|
|
| 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 |
| INCIDENT_ID |
number |
0 |
√ |
|
null |
|
|
| EVENT_DATE |
date |
7 |
√ |
|
null |
|
|
| TYPE |
varchar2 |
23 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT
IP.INC_INCIDENT_ID,
TRUNC(A.ARREST_DATE),
'ARREST_DATE'
FROM ARRESTEES A
INNER JOIN INCIDENT_PEOPLE IP ON A.INC_PER_ID = IP.INC_PER_ID
INNER JOIN INCIDENT_SUPPLEMENTS ISUP ON IP.INC_INCIDENT_ID = ISUP.INC_INCIDENT_ID AND IP.SUPP_SEQ = ISUP.SUPP_SEQ
WHERE A.ARREST_DATE IS NOT NULL
AND ISUP.ISC_STATUS_CODE = 'A'
UNION
SELECT
O.INC_INCIDENT_ID,
TRUNC(O.OFFENSE_STATUS_DATE),
'OFFENSE_STATUS_DATE'
FROM OFFENSES O
INNER JOIN INCIDENT_SUPPLEMENTS ISUP ON O.INC_INCIDENT_ID = ISUP.INC_INCIDENT_ID AND O.SUPP_SEQ = ISUP.SUPP_SEQ
WHERE ISUP.ISC_STATUS_CODE = 'A'
UNION
SELECT IPROP.INCSUP_INCIDENT_ID,
TRUNC(IPROP.DATE_RECOVERED),
'PROPERTY_DATE_RECOVERED'
FROM INCIDENT_PROPERTIES IPROP
INNER JOIN INCIDENT_SUPPLEMENTS ISUP ON IPROP.INCSUP_INCIDENT_ID = ISUP.INC_INCIDENT_ID AND IPROP.INCSUP_SUPP_SEQ = ISUP.SUPP_SEQ
WHERE IPROP.DATE_RECOVERED IS NOT NULL
AND ISUP.ISC_STATUS_CODE = 'A'
UNION
SELECT
IV.INCIDENT_ID,
TRUNC(IV.DATE_RECOVERED),
'VEHICLE_DATE_RECOVERED'
FROM INCIDENT_VEHICLES IV
INNER JOIN INCIDENT_SUPPLEMENTS ISUP ON IV.INCIDENT_ID = ISUP.INC_INCIDENT_ID AND IV.SUPP_SEQ = ISUP.SUPP_SEQ
WHERE IV.DATE_RECOVERED IS NOT NULL
AND ISUP.ISC_STATUS_CODE = 'A'
Possibly Referenced Tables/Views:
