|
|
| 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 |
38 |
|
|
|
|
|
| INC_REPORT_NUMBER |
varchar2 |
20 |
|
|
|
|
|
| AGNCY_CD_AGENCY_CODE |
varchar2 |
30 |
|
|
|
|
|
| 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 |
|
|
| GANG_ID |
number |
20 |
|
|
|
|
| GANGS.GANG_ID
|
Implied Constraint R |
|
| COMMENTS |
varchar2 |
255 |
√ |
|
null |
|
|
| GANG_ROLE_CODE |
varchar2 |
30 |
|
|
|
|
|
| GANG_ROLE_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| GANG_TYPE_CODE |
varchar2 |
30 |
|
|
|
|
|
| NAME |
varchar2 |
80 |
√ |
|
null |
|
|
| NAME_TYPE_CODE |
varchar2 |
2 |
|
|
|
|
|
| GANG_TYPE_CD_TYPE |
varchar2 |
30 |
|
|
|
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT ig.incsup_inc_incident_id incident_id, i.inc_report_number,
i.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, ig.gan_gang_id gang_id,
ig.comments, ig.grcd_code gang_role_code,
ec.description gang_role_desc, g.gang_type_code,
--gtc.gang_type_desc,
gn.NAME,
gn.name_type_code, g.gang_type_cd_type
FROM incident_gangs ig,
incidents i,
incident_supplements isupp,
gangs g,
--gang_type_codes gtc,
gang_names gn,
ejs_codes ec
WHERE ig.incsup_inc_incident_id = i.incident_id
AND i.incident_id = isupp.inc_incident_id
AND isupp.supp_seq = ig.incsup_supp_seq
AND ig.gan_gang_id = g.gang_id
--AND g.gang_type_code = gtc.gang_type_code
AND g.gang_id = gn.gang_id
AND ig.grcd_code = ec.code
--AND ec.code_type = 'GANG_ROLE_CODES'
AND ec.code_type = ig.grcd_code_type
Possibly Referenced Tables/Views:
