Parts Management System

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

• Uses Catalyst
• Initial version uses SQLite, full version uses mySQL
• Forms are implemented using FormFu

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