Table slot9.WORLD.TSTA.DV_SERVICE_RECORDS
This table stores service/maintanence records on department vehicles
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
SERVICE_ID number 0
DV_CRASH_SERVICE_RECORDS_VW.SERVICE_ID Implied Constraint R
DV_CRASH_SERVICE_REPAIRS_VW.SERVICE_ID Implied Constraint R
DV_SERVICE_ATTACHMENTS.SERVICE_ID DVSERATT_DVSERV_FK R
DV_SERVICE_IMAGES.SERVICE_ID DVSERIMA_DVSERV_FK R
DV_SERVICE_REPAIRS.SERVICE_ID DVREPAIR_DVSERV_FK R
DV_SERVICE_REQUEST.SERVICE_ID DVREQST_DVSERV_FK R
Unique identifier for service record
VEHICLE_ID number 0
DEPARTMENT_VEHICLES.VEHICLE_ID DVSERV_DV_FK R
Department vehicle id
MILEAGE number 0  √  null Current mileage
START_DATE date 7  √  null Service start date/time
END_DATE date 7  √  null Service end date/time
VENDOR varchar2 100  √  null Service vendor (free text)
VENDOR_ID number 0  √  null
ITEM_VENDORS.VENDOR_ID DVSERV_ITVD_FK R
Service vendor id (fk to ITEM_VENDORS)
TECHNICIAN varchar2 100  √  null Service technician
INVOICE_NUMBER varchar2 100  √  null Service invoice number
HOURS_DOWN number 0  √  null Hours vehicle is out of commision
COMPLETION_DATE date 7  √  null Estimated service completion date
COMMENTS varchar2 255  √  null Service comments
SERVICE_COST number 0  √  null Service cost
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
REC_ID number 0  √  null
CRASH_ID number 0  √  null
DV_CRASHES.CRASH_ID DVSERV_CRASH_FK R
Department crash id FK
ESTIMATED_COST number 0  √  null
SUPPLEMENTAL_COST number 0  √  null
RESET_INTERVAL_FLAG varchar2 1  √  'Y'

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"SERVICE_ID" IS NOT NULL DVSERV_ID_NN
"VEHICLE_ID" IS NOT NULL DVSERV_VEH_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
SERVICE_ID Primary key Asc DVSERV_PK
CRASH_ID Performance Asc DVSERV_CRASH_FK_I
VEHICLE_ID Performance Asc DVSERV_DV_FK_I
VENDOR_ID Performance Asc DVSERV_ITVD_FK_I

Close relationships  within of separation: