Table slot9.WORLD.TSTA.PERSON_CAUTIONS
This table stores caution codes added to a MASTER PERSON 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
PER_PERSON_ID number 0
PEOPLE.PERSON_ID PCS_PER_FK C
Person ID number
CAUTN_CAUTION_CODE varchar2 30
EJS_CODES.CODE PCS_CAUTN_CAUTION__EJS_CODE_FK R
Caution code for anyone dealing with the individual
CREATOR_ID varchar2 100  √  null Creator"s User ID.
CREATOR_DATE date 7  √  null Creation Date.
UPDATOR_ID varchar2 100  √  null Updator"s User ID.
UPDATOR_DATE date 7  √  null Update Date.
PCS_COMMENT varchar2 80  √  null
CAUTN_CAUTION_CODE_TYPE varchar2 30  √  'CAUTION_CODES'
EJS_CODES.CODE_TYPE PCS_CAUTN_CAUTION__EJS_CODE_FK R
REC_ID number 0  √  null
DATE_OF_INFO date 7  √  null
START_DATE date 7  √  null
EXPIRE_DATE date 7  √  null
NEXT_REVIEW_DATE date 7  √  null
ID number 0
COURT_CASE_DELETE.ID Implied Constraint R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"CAUTN_CAUTION_CODE" IS NOT NULL PCS_CAUTN_CAUTION_CODE_NN
"PER_PERSON_ID" IS NOT NULL PCS_PER_PERSON_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc PCS_PK
CAUTN_CAUTION_CODE_TYPE + CAUTN_CAUTION_CODE Performance Asc/Asc PCS_CAUTN_CAUTION__EJS_CODE_I
CAUTN_CAUTION_CODE Performance Asc PCS_CAUTN_FK_I
PER_PERSON_ID Performance Asc PCS_PER_FK_I

Close relationships  within of separation: