Advanced Database Information

Data contained in the winmulti version 6 SQLite databases

SQLite, Useage.db3, remakes

...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

..\_machine\diagnostic\diagnostic.db3

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

Alarm Log

logs every alarm that is triggered

Odometer

under development

Production Reports -

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

runningMH

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

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

runningSaw

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

timings

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

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

en none 0

Draft