Requirements solicitation and RFC

[tpoomlmly]

Blocked by database design

[tpoomlmly]

I made a (partial) list of who might want to do what and why

• Society member - add new items to the inventory - keep track of them
• Society member - see what items we have - plan events + work out what more to get
• Society member - generate new asset codes automatically - avoid using the old + "temporary" tools
• Society member - print (or get PDFs of) asset labels - avoid having to use external label making software
• Society member - find items by name, location, asset code - look stuff up without having to know all details
• Society member - find a single item by asset code - scan a QR code on an asset label + see all its details
• Society member - scan QR codes by webcam - look stuff up by scanning even without a handheld scanner
• Society member - add items without an asset tag - track consumable stuff
• Technical officer/president - manage who has read/write access - stop unwanted people messing with the database
• Technical officer - keep an audit log - know who changed what + when
• Technical officer - undo others' unwanted database changes - remedy wayward behaviour
• Society member - undo own unwanted actions - accidents happen
• Society member - edit how much of a consumable we have - update the system when we use or buy stuff
• Society member - know + set if an item is lost, broken or gone - find it, fix it or mourn it
• Society member - mark items whose status doesn't correspond with the inventory - let others know that the inventory system is wrong without having to locate the item straight away
• Society member - know where items are - find them
  • Location attribute
• Society member - know where items should be - put them back where they go
  • Name of container that fits best
• Society member - see when an item was last known about - check up on it, make sure it's still there, update the inventory accordingly
• Society member - find all the items of the same/similar type - count how much of a particular thing we have
• Society member - exclude damaged/lost etc. items when searching - count only the good ones when sorting the others out isn't practical

[tpoomlmly]

• Society member - find out what items are in a particular RUB/location - know where things are supposed to be