Table slot9.WORLD.TSTA.COLLAPSED_MASTER_NAMES
This tables stores master name information for collapsed people.
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
CMN_ID number 0 Primary Key
PERSON_ID number 0
JAIL_PEOPLE.PERSON_ID Implied Constraint R
Person ID number
CLE_ID number 0
COLLAPSE_LOG_ENTRIES.CLE_ID CMN_CLE_FK R
Foriegn key to COLLAPSE_LOG_ENTRIES
MN_ID number 0 Master Name ID number
LNAME varchar2 100  √  null Last Name
FNAME varchar2 100  √  null First Name
MNAME varchar2 100  √  null Middle Name
DOB date 7  √  null Date of Birth
SSN number 0  √  null Social Security Number
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 Title (Jr, Sr, III)
TITLE_CODE_TYPE varchar2 30  √  null
DATE_OF_INFO date 7  √  null
REC_ID number 0  √  null
NAME_TYPE_CODE varchar2 30 Code to identify if Name is Primary or Alias
NAME_TYPE_CODE_TYPE varchar2 30  √  'NAME_TYPE_CODES'

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"CLE_ID" IS NOT NULL CMN_CLE_ID_NN
"CMN_ID" IS NOT NULL CMN_ID_NN
"MN_ID" IS NOT NULL CMN_MN_ID_NN
"NAME_TYPE_CODE" IS NOT NULL CMN_NAME_TYPE_CODE_NN
"PERSON_ID" IS NOT NULL CMN_PERSON_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
CMN_ID Primary key Asc CMN_PK
CLE_ID Performance Asc CMN_CLE_FK_I

Close relationships: