Advanced Database Information

Auteur avatarGareth Green | Dernière modification 30/06/2022 par Gareth Green en cours de rédaction

...All .db3 databases are live data and use a very simple SQLite structure. They are not designed for advanced sharing and should be treated as read only. A copy of the database should be made before running any queries


..\_machine\Useage.db3 Database

A database is produced called useage.db3 containing all data for work that has passed through the machine

Location:
..masterdir..\_machine\useage.db3
..masterdir.. is normally c:\ddrive\


Database Structure

Advanced Database Information Image.png

..\_machine\diagnostic\diagnostic.db3

Location:
..masterdir..\_machine\diagnostic\diagnostic.db3
..masterdir.. is normally c:\ddrive\


Alarm Log

logs every alarm that is triggered

Advanced Database Information Image 1.png

Odometer

under development

Advanced Database Information Image 2.png


Production Reports -

Log of each report sent to the production email address with the totals of the daily production values

Advanced Database Information Image 3.png


runningMH

Log of each minute of running detailing how many seconds in that minute the machine was running, idle or waiting for an operator.

Advanced Database Information Image 4.png


runningMHArchive


Commentaires

Draft