Table slot9.WORLD.TSTA.MASTER_NAMES
This tables stores names 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
ARREST_PEOPLE.PERSON_ID ARRP_MN_FK R
CITATION_PEOPLE.PERSON_ID CP_MN_FK C
CRIMINAL_COMPLAINTS.PER_PERSON_ID CRMCMP_MN_FK R
E_WARRANTS.MN_PER_PERSON_ID EWAR_MN_FK R
INCIDENT_PEOPLE.PER_PERSON_ID INCPER_MN_FK C
PEOPLE_WARRANTS.PER_PERSON_ID PEOPLE_WAR_MN_FK R
USER_FIELD_PER_VALUES.PERSON_ID USRSCRN_UFPV_MN_ID_FK R
PEOPLE.PERSON_ID MN_PER_FK C
Person ID number
MN_ID number 0
ARREST_PEOPLE.MN_ID ARRP_MN_FK R
CITATION_PEOPLE.MN_ID CP_MN_FK C
CRIMINAL_COMPLAINTS.MN_MN_ID CRMCMP_MN_FK R
E_WARRANTS.MN_MN_ID EWAR_MN_FK R
INCIDENT_PEOPLE.MN_MN_ID INCPER_MN_FK C
PEOPLE_WARRANTS.MN_MN_ID PEOPLE_WAR_MN_FK R
USER_FIELD_PER_VALUES.MN_ID USRSCRN_UFPV_MN_ID_FK R
Master Name ID number
LNAME varchar2 100  √  null Last Name
FNAME varchar2 80  √  null First Name
MNAME varchar2 80  √  null Middle Name
DOB date 7  √  null Date of Birth
SSN number 0  √  null Social Security Number
SLNAME varchar2 4  √  null Soundex value of Last Name
SFNAME varchar2 4  √  null Soundex value of First Name
CREATOR_ID varchar2 100  √  null Person creating the record
CREATOR_DATE date 7  √  null Date of record creation
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
TITLE_CODE varchar2 30  √  null
EJS_CODES.CODE MN_TITLE_CODE_EJS_CODE_FK R
Title (Jr, Sr, III)
TITLE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE MN_TITLE_CODE_EJS_CODE_FK R
DATE_OF_INFO date 7  √  null
REC_ID number 0  √  null
NAME_TYPE_CODE varchar2 30
EJS_CODES.CODE MN_NAME_TYPE_CODE_EJS_CODE_FK R
Code to identify if Name is Primary or Alias
NAME_TYPE_CODE_TYPE varchar2 30  √  'NAME_TYPE_CODES'
EJS_CODES.CODE_TYPE MN_NAME_TYPE_CODE_EJS_CODE_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"MN_ID" IS NOT NULL MN_MN_ID_NN
"NAME_TYPE_CODE" IS NOT NULL MN_NAME_TYPE_CODE_NN
"PER_PERSON_ID" IS NOT NULL MN_PER_PERSON_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
MN_ID + PER_PERSON_ID Primary key Asc/Asc MN_PK
LNAME + FNAME Performance Asc/Asc LNAME_FNAME_I
LNAME + FNAME + DOB Performance Asc/Asc/Asc MASTER_NAME_LNAME_FNAME_DOB
Performance MN_FNAME_FB_I
Performance MN_FNAME_L_FB_I
LNAME Performance Asc MN_LNAME
LNAME + DOB Performance Asc/Asc MN_LNAME_DOB
Performance MN_LNAME_FB_I
Performance MN_LNAME_L_FB_I
Performance MN_MNAME_FB_I
Performance MN_MNAME_L_FB_I
NAME_TYPE_CODE_TYPE + NAME_TYPE_CODE Performance Asc/Asc MN_NAME_TYPE_CODE_FK_I
PER_PERSON_ID Performance Asc MN_PER_FK_I
SSN + LNAME + FNAME + DOB Performance Asc/Asc/Asc/Asc MN_SSN_NAME_I
TITLE_CODE Performance Asc MN_TC1_FK_I
TITLE_CODE_TYPE + TITLE_CODE Performance Asc/Asc MN_TITLE_CODE_EJS_CODE_I

Close relationships  within of separation: