Table slot9.WORLD.TSTA.MISC_ID_RESTRICTIONS
This table stores restriction information for miscellaneous ids 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 MIR_MISCID_FK C
Misc type code
PER_PERSON_ID number 0
MISC_IDS.PER_PERSON_ID MIR_MISCID_FK C
Person ID number
ID_NUMBER varchar2 30
MISC_IDS.ID_NUMBER MIR_MISCID_FK C
Miscellaneous ID Number
MISC_ID_CODE varchar2 2
MISC_ID_REST_CODES.MISC_ID_CODE MIR_MIRC_FK R
Misc type code
RESTRICTION_CODE varchar2 2
MISC_ID_REST_CODES.RESTRICTION_CODE MIR_MIRC_FK R
MISC_ID_CNTR number 38
MISC_IDS.MISC_ID_CNTR MIR_MISCID_FK C
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ID_NUMBER" IS NOT NULL MIR_ID_NUMBER_NN
"MISC_CD_MISC_ID_CODE" IS NOT NULL MIR_MISC_CD_MISC_ID_CODE_NN
"MISC_ID_CNTR" IS NOT NULL MIR_MISC_ID_CNTR_NN
"MISC_ID_CODE" IS NOT NULL MIR_MISC_ID_CODE_NN
"PER_PERSON_ID" IS NOT NULL MIR_PER_PERSON_ID_NN
"RESTRICTION_CODE" IS NOT NULL MIR_RESTRICTION_CODE_NN

Indexes:
Column(s) Type Sort Constraint Name
MISC_CD_MISC_ID_CODE + PER_PERSON_ID + ID_NUMBER + MISC_ID_CODE + RESTRICTION_CODE + MISC_ID_CNTR Primary key Asc/Asc/Asc/Asc/Asc/Asc MIR_PK
MISC_ID_CODE + RESTRICTION_CODE Performance Asc/Asc MIR_MIRC_FK_I
PER_PERSON_ID + MISC_CD_MISC_ID_CODE + ID_NUMBER + MISC_ID_CNTR Performance Asc/Asc/Asc/Asc MIR_MISCID2_FK_I
MISC_CD_MISC_ID_CODE + ID_NUMBER + PER_PERSON_ID + MISC_ID_CNTR Performance Asc/Asc/Asc/Asc MIR_MISCID_FK_I

Close relationships  within of separation: