In order to establish a more consistent and traceable system for the management of SITTV equipment, a new system shall be put into place in order to ease the administration of operations.
The lack of a proper equipment management system has needlessly tasked members, and made operations difficult.
The system in question should be similar to library self check-out/in system. Verified users will be able to login with their username/production, scan the items needed for the production, and log their usage.
- List of user names and cwid's
- List of productions
- Barcode, name (and possibly pictures)
- Ability to keep track of who has what privileges.
- Ability to login by name/cwid pair
- Ability to sign in by production
- Autogeneration of forms
- Automatic return (regardless of user login)
- Ability to check out who/which productions are in possession of what equipment.
- Usage statistics based on logs (what equipment is used by most, by whom, etc.)
- Bookie Bot the bot that comes after you if you don't return what you owe
- Slack bot for overdue item notifications
- Contacts necessary parties (user, producer, director of operations, etc.)
- Containerize the database (most likely using Docker)
- Use a standard scripting language such as Python or NodeJS.
- Integration of a card-swipe system to expedite login on the touch screen.
- Item entry by barcode and calendar selector (for date-until).
| Component | Tool |
|---|---|
| Database | MongoDB, Redis |
| Language | Python |
| Web Framework | Flask |
| Containerization | Docker |
| Field | Type |
|---|---|
| Name | string |
| Username/email | string |
| CWID | int64 |
| Productions | list of string |
| Field | Type |
|---|---|
| Name | string |
| Barcode | int64 |
| Checkout | Checkout |
| Field | Type |
|---|---|
| Who | user name (string) |
| Production | string |
| Checkout Date | date |
| Until When | date |