Table slot9.WORLD.TSTA.PERSON_ATTACHMENTS
This table stores attachments 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
DATE_OF_INFO date 7  √  null
ATTACHMENT_DESC varchar2 2000  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
ATT_ID number 0
ATTACHMENTS.ID PA_ATT_FK C
KEYWORD varchar2 30  √  null
EJS_CODES.CODE PA_EJS_CODE_FK R
PERSON_ID number 38
PEOPLE.PERSON_ID PA_PER_FK R
REC_ID number 0  √  null
KEYWORD_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE PA_EJS_CODE_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ATT_ID" IS NOT NULL PA_ATT_ID_NN
"PERSON_ID" IS NOT NULL PA_PERSON_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
PERSON_ID + ATT_ID Primary key Asc/Asc PA_PK
ATT_ID Performance Asc PA_ATT_FK_I
KEYWORD_TYPE + KEYWORD Performance Asc/Asc PA_EJS_CODE_FK_I
PERSON_ID Performance Asc PA_PER_FK_I

Close relationships  within of separation: