Table slot9.WORLD.TSTA.FIELD_INTERVIEWS
This table stores the field interview information (referred to as FIELD CONTACTS 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
FLDINT_ID number 0
CASE_ACTIVITY_FLDINTS.FLDINT_ID CACTINT_FLDINT_FK R
CASE_FIELD_INTS.FLDINT_ID CFINT_FLDINT_FK R
CASE_SEARCH_FIELD_CONTACT_VW.FLDINT_ID Implied Constraint R
FIELD_INT_SEARCH_GANG_VW.FLDINT_ID Implied Constraint R
FIELD_INT_SEARCH_LOCATION_VW.FLDINT_ID Implied Constraint R
FIELD_INT_SEARCH_MIN_VW.FLDINT_ID Implied Constraint R
FIELD_INT_SEARCH_OFFICER_VW.FLDINT_ID Implied Constraint R
FIELD_INT_SEARCH_ORG_VW.FLDINT_ID Implied Constraint R
FIELD_INT_SEARCH_PERSON_VW.FLDINT_ID Implied Constraint R
FIELD_INT_SEARCH_VEHICLE_VW.FLDINT_ID Implied Constraint R
FIELD_INTERVIEW_ATTACHMENTS.FLDINT_ID FLDINTATT_FLDINT_FK C
FLDINT_ADD_VW.FLDINT_ID Implied Constraint R
FLDINT_ADDRESSES.FLDINT_ID FI_ADDR_FLDINT_FK C
FLDINT_BUSINESSES.FLDINT_ID FI_BUSINESS_FLDINT_FK C
FLDINT_DELETE.FLDINT_ID Implied Constraint R
FLDINT_DISPATCHES.FLDINT_ID FIDISP_FLDINT_FK R
FLDINT_GANG_VW.FLDINT_ID Implied Constraint R
FLDINT_GANGS.FLDINT_ID FI_GANG_FLDINT_FK C
FLDINT_IMAGES.FLDINT_ID FLDIM_FLDINT_FK C
FLDINT_INTELL.FLDINT_ID FINTEL_FLDINT_FK C
FLDINT_INTELL_VW.FLDINT_ID Implied Constraint R
FLDINT_NARRATIVES_VW.FLDINT_ID Implied Constraint R
FLDINT_OFF_VW.FLDINT_ID Implied Constraint R
FLDINT_OFFICERS.FLDINT_ID FLDO_FLDINT_FK C
FLDINT_PEOPLE.FLDINT_ID FLDIP_FLDINT_FK C
FLDINT_VEH_VW.FLDINT_ID Implied Constraint R
FLDINT_VEHICLES.FLDINT_ID FLDIV_FLDINT_FK C
INCIDENT_FLDINTS.FLDINT_ID INCFLD_FLDINT_FK C
JS_FIELD_CONTACT_ADDRESS_VW.FLDINT_ID Implied Constraint R
JS_FIELD_CONTACT_GANG_VW.FLDINT_ID Implied Constraint R
JS_FIELD_CONTACT_OFFICERS_VW.FLDINT_ID Implied Constraint R
JS_FIELD_CONTACT_VW.FLDINT_ID Implied Constraint R
USI_FI_FIELDS.INTERVIEW_ID USI_FIF_FLDINT_FK R
USI_FIELD_INTERVIEWS.INTERVIEW_ID USI_FI_FLDINT_FK R
Field Interview ID Number - Primary Key
FLDINT_DATE date 7 Date and Time of Field Interview
SUMMARY varchar2 2000  √  null Field Interview Summary/Notes
AGENCY_ONLY_YN varchar2 1  √  'N' Agency Only Y/N
SECURITY_LEVEL number 0  √  null Security Level Setting for Information
INTELL_ONLY_YN varchar2 1  √  'N' Field Interview for Intell Users Only
CREATOR_ID varchar2 100  √  null Record Create By User ID
CREATOR_DATE date 7  √  null Date Record Created
UPDATOR_ID varchar2 100  √  null Record Last Updated By User ID
UPDATOR_DATE date 7  √  null Date Record last updated
AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE FLDINT_AGNCY_CD_FK R
Agency involved
NOTE_ID number 0  √  null
EJS_NOTES.NOTE_ID FLDINT_EJSN_FK R
Uniqe ID for Note
REC_ID number 0  √  null
FLDINT_TYPE varchar2 30  √  null
EJS_CODES.CODE FLDINT_EJS_CODES_FK R
FLDINT_TYPE_TYPE varchar2 30  √  NULL
EJS_CODES.CODE_TYPE FLDINT_EJS_CODES_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
AGENCY_ONLY_YN IN ('Y', 'N') CK_FLDINT_AGENCY_ONLY_YN
INTELL_ONLY_YN IN ('Y', 'N') CK_FLDINT_INTELL_ONLY_YN
"AGENCY_CODE" IS NOT NULL FLDINT_AGENCY_CODE_NN
"FLDINT_DATE" IS NOT NULL FLDINT_FLDINT_DATE_NN
"FLDINT_ID" IS NOT NULL FLDINT_FLDINT_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
FLDINT_ID Primary key Asc FLDINT_PK
AGENCY_CODE Performance Asc FLDINT_AGNCY_CD_FK_I
FLDINT_TYPE_TYPE + FLDINT_TYPE Performance Asc/Asc FLDINT_EJS_CODES_FK_I
NOTE_ID Performance Asc FLDINT_EJSN_FK_I

Close relationships  within of separation: