Difference between revisions of "Inventory Database"
From Makers Local 256
m (→Future Enchancements: fixed category tags. again.) |
Spacefelix (Talk | contribs) m (Added Webcam) |
||
| Line 23: | Line 23: | ||
== Future Enchancements == | == Future Enchancements == | ||
* Ability to scan barcodes and add to the database | * Ability to scan barcodes and add to the database | ||
| − | + | * Take a picture with a webcam/upload pictures - May allow QR Code use as an alternative to barcoding | |
Revision as of 12:30, 28 January 2010
|
Creator: |
Overview
We've been throwing this idea around for a while. I've got a license (and experience) with PhpRunner it wouldn't be hard to whip up a prototype and have it functional on the website / kiosk within an hour or three.
Database Fields
- Item Name (Baseball Bat)
- Item Physical Description (it's about 3 feet long, brown, and looks like a bat)
- Item Functional Description (you hit baseballs with it)
- Date Donated (March 23rd, 2010)
- Person who Donated (Babe Ruth)
- Item's Estimated Value (could help treasurer determine a value of the item) ($20)
- Treasurer's Established Value (could be useful if we ever have to make an insurance claim) ($1,500)
- Where in the Shop the item is stored (Let's people know where to look, and hopefully where to put back) (In the back corner of the library)
- Item Serial Number (unique ID for tracking shop property)
- Loaned / Donated Boolean (to establish whether the shop owns this piece of tracked property)
Future Enchancements
- Ability to scan barcodes and add to the database
- Take a picture with a webcam/upload pictures - May allow QR Code use as an alternative to barcoding
