sde1000
commented
2 years ago Perhaps better to have a barcodes table with references to stock types and PLUs; a check can then be used to ensure a single barcode can't refer to both a stock type and a PLU.
How would barcode support work?
From a hardware point of view: most barcode scanners pretend to be keyboards. Some can also be switched into other modes: serial port (either over USB or Bluetooth), or "HID POS" using HID usage table 0x8c. These other modes may support features like flashing the light on the scanner red or green depending on whether the item was known, etc.