Table slot9.WORLD.TSTA.JAIL_PEOPLE
This table stores birth places for a MASTER PERSON as entered 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
ARREST_ADDRESS_SEARCH_VW.PERSON_ID Implied Constraint R
ARREST_CFS_SEARCH_VW.PERSON_ID Implied Constraint R
ARREST_DISPOSITION_SEARCH_VW.PERSON_ID Implied Constraint R
ARREST_JAIL_SEARCH_VW.PERSON_ID Implied Constraint R
ARREST_NARRATIVE_SEARCH_VW.PERSON_ID Implied Constraint R
ARREST_ORG_SEARCH_VW.PERSON_ID Implied Constraint R
ARREST_PERSON_SEARCH_VW.PERSON_ID Implied Constraint R
ARREST_PROPERTY_SEARCH_VW.PERSON_ID Implied Constraint R
ARREST_SEARCH_VW.PERSON_ID Implied Constraint R
ARREST_VEHICLE_SEARCH_VW.PERSON_ID Implied Constraint R
BI_CITATIONS_VW.PERSON_ID Implied Constraint R
CITATION_PERSON_VW.PERSON_ID Implied Constraint R
COLLAPSED_MASTER_NAMES.PERSON_ID Implied Constraint R
COURT_APPEARANCE_SEARCH_VW.PERSON_ID Implied Constraint R
COURT_CASE_APP_SEARCH_VW.PERSON_ID Implied Constraint R
COURT_CASE_SEARCH_VW.PERSON_ID Implied Constraint R
DISPATCH_EVENT_PEOPLE_VW.PERSON_ID Implied Constraint R
EXPORT_TRANSACTION_LOGS.PERSON_ID Implied Constraint R
INCIDENT_BOLO_PEOPLE_VW.PERSON_ID Implied Constraint R
INCIDENT_CASE_SEARCH_VW.PERSON_ID Implied Constraint R
INCIDENT_PEOPLE_VW.PERSON_ID Implied Constraint R
JS_BAIR_PERSON_VW.PERSON_ID Implied Constraint R
JS_BASE64_IMAGES_VW.PERSON_ID Implied Constraint R
JS_CITATION_VW.PERSON_ID Implied Constraint R
JS_FIELD_ARREST_CHARGE_VW.PERSON_ID Implied Constraint R
JS_FIELD_ARREST_VW.PERSON_ID Implied Constraint R
JS_INCIDENT_CASE_VW.PERSON_ID Implied Constraint R
JS_INCIDENT_OFFNDR_EVIDENCE_VW.PERSON_ID Implied Constraint R
JS_WARRANT_OFFENSE_CHARGE_VW.PERSON_ID Implied Constraint R
JS_WARRANT_VW.PERSON_ID Implied Constraint R
PEOPLE_ADDRESS_VW.PERSON_ID Implied Constraint R
PEOPLE_COMBO_ADDR_PHONES_VW.PERSON_ID Implied Constraint R
PEOPLE_COMBO_ADR_PH_VW.PERSON_ID Implied Constraint R
PEOPLE_COMBO_ADR_VW.PERSON_ID Implied Constraint R
PEOPLE_COMBO_PH_VW.PERSON_ID Implied Constraint R
PEOPLE_COMBO_VW.PERSON_ID Implied Constraint R
PEOPLE_JAIL_SEARCH_VW.PERSON_ID Implied Constraint R
PEOPLE_MASTER_NAME_VW.PERSON_ID Implied Constraint R
PEOPLE_MISC_ID_VW.PERSON_ID Implied Constraint R
PEOPLE_PHONE_VW.PERSON_ID Implied Constraint R
PEOPLE_PHYS_DESC_VW.PERSON_ID Implied Constraint R
PEOPLE_SEARCH_ONEADDRESS_VW.PERSON_ID Implied Constraint R
PEOPLE_SMT_VW.PERSON_ID Implied Constraint R
PEOPLE_VEHICLE_VW.PERSON_ID Implied Constraint R
PERSON_ADDR_HISTORY.PERSON_ID Implied Constraint R
PERSON_ADDR_PHONES.PERSON_ID Implied Constraint R
PERSON_ASSOC_CNT_VW.PERSON_ID Implied Constraint R
PERSON_CAUTIONS_VW.PERSON_ID Implied Constraint R
PERSON_COLLAPSE_LOG_VW.PERSON_ID Implied Constraint R
PERSON_DUP_SEARCH_VW.PERSON_ID Implied Constraint R
PHYDESC_PERIMAGE_VW.PERSON_ID Implied Constraint R
WARRANT_OFFENSE_CHARGE_VW.PERSON_ID Implied Constraint R
WARRANT_PERSON_ADDR_VW.PERSON_ID Implied Constraint R
WARRANTS_VW.PERSON_ID Implied Constraint R
PEOPLE.PERSON_ID JP_PER_FK C
DIABETIC varchar2 1  √  null
EPILEPTIC varchar2 1  √  null
SUSPECTED_GANG_MEMBER varchar2 1  √  null
BIRTH_COUNTRY varchar2 30  √  null
EJS_CODES.CODE JP_BIRTH_COUNTRY_EJS_CODE_FK R
REASON_SUSPECTED_GANG_MEMBER varchar2 30  √  null
BIRTH_STATE varchar2 30  √  null
EJS_CODES.CODE JP_BIRTH_STATE_EJS_CODE_FK R
BIRTH_CITY varchar2 25  √  null
EMERGENCY_CONTACT_NAME varchar2 255  √  null
EMERGENCY_PHONE_AREA varchar2 3  √  null
EMERGENCY_PHONE_PREFIX varchar2 3  √  null
EMERGENCY_PHONE_SUFFIX varchar2 4  √  null
EMERGENCY_PHONE_EXT varchar2 8  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
EMERGENCY_PHONE_EXT_2 varchar2 8  √  null
EMERGENCY_PHONE_PREFIX_2 varchar2 3  √  null
EMERGENCY_PHONE_SUFFIX_2 varchar2 4  √  null
RECIDIVIST varchar2 1  √  null
RELATIONSHIP varchar2 30  √  null
EMERGENCY_PHONE_AREA_2 varchar2 3  √  null
HENRY1 varchar2 14  √  null
HENRY2 varchar2 14  √  null
NCIC_FINGERPRINT varchar2 20  √  null
CITIZENSHIP_COUNTRY varchar2 30  √  null
EJS_CODES.CODE JP_CITIZENSHIP_COU_EJS_CODE_FK R
BIRTH_COUNTRY_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE JP_BIRTH_COUNTRY_EJS_CODE_FK R
BIRTH_STATE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE JP_BIRTH_STATE_EJS_CODE_FK R
CITIZENSHIP_COUNTRY_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE JP_CITIZENSHIP_COU_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
"PERSON_ID" IS NOT NULL JP_PERSON_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
PERSON_ID Primary key Asc JP_PK
BIRTH_COUNTRY_TYPE + BIRTH_COUNTRY Performance Asc/Asc JP_BIRTH_COUNTRY_EJS_CODE_I
BIRTH_STATE_TYPE + BIRTH_STATE Performance Asc/Asc JP_BIRTH_STATE_EJS_CODE_I
CITIZENSHIP_COUNTRY_TYPE + CITIZENSHIP_COUNTRY Performance Asc/Asc JP_CITIZENSHIP_COU_EJS_CODE_I
CITIZENSHIP_COUNTRY Performance Asc JP_CNTRY_CD_CITIZENSHIP_FK_I
BIRTH_COUNTRY Performance Asc JP_CNTRY_CD_FK_I
BIRTH_STATE Performance Asc JP_STATE_CD_FK_I

Close relationships  within of separation: