Ok I see that the "archive" table is the master I would expect to see but am confused as to how/why all the other tables are created. Are they derived and updated from the archive table with individual update queries that run each time the archive table has a record added?
If something in the archive table is manipulated manually will it be reflected in the archive sub tables or do they have to be modified / updated manually as well? If data from the archive table was way out of range for some maintenance procedure reason on the senors would deleting those records manually need to be done to each of the sub tables as well? Are the subtables created as child recordsets of the main archive table in order to allow some generated reports to access data more quickly ? Why do those reports just not run specific queries for that specific data selecting from the main table rather than creating extra separate tables? On Fri, 2018-10-12 at 16:55 -0700, Thomas Keffer wrote: > Did you check out the section The database in the Customizing Guide? > Take a look, then come back with any questions you might have. > > -tk > > On Fri, Oct 12, 2018 at 4:31 PM CCOR58 <cattlecountryra...@gmail.com> > wrote: > > Is there any big picture tech descriptives about the tables in the > > weewx archive database? > > > > I connect to the mysql database using LibreOffice-base as well as > > phpmyadmin and I see a large number of tables but each table seems > > to > > only have two columns usually. > > > > I would like to create custom reports using libreOffice base but I > > need > > to get a better handle on what I am seeing. > > > > Usually I would expect to find a table with single record > > containing > > multiple fields each holding the latest data collected from the > > sensors > > at aspecified sample date and time. > > > > The weewx database appears to be set up under a different paradigm > > I > > fail to grasp. > > > > If there is any place that has refinfo that would help me > > understand > > what was used to design the database I would appreciate it. > > > > Thanks > > Andy > > -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
