Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sensors
- - id (pk)
- - name
- - description
- - units
- sensor_readings
- - id (pk)
- - sensor_id (fk to sensors)
- - value (actual sensor value stored here)
- - time (date/time the sensor sample was taken)
- SELECT * FROM sensor_readings WHERE sensor_id = x AND time > y AND time < z
Add Comment
Please, Sign In to add comment