Table slot9.WORLD.TSTA.INCIDENT_VEHICLES
This table stores the association to MASTER VEHICLES and their role 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
VEHICLE_ID number 38
VEHICLES.VEHICLE_ID INCVEH_VEH_FK R
Vehicle ID number
INCIDENT_ID number 38
INCIDENT_SUPPLEMENTS.INC_INCIDENT_ID INCVEH_INCSUP_FK R
Incident ID number assigned
SUPP_SEQ number 38
INCIDENT_SUPPLEMENTS.SUPP_SEQ INCVEH_INCSUP_FK R
Supplement Sequence Number 1 = Original Report
ROLE_CODE varchar2 30
EJS_CODES.CODE INCVEH_ROLE_CODE_EJS_CODE_FK R
STATUS_CODE varchar2 30
EJS_CODES.CODE INCVEH_STATUS_EJS_CODES_FK R
Property Status Code
LOCKED varchar2 1  √  null Is the vehicle Locked?
KEYS_IN_VEHICLE varchar2 1  √  null Are the keys in the vehicle?
CREATOR_ID varchar2 100  √  null Yes, No, or Unkown Fields
CREATOR_DATE date 7  √  null Date Record was created
UPDATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
UPDATOR_DATE date 7  √  null Date Record was last updated
DATE_RECOVERED date 7  √  null Date vehicle was recovered
INC_VEH_ID number 38
INC_VEH_OFFENSES.INC_VEH_ID IVO_INCVEH_FK C
ADDRESS_ID number 38  √  null
ADDRESSES.ADDRESS_ID INCVEH_ADDR_FK R
ROLE_CODE_TYPE varchar2 30  √  'VEHICLE_ROLE_CODES'
EJS_CODES.CODE_TYPE INCVEH_ROLE_CODE_EJS_CODE_FK R
STATUS_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE INCVEH_STATUS_EJS_CODES_FK R
REC_ID number 0  √  null
DAMAGE_REMARKS varchar2 255  √  null
INC_PER_ID number 0  √  null
INCIDENT_PEOPLE.INC_PER_ID INCVEH_INCPER_FK R
IB_INCIDENT_ID number 38  √  null
INCIDENT_BUSINESSES.INC_INCIDENT_ID INCVEH_IB_FK R
IB_BUSINESS_NUMBER number 38  √  null
INCIDENT_BUSINESSES.BUSNS_BUSINESS_NUMBER INCVEH_IB_FK R
DATE_OWNER_NOTIFIED date 7  √  null
VALUE number 11,2  √  null
LOADED_BY varchar2 30  √  null
LAST_LOAD_DATE date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
KEYS_IN_VEHICLE IN ('Y', 'N') CK_INCVEH_KEYS_IN_VEHICLE
LOCKED IN ('Y', 'N') CK_INCVEH_LOCKED
"INC_VEH_ID" IS NOT NULL INCVEH_INC_VEH_ID_NN
"INCIDENT_ID" IS NOT NULL INCVEH_INCIDENT_ID_NN
"ROLE_CODE" IS NOT NULL INCVEH_ROLE_CODE_NN
"STATUS_CODE" IS NOT NULL INCVEH_STATUS_CODE_NN
"SUPP_SEQ" IS NOT NULL INCVEH_SUPP_SEQ_NN
"VEHICLE_ID" IS NOT NULL INCVEH_VEHICLE_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
INC_VEH_ID Primary key Asc INCVEH_PK
ADDRESS_ID Performance Asc INCVEH_ADDR_FK_I
IB_INCIDENT_ID + IB_BUSINESS_NUMBER Performance Asc/Asc INCVEH_IB_FK_I
INC_PER_ID Performance Asc INCVEH_INCPER_FK_I
INCIDENT_ID + SUPP_SEQ Performance Asc/Asc INCVEH_INCSUP_FK_I
ROLE_CODE_TYPE + ROLE_CODE Performance Asc/Asc INCVEH_ROLE_CODE_EJS_CODE_I
STATUS_CODE_TYPE + STATUS_CODE Performance Asc/Asc INCVEH_STATUS_EJS_CODES_FK_I
VEHICLE_ID Performance Asc INCVEH_VEH_FK_I
ROLE_CODE Performance Asc INCVEH_VR_FK_I

Close relationships  within of separation: