Database structure
From PhotoVoltaic Logger new generation
Contents
Abstract
pvlng_type
pvlng_channel
pvlng_tree
The channel tree is organized in a nested set structure.
The nested set model is a particular technique for representing nested sets (also known as trees or hierarchies) in relational databases. -- Wikipedia:Nested set model
More theory about nested sets.
pvlng_reading_num / pvlng_reading_str
The timestamps are not stored as "normal" timestamp type, but as unsigned integer.
It was tested and have significant more performance for consolidated data readouts.
