The live table is used to store incoming observations. Please note that only a subset of all columns is shown in the table below. The script processing the observations and saving them into this database table automatically creates additional columns if there are data. ... in the table indicate the data columns (e.g,. temperature observations, cloud cover observations, ...).
The live table is a rolling database containing the latest observations for all incoming stations. This is a rolling database, older observations are deleted from time to time whereof the data for some selected stations are moved into the archive <table-archive> database table.
The archive table has the same structure as the live <table-live> database table and contains long-term archive data for a set of specified stations. We keep the data for the tournament stations and drop all others as we don't want to keep a copy of all observations (would be a huge database and an unnecessary and unused copy of everything).
The script Observations.py <script-Observations> is reading the observations from the live <table-live> database table and :pyprepares <getobs.getobs.prepare> the observations as they will be used for the ranking. These observations are stored in this table used by the Wetterturnier Wordpress Plugin plugin to display the latest observations and by Persistenz.py <script-Persistenz> to submit the Persistence reference forecast.