Table slot9.WORLD.TSTA.INCIDENT_BUSINESSES
This tables stores associations to MASTER BUSINESSES (referred to as organizations) added to the 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_INCIDENT_ID number 0
INCIDENT_PROPERTIES.IB_INC_INCIDENT_ID INCPRO_IB_FK R
INCIDENT_VEHICLES.IB_INCIDENT_ID INCVEH_IB_FK R
VICTIMS.INCIDENT_ID VIC_INCBUS_FK C
INCIDENTS.INCIDENT_ID IB_INC_FK C
Incident ID number assigned
BUSNS_BUSINESS_NUMBER number 0
INCIDENT_PROPERTIES.IB_BUSNS_BUSINESS_NUMBER INCPRO_IB_FK R
INCIDENT_VEHICLES.IB_BUSINESS_NUMBER INCVEH_IB_FK R
VICTIMS.BUSINESS_NUMBER VIC_INCBUS_FK C
BUSINESSES.BUSINESS_NUMBER IB_BUSNS_FK R
Unique id for business
IB1_ROLE_TYPE varchar2 30
EJS_CODES.CODE IB_IB1_ROLE_TYPE_EJS_CODE_FK R
role code (business"s)
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
SUPP_SEQ number 5  √  null
IB1_ROLE_TYPE_TYPE varchar2 30  √  'INC_BUSINESS_ROLE_CODE'
EJS_CODES.CODE_TYPE IB_IB1_ROLE_TYPE_EJS_CODE_FK R
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"BUSNS_BUSINESS_NUMBER" IS NOT NULL IB_BUSNS_BUSINESS_NUMBER_NN
"IB1_ROLE_TYPE" IS NOT NULL IB_IB1_ROLE_TYPE_NN
"INC_INCIDENT_ID" IS NOT NULL IB_INC_INCIDENT_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
INC_INCIDENT_ID + BUSNS_BUSINESS_NUMBER Primary key Asc/Asc IB_PK
BUSNS_BUSINESS_NUMBER Performance Asc IB_BUSNS_FK_I
IB1_ROLE_TYPE Performance Asc IB_IB1_FK_I
IB1_ROLE_TYPE_TYPE + IB1_ROLE_TYPE Performance Asc/Asc IB_IB1_ROLE_TYPE_EJS_CODE_I
INC_INCIDENT_ID Performance Asc IB_INC_FK_I

Close relationships  within of separation: