Table slot9.WORLD.TSTA.PEOPLE
This table stores the MASTER PERSON information added 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
PERSON_ID number 0
ARRESTS.PERSON_ID ARR_PER_FK C
BOLO_PEOPLE.PERSON_ID BOLO_P_PER_FK C
BUSINESS_ALARMS.PERSON_ID BUSALRM_PER_FK C
CASE_ACTIVITY_NAMES.PERSON_ID CACTNAMES_PER_FK R
COURT_CASE_PEOPLE.PER_PERSON_ID CRTCASEPPL_PER_FK R
COURT_PAPER_LOGS.PERSON_SERVED_ID CPAP_LOG_PER_FK R
COURT_PAPER_PARTIES.PERSON_ID CPP_PER_FK R
CP_DEL_LOG_PARTIES.PERSON_ID CPLOGPARTY_PER_FK C
CP_DELETE_PARTY.PERSON_ID CPDELPAR_LOG_PER_FK R
CP_DELETE_PAYMENT.PERSON_ID CPDELPAY_PER_FK R
CP_DELETE_SERVICE_ADDR.PERSON_ID CPDELSADDR_PER_FK R
CRIMINAL_COMPLAINTS.PER_PERSON_ID CRMCMP_PER_FK R
DISPATCH_EVENT_PEOPLE.PER_PERSON_ID DEP_PER_FK R
DOMESTIC_VIOLENCE_VICTIMS.PERSON_ID DVV_PER_FK C
EDUCATION.PERSON_ID EDU_PER_FK C
EMAILS.PER_PERSON_ID EMAIL_PER_FK C
EMPLOYMENTS.PER_PERSON_ID EMP_PER_FK C
ENROLLMENTS.PERSON_ID ENR120_PER_FK R
FLDINT_PEOPLE.PERSON_ID FLDIP_PER_FK C
GANG_PEOPLE.PERSON_ID GP_PER_FK R
IMPOUND_PEOPLE.PERSON_ID IMPP_PER_FK C
JAIL_PEOPLE.PERSON_ID JP_PER_FK C
LANGUAGES.PER_PERSON_ID LNG_PER_FK R
MASTER_NAMES.PER_PERSON_ID MN_PER_FK C
MILITARY_SERVICE.PER_PERSON_ID MIL_SER_PER_FK R
MISC_IDS.PER_PERSON_ID MISCID_PER_FK C
PAWN_TICKETS.PER_PERSON_ID PT_PER_FK R
PEOPLE_BUSINESSES.PERSON_ID PEOBUS_PER_FK C
PEOPLE_PROPERTIES.PERSON_ID PEPROP_PER_FK R
PEOPLE_RELATIONS.PRIMARY_PERSON_ID PRIM_PREL_PER_FK C
PEOPLE_RELATIONS.RELATED_PERSON_ID REL_PREL_PER_FK C
PEOPLE_VEHICLES.PERSON_ID PERV_PER_FK R
PERMIT_PEOPLE.PERSON_ID PRMP_PER_FK C
PERSON_ADDRESSES.PERSON_ID PER_ADDR_PER_FK C
PERSON_ATTACHMENTS.PERSON_ID PA_PER_FK R
PERSON_CAUTIONS.PER_PERSON_ID PCS_PER_FK C
PERSON_FINGERPRINTS.PERSON_ID PF_PER_FK C
PERSON_IMAGES.PER_PERSON_ID PI_PER_FK C
PERSON_SPECIAL_NEEDS.PERSON_ID PSN_PER_FK C
PHONES.PER_PERSON_ID PHONE_PER_FK C
PHOTO_LINEUP_DELETE.SUSPECT_PERSON_ID PHTOLNUPD_PER_FK R
PHYSICAL_DESCRIPTIONS.PER_PERSON_ID PHY_PER_FK C
PROPERTY_HOLDS.DISPOSITION_PERSON_ID PROPHO_PER_FK R
SMTS.PER_PERSON_ID SMT_PER_FK C
USER_FIELD_PER_VALUES.PERSON_ID USRSCRN_UFPV_PER_FK R
USI_PEOPLE.PERSON_ID USI_PER_PER_FK R
Person ID number
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
CREATOR_ID varchar2 100  √  null Person creating the record
MASTER_PERSON_ID number 0
MASTER_PEOPLE.MASTER_PERSON_ID PER_MPER_FK R
REC_ID number 0  √  null
LOADED_BY varchar2 100  √  null Interface that loaded this index record.
LAST_LOAD_DATE date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"PERSON_ID" IS NOT NULL PER_PERSON_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
PERSON_ID Primary key Asc PER_PK
MASTER_PERSON_ID Performance Asc PER_MPER_FK_I

Close relationships  within of separation: