Difference between revisions of "Inventory Database"
From Makers Local 256
(added page for collaborating on an inventory database) |
(added potential fields) |
||
| Line 8: | Line 8: | ||
We've been throwing this idea around for a while. | We've been throwing this idea around for a while. | ||
I've got a license (and experience) with [http://www.xlinesoft.com/phprunner/ PhpRunner] it wouldn't be hard to whip up a prototype and have it functional on the website / kiosk within an hour or three. | I've got a license (and experience) with [http://www.xlinesoft.com/phprunner/ 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 == | == Future Enchancements == | ||
Revision as of 11:07, 6 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
