|
|
| 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 |
| DISPATCH_ID |
number |
38 |
|
|
|
|
|
| DISPATCH_DATE |
date |
7 |
√ |
|
null |
|
|
| DISPATCH_TIME |
date |
7 |
√ |
|
null |
|
|
| CLOSE_DATE |
date |
7 |
√ |
|
null |
|
|
| AGENCY |
varchar2 |
25 |
√ |
|
null |
|
|
| CALL_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| INC_REPORT_NUMBER |
varchar2 |
20 |
√ |
|
null |
|
|
| CASE_AGENCY |
varchar2 |
25 |
√ |
|
null |
|
|
| ASSIGNED_TO |
varchar2 |
25 |
√ |
|
null |
|
|
| INTERNAL_ID |
varchar2 |
15 |
√ |
|
null |
|
|
| OFFICER_DISPATCH_DATE |
date |
7 |
√ |
|
null |
|
|
| OFFICER_AGENCY |
varchar2 |
30 |
√ |
|
null |
|
|
| OFFICER_FNAME |
varchar2 |
20 |
√ |
|
null |
|
|
| OFFICER_LNAME |
varchar2 |
20 |
√ |
|
null |
|
|
| OFFICER_TITLE |
varchar2 |
20 |
√ |
|
null |
|
|
| UNIT |
varchar2 |
15 |
√ |
|
null |
|
|
| UNIT_AGENCY |
varchar2 |
30 |
√ |
|
null |
|
|
| STREET_NUMBER |
varchar2 |
10 |
√ |
|
null |
|
|
| STREET_DIRECTION |
varchar2 |
30 |
√ |
|
null |
|
|
| STREET_DIR_SUFFIX |
varchar2 |
30 |
√ |
|
null |
|
|
| STREET_NAME |
varchar2 |
40 |
√ |
|
null |
|
|
| STREET_CD_STREET_TYPE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| SUB_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| SUB_NUMBER |
varchar2 |
40 |
√ |
|
null |
|
|
| CITY |
varchar2 |
40 |
√ |
|
null |
|
|
| STATE |
varchar2 |
30 |
√ |
|
null |
|
|
| ZIP4 |
number |
4 |
√ |
|
null |
|
|
| ZIP5 |
varchar2 |
30 |
√ |
|
null |
|
|
| BEAT |
varchar2 |
30 |
√ |
|
null |
|
|
| SUB_BEAT |
varchar2 |
30 |
√ |
|
null |
|
|
| LATITUDE |
varchar2 |
30 |
√ |
|
null |
|
|
| LONGITUDE |
varchar2 |
30 |
√ |
|
null |
|
|
| BOUNDARY_STREET |
varchar2 |
60 |
√ |
|
null |
|
|
| CROSS_STREET |
varchar2 |
60 |
√ |
|
null |
|
|
| CROSS_STREET_DIRECTION |
varchar2 |
30 |
√ |
|
null |
|
|
| CROSS_STREET_NUMBER |
varchar2 |
10 |
√ |
|
null |
|
|
| CROSS_STREET_DIR_SUFFIX |
varchar2 |
30 |
√ |
|
null |
|
|
| CROSS_STREET_TYPE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| ASSIGNED_INCIDENT |
varchar2 |
1 |
√ |
|
null |
|
|
| UPDATOR_DATE |
date |
7 |
√ |
|
null |
|
|
| COMMON_PLACE_NAME |
varchar2 |
80 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
select
de.DISPATCH_ID,
de.DISPATCH_DATE,
de.DISPATCH_TIME,
de.CLOSE_DATE,
de.AGENCY,
de.CALL_TYPE,
dec.INC_REPORT_NUMBER,
dec.AGENCY,
dec.ASSIGNED_TO,
deo.CAD_PERSID,
deo.DISPATCH_DATE,
deo.OFFICER_AGENCY,
deo.OFFICER_FNAME,
deo.OFFICER_LNAME,
deo.OFFICER_TITLE,
deo.UNIT,
deo.UNIT_AGENCY,
de.STREET_NUMBER,
de.STREET_DIRECTION,
de.STREET_DIR_SUFFIX,
de.STREET_NAME,
de.STREET_CD_STREET_TYPE_CODE,
de.SUB_TYPE,
de.SUB_NUMBER,
de.CITY,
de.STATE,
de.ZIP4,
de.ZIP5,
de.BEAT,
de.SUB_BEAT,
de.LATITUDE,
de.LONGITUDE,
de.BOUNDARY_STREET,
de.CROSS_STREET,
de.CROSS_STREET_DIRECTION,
de.CROSS_STREET_NUMBER,
de.CROSS_STREET_DIR_SUFFIX,
de.CROSS_STREET_TYPE_CODE,
dec.assigned_incident,
de.updator_date,
de.common_place_name
FROM DISPATCH_EVENTS de,
DISPATCH_EVENT_CASES dec,
DISPATCH_EVENT_OFFICERS deo
WHERE de.dispatch_id = dec.dispatch_id(+) AND
de.dispatch_id = deo.dispatch_id(+)
Possibly Referenced Tables/Views:
