|
|
| 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 |
| OFFICER_ID |
number |
0 |
|
|
|
|
| OFFICERS.OFFICER_ID
|
Implied Constraint R |
|
| INC_CASE_ID |
number |
0 |
|
|
|
|
|
| INC_CASE_NUMBER |
varchar2 |
20 |
|
|
|
|
|
| INCIDENT_CASE_AGENCY |
varchar2 |
30 |
|
|
|
|
|
| INCIDENT_ID |
number |
0 |
√ |
|
null |
|
|
| INC_REPORT_NUMBER |
varchar2 |
20 |
√ |
|
null |
|
|
| INCIDENT_AGENCY |
varchar2 |
30 |
√ |
|
null |
|
|
| UNIT_CODE |
varchar2 |
5 |
√ |
|
null |
|
|
| LNAME |
varchar2 |
20 |
|
|
|
|
|
| FNAME |
varchar2 |
20 |
√ |
|
null |
|
|
| TITLE |
varchar2 |
20 |
√ |
|
null |
|
|
| SUPERVISOR |
varchar2 |
1 |
√ |
|
null |
|
|
| USER_ID |
varchar2 |
100 |
√ |
|
null |
|
|
| INTERNAL_ID |
varchar2 |
100 |
|
|
|
|
|
| DETECTIVE |
varchar2 |
1 |
√ |
|
null |
|
|
| RSC_STATUS_CODE |
varchar2 |
30 |
|
|
|
|
|
| UCR_STATUS |
varchar2 |
30 |
√ |
|
null |
|
|
| DATE_ASSIGNED |
date |
7 |
√ |
|
null |
|
|
| DATE_CLEARED |
date |
7 |
√ |
|
null |
|
|
| DATE_EXPIRED |
date |
7 |
√ |
|
null |
|
|
| REVIEW_UPDATE |
varchar2 |
1 |
√ |
|
null |
|
|
| REPORT_DATE |
date |
7 |
√ |
|
null |
|
|
| START_DATE |
date |
7 |
√ |
|
null |
|
|
| END_DATE |
date |
7 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT o.officer_id, ic.inc_case_id, ic.inc_case_number, ic.agency_code,
ici.incident_id, i.inc_report_number, i.agncy_cd_agency_code,
ic.unit_code, o.lname, o.fname, o.title, o.supervisor, o.user_id,
o.internal_id, o.detective, ic.rsc_status_code, ic.case_status_code,
ico.end_date, ic.date_cleared, ic.date_expired,
ic.review_update, i.report_date, i.start_date, i.end_date
FROM officers o,
incident_cases ic,
incident_case_officers ico,
incidents i,
inc_case_incidents ici
WHERE o.officer_id = ico.officer_id
AND ic.inc_case_id = ici.inc_case_id(+)
AND ic.inc_case_id = ico.inc_case_id
AND ici.incident_id = i.incident_id(+)
Possibly Referenced Tables/Views:
