Table slot9.WORLD.TSTA.TOW_COMPANY_CODES
This table stores the tow company information for a tow 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
TOWING_CO_NAME varchar2 40
PHONE_AREA varchar2 3  √  null Towing phone area code
PHONE_PREFIX varchar2 3  √  null Towing phone prefix
PHONE_SUFFIX varchar2 4  √  null Towing phone suffix
TOWING_CO_STREET varchar2 40  √  null Towing company street
TOWING_CO_ZIP varchar2 5  √  null Towing company zip
TOWING_CO_CITY varchar2 40  √  null Towing compnay City
TOWING_CO_STATE varchar2 30  √  null
EJS_CODES.CODE TCC_TOWING_CO_STAT_EJS_CODE_FK R
State code designator
CREATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
UPDATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
CREATOR_DATE date 7  √  null Date record was created
UPDATOR_DATE date 7  √  null Date record was updated
TOWING_CO_STATE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE TCC_TOWING_CO_STAT_EJS_CODE_FK R
REC_ID number 0  √  null
TOWING_CO_ID number 0
ARRESTS.TOWING_CO_ID ARR_TCC_FK R
DV_CRASH_TOWS.TOWING_CO_ID CRASHTOW_TCC_FK R
JS_FIELD_ARREST_CHARGE_VW.TOWING_CO_ID Implied Constraint R
JS_FIELD_ARREST_VW.TOWING_CO_ID Implied Constraint R
JS_VEHICLE_TOW_IMPOUND_VW.TOWING_CO_ID Implied Constraint R
TOWS.TOWING_CO_ID TOW_TCC_FK R
ZZ_TOW_COMPANY_CODES.TOWING_CO_ID Implied Constraint R
ZZC1_TOW_COMPANY_CODES.TOWING_CO_ID Implied Constraint R
ZZV1_TOW_COMPANY_CODES.TOWING_CO_ID Implied Constraint R
COUNTY_CODE varchar2 30  √  null
EJS_CODES.CODE TCC_COUNTY_CODE_EJS_CODE_FK R
COUNTY_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE TCC_COUNTY_CODE_EJS_CODE_FK R
ACTIVE_FLAG varchar2 1  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"TOWING_CO_ID" IS NOT NULL TCC_TOWING_CO_ID_NN
"TOWING_CO_NAME" IS NOT NULL TCC_TOWING_CO_NAME_NN

Indexes:
Column(s) Type Sort Constraint Name
TOWING_CO_ID Primary key Asc TCC_PK
COUNTY_CODE_TYPE + COUNTY_CODE Performance Asc/Asc TCC_COUNTY_CODE_EJS_CODE_I
TOWING_CO_STATE Performance Asc TCC_STATE_CD_FK_I
TOWING_CO_STATE_TYPE + TOWING_CO_STATE Performance Asc/Asc TCC_TOWING_CO_STAT_EJS_CODE_I

Close relationships  within of separation: