[version en cours de rédaction]

Version actuelle datée du 30 juin 2022 à 10:13

Data contained in the winmulti version 6 SQLite databases

Auteur Gareth Green | Dernière modification 30/06/2022 par Gareth Green en cours de rédaction ⧼frevu-button-review-label⧽

Pas encore d'image

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

Commentaires

Draft

@@ Ligne 17 : / Ligne 17 : @@
 '''Database Structure'''{{#annotatedImageLight:Fichier:Advanced Database Information Image.png|0=800px|hash=|jsondata=|mediaClass=Image|type=frameless|align=center|src=https://stuga.dokit.app/images/f/fb/Advanced_Database_Information_Image.png|href=./Fichier:Advanced Database Information Image.png|resource=./Fichier:Advanced Database Information Image.png|caption=|size=800px}}
-= ..\_machine\diagnostic\diagnostic.db3 =
+=..\_machine\diagnostic\diagnostic.db3=
 <syntaxhighlight>
 Location:
@@ Ligne 24 : / Ligne 24 : @@
 </syntaxhighlight><br />
-== Alarm Log ==
+=='''Alarm Log'''==
 logs every alarm that is triggered{{#annotatedImageLight:Fichier:Advanced Database Information Image 1.png|0=800px|hash=|jsondata=|mediaClass=Image|type=frameless|align=center|src=https://stuga.dokit.app/images/a/a0/Advanced_Database_Information_Image_1.png|href=./Fichier:Advanced Database Information Image 1.png|resource=./Fichier:Advanced Database Information Image 1.png|caption=|size=800px}}
-== '''Odometer''' ==
+=='''Odometer'''==
 under development{{#annotatedImageLight:Fichier:Advanced Database Information Image 2.png|0=800px|hash=|jsondata=|mediaClass=Image|type=frameless|align=center|src=https://stuga.dokit.app/images/8/8a/Advanced_Database_Information_Image_2.png|href=./Fichier:Advanced Database Information Image 2.png|resource=./Fichier:Advanced Database Information Image 2.png|caption=|size=800px}}<br />
-== '''Production Reports''' - ==
+=='''Production Reports''' -==
 Log of each report sent to the production email address with the totals of the daily production values{{#annotatedImageLight:Fichier:Advanced Database Information Image 3.png|0=800px|hash=|jsondata=|mediaClass=Image|type=frameless|align=center|src=https://stuga.dokit.app/images/e/ed/Advanced_Database_Information_Image_3.png|href=./Fichier:Advanced Database Information Image 3.png|resource=./Fichier:Advanced Database Information Image 3.png|caption=|size=800px}}<br />
-== '''runningMH''' ==
+=='''runningMH'''==
 Log of each minute of running detailing how many seconds in that minute the machine was running, idle or waiting for an operator.{{#annotatedImageLight:Fichier:Advanced Database Information Image 4.png|0=800px|hash=|jsondata=|mediaClass=Image|type=frameless|align=center|src=https://stuga.dokit.app/images/a/a8/Advanced_Database_Information_Image_4.png|href=./Fichier:Advanced Database Information Image 4.png|resource=./Fichier:Advanced Database Information Image 4.png|caption=|size=800px}}<br />
-== '''runningMHArchive''' ==
+=='''runningMHArchive'''==
-<br /></translate>
+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{{#annotatedImageLight:Fichier:Advanced Database Information Image 5.png|0=800px|hash=|jsondata=|mediaClass=Image|type=frameless|align=center|src=https://stuga.dokit.app/images/a/aa/Advanced_Database_Information_Image_5.png|href=./Fichier:Advanced Database Information Image 5.png|resource=./Fichier:Advanced Database Information Image 5.png|caption=|size=800px}}
+=='''runningSaw'''==
+This is the same data as runningMH but for the saw side of a 2-side machine. It is not used in calculation{{#annotatedImageLight:Fichier:Advanced Database Information Image 6.png|0=800px|hash=|jsondata=|mediaClass=Image|type=frameless|align=center|src=https://stuga.dokit.app/images/d/d6/Advanced_Database_Information_Image_6.png|href=./Fichier:Advanced Database Information Image 6.png|resource=./Fichier:Advanced Database Information Image 6.png|caption=|size=800px}}
+=='''timings'''==
+Log of the time taken for each operation macro on each profile. Used to calculate batch time predictions.{{#annotatedImageLight:Fichier:Advanced Database Information Image 7.png|0=800px|hash=|jsondata=|mediaClass=Image|type=frameless|align=center|src=https://stuga.dokit.app/images/0/07/Advanced_Database_Information_Image_7.png|href=./Fichier:Advanced Database Information Image 7.png|resource=./Fichier:Advanced Database Information Image 7.png|caption=|size=800px}}
+=='''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{{#annotatedImageLight:Fichier:Advanced Database Information Image 8.png|0=800px|hash=|jsondata=|mediaClass=Image|type=frameless|align=center|src=https://stuga.dokit.app/images/a/a8/Advanced_Database_Information_Image_8.png|href=./Fichier:Advanced Database Information Image 8.png|resource=./Fichier:Advanced Database Information Image 8.png|caption=|size=800px}}<br /></translate>
 {{PageLang
 |Language=en

Advanced Database Information : Différence entre versions