MySQL Table Design

Hi All,
I am in the process of creating a data logging database, which will record analytical results from a number of sensors (e.g. Temperature, Humidity, Dust, WindSpeed, WindDirection) at least to start with.
My issue is that the sensors are not always placed at the one location, but rather the sensor would be 'assigned' to a client for a period of time, then returned to the assignable pool, to be reassigned to a client at a later period of time.
So my question is, how is the best way to…
MySQL Table Design

See original post by Trav H

Leave a Reply