Table slot9.WORLD.TSTA.DV_CRASH_TOWS
This table stores tow information added to a vehicle crash
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
CRASH_TOW_ID number 0 PK of table
CRASH_ID number 0
DV_CRASHES.CRASH_ID CRASHTOW_CRASH_FK R
FK to DV_CRASHES
TOWING_CO varchar2 40  √  null Name of towing company
STATE_CD_STATE_CODE varchar2 30  √  null
EJS_CODES.CODE CRASHTOW_EJSCD_STATE_FK R
State code designator
STATE_CD_STATE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE CRASHTOW_EJSCD_STATE_FK R
TOWING_CO_STREET varchar2 40  √  null Towing company street address
TOWING_CO_ZIP number 0  √  null Towing company zip code
TOWING_CITY varchar2 40  √  null
PHONE_PREFIX varchar2 3  √  null Towing company phone prefix
PHONE_SUFFIX varchar2 4  √  null Towing company phone suffix
PHONE_AREA varchar2 3  √  null Towing company phone area code
DRIVER varchar2 80  √  null Tow truck driver
TOW_DATE date 7  √  null
TOWING_CO_ID number 0  √  null
TOW_COMPANY_CODES.TOWING_CO_ID CRASHTOW_TCC_FK R
REFERENCE_NUMBER varchar2 100  √  null Crash tow reference number
CREATOR_ID varchar2 100  √  null Person creating the record
CREATOR_DATE date 7  √  null Date record created
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
REC_ID number 0  √  null
TOW_COST number 0  √  null Tow Cost

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"CRASH_ID" IS NOT NULL CRASHTOW_CRASH_ID_NN
"CRASH_TOW_ID" IS NOT NULL CRASHTOW_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
CRASH_TOW_ID Primary key Asc CRASHTOW_PK
CRASH_ID Performance Asc CRASHTOW_CRASH_FK_I
STATE_CD_STATE_CODE_TYPE + STATE_CD_STATE_CODE Performance Asc/Asc CRASHTOW_EJSCD_STATE_FK_I
TOWING_CO_ID Performance Asc CRASHTOW_TCC_FK_I

Close relationships  within of separation: