|
|
| 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 |
√ |
|
null |
|
| OFFICERS.OFFICER_ID
|
Implied Constraint R |
|
| AGNCY_CD_AGENCY_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| LNAME |
varchar2 |
20 |
√ |
|
null |
|
|
| FNAME |
varchar2 |
20 |
√ |
|
null |
|
|
| TITLE |
varchar2 |
20 |
√ |
|
null |
|
|
| SUPERVISOR |
varchar2 |
1 |
√ |
|
null |
|
|
| USER_ID |
varchar2 |
100 |
√ |
|
null |
|
|
| DETECTIVE |
varchar2 |
1 |
√ |
|
null |
|
|
| INC_INCIDENT_ID |
number |
0 |
|
|
|
|
|
| INC_CASE_ID |
number |
0 |
|
|
|
|
|
| INC_REPORT_NUMBER |
varchar2 |
20 |
|
|
|
|
|
| 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 |
|
|
| REPORT_DATE |
date |
7 |
|
|
|
|
|
| START_DATE |
date |
7 |
√ |
|
null |
|
|
| END_DATE |
date |
7 |
√ |
|
null |
|
|
| REVIEW_UPDATE |
varchar2 |
1 |
√ |
|
null |
|
|
| INTERNAL_ID |
varchar2 |
100 |
√ |
|
null |
|
|
| SUPP_SEQ |
number |
0 |
|
|
|
|
|
| STATUS |
varchar2 |
30 |
|
|
|
|
|
| RESPONSIBLE_USER_ID |
varchar2 |
100 |
√ |
|
null |
|
|
| AGENCY_ONLY |
varchar2 |
1 |
√ |
|
null |
|
|
| CID |
varchar2 |
1 |
√ |
|
null |
|
|
| SECURITY_LEVEL |
number |
38 |
√ |
|
null |
|
|
| SUMMARY |
varchar2 |
1000 |
√ |
|
null |
|
|
| UNIT_CODE |
varchar2 |
5 |
√ |
|
null |
|
|
| INC_CASE_NUMBER |
varchar2 |
20 |
|
|
|
|
|
| INC_CASE_AGENCY |
varchar2 |
30 |
|
|
|
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT o.officer_id,
ins.supp_agency_code,
o.lname, o.fname,
o.title,
o.supervisor,
o.user_id,
o.detective,
ici.incident_id,
ic.inc_case_id,
i.inc_report_number,
ic.rsc_status_code,
ic.case_status_code,
ico.end_date,
ic.date_cleared,
ic.date_expired,
i.report_date,
i.start_date,
i.end_date,
ic.review_update,
o.internal_id,
ins.supp_seq,
ins.isc_status_code,
ins.responsible_user_id,
ins.agency_only, ins.cid,
ins.security_level,
i.summary, ic.unit_code,
ic.inc_case_number,
ic.agency_code
FROM officers o,
incident_cases ic,
incident_case_officers ico,
incidents i,
incident_supplements ins,
inc_case_incidents ici
WHERE o.officer_id(+) = ico.officer_id
AND i.incident_id = ici.incident_id
AND i.incident_id = ins.inc_incident_id
AND ici.incident_id = ins.inc_incident_id
AND ic.inc_case_id = ici.inc_case_id
AND ic.inc_case_id = ico.inc_case_id
AND ico.role_code='PRIMARY'
Possibly Referenced Tables/Views:
