|
|
| 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 |
| ARREST_ID |
number |
0 |
√ |
|
null |
|
| ARRESTS.ARREST_ID
|
Implied Constraint R |
|
| WARRANT_ID |
number |
0 |
√ |
|
null |
|
|
| STATUTE |
varchar2 |
20 |
√ |
|
null |
|
|
| CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| DESCRIPTION |
varchar2 |
4000 |
√ |
|
null |
|
|
| OFFENSE_DATE |
date |
7 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT
ARREST_ID,
null,
CG.STATUTE,
CG.CODE,
CG.CHA_DESC,
AC.OFFENSE_DATE
FROM ARREST_CHARGES AC
INNER JOIN CHARGE_CODES CG ON AC.CHARGE_CODE = CG.CODE
UNION
SELECT
AW.ARREST_ID,
AW.WARRANT_ID,
CC.STATUTE,
CC.CODE,
CC.CHA_DESC,
EW.DATE_ISSUED
FROM ARREST_WARRANTS AW
INNER JOIN E_WARRANTS EW ON AW.WARRANT_ID = EW.WARRANT_ID
INNER JOIN WARRANT_CHARGES WC ON EW.WARRANT_ID = WC.EWAR_WARRANT_ID
INNER JOIN CHARGE_CODES CC ON WC.CHA_CODE = CC.CODE
UNION
SELECT
AW.ARREST_ID,
AW.WARRANT_ID,
null,
ACCC.ARREST_CHARGE_CODE,
ACCC.ARREST_CHA_DESC,
EW.DATE_ISSUED
FROM ARREST_WARRANTS AW
INNER JOIN E_WARRANTS EW ON AW.WARRANT_ID = EW.WARRANT_ID
INNER JOIN WARRANT_ARREST_CHARGES WAC ON EW.WARRANT_ID = WAC.WARRANT_ID
INNER JOIN ARREST_CHARGE_CODES ACCC ON WAC.ARREST_CHARGE_CODE = ACCC.ARREST_CHARGE_CODE
UNION
SELECT
AW.ARREST_ID,
AW.WARRANT_ID,
null,
null,
WFC.WARRANT_CHARGE,
EW.DATE_ISSUED
FROM ARREST_WARRANTS AW
INNER JOIN E_WARRANTS EW ON AW.WARRANT_ID = EW.WARRANT_ID
INNER JOIN WARRANT_FREETEXT_CHARGES WFC ON EW.WARRANT_ID = WFC.WARRANT_ID
UNION
SELECT
AW.ARREST_ID,
null,
null,
null,
AW.EXT_CHARGE_DESC,
null
FROM ARREST_WARRANTS AW
LEFT OUTER JOIN E_WARRANTS EW ON AW.WARRANT_ID = EW.WARRANT_ID
WHERE EW.WARRANT_ID IS NULL
Possibly Referenced Tables/Views:
