Table slot9.WORLD.TSTA.CP_PAYMENT_PARTIES_LOG
This table logs adding and removing service parties a fee collection is made for
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
LOG_ID number 0
EJS_JOB_LOG.LOG_ID Implied Constraint R
ITEM_LOG_ENTRIES.LOG_ID Implied Constraint R
ITEM_LOG_VW.LOG_ID Implied Constraint R
MASTER_INDEX_DELETE_LOG.LOG_ID Implied Constraint R
Primary key. Unique sequence value
NEW_VALUE varchar2 255  √  null List of parties the collection is made for
FEE_PAYMENT_ID number 0  √  null
COURT_PAPER_PAYMENTS.FEE_PAYMENT_ID Implied Constraint R
Fee Collection ID from the COURT_PAPER_PAYMENTS table
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
FEE_PAYMENT_AUDIT_ID number 0  √  null
COURT_PAPER_PAYMENTS_AUDIT.FEE_PAYMENT_AUDIT_ID CPPPLOG_CPPAYAUD_FK C
FK to COURT_PAPER_PAYMENTS_AUDIT

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"LOG_ID" IS NOT NULL CPPPLOG_LOG_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
LOG_ID Primary key Asc CPPPLOG_PK
FEE_PAYMENT_AUDIT_ID Performance Asc CPPPLOG_CPPAYAUD_FK_I
FEE_PAYMENT_ID Performance Asc CPPPLOG_FEEPAYID_I

Close relationships  within of separation: