Table slot9.WORLD.TSTA.DV_SERVICE_REQUEST
This table stores service request records for a department vehicle
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
REQUEST_ID number 0
DV_REQUEST_ATTACHMENTS.REQUEST_ID DVREQATT_DVREQST_FK R
DV_REQUEST_IMAGES.REQUEST_ID DVREQIMA_DVREQST_FK R
EXTERNAL_INFO_REQUESTS.REQUEST_ID Implied Constraint R
FLEET_DASHBOARD_SERVICE_VW.REQUEST_ID Implied Constraint R
Unique identifier for service request record
VEHICLE_ID number 0
DEPARTMENT_VEHICLES.VEHICLE_ID DVREQST_DV_FK R
Department vehicle associated to the request
REQUEST_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE DVREQST_EJSCD_TYPE_FK R
EJS Code for request type
REQUEST_TYPE_CODE_TYPE varchar2 30  √  'VEHICLE_REQUEST_TYPES'
EJS_CODES.CODE_TYPE DVREQST_EJSCD_TYPE_FK R
EJS Code Type for request type
REQUEST_LOGIN_ID varchar2 100  √  null
IJIS_USER_PROFILES.LOGIN_ID DVREQST_IUP_REQ_FK R
Officer user ID who made the request
REQUEST_DATE date 7  √  null Date/time of request
REVIEW_LOGIN_ID varchar2 100  √  null
IJIS_USER_PROFILES.LOGIN_ID DVREQST_IUP_REV_FK R
Officer user ID who reviewed the request
REVIEW_DATE date 7  √  null Date/time reviewed
DESCRIPTION varchar2 255  √  null Free text request description
STATUS_CODE varchar2 30  √  null
EJS_CODES.CODE DVREQST_EJSCD_STAT_FK R
EJS Code for request status
STATUS_CODE_TYPE varchar2 30  √  'VEHICLE_REQUEST_STATUS_CODES'
EJS_CODES.CODE_TYPE DVREQST_EJSCD_STAT_FK R
EJS Code Type for request status
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
SERVICE_ID number 0  √  null
DV_SERVICE_RECORDS.SERVICE_ID DVREQST_DVSERV_FK R
Associated service/maintenace record resolving the request

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"REQUEST_ID" IS NOT NULL DVREQST_ID_NN
"VEHICLE_ID" IS NOT NULL DVREQST_VEHICLE_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
REQUEST_ID Primary key Asc DVREQST_PK
VEHICLE_ID Performance Asc DVREQST_DV_FK_I
SERVICE_ID Performance Asc DVREQST_DVSERV_FK_I
STATUS_CODE_TYPE + STATUS_CODE Performance Asc/Asc DVREQST_EJSCD_STAT_FK_I
REQUEST_TYPE_CODE_TYPE + REQUEST_TYPE_CODE Performance Asc/Asc DVREQST_EJSCD_TYPE_FK_I
REQUEST_LOGIN_ID Performance Asc DVREQST_IUP_REQ_FK_I
REVIEW_LOGIN_ID Performance Asc DVREQST_IUP_REV_FK_I

Close relationships  within of separation: