Soil Moisture Quality Monitor

schema.dbml

// 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