|
|
| 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 |
|
|
|
|
|
| AGNCY_CD_AGENCY_CODE |
varchar2 |
30 |
|
|
|
|
|
| REPORT_DATE |
date |
7 |
|
|
|
|
|
| SUMMARY |
varchar2 |
1000 |
√ |
|
null |
|
|
| VEHICLE_ID |
number |
38 |
|
|
|
|
| VEHICLES.VEHICLE_ID
|
Implied Constraint R |
|
| ROLE_CODE |
varchar2 |
30 |
|
|
|
|
|
| STATUS_CODE |
varchar2 |
30 |
|
|
|
|
|
| CASE_NUMBER |
char |
0 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT
I.INCIDENT_ID,
I.AGNCY_CD_AGENCY_CODE,
I.REPORT_DATE,
I.SUMMARY,
IV.VEHICLE_ID,
IV.ROLE_CODE,
IV.STATUS_CODE,
''
FROM INCIDENTS I
, INCIDENT_VEHICLES IV
WHERE I.INCIDENT_ID = IV.INCIDENT_ID
Possibly Referenced Tables/Views:
