Table slot9.WORLD.TSTA.MISC_ID_CLASSES
This table stores the class information for a miscellaneous id 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
CREATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
UPDATOR_DATE date 7  √  null
MISC_CD_MISC_ID_CODE varchar2 2
MISC_IDS.MISC_CD_MISC_ID_CODE MIC_MISCID_FK C
Misc type code
PER_PERSON_ID number 0
MISC_IDS.PER_PERSON_ID MIC_MISCID_FK C
Person ID number
ID_NUMBER varchar2 30
MISC_IDS.ID_NUMBER MIC_MISCID_FK C
Miscellaneous ID Number
MISC_ID_CODE varchar2 2
MISC_ID_CLASS_CODES.MISC_ID_CODE MIC_MICC_FK R
Misc type code
CLASS_CODE varchar2 3
MISC_ID_CLASS_CODES.CLASS_CODE MIC_MICC_FK R
MISC_ID_CNTR number 38
MISC_IDS.MISC_ID_CNTR MIC_MISCID_FK C
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"CLASS_CODE" IS NOT NULL MIC_CLASS_CODE_NN
"ID_NUMBER" IS NOT NULL MIC_ID_NUMBER_NN
"MISC_CD_MISC_ID_CODE" IS NOT NULL MIC_MISC_CD_MISC_ID_CODE_NN
"MISC_ID_CNTR" IS NOT NULL MIC_MISC_ID_CNTR_NN
"MISC_ID_CODE" IS NOT NULL MIC_MISC_ID_CODE_NN
"PER_PERSON_ID" IS NOT NULL MIC_PER_PERSON_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
MISC_CD_MISC_ID_CODE + PER_PERSON_ID + ID_NUMBER + MISC_ID_CODE + CLASS_CODE + MISC_ID_CNTR Primary key Asc/Asc/Asc/Asc/Asc/Asc MIC_PK
MISC_ID_CODE + CLASS_CODE Performance Asc/Asc MIC_MICC_FK_I
PER_PERSON_ID + MISC_CD_MISC_ID_CODE + ID_NUMBER + MISC_ID_CNTR Performance Asc/Asc/Asc/Asc MIC_MISCID2_FK_I
MISC_CD_MISC_ID_CODE + ID_NUMBER + PER_PERSON_ID + MISC_ID_CNTR Performance Asc/Asc/Asc/Asc MIC_MISCID_FK_I

Close relationships  within of separation: