Skip to content

Latest commit

 

History

History
55 lines (42 loc) · 2.13 KB

README.md

File metadata and controls

55 lines (42 loc) · 2.13 KB

Automation & Robotics Club @ BPHC

SIMS - Smart Inventory Management System

Introduction

This is the inventory management system of the Automation & Robotics Club of BITS Pilani Hyderabad Campus. All the code is in Python 3 and PyQt5 with several autogenerated lines of code from QtCreator .ui files.

This application runs on a Raspberry Pi 3 connected to an 8" 1280x800 touchscreen. Combined with an upcoming Smart Lock project, this will make the management of inventory in small labs much easier.

Installation

On Ubuntu or derivative distros, simply run:

sudo apt install pyqt5-dev pyqt5-dev-tools python-sqlite python3-serial python3-crypto

Then, run the file using:

./main.py

Database

Users

ID Name Email ID Phone call Phone whatsapp Room no. Salt Hashed Password Fingerprint ID Is Admin
  • This table consists of all the registered users and their relevent information.
  • The Is Admin field determines whether a particular user has access to the admin functions.
  • Here ID is a primary key.

Transactions

ID Name Item ID Quantity Issue Datetime Withdraw Datetime Return Datetime
  • This table is used to manaage all the withdran items from the inventory.
  • A particular entry will be moved to the History table after the item is returned.
  • Here ID is a foreign key.

History

ID Name Item ID Quantity Issue Datetime Withdraw Datetime Return Datetime
  • this table has the details of all the transactions that have occurred previously.
  • Here ID is a foreign key.

Inventory

Item ID Name RFID Shelf no. Box no. Catagory Quantity Description
  • This table consists of all list of Items present in the inventory along with their location and quantity.
  • Here Item ID is a primary key.

Purchase

ID Project Price Item Date
  • This table is used to record all the purchase requests from the users.
  • Here ID is a foreign key.