Personal tools

Database structure

From PhotoVoltaic Logger new generation

Revision as of 15:29, 2 March 2014 by KKoPV (talk | contribs)
Jump to: navigation, search

Abstract

pvlng_type

DBTableType.png

pvlng_channel

DBTableChannel.png

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.

DBTableTree.png

pvlng_reading_num / pvlng_reading_str

DBTableReadingNum.pngDBTableReadingStr.png