Table slot9.WORLD.TSTA.PEOPLE_RELATIONS
This table stores the association between multiple MASTER PEOPLE with a relationship code
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
PRIMARY_PERSON_ID number 0
PEOPLE.PERSON_ID PRIM_PREL_PER_FK C
RELATED_PERSON_ID number 0  √  null
PEOPLE.PERSON_ID REL_PREL_PER_FK C
REL_RELATION_CODE varchar2 30
EJS_CODES.CODE PREL_PREL_EJS_CODES_FK R
NEXT_OF_KIN varchar2 1 'N'
DATE_OF_INFO date 7  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
EMERGENCY_CONTACT varchar2 1  √  'N'
DEPENDENT_YN varchar2 1  √  'N'
P_RELATION_CODE_TYPE varchar2 30 'PEOPLE_RELATION_CODES'
EJS_CODES.CODE_TYPE PREL_PREL_EJS_CODES_FK R
REC_ID number 0  √  null
PERSON_RELATION_ID number 0 Primary Key - ID generated from sequence PEOPLE_RELATIONS_SEQ
LNAME varchar2 100  √  null Last name of partially known relation person
FNAME varchar2 80  √  null First name of partially known relation person
PHONE varchar2 30  √  null Phone number of partially known relation person
DOB date 7  √  null Date of birth of partially known relation person
RACE_CODE varchar2 30  √  null
EJS_CODES.CODE REL_PREL_RACE_FK C
Race code (ejs code) of partially known relation person
RACE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE REL_PREL_RACE_FK C
Race code type (ejs code) of partially known relation person
SEX_CODE varchar2 30  √  null
EJS_CODES.CODE REL_PREL_SEX_FK C
Sex code (ejs code) of partially known relation person
SEX_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE REL_PREL_SEX_FK C
Sex code type (ejs code) of partially known relation person

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
DEPENDENT_YN IN ('Y', 'N') CK_PREL_DEPENDENT_YN
EMERGENCY_CONTACT IN ('Y', 'N') CK_PREL_EMERGENCY_CONTACT
"NEXT_OF_KIN" IS NOT NULL PREL_NEXT_OF_KIN_NN
"P_RELATION_CODE_TYPE" IS NOT NULL PREL_P_RELATION_CODE_TYPE_NN
"PRIMARY_PERSON_ID" IS NOT NULL PREL_PRIMARY_PERSON_ID_NN
"REL_RELATION_CODE" IS NOT NULL PREL_REL_RELATION_CODE_NN

Indexes:
Column(s) Type Sort Constraint Name
PERSON_RELATION_ID Primary key Asc PREL_PK
P_RELATION_CODE_TYPE + REL_RELATION_CODE Performance Asc/Asc PREL_PREL_EJS_CODES_FK_I
PRIMARY_PERSON_ID Performance Asc PRIM_PREL_PER_FK_I
RELATED_PERSON_ID Performance Asc REL_PREL_PER_FK_I

Close relationships  within of separation: