Table slot9.WORLD.TSTA.CITATION_PEOPLE
This table stores the association to MASTER PEOPLE added to the citation 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
ROLE_CODE varchar2 30
EJS_CODES.CODE CITP_ROLE_CODE_EJS_CODE_FK R
MN_ID number 0
MASTER_NAMES.MN_ID CP_MN_FK C
Master Name ID number
CITATION_ID number 38
CITATIONS.CITATION_ID CP_CITATION_FK C
sequence to distinguish individual tickets
PERSON_ID number 0
MASTER_NAMES.PER_PERSON_ID CP_MN_FK C
Person ID number
CREATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
CREATOR_DATE date 7  √  null Date of record creation
UPDATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
UPDATOR_DATE date 7  √  null Date of record update
ROLE_CODE_TYPE varchar2 30  √  'PERSON_CITATION_ROLE_CODES'
EJS_CODES.CODE_TYPE CITP_ROLE_CODE_EJS_CODE_FK R
REC_ID number 0  √  null
BAC varchar2 15  √  null
MISC_ID_NUMBER varchar2 30  √  null
MISC_IDS.ID_NUMBER CITP_MISC_ID_FK R
MISC_ID_CODE varchar2 2  √  null
MISC_IDS.MISC_CD_MISC_ID_CODE CITP_MISC_ID_FK R
MISC_ID_CNTR number 38  √  null
MISC_IDS.MISC_ID_CNTR CITP_MISC_ID_FK R
COMMER_DRIVER_LIC char 1  √  'N'
MISC_ID_PERSON_ID number 0  √  null
MISC_IDS.PER_PERSON_ID CITP_MISC_ID_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"CITATION_ID" IS NOT NULL CITP_CITATION_ID_NN
"MN_ID" IS NOT NULL CITP_MN_ID_NN
"PERSON_ID" IS NOT NULL CITP_PERSON_ID_NN
"ROLE_CODE" IS NOT NULL CITP_ROLE_CODE_NN
COMMER_DRIVER_LIC IN ('Y','N') CK_CITP_COMMER_LIC

Indexes:
Column(s) Type Sort Constraint Name
PERSON_ID + MN_ID + CITATION_ID + ROLE_CODE Primary key Asc/Asc/Asc/Asc CITP_PK
MISC_ID_PERSON_ID + MISC_ID_CODE + MISC_ID_NUMBER + MISC_ID_CNTR Performance Asc/Asc/Asc/Asc CITP_MISC_ID_FK_I
ROLE_CODE_TYPE + ROLE_CODE Performance Asc/Asc CITP_ROLE_CODE_EJS_CODE_I
CITATION_ID Performance Asc CP_CITATION_FK_I
ROLE_CODE Performance Asc CP_CRC_FK_I
MN_ID + PERSON_ID Performance Asc/Asc CP_MN_FK_I

Close relationships  within of separation: