Table slot9.WORLD.TSTA.DV_STORAGE_LOCATIONS
This table stores storage location associations to 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
STORAGE_LOCATION_ID number 0 Unique identifier for storage location association
VEHICLE_ID number 0
DEPARTMENT_VEHICLES.VEHICLE_ID DVLOC_DV_FK R
Department vehicle id
VEH_LOC_CODE varchar2 30  √  null
EJS_CODES.CODE DVLOC_EJSCD_LOC_FK R
EJS Code for storage location
VEH_LOC_CODE_TYPE varchar2 30  √  'VEHICLE_STORAGE_CODES'
EJS_CODES.CODE_TYPE DVLOC_EJSCD_LOC_FK R
EJS Code Type for storage location
START_DATE date 7  √  null Date/time storage location assocation start
END_DATE date 7  √  null Date/time storage location assocation end
COMMENTS varchar2 255  √  null Comment for storage location assocation
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

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"STORAGE_LOCATION_ID" IS NOT NULL DVLOC_ID_NN
"VEHICLE_ID" IS NOT NULL DVLOC_VEHICLE_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
STORAGE_LOCATION_ID Primary key Asc DVLOC_PK
VEHICLE_ID Performance Asc DVLOC_DV_FK_I
VEH_LOC_CODE_TYPE + VEH_LOC_CODE Performance Asc/Asc DVLOC_EJSCD_LOC_FK_I
END_DATE Performance Asc DVLOC_ENDDATE_I
START_DATE Performance Asc DVLOC_STARTDATE_I

Close relationships  within of separation: