Table slot9.WORLD.TSTA.COURT_PAPER_LOGS
This table stores the log entries for actions taken on a court paper 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_PAPERS.CP_ID CPAP_LOG_CPAP_FK C
LOG_NUM number 0
CP_DELETE_PARTY.LOG_NUM CPDELPAR_LOG_CPAP_LOG_FK C
CP_DELETE_PAYMENT.LOG_NUM CPDELPAY_CPAP_LOG_FK C
CP_DELETE_SERVICE_ADDR.LOG_NUM CPDELSADDR_CPAP_LOG_FK C
IMPOUND_LOG.LOG_NUM Implied Constraint R
JS_CIVIL_PROCESS_LOG_VW.LOG_NUM Implied Constraint R
JS_CIVIL_PROCESS_PARTY_VW.LOG_NUM Implied Constraint R
WARRANT_LOG.LOG_NUM Implied Constraint R
CP_PERSON_ID number 38  √  null
CP_BUSINESS_ID number 38  √  null
SERVE_DATE date 7  √  null
SERVING_PERSON varchar2 100  √  null
PERSON_SERVED varchar2 100  √  null
SERVE_LOCATION varchar2 100  √  null
CP_STATUS_CODE varchar2 30  √  null
EJS_CODES.CODE CPAP_LOG_STATUS_TYPE_FK R
CP_STATUS_CODE_TYPE varchar2 30  √  'CP_STATUS_REASON_CODES'
EJS_CODES.CODE_TYPE CPAP_LOG_STATUS_TYPE_FK R
LOG_COMMENT varchar2 4000  √  null
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
SERVE_LOCATION_ID number 38  √  null
ADDRESSES.ADDRESS_ID CPAP_LOG_ADDR_FK R
The id of the location the court paper was served
PERSON_SERVED_ID number 38  √  null
PEOPLE.PERSON_ID CPAP_LOG_PER_FK R
The id of the person who the court paper was served to
BUSINESS_SERVED_ID number 38  √  null
BUSINESSES.BUSINESS_NUMBER CPAP_LOG_BUSNS_FK R
The id of the business the court paper was served to
OFFICER_ID number 38  √  null
OFFICERS.OFFICER_ID CPAP_LOG_OFF1_FK R
TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE CPAP_LOG_TYPE_CD_FK R
Partial FK Indicating the type of log entry
TYPE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE CPAP_LOG_TYPE_CD_FK R
Partial FK Indicating the type of log entry
MANUAL_FLAG varchar2 1  √  'N' If Y, indicates a log is manually entered and may be edited
CP_PARTY_ID number 0  √  null
COURT_PAPER_UNKNWN_DETAILS.CP_PARTY_ID Implied Constraint R
NOTICE_LOCATION varchar2 100  √  null Free text column stores the location where a notice is posted
ATTORNEY_PARTY_ID number 0  √  null
COURT_PAPER_PARTIES.CP_PARTY_ID CPAP_LOG_CPP_ATT_FK R
CP Party ID FK of the attorney or law firm associated to the service
ATTORNEY_NAME varchar2 100  √  null Free text description of attorney or law firm associated to the service
PLAINTIFF_PARTY_ID number 0  √  null
COURT_PAPER_PARTIES.CP_PARTY_ID CPAP_LOG_CPP_PLAN_FK R
CP Party ID FK of the plaintiff associated to the service
PLAINTIFF_NAME varchar2 100  √  null Free text description of plaintiff associated to the service
COURT_ID number 0  √  null FK to COURT_LOCATION_CODES associates the service to a court
COURT_COMMENT varchar2 4000  √  null Court comment when associated to the service
RELATION_CODE varchar2 30  √  null
EJS_CODES.CODE CPAP_LOG_EJSCD_REL_FK R
Partial FK Indicating serving person relationship to party
RELATION_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE CPAP_LOG_EJSCD_REL_FK R
Partial FK Indicating serving person relationship to party
RELATION_LENGTH varchar2 10  √  null Indicating relationship length of serving person to party
AGE_CODE varchar2 30  √  null
EJS_CODES.CODE CPAP_LOG_EJSCD_AGE_FK R
Partial FK Indicating serving person age
AGE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE CPAP_LOG_EJSCD_AGE_FK R
Partial FK Indicating serving person age
POSITION varchar2 100  √  null Indicating serving person job position
TITLE varchar2 100  √  null Indicating serving person job title

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"CP_ID" IS NOT NULL CPAP_LOG_CP_ID_NN
"LOG_NUM" IS NOT NULL CPAP_LOG_LOG_NUM_NN

Indexes:
Column(s) Type Sort Constraint Name
LOG_NUM Primary key Asc CPAP_LOG_PK
SERVE_LOCATION_ID Performance Asc CPAP_LOG_ADDR_FK_I
BUSINESS_SERVED_ID Performance Asc CPAP_LOG_BUSNS_FK_I
COURT_ID Performance Asc CPAP_LOG_COURT_ID_I
CP_PARTY_ID Performance Asc CPAP_LOG_CP_PARTY_ID_I
CP_ID Performance Asc CPAP_LOG_CPAP_FK_I
ATTORNEY_PARTY_ID Performance Asc CPAP_LOG_CPP_ATT_FK_I
PLAINTIFF_PARTY_ID Performance Asc CPAP_LOG_CPP_PLAN_FK_I
AGE_TYPE + AGE_CODE Performance Asc/Asc CPAP_LOG_EJSCD_AGE_FK_I
RELATION_TYPE + RELATION_CODE Performance Asc/Asc CPAP_LOG_EJSCD_REL_FK_I
OFFICER_ID Performance Asc CPAP_LOG_OFF1_FK_I
PERSON_SERVED_ID Performance Asc CPAP_LOG_PER_FK_I
CP_STATUS_CODE_TYPE + CP_STATUS_CODE Performance Asc/Asc CPAP_LOG_STATUS_TYPE_FK_I
TYPE_CODE_TYPE + TYPE_CODE Performance Asc/Asc CPAP_LOG_TYPE_CD_FK_I

Close relationships  within of separation: