Table slot9.WORLD.TSTA.LEGAL_SEARCH_INDEX
This table is not currently used
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 Comments
LEGAL_SEARCH_ID number 0
LEGAL_SEARCH_ADDRESSES.LEGAL_SEARCH_ID LSA_LSI_FK C
LEGAL_SEARCH_PEOPLE.LEGAL_SEARCH_ID LSP_LSI_FK C
LSI_ADDRESSES_VW.LEGAL_SEARCH_ID Implied Constraint R
LSI_PEOPLE_VW.LEGAL_SEARCH_ID Implied Constraint R
LSI_VW.LEGAL_SEARCH_ID Implied Constraint R
LS_STATUS_CODE varchar2 30
EJS_CODES.CODE LSI_LS_STATUS_CODE_EJS_CODE_FK R
LS_TYPE_CODE varchar2 30
EJS_CODES.CODE LSI_LS_TYPE_CODE_EJS_CODE_FK R
ISSUE_DATE date 7
RETURN_DATE date 7  √  null
CASE_ID number 12  √  null
JUDGE_NUMBER number 38
JUDGES.JUDGE_NUMBER LSI_JUD_FK R
OFFICER_ID number 0
OFFICERS.OFFICER_ID LSI_OFF_1_FK R
AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE LSI_AGNCY_CD_FK R
VEH_LIC_NUMBER varchar2 12  √  null
VEH_STATE_CODE varchar2 30  √  null
EJS_CODES.CODE LSI_VEH_STATE_CODE_EJS_CODE_FK R
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
LS_STATUS_CODE_TYPE varchar2 30  √  'LEGAL_SEARCH_STATUS_CODES'
EJS_CODES.CODE_TYPE LSI_LS_STATUS_CODE_EJS_CODE_FK R
LS_TYPE_CODE_TYPE varchar2 30  √  'LEGAL_SEARCH_TYPE_CODES'
EJS_CODES.CODE_TYPE LSI_LS_TYPE_CODE_EJS_CODE_FK R
VEH_STATE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE LSI_VEH_STATE_CODE_EJS_CODE_FK R
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"AGENCY_CODE" IS NOT NULL LSI_AGENCY_CODE_NN
"ISSUE_DATE" IS NOT NULL LSI_ISSUE_DATE_NN
"JUDGE_NUMBER" IS NOT NULL LSI_JUDGE_NUMBER_NN
"LEGAL_SEARCH_ID" IS NOT NULL LSI_LEGAL_SEARCH_ID_NN
"LS_STATUS_CODE" IS NOT NULL LSI_LS_STATUS_CODE_NN
"LS_TYPE_CODE" IS NOT NULL LSI_LS_TYPE_CODE_NN
"OFFICER_ID" IS NOT NULL LSI_OFFICER_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
LEGAL_SEARCH_ID Primary key Asc LSI_PK
AGENCY_CODE Performance Asc LSI_AGNCY_CD_FK_I
JUDGE_NUMBER Performance Asc LSI_JUD_FK_I
LS_STATUS_CODE_TYPE + LS_STATUS_CODE Performance Asc/Asc LSI_LS_STATUS_CODE_EJS_CODE_I
LS_TYPE_CODE_TYPE + LS_TYPE_CODE Performance Asc/Asc LSI_LS_TYPE_CODE_EJS_CODE_I
LS_STATUS_CODE Performance Asc LSI_LSSC_FK_I
LS_TYPE_CODE Performance Asc LSI_LSTC_FK_I
OFFICER_ID Performance Asc LSI_OFF_1_FK_I
VEH_STATE_CODE Performance Asc LSI_STATE_CD_FK_I
VEH_STATE_CODE_TYPE + VEH_STATE_CODE Performance Asc/Asc LSI_VEH_STATE_CODE_EJS_CODE_I

Close relationships  within of separation: