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

After a complete day, the runningMH data is compressed and summed into in 15 minute intervals. This process happens when the front end winMulti is run from the desktop - all previous days are archived. The archve data is used to create the daily calculations

Advanced Database Information Image 5.png

runningSaw

This is the same data as runningMH but for the saw side of a 2-side machine. It is not used in calculation

Advanced Database Information Image 6.png

timings

Log of the time taken for each operation macro on each profile. Used to calculate batch time predictions.

Advanced Database Information Image 7.png

timingsArchive

Archive of the timings data. This process happens when the front end winMulti is run from the desktop - all previous days are archived. The archve data is used to create the daily calculations

Advanced Database Information Image 8.png


Commentaires

Draft