Voir la source de Advanced Database Information

{{Tuto Details
|Description=<translate>Data contained in the winmulti version 6 SQLite databases</translate>
|Categories=Software
|Tags=SQLite, Useage.db3, remakes
}}
<translate>{{Warning|...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}}<br />

=..\_machine\Useage.db3 Database=
A database is produced called useage.db3 containing all data for work that has passed through the machine<syntaxhighlight>
Location:
..masterdir..\_machine\useage.db3
..masterdir.. is normally c:\ddrive\
</syntaxhighlight>



'''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=
<syntaxhighlight>
Location:
..masterdir..\_machine\diagnostic\diagnostic.db3
..masterdir.. is normally c:\ddrive\
</syntaxhighlight><br />

=='''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'''==
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''' -==
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'''==
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'''==
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
|SourceLanguage=none
|IsTranslation=0
}}
{{AddComments}}
{{Tuto Status
|Complete=Draft
}}