Table slot9.WORLD.TSTA.DISPATCH_EVENT_PEOPLE
This table stores information about people involved with an event.
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
DISPATCH_PERSON_ID number 0
DISPATCH_PERSON_MISC_IDS.DISPATCH_PERSON_ID DEPMID_DEP_FK C
DISPATCH_PERSON_ROLES.DISPATCH_PERSON_ID DPR_DEP_FK C
DISPATCH_PERSON_VEHICLES.DISPATCH_PERSON_ID DPV_DEP_FK C
Unique identifier for this person involved with this event (Primary Key).
DISPATCH_ID number 38
DISPATCH_EVENTS.DISPATCH_ID DEP_DISPTCH_FK C
Unique identifier of the associated event.
PER_PERSON_ID number 0  √  null
PEOPLE.PERSON_ID DEP_PER_FK R
Unique identifier of the associated master person index record, if any.
LNAME varchar2 100  √  null Last name of the person involved.
FNAME varchar2 80  √  null First name of the person involved.
MNAME varchar2 80  √  null Middle name of the person involved.
TITLE_CODE varchar2 30  √  null
EJS_CODES.CODE DEP_TITLE_EJS_CODES_FK R
Name suffix of the person involved.
TITLE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE DEP_TITLE_EJS_CODES_FK R
EJS_CODES Code type for the name suffix.
ADDRESS varchar2 200  √  null Full Address of person involved.
STREET_NUMBER varchar2 30  √  null Street # component of address for person involved.
STREET_DIRECTION varchar2 30  √  null
EJS_CODES.CODE DEP_STR_DIR_EJS_CODES_FK R
Street direction prefix component of address for person involved
STR_DIR_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE DEP_STR_DIR_EJS_CODES_FK R
EJS_CODES Code type for Street direction prefix.
STREET_NAME varchar2 40  √  null Street Name component of address for person involved.
STREET_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE DEP_STR_TYPE_EJS_CODES_FK R
Street Type component of address for person involved.
STR_TYPE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE DEP_STR_TYPE_EJS_CODES_FK R
EJS_CODES Code type for Street type.
STREET_DIR_SUFFIX varchar2 30  √  null
EJS_CODES.CODE DEP_DIR_SUF_EJS_CODES_FK R
Street Direction Suffix component of address for person involved.
STR_DIR_SUF_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE DEP_DIR_SUF_EJS_CODES_FK R
EJS_CODES Code type for street direction suffix.
SUB_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE DEP_SUB_TYPE_EJS_CODES_FK R
Sub Address Type component of address for person involved.
SUB_TYPE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE DEP_SUB_TYPE_EJS_CODES_FK R
EJS_CODES Code type for address sub type.
SUB_NUMBER varchar2 30  √  null Sub Address Number component of address for person involved.
CITY varchar2 40  √  null City Name component of address for person involved.
STATE_CODE varchar2 30  √  null
EJS_CODES.CODE DEP_STATE_EJS_CODES_FK R
State component of address for person involved.
STATE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE DEP_STATE_EJS_CODES_FK R
EJS_CODES Code type for state code.
ZIP5 varchar2 30  √  null 1st part of Zip Code component of address for person involved.
ZIP4 varchar2 30  √  null 2nd part of Zip Code component of address for person involved.
PHONE varchar2 30  √  null Phone number of the person involved.
SSN varchar2 30  √  null Social Security Number of the person involved.
DOB date 7  √  null Date of Birth of the person involved.
RACE_CODE varchar2 30  √  null
EJS_CODES.CODE DEP_RACE_EJS_CODES_FK R
Code for the race of the person involved.
RACE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE DEP_RACE_EJS_CODES_FK R
EJS_CODES Code type for race codes.
SEX_CODE varchar2 30  √  null
EJS_CODES.CODE DEP_SEX_EJS_CODES_FK R
Code for the gender of the person involved.
SEX_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE DEP_SEX_EJS_CODES_FK R
EJS_CODES Code type for gender codes.
HEIGHT varchar2 30  √  null Height of the person involved.
WEIGHT varchar2 30  √  null Weight of the person involved.
EYE_COLOR_CODE varchar2 30  √  null
EJS_CODES.CODE DEP_EYE_COLOR_EJS_CODES_FK R
Code for the Eye color of the person involved.
EYE_COLOR_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE DEP_EYE_COLOR_EJS_CODES_FK R
EJS_CODES Code type for eye color codes.
HAIR_COLOR_CODE varchar2 30  √  null
EJS_CODES.CODE DEP_HAIR_COLOR_EJS_CODES_FK R
Code for the Hair color of the person involved.
HAIR_COLOR_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE DEP_HAIR_COLOR_EJS_CODES_FK R
EJS_CODES Code type for hair color codes.
SKIN_CODE varchar2 30  √  null
EJS_CODES.CODE DEP_SKIN_EJS_CODES_FK R
Code for the Skin type,tone, or complexion of the person involved.
SKIN_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE DEP_SKIN_EJS_CODES_FK R
EJS_CODES Code type for skin codes.
SMT_DESCRIPTION varchar2 4000  √  null Description of any scars, marks, tatoos, or other characteristics of each person.
COMMENTS varchar2 4000  √  null Text field for comments.
DATE_OF_INFO date 7  √  null Date/time this information was obtained.
CREATOR_ID varchar2 100  √  null Person creating the record.
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.
REC_ID number 0  √  null Numeric ID of this record across the entire schema.
AGE number 0  √  null
CAD_PERSON_ID varchar2 100  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"DISPATCH_ID" IS NOT NULL DEP_DISPATCH_ID_NN
"DISPATCH_PERSON_ID" IS NOT NULL DEP_DISPATCH_PERSON_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
DISPATCH_PERSON_ID Primary key Asc DEP_PK
STR_DIR_SUF_TYPE + STREET_DIR_SUFFIX Performance Asc/Asc DEP_DIR_SUF_EJS_CODES_FK_I
DISPATCH_ID Performance Asc DEP_DISPTCH_FK_I
DOB Performance Asc DEP_DOB_FB_I
EYE_COLOR_CODE_TYPE + EYE_COLOR_CODE Performance Asc/Asc DEP_EYE_COLOR_EJS_CODES_FK_I
Performance DEP_FNAME_FB_I
HAIR_COLOR_CODE_TYPE + HAIR_COLOR_CODE Performance Asc/Asc DEP_HAIR_COLOR_EJS_CODES_FK_I
DOB Performance Asc DEP_LNAME_FNAME_DOB_FB_I
PER_PERSON_ID Performance Asc DEP_PER_FK_I
RACE_CODE_TYPE + RACE_CODE Performance Asc/Asc DEP_RACE_EJS_CODES_FK_I
SEX_CODE_TYPE + SEX_CODE Performance Asc/Asc DEP_SEX_EJS_CODES_FK_I
SKIN_CODE_TYPE + SKIN_CODE Performance Asc/Asc DEP_SKIN_EJS_CODES_FK_I
SSN Performance Asc DEP_SSN_I
STATE_CODE_TYPE + STATE_CODE Performance Asc/Asc DEP_STATE_EJS_CODES_FK_I
STR_DIR_TYPE + STREET_DIRECTION Performance Asc/Asc DEP_STR_DIR_EJS_CODES_FK_I
STR_TYPE_CODE_TYPE + STREET_TYPE_CODE Performance Asc/Asc DEP_STR_TYPE_EJS_CODES_FK_I
SUB_TYPE_CODE_TYPE + SUB_TYPE_CODE Performance Asc/Asc DEP_SUB_TYPE_EJS_CODES_FK_I
TITLE_CODE_TYPE + TITLE_CODE Performance Asc/Asc DEP_TITLE_EJS_CODES_FK_I

Close relationships  within of separation: