Table slot9.WORLD.TSTA.MODUS_OPERANDI
This table stores the modus operandi associated with an offense added to an INCIDENT 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
MO_ID number 0 A unique sequence number for each MO
INCIDENT_ID number 0
INCIDENT_SUPPLEMENTS.INC_INCIDENT_ID MO_INCSUP_FK C
Incident ID number for MO
SUPP_SEQ number 0
INCIDENT_SUPPLEMENTS.SUPP_SEQ MO_INCSUP_FK C
Supplement Sequence Number for MO
OFFENSE_NUMBER number 0  √  null
OFFENSES.OFFENSE_NUMBER MO_OFFNSE_FK C
Offense Number of the Offense
INCIDENT_ID_OFFENSE number 0  √  null
OFFENSES.INC_INCIDENT_ID MO_OFFNSE_FK C
Incident ID number of the Offense
SUPP_SEQ_OFFENSE number 0  √  null
OFFENSES.SUPP_SEQ MO_OFFNSE_FK C
Supplement Sequence Number for of the Offense
MEANS_CODE varchar2 5  √  null
MO_MEANS_CODES.MEANS_CODE MO_MMC_FK R
Code for MO Means
METHOD_OF_ENTRY_CODE varchar2 5  √  null
MO_METHOD_OF_ENTRY_CODES.METHOD_OF_ENTRY_CODE MO_MET_FK R
POINT_OF_ENTRY_CODE varchar2 5  √  null
MO_POINT_OF_ENTRY_CODES.POINT_OF_ENTRY_CODE MO_MPE_FK R
Code for MO Point of Entry
TRADEMARK_CODE varchar2 5  √  null
MO_TRADEMARK_CODES.TRADEMARK_CODE MO_MTRC_FK R
Code for MO Trademark
MO_COMMENT varchar2 255  √  null A comment that further explains the MO
CREATOR_ID varchar2 100  √  null Person that created record
CREATOR_DATE date 7  √  null Date record was created
UPDATOR_ID varchar2 100  √  null Person who last updated record
UPDATOR_DATE date 7  √  null Date record was last updated
POINT_OF_EXIT_CODE varchar2 5  √  null
MO_POINT_OF_EXIT_CODES.POINT_OF_EXIT_CODE MO_MPX_FK R
Code for MO Point of Exit
INC_PER_ID number 0  √  null
INCIDENT_PEOPLE.INC_PER_ID MO_INC_PEOPLE_FK R
FK to Incident People INC_PER_ID
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"INCIDENT_ID" IS NOT NULL MO_INCIDENT_ID_NN
"MO_ID" IS NOT NULL MO_MO_ID_NN
"SUPP_SEQ" IS NOT NULL MO_SUPP_SEQ_NN

Indexes:
Column(s) Type Sort Constraint Name
MO_ID + INCIDENT_ID + SUPP_SEQ Primary key Asc/Asc/Asc MO_PK
INC_PER_ID Performance Asc MO_INCPER_FK_I
INCIDENT_ID + SUPP_SEQ Performance Asc/Asc MO_INCSUP_FK_I
METHOD_OF_ENTRY_CODE Performance Asc MO_MET_FK_I
MEANS_CODE Performance Asc MO_MMC_FK_I
POINT_OF_ENTRY_CODE Performance Asc MO_MPE_FK_I
POINT_OF_EXIT_CODE Performance Asc MO_MPX_FK_I
TRADEMARK_CODE Performance Asc MO_MTRC_FK_I
INCIDENT_ID_OFFENSE + OFFENSE_NUMBER + SUPP_SEQ_OFFENSE Performance Asc/Asc/Asc MO_OFFNSE_FK_I

Close relationships  within of separation: