wiki:BluePrint/Vehicle/Projectmanagement

Version 15 (modified by cliftonsis, 11 years ago) ( diff )

--

Introduction

Vehicle maintenance can be hard to keep track of with a large group of vehicles.

Description

System to keep track of the type of maintenance, the date it was performed, and a parts inventory for on site locations.

Requirements

Database for parts inventory:

  • [Engine oil]
  • [Oil filters]
  • [Air filters]
  • [Spark plugs]
  • [Transmission fluid]
  • [Axle fluid]
  • [Engine Coolant]
  • [Brakes]
  • [Tires]

Database for maintenance:

  • [VIN number]
  • [Maintenance date]
  • [Work performed]
  • [Parts used]
  • [Mechanic]

Database for vehicles:

  • [Make]
  • [Model]
  • [Manufacture date]
  • [VIN number]
  • [License plate]
  • [Color]
  • [Type]

Use-Cases

http://i290.photobucket.com/albums/ll251/p455w0rd/Untitled_zpse163c2e2.jpg

Design

http://i290.photobucket.com/albums/ll251/p455w0rd/VehicleManagement1_zpsc3a06d29.jpg

Implementation

http://i290.photobucket.com/albums/ll251/p455w0rd/TableStructures_zps5d54df4d.jpg

http://i290.photobucket.com/albums/ll251/p455w0rd/TableStructures2_zps4d815f11.jpg

http://i290.photobucket.com/albums/ll251/p455w0rd/TableStructures3_zps77ea04d7.jpg

Wall Chart 1 http://i290.photobucket.com/albums/ll251/p455w0rd/Wallchart_zps050d0aa1.jpg

Wall Chart 2 http://i290.photobucket.com/albums/ll251/p455w0rd/Wallchart2_zps7e1299a0.jpg

http://i290.photobucket.com/albums/ll251/p455w0rd/frmMainMenu_zpsef864a48.jpg

http://i290.photobucket.com/albums/ll251/p455w0rd/frmVINInfo_zps09b486c7.jpg

http://i290.photobucket.com/albums/ll251/p455w0rd/frmEngineCapacities_zps467de65c.jpg

http://i290.photobucket.com/albums/ll251/p455w0rd/frmSevereSchedule_zps618b1284.jpg

http://i290.photobucket.com/albums/ll251/p455w0rd/frmPartsInventory_zpsc75260a0.jpg

http://i290.photobucket.com/albums/ll251/p455w0rd/frmWorkOrder_zpsc9be1547.jpg

References

Notes

Youtube Video http://www.youtube.com/watch?v=52ynWZ25iR0&feature=youtu.be

Note: See TracWiki for help on using the wiki.