Parts Management System

From Wiki
Jump to navigationJump to search

Overview

What I want in a parts management system:

  • Web based (apache/mysql preferable)
  • Easily add/update parts counts
  • Features
    • Scan barcode on product, pull up data if exists
    • Determine what projects use a given part
    • Project bill of materials (BOM)
    • Search for part on part number, keyword, etc
    • Determine if enough parts on-hand to build a project


  • Parts fields
    • Description
    • Wren Industries part number
    • Footprint (TO-92, 0603, etc)
    • Value (10K, .01uf, etc)
    • Quantity on-hand
    • List of suppliers
    • Tags (resistor, cpu, etc)
    • Photograph (URL)
    • CAD footprint name
    • Free-form notes fields
    • Purchase lots
      • Manufacturers part number
      • Manufacturer
      • Supplier (Digikey, Mouser, Microchip, etc)
      • Supplier part number
      • Link to supplier datasheet
      • Date purchased
      • Quantity purchased
      • Cost (paid or sample)
      • Barcode
      • Location (bin #, shelf, etc)


  • Project fields:
    • Name
    • Start date
    • End date
    • Website
    • Database (Z80.ddb, etc)
    • Status (complete, schematics, boards, etc)
    • Notes
    • List of parts used

Software

Sections

  • User manager (add/edit/delete)
  • Supplier manager (view/add/edit/delete)
  • Project manager (view/add/edit/delete/report)
  • Parts manager (view/add/edit/delete/report)

Misc Notes

  • Referenced items can't be deleted (i.e., cannot delete part X if a project is using part X)
  • User classes are:
    • Admin - do anything
    • Engineer - add/edit/delete suppliers, projects and parts
    • Guest - view suppliers, projects and parts