Introduce separate table for sensor meta data
Move all sensor meta data from the publishedsensors table to a separate table. The publishedsensors table would then only be used to really publish sensors (and hide others) and create aliases, whereas the new meta data table would hold information also about hidden sensors.
Fields in the meta data table:
- SID
- Unit
- Factor
How should the virtual sensor be handled? In a separate table?