|
|
| 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 |
| INC_INCIDENT_ID |
number |
0 |
√ |
|
null |
|
|
| PER_PERSON_ID |
number |
0 |
√ |
|
null |
|
|
| MN_MN_ID |
number |
0 |
√ |
|
null |
|
|
| INC_PER_ID |
number |
0 |
√ |
|
null |
|
|
| BUSINESS_NUMBER |
number |
0 |
√ |
|
null |
|
|
| SUPP_SEQ |
number |
0 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT i.incident_id, ip.per_person_id, ip.mn_mn_id, ip.inc_per_id,
TO_NUMBER (NULL) business_number, ip.supp_seq
FROM incident_people ip, incidents i
WHERE i.incident_id = ip.inc_incident_id
UNION
SELECT i.incident_id "INC_INCIDENT_ID", TO_NUMBER (NULL) per_person_id,
TO_NUMBER (NULL) mn_mn_id, TO_NUMBER (NULL) inc_per_id,
ib.busns_business_number business_number, ib.supp_seq "SUPP_SEQ"
FROM incidents i, incident_businesses ib
WHERE i.incident_id = ib.inc_incident_id
Possibly Referenced Tables/Views:
