Table slot9.WORLD.TSTA.TOWS
This table stores tow information added to a vehicle 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
VEH_VEHICLE_ID number 0
IMPOUND.VEHICLE_ID IMPD_TOW_FK R
TOW_REASONS.VEH_VEHICLE_ID TOWRSN_TOW_FK R
VEHICLES.VEHICLE_ID TOW_VEH_FK C
Vehicle ID number
TOWING_CO varchar2 40  √  null Name of towing company
CITY_CD_CITY_CODE varchar2 30  √  null
EJS_CODES.CODE TOW_CITY_CD_CITY_C_EJS_CODE_FK R
City/Unincorp. code (I-UCR)
STATE_CD_STATE_CODE varchar2 30  √  null
EJS_CODES.CODE TOW_STATE_CD_STATE_EJS_CODE_FK R
State code designator
TCC_TOWING_CO_NAME varchar2 40  √  null
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
TEXT varchar2 255  √  null Towing tex
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
TOW_SEQ number 0
IMPOUND.TOW_SEQ IMPD_TOW_FK R
TOW_REASONS.TOW_SEQ TOWRSN_TOW_FK R
Towing - Vehicle Sequence
SLIP_NUMBER varchar2 20  √  null Number on tow slip
DRIVER varchar2 80  √  null Tow truck driver
CITY_CD_CITY_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE TOW_CITY_CD_CITY_C_EJS_CODE_FK R
STATE_CD_STATE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE TOW_STATE_CD_STATE_EJS_CODE_FK R
REC_ID number 0  √  null
TOW_DATE date 7  √  null
TOWING_CO_ID number 0  √  null
TOW_COMPANY_CODES.TOWING_CO_ID TOW_TCC_FK R
AUTH_OFF_ID number 38  √  null
OFFICERS.OFFICER_ID TOW_OFF1_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"TOW_SEQ" IS NOT NULL TOW_TOW_SEQ_NN
"VEH_VEHICLE_ID" IS NOT NULL TOW_VEH_VEHICLE_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
VEH_VEHICLE_ID + TOW_SEQ Primary key Asc/Asc TOW_PK
CITY_CD_CITY_CODE_TYPE + CITY_CD_CITY_CODE Performance Asc/Asc TOW_CITY_CD_CITY_C_EJS_CODE_I
CITY_CD_CITY_CODE Performance Asc TOW_CITY_CD_FK_I
AUTH_OFF_ID Performance Asc TOW_OFF1_FK_I
STATE_CD_STATE_CODE Performance Asc TOW_STATE_CD_FK_I
STATE_CD_STATE_CODE_TYPE + STATE_CD_STATE_CODE Performance Asc/Asc TOW_STATE_CD_STATE_EJS_CODE_I
TOWING_CO_ID Performance Asc TOW_TCC_FK_I
VEH_VEHICLE_ID Performance Asc TOW_VEH_FK_I

Close relationships  within of separation: