Is it possible to create a mini ERP with NR?
I'm planning to use 3 tablets to access node-red hosted on 1 pc.Each tablet is used as data entry for a single machine and requires a different login to access the dashboard. Mysql database is stored on the pc. The ERP functions as follows:
(1)A user can send recipe/work order from the pc to each machine.
(2)users can login from the tablet to see the work order for respective machine and key in details such as breakdowns, start time, finish time, output, scrap, etc
(3) All data is then stored on the mysql database which management can retrieve data from.
(4) Live update of each machine can also be seen such as daily output, scrap, OEE, breakdown records etc.
Appreciate inputs and feedback on this. Thanks