|
|
| 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 |
| ID |
varchar2 |
140 |
√ |
|
null |
|
|
| COUNTY |
varchar2 |
100 |
√ |
|
null |
|
|
| GANG_ID |
number |
20 |
|
|
|
|
| GANGS.GANG_ID
|
Implied Constraint R |
|
| GANG_NAME |
varchar2 |
80 |
√ |
|
null |
|
|
| LEVEL_CODE |
varchar2 |
2 |
|
|
|
|
|
| GANG_TYPE_CODE |
varchar2 |
30 |
|
|
|
|
|
| GANG_STATUS_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| GANG_STATUS_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| GANG_STATUS_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| STATUS_DATE |
varchar2 |
19 |
√ |
|
null |
|
|
| GANG_TYPE_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| INDX_SEC_LEVEL_CODE |
number |
0 |
√ |
|
null |
|
|
| INDX_SEC_LEVEL_ID |
varchar2 |
100 |
√ |
|
null |
|
|
| INDX_SEC_LEVEL_AGENCY |
varchar2 |
30 |
√ |
|
null |
|
|
| ACTIVE_SUBSCRIPTION |
varchar2 |
1 |
√ |
|
null |
|
|
| NAME_TYPE_CODE |
varchar2 |
2 |
√ |
|
null |
|
|
| NAME_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| DATE_OF_INFO |
varchar2 |
19 |
√ |
|
null |
|
|
| EJS_COMMENT |
varchar2 |
4000 |
√ |
|
null |
|
|
| LASTNAME |
varchar2 |
100 |
√ |
|
null |
|
|
| FIRSTNAME |
varchar2 |
80 |
√ |
|
null |
|
|
| DOB |
varchar2 |
19 |
√ |
|
null |
|
|
| SSN |
number |
0 |
√ |
|
null |
|
|
| GANG_LEVEL_DESC |
varchar2 |
60 |
√ |
|
null |
|
|
| INDX_SEC_LEVEL_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| INDX_SEC_LEVEL_AGENCY_DESC |
varchar2 |
40 |
√ |
|
null |
|
|
| RACE |
varchar2 |
4000 |
√ |
|
null |
|
|
| RACE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| SEX_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| SEX |
varchar2 |
4000 |
√ |
|
null |
|
|
| NAME_TYPE_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| CREATEDBY |
varchar2 |
100 |
√ |
|
null |
|
|
| CREATION_DATE |
date |
7 |
√ |
|
null |
|
|
| MODIFICATION_DATE |
date |
7 |
√ |
|
null |
|
|
| MODIFIEDBY |
varchar2 |
100 |
√ |
|
null |
|
|
| MEMBERS_COUNT |
number |
0 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT UPPER(i.db_schema) || g.gang_id AS ID,
UPPER(i.db_schema) AS county,
g.gang_id AS gang_id,
gn.NAME AS gang_name,
g.level_code AS level_code,
g.gang_type_code AS gang_type_code,
gp.status_code AS gang_status_code,
gp.status_code_type AS gang_status_type,
ensd.description AS gang_status_desc,
TO_CHAR (gp.status_date, 'MM/DD/YYYY HH:MI AM') AS status_date,
gtc.description AS gang_type_desc,
g.indx_sec_level_code AS indx_sec_level_code,
g.indx_sec_level_id AS indx_sec_level_id,
g.indx_sec_level_agency AS indx_sec_level_agency,
g.active_subscription AS active_subscription,
gn.name_type_code AS name_type_code,
gn.name_type AS name_type,
TO_CHAR (gn.date_of_info, 'MM/DD/YYYY HH:MI AM') AS date_of_info,
ejs.ejs_comment AS ejs_comment,
mn.lname AS lastname,
mn.fname AS firstname,
TO_CHAR (mn.dob, 'MM/DD/YYYY HH:MI AM') AS dob,
mn.ssn AS ssn,
glc.gang_level_desc AS gang_level_desc,
misc.description AS indx_sec_level_desc,
ac.agency_desc AS indx_sec_level_agency_desc,
erace.description AS race,
mp.race_code AS race_code,
mp.sex_code AS sex_code,
esex.description AS sex,
entd.description AS name_type_desc,
g.creator_id AS createdby,
g.creator_date AS creation_date,
g.updator_date AS modification_date,
g.updator_id AS modifiedby,
ABS (EJS_SOLR_PK.EJS_GET_GANG_MEMBER_COUNT (g.gang_id)) AS members_count
FROM install i, gangs g LEFT OUTER JOIN gang_names gn ON g.gang_id = gn.gang_id
LEFT OUTER JOIN ejs_comments ejs ON g.rec_id = ejs.rec_id
LEFT OUTER JOIN gang_people gp ON g.gang_id = gp.gang_id
LEFT OUTER JOIN master_names mn ON mn.per_person_id = gp.person_id
LEFT OUTER JOIN master_people mp ON mn.per_person_id = mp.master_person_id
LEFT OUTER JOIN ejs_codes gtc ON gtc.code = g.gang_type_code AND gtc.code_type = g.gang_type_cd_type
LEFT OUTER JOIN gang_level_codes glc ON g.level_code = glc.level_code
LEFT OUTER JOIN master_index_security_codes misc ON g.indx_sec_level_code = misc.indx_sec_level_code
LEFT OUTER JOIN agency_codes ac ON g.indx_sec_level_agency = ac.agency_code
LEFT OUTER JOIN ejs_codes erace ON erace.code = mp.race_code AND erace.code_type = mp.race_code_type
LEFT OUTER JOIN ejs_codes esex ON esex.code = mp.sex_code AND esex.code_type = mp.sex_code_type
LEFT OUTER JOIN ejs_codes entd ON entd.code = gn.name_type_code AND entd.code_type = 'GANG_NAME_TYPE_CODES'
LEFT OUTER JOIN ejs_codes ensd ON ensd.code = gp.status_code AND ensd.code_type = gp.status_code_type
Possibly Referenced Tables/Views:
