Table slot9.WORLD.TSTA.COURT_PAPERS
This table stores court papers (referred to as Civil Process) in the application
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
CP_ID number 0
COURT_PAPER_ATTACHMENTS.CP_ID CPAP_ATTCH_CPAP_FK C
COURT_PAPER_FEES.CP_ID CPAP_FEE_CPAP_FK R
COURT_PAPER_IMAGES.CP_ID CPAP_IMA_CPAP_FK C
COURT_PAPER_LOCATIONS.CP_ID CPLOC_CPAP_FK C
COURT_PAPER_LOGS.CP_ID CPAP_LOG_CPAP_FK C
COURT_PAPER_OFFICERS.CP_ID CPOFF_CPAP_FK R
COURT_PAPER_PARTIES.CP_ID CPP_CPAP_FK R
COURT_PAPER_REFS.CP_ID CPREF_CPAP_FK C
USI_COURT_PAPER_FIELDS.CP_ID USI_CPF_CPAP_FK R
USI_COURT_PAPERS.CP_ID USI_CP_CPAP_FK R
CP_DEL_LOG.CP_ID Implied Constraint R
CP_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE CPAP_TYPE_CODE_FK R
EVENT_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE CPAP_EVENT_CODE_FK R
AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE CPAP_AGNCY_CD_FK R
COUNTY_CODE varchar2 30
EJS_CODES.CODE CPAP_COUNTY_CODE_FK R
PLAINTIFF varchar2 100  √  null
FILED_DATE date 7  √  null
RECIEVED_DATE date 7  √  null
STATE_CODE varchar2 30
EJS_CODES.CODE CPAP_STATE_CODE_FK R
CP_TYPE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE CPAP_TYPE_CODE_FK R
EVENT_TYPE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE CPAP_EVENT_CODE_FK R
COUNTY_CODE_TYPE varchar2 30  √  'COUNTY_CODES'
EJS_CODES.CODE_TYPE CPAP_COUNTY_CODE_FK R
STATE_CODE_TYPE varchar2 30  √  'STATE_CODES'
EJS_CODES.CODE_TYPE CPAP_STATE_CODE_FK R
AGENCY_ONLY varchar2 1  √  'N'
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
REC_ID number 0  √  null
COURT_DATE date 7  √  null
COURT_TIME date 7  √  null
COURT_DAYS number 0  √  null
EXPIRE_DATE date 7  √  null
EXPIRE_TIME date 7  √  null
CP_STATUS_CODE varchar2 30  √  'OPEN'
EJS_CODES.CODE CPAP_EJSCD_STATUS_FK R
CP_STATUS_CODE_TYPE varchar2 30  √  'CP_STATUS_CODES'
EJS_CODES.CODE_TYPE CPAP_EJSCD_STATUS_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"AGENCY_CODE" IS NOT NULL CPAP_AGENCY_CODE_NN
"COUNTY_CODE" IS NOT NULL CPAP_COUNTY_CODE_NN
"CP_ID" IS NOT NULL CPAP_CP_ID_NN
"STATE_CODE" IS NOT NULL CPAP_STATE_CODE_NN

Indexes:
Column(s) Type Sort Constraint Name
CP_ID Primary key Asc CPAP_PK
AGENCY_CODE Performance Asc CPAP_AGNCY_CD_FK_I
COUNTY_CODE Performance Asc CPAP_CNTY_CD_FK_I
COUNTY_CODE_TYPE + COUNTY_CODE Performance Asc/Asc CPAP_COUNTY_CODE_FK_I
CP_STATUS_CODE_TYPE + CP_STATUS_CODE Performance Asc/Asc CPAP_EJSCD_STATUS_FK_I
EVENT_TYPE_CODE_TYPE + EVENT_TYPE_CODE Performance Asc/Asc CPAP_EVENT_CODE_FK_I
FILED_DATE Performance Asc CPAP_FILED_DATE_FK_I
STATE_CODE_TYPE + STATE_CODE Performance Asc/Asc CPAP_STATE_CD_FK_I
STATE_CODE Performance Asc CPAP_STATE_CD_I
CP_TYPE_CODE_TYPE + CP_TYPE_CODE Performance Asc/Asc CPAP_TYPE_CODE_FK_I

Close relationships  within of separation: