Database structure

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 difference between the reading tables is only the data format for reading values.

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.

pvlng_babelkit

Here are stored all translations for the web frontend based on the "BabelKit - Multilingual Code Description Lookup Table" project.