|
|
| 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 |
|
|
|
|
|
| INCIDENTNUM |
varchar2 |
20 |
|
|
|
|
|
| AGNCY_CD_AGENCY_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| REPORT_DATE |
date |
7 |
|
|
|
|
|
| START_DATE |
date |
7 |
√ |
|
null |
|
|
| END_DATE |
date |
7 |
√ |
|
null |
|
|
| STATUS |
varchar2 |
30 |
|
|
|
|
|
| SUPP_SEQ |
number |
0 |
|
|
|
|
|
| RESPONSIBLE_USER_ID |
varchar2 |
100 |
√ |
|
null |
|
|
| AGENCY_ONLY |
varchar2 |
1 |
√ |
|
null |
|
|
| CID |
varchar2 |
1 |
√ |
|
null |
|
|
| SECURITY_LEVEL |
number |
38 |
√ |
|
null |
|
|
| SUMMARY |
varchar2 |
1000 |
√ |
|
null |
|
|
| ADDRESS_ID |
number |
0 |
|
|
|
|
|
| STREET_NUMBER |
varchar2 |
10 |
√ |
|
null |
|
|
| DIRCT_CD_DIRECTION_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| PW_ADDR_STREET1 |
varchar2 |
40 |
√ |
|
null |
|
|
| STREET_CD_STREET_TYPE_CODE_COD |
varchar2 |
30 |
√ |
|
null |
|
|
| ADDR_SC_ADDRESS_SUBTYPE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| SUB_NUMBER |
varchar2 |
50 |
√ |
|
null |
|
|
| INTRSECT1_STREET_NUMBER |
varchar2 |
10 |
√ |
|
null |
|
|
| INTRSECT1_DIR |
varchar2 |
30 |
√ |
|
null |
|
|
| INTRSECT1_NAME |
varchar2 |
40 |
√ |
|
null |
|
|
| ADDITIONAL_INFO |
varchar2 |
255 |
√ |
|
null |
|
|
| BEAT |
varchar2 |
30 |
√ |
|
null |
|
|
| SUB_BEAT |
varchar2 |
30 |
√ |
|
null |
|
|
| PW_ADDR_CITY |
varchar2 |
40 |
√ |
|
null |
|
|
| STATE_CD_STATE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| PW_ADDR_ZIPCODE |
varchar2 |
30 |
√ |
|
null |
|
|
| ZIP4 |
number |
0 |
√ |
|
null |
|
|
| INTERNAL_INCIDENT |
varchar2 |
1 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT i.incident_id, i.inc_report_number,
isupp.supp_agency_code "AGNCY_CD_AGENCY_CODE", i.report_date,
i.start_date, i.end_date, isupp.isc_status_code "STATUS",
isupp.supp_seq, isupp.responsible_user_id, isupp.agency_only,
isupp.cid, isupp.security_level, i.summary, a.address_id,
a.street_number, a.dirct_cd_direction_code, a.street_name,
a.street_cd_street_type_code, a.addr_sc_address_subtype_code,
a.sub_number, a.intrsect1_street_number, a.intrsect1_dir,
a.intrsect1_name, ia.inc_addr_comment, a.beat, a.sub_beat, a.city,
a.state_cd_state_code, a.zip5, a.zip4, i.internal_incident
FROM addresses a,
incidents i,
incident_supplements isupp,
incident_addresses ia
WHERE ia.incident_id = i.incident_id
AND isupp.inc_incident_id = i.incident_id
AND a.address_id = ia.address_id
Possibly Referenced Tables/Views:
