|
|
| 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 |
| VICTIM_NAME |
varchar2 |
181 |
√ |
|
null |
|
|
| INC_INCIDENT_ID |
number |
0 |
√ |
|
null |
|
|
| BUSINESS_NUMBER |
number |
0 |
√ |
|
null |
|
|
| INC_PER_ID |
number |
0 |
√ |
|
null |
|
|
| PER_PERSON_ID |
number |
0 |
√ |
|
null |
|
|
| MN_MN_ID |
number |
0 |
√ |
|
null |
|
|
| SUPP_SEQ |
number |
0 |
√ |
|
null |
|
|
| ROLE_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| V_NUMBER |
number |
38 |
√ |
|
null |
|
| VICTIMS.V_NUMBER
|
Implied Constraint R |
|
| ACTIVITY_TYPE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| ASSIGNMENT_TYPE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| ORI_OTHER_JURIS |
varchar2 |
9 |
√ |
|
null |
|
|
| VICTIM_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT mn.fname || ' ' || lname victim_name,
ip.inc_incident_id,
TO_NUMBER (NULL) business_number,
ip.inc_per_id,
ip.per_person_id,
ip.mn_mn_id,
ip.supp_seq,
irp.role_type,
v.v_number,
v.activity_type_code,
v.assignment_type_code,
v.ori_other_juris,
v.victm_cd_victim_type_code
FROM incident_people ip,
incident_person_roles irp,
master_names mn,
victims v
WHERE ip.mn_mn_id = mn.mn_id
AND ip.per_person_id = mn.per_person_id
AND irp.inc_per_id = ip.inc_per_id
AND ip.inc_per_id = v.inc_per_id(+)
AND EXISTS (SELECT 1 FROM INCIDENT_PERSON_ROLES IPR WHERE IPR.INC_PER_ID = IP.INC_PER_ID AND IPR.ROLE_TYPE = 'V')
UNION
SELECT b.business_name victim_name,
ib.inc_incident_id,
ib.busns_business_number business_number,
TO_NUMBER (NULL) inc_per_id,
TO_NUMBER (NULL) per_person_id,
TO_NUMBER (NULL) mn_mn_id,
ib.supp_seq,
ib.ib1_role_type role_type,
v.v_number,
v.activity_type_code,
v.assignment_type_code,
v.ori_other_juris,
v.victm_cd_victim_type_code
FROM incident_businesses ib, businesses b, victims v
WHERE b.business_number = ib.busns_business_number
AND ib.busns_business_number = v.business_number(+)
AND ib.inc_incident_id = v.incident_id(+)
AND ib.ib1_role_type = 'V'
Possibly Referenced Tables/Views:
