|
|
| 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 |
|
|
|
|
|
| INC_REPORT_NUMBER |
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 |
|
|
|
|
|
| STATUS_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| APPROVAL_DATE |
date |
7 |
√ |
|
null |
|
|
| 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 |
|
|
| FORWARD_TO_SA |
varchar2 |
1 |
√ |
|
null |
|
|
| INC_AGNCY_CD_AGENCY_CODE |
varchar2 |
30 |
|
|
|
|
|
| INC_START_TIME |
date |
7 |
√ |
|
null |
|
|
| INC_CREATOR_ID |
varchar2 |
100 |
√ |
|
null |
|
|
| DS_ICR_DATE |
date |
7 |
√ |
|
null |
|
|
| DS_ICR_SUBMISSION_STATUS |
varchar2 |
30 |
√ |
|
null |
|
|
| PUBLIC_FLAG |
varchar2 |
1 |
√ |
|
null |
|
|
| APPROVING_AGENCY_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| END_DATE_TIME |
date |
7 |
√ |
|
null |
|
|
| CARGO_THEFT_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| INC_DISP_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| INC_DISP_CODE_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT
i.incident_id
, i.inc_report_number
, isupp.supp_agency_code
, i.report_date
, i.start_date
, i.end_date
, isupp.isc_status_code
, isupp.isc_status_code_type
, isupp.approval_date
, isupp.supp_seq
, isupp.responsible_user_id
, isupp.agency_only
, isupp.cid
, isupp.security_level
, i.summary
, isupp.forward_to_sa
, i.agncy_cd_agency_code
, i.start_time
, i.creator_id
, isupp.ds_icr_date
, isupp.ds_icr_submission_status
, i.public_flag
, isupp.approving_agency_code
, i.end_time
, i.cargo_theft_code
, i.inc_disp_code
, i.inc_disp_code_type
FROM
incidents i
, incident_supplements isupp
WHERE isupp.inc_incident_id = i.incident_id
Possibly Referenced Tables/Views:
