Hey Jim good to see you again!
so let me add a few things to this,
This is more or less a proof of concept project not a production one, its purpose is to see if a tracking system like this is even viable for our environment. If this project does deem viable our software dev team would take this rough draft and mold/tweek it to fit their guidelines for trademarking and all the legal mumbo jumbo … all i am tasked with is getting some sort of rough/ugly beta test online no matter how it looks as long as its easy and streamlined to use.
Speaking of environment, let me explain a bit more about how this would be used. I work in the IT dept of a major distribution warehouse, here we have several different job types that use RF scanners to pick product for shipping and cycle product coming in and other jobs but i’m sure you get the point. as such our employees are hired for 1 position (job type) and that is all they do. so the many to many idea is not an important aspect of this as if someone was to move positions we could just go into the db and change their job id.
The equipment used here … there are only 3 major types of RF equipment that we need to track Tablets, Handheld and Wearable. The Wearable has a separate accessory that would need to be tracked with it as well and is the only one that has an “add on” so to speak and that is the Ring Scanner (rsid). Now the Job function will determine what type of device you are going to use, so picker would get a handheld and stocker a wearable/ring scanners ect …
now as for the use of this it will be loaded on a kiosk machine that only allows access to a single webpage. On that page would be 1 input field and a check in/out button. A user would enter their Team Member ID (JJones, G3219543) by scanning their badge (no keyboard will be connected to this machine) and click the button, then a box would popup giving them a RANDOM Locker Number and Combo to the correct piece of equipment for the job type assigned to them in the database. after they are done for the day they would then go back to the kiosk and scan their badge again and click the button this time the script would see that the user already checked out something and would check it in giving them a random empty locker and combo to put the equipment into. I may add scanning a barcode of the equipment’s asset tag id (hwid) when checking in. Now keep in mind there are several shifts of employees as this is a 24/7 operation and the same piece of equipment may be used/checked out 2-3 times a day as long as it was checked back in.
Now with all that said i also need it to store all the check ins/outs as we would need to have the ability to pull past data incase something is lost or damaged beyond repair we would have to look to see who was the last 1-20 users of the device.
I hope this cleared everything up.