Created
November 12, 2025 19:20
-
-
Save AlexDev404/17e9ae7eb16a14e287653e9a119be610 to your computer and use it in GitHub Desktop.
Soil Moisture Quality Monitor
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Soil Moisture Quality Monitor | |
| Table Users { | |
| user_id serial [pk] | |
| username string | |
| password string | |
| } | |
| Table Nodes { | |
| device_id serial [pk] | |
| status enum | |
| } | |
| Table NodeData { | |
| user_id serial | |
| device_id serial | |
| moisture_content float | |
| timestamp timestamp | |
| } | |
| Table NodeFavorites { | |
| user_id serial | |
| device_id serial | |
| } | |
| Ref: | |
| NodeData.device_id > Nodes.device_id | |
| Ref: | |
| NodeData.user_id > Users.user_id | |
| Ref: | |
| NodeFavorites.user_id > Users.user_id | |
| Ref: | |
| NodeFavorites.device_id > Nodes.device_id |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment