Table slot9.WORLD.TSTA.INCIDENT_PROPERTIES
This tables stores the association with MASTER PROPERTIES 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
INC_PROP_ID number 0
INC_PROP_LATEST_APPR_VW.INC_PROP_ID Implied Constraint R
INCIDENT_PROPERTY_VW.INC_PROP_ID Implied Constraint R
JS_INCIDENT_PROPERTY_VW.INC_PROP_ID Implied Constraint R
USI_INCIDENT_PROPERTIES.INC_PROP_ID USI_INCPROP_INCPRO_FK R
DATE_RECOVERED date 7  √  null
DATE_OWNER_NOTIFIED date 7  √  null
PRINT_LABEL varchar2 1  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
OFFENSE_INCIDENT_ID number 38  √  null
OFFENSES.INC_INCIDENT_ID INCPRO_OFFNSE_FK C
OFFENSE_NUMBER number 38  √  null
OFFENSES.OFFENSE_NUMBER INCPRO_OFFNSE_FK C
OFFENSE_SUPP_SEQ number 5  √  null
OFFENSES.SUPP_SEQ INCPRO_OFFNSE_FK C
INCPER_MN_ID number 38  √  null
INCPER_PERSON_ID number 38  √  null
INCPER_INCIDENT_ID number 38  √  null
INCSUP_INCIDENT_ID number 38
INCIDENT_SUPPLEMENTS.INC_INCIDENT_ID INCPRO_INCSUP_FK C
INCSUP_SUPP_SEQ number 38
INCIDENT_SUPPLEMENTS.SUPP_SEQ INCPRO_INCSUP_FK C
PROPERTY_ID number 38  √  null
PROPERTIES.PROPERTY_ID INCPRO_PRO_FK R
STATUS_CODE varchar2 30  √  null
EJS_CODES.CODE INCPRO_STATUS_EJS_CODES_FK R
IB_INC_INCIDENT_ID number 38  √  null
INCIDENT_BUSINESSES.INC_INCIDENT_ID INCPRO_IB_FK R
Incident ID number assigned
IB_BUSNS_BUSINESS_NUMBER number 38  √  null
INCIDENT_BUSINESSES.BUSNS_BUSINESS_NUMBER INCPRO_IB_FK R
Unique id for business
INC_PER_ID number 0  √  null
INCIDENT_PEOPLE.INC_PER_ID INCPRO_INCPER_FK R
STATUS_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE INCPRO_STATUS_EJS_CODES_FK R
PROP_LOSS_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE INCPRO_PROPLOSS_EJS_CODES_FK R
PROP_LOSS_CODE varchar2 30  √  null
EJS_CODES.CODE INCPRO_PROPLOSS_EJS_CODES_FK R
REC_ID number 0  √  null
DAMAGE_REMARKS varchar2 255  √  null
VALUE number 11,2  √  null
EVIDENCE varchar2 1  √  'N'
EVIDENCE_ID number 0  √  null
EVIDENCE.EVIDENCE_ID INCPRO_EVI_FK R
Evidence ID for the incident property.
PROPERTY_HOLD_ID number 0  √  null
PROPERTY_HOLDS.ID INCPRO_PROPHO_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
EVIDENCE IN ('Y', 'N') CK_INCPRO_EVID
PRINT_LABEL IN ('Y', 'N') CK_INCPRO_PRINT_LABEL
"INC_PROP_ID" IS NOT NULL INCPRO_INC_PROP_ID_NN
"INCSUP_INCIDENT_ID" IS NOT NULL INCPRO_INCSUP_INCIDENT_ID_NN
"INCSUP_SUPP_SEQ" IS NOT NULL INCPRO_INCSUP_SUPP_SEQ_NN

Indexes:
Column(s) Type Sort Constraint Name
INC_PROP_ID Primary key Asc INCPRO_PK
EVIDENCE_ID Performance Asc INCPRO_EVI_FK_I
IB_INC_INCIDENT_ID + IB_BUSNS_BUSINESS_NUMBER Performance Asc/Asc INCPRO_IB_FK_I
INC_PER_ID Performance Asc INCPRO_INCPER_FK_I
INCSUP_INCIDENT_ID + INCSUP_SUPP_SEQ Performance Asc/Asc INCPRO_INCSUP_FK_I
OFFENSE_INCIDENT_ID + OFFENSE_NUMBER + OFFENSE_SUPP_SEQ Performance Asc/Asc/Asc INCPRO_OFFNSE_FK_I
PROPERTY_ID Performance Asc INCPRO_PRO_FK_I
PROPERTY_HOLD_ID Performance Asc INCPRO_PROPHO_FK_I
PROP_LOSS_CODE_TYPE + PROP_LOSS_CODE Performance Asc/Asc INCPRO_PROPLOSS_EJS_CODES_FK_I
STATUS_CODE_TYPE + STATUS_CODE Performance Asc/Asc INCPRO_STATUS_EJS_CODES_FK_I

Close relationships  within of separation: