|
|
| 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 |
| LEGAL_SEARCH_ID |
number |
0 |
|
|
|
|
|
| LS_STATUS_CODE |
varchar2 |
30 |
|
|
|
|
|
| LS_TYPE_CODE |
varchar2 |
30 |
|
|
|
|
|
| ISSUE_DATE |
date |
7 |
|
|
|
|
|
| RETURN_DATE |
date |
7 |
√ |
|
null |
|
|
| CASE_ID |
number |
12 |
√ |
|
null |
|
|
| JUDGE_NUMBER |
number |
38 |
|
|
|
|
|
| OFFICER_ID |
number |
0 |
|
|
|
|
| OFFICERS.OFFICER_ID
|
Implied Constraint R |
|
| AGENCY_CODE |
varchar2 |
30 |
|
|
|
|
|
| VEH_LIC_NUMBER |
varchar2 |
12 |
√ |
|
null |
|
|
| VEH_STATE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| LS_COMMENT |
varchar2 |
255 |
√ |
|
null |
|
|
| CREATOR_ID |
varchar2 |
100 |
√ |
|
null |
|
|
| CREATOR_DATE |
date |
7 |
√ |
|
null |
|
|
| UPDATOR_ID |
varchar2 |
100 |
√ |
|
null |
|
|
| UPDATOR_DATE |
date |
7 |
√ |
|
null |
|
|
| LAST_NAME |
varchar2 |
30 |
√ |
|
null |
|
|
| FIRST_NAME |
varchar2 |
20 |
√ |
|
null |
|
|
| MIDDLE_NAME |
varchar2 |
20 |
√ |
|
null |
|
|
| JUDGE_LAST_NAME |
varchar2 |
30 |
|
|
|
|
|
| JUDGE_FIRST_NAME |
varchar2 |
20 |
|
|
|
|
|
| JUDGE_ACTIVE |
varchar2 |
1 |
|
|
|
|
|
| OFFICER_AGENCY |
varchar2 |
30 |
|
|
|
|
|
| OFFICER_LNAME |
varchar2 |
20 |
|
|
|
|
|
| OFFICER_FNAME |
varchar2 |
20 |
√ |
|
null |
|
|
| OFFICER_INTERNAL_ID |
varchar2 |
100 |
|
|
|
|
|
| OFFICER_TITLE |
varchar2 |
20 |
√ |
|
null |
|
|
| OFFICER_ACTIVE |
varchar2 |
1 |
√ |
|
null |
|
|
| CASE_NUMBER |
varchar2 |
0 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT
LSI.LEGAL_SEARCH_ID
,LSI.LS_STATUS_CODE
,LSI.LS_TYPE_CODE
,LSI.ISSUE_DATE
,LSI.RETURN_DATE
,LSI.CASE_ID
,LSI.JUDGE_NUMBER
,LSI.OFFICER_ID
,LSI.AGENCY_CODE
,LSI.VEH_LIC_NUMBER
,LSI.VEH_STATE_CODE
,LSI.LS_COMMENT
,LSI.CREATOR_ID
,LSI.CREATOR_DATE
,LSI.UPDATOR_ID
,LSI.UPDATOR_DATE
,LSP.LAST_NAME
,LSP.FIRST_NAME
,LSP.MIDDLE_NAME
,JUD.LAST_NAME
,JUD.FIRST_NAME
,JUD.ACTIVE
,OFF.AGNCY_CD_AGENCY_CODE
,OFF.LNAME
,OFF.FNAME
,OFF.INTERNAL_ID
,OFF.TITLE
,OFF.ACTIVE
,NULL
FROM LEGAL_SEARCH_INDEX LSI
,LEGAL_SEARCH_PEOPLE LSP
,JUDGES JUD
,OFFICERS OFF
WHERE LSP.LEGAL_SEARCH_ID = LSI.LEGAL_SEARCH_ID
AND JUD.JUDGE_NUMBER = LSI.JUDGE_NUMBER
AND OFF.OFFICER_ID = LSI.OFFICER_ID
Possibly Referenced Tables/Views:
