Table slot9.WORLD.TSTA.MISC_IDS
This table stores miscellaneous identifiers added to a MASTER PERSON in the application (e.g. passport number, air force serial number)
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
CITATION_PEOPLE.MISC_ID_PERSON_ID CITP_MISC_ID_FK R
MISC_ID_CLASSES.PER_PERSON_ID MIC_MISCID_FK C
MISC_ID_RESTRICTIONS.PER_PERSON_ID MIR_MISCID_FK C
PEOPLE.PERSON_ID MISCID_PER_FK C
Person ID number
ID_NUMBER varchar2 30
CITATION_PEOPLE.MISC_ID_NUMBER CITP_MISC_ID_FK R
MISC_ID_CLASSES.ID_NUMBER MIC_MISCID_FK C
MISC_ID_RESTRICTIONS.ID_NUMBER MIR_MISCID_FK C
Miscellaneous ID Number
STATE_CD_STATE_CODE varchar2 30  √  null
EJS_CODES.CODE MISCID_STATE_CD_ST_EJS_CODE_FK R
State code designator
CNTRY_CD_COUNTRY_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE MISCID_CNTRY_CD_CO_EJS_CODE_FK R
Code for the governing body
MISC_CD_MISC_ID_CODE varchar2 2
CITATION_PEOPLE.MISC_ID_CODE CITP_MISC_ID_FK R
MISC_ID_CLASSES.MISC_CD_MISC_ID_CODE MIC_MISCID_FK C
MISC_ID_RESTRICTIONS.MISC_CD_MISC_ID_CODE MIR_MISCID_FK C
MISC_ID_CODES.MISC_ID_CODE MISCID_MISC_CD_FK R
Misc type code
DATE_OF_ISSUE date 7  √  null Date document was issued
CREATOR_DATE date 7  √  null
CREATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
EXPIRATION date 7  √  null
MISC_ID_TYPE varchar2 30  √  null
EJS_CODES.CODE MISCID_MISC_ID_TYP_EJS_CODE_FK R
MISC_ID_CNTR number 38
CITATION_PEOPLE.MISC_ID_CNTR CITP_MISC_ID_FK R
MISC_ID_CLASSES.MISC_ID_CNTR MIC_MISCID_FK C
MISC_ID_RESTRICTIONS.MISC_ID_CNTR MIR_MISCID_FK C
CNTRY_CD_COUNTRY_TYPE_COD_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE MISCID_CNTRY_CD_CO_EJS_CODE_FK R
MISC_ID_TYPE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE MISCID_MISC_ID_TYP_EJS_CODE_FK R
STATE_CD_STATE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE MISCID_STATE_CD_ST_EJS_CODE_FK R
REC_ID number 0  √  null
DATE_OF_INFO date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ID_NUMBER" IS NOT NULL MISCID_ID_NUMBER_NN
"MISC_CD_MISC_ID_CODE" IS NOT NULL MISCID_MISC_CD_MISC_ID_CODE_NN
"MISC_ID_CNTR" IS NOT NULL MISCID_MISC_ID_CNTR_NN
"PER_PERSON_ID" IS NOT NULL MISCID_PER_PERSON_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
PER_PERSON_ID + MISC_CD_MISC_ID_CODE + ID_NUMBER + MISC_ID_CNTR Primary key Asc/Asc/Asc/Asc MISCID_PK
ID_NUMBER + MISC_CD_MISC_ID_CODE Performance Asc/Asc MISC_ID_NUMBER_TYPE_I
CNTRY_CD_COUNTRY_TYPE_COD_TYPE + CNTRY_CD_COUNTRY_TYPE_CODE Performance Asc/Asc MISCID_CNTRY_CD_CO_EJS_CODE_I
CNTRY_CD_COUNTRY_TYPE_CODE Performance Asc MISCID_CNTRY_CD_FK_I
MISC_CD_MISC_ID_CODE Performance Asc MISCID_MISC_CD_FK_I
MISC_ID_TYPE_TYPE + MISC_ID_TYPE Performance Asc/Asc MISCID_MISC_ID_TYP_EJS_CODE_I
MISC_ID_TYPE Performance Asc MISCID_MITC_FK_I
PER_PERSON_ID Performance Asc MISCID_PER_FK_I
PER_PERSON_ID + STATE_CD_STATE_CODE + MISC_CD_MISC_ID_CODE Performance Asc/Asc/Asc MISCID_REGEX_ST_DL_FNCBAS_I
STATE_CD_STATE_CODE Performance Asc MISCID_STATE_CD_FK_I
STATE_CD_STATE_CODE_TYPE + STATE_CD_STATE_CODE Performance Asc/Asc MISCID_STATE_CD_ST_EJS_CODE_I
Performance MISCID_UPPER_SPECHAR_FNCBAS_I

Close relationships  within of separation: