summaryrefslogtreecommitdiff
path: root/mqtt_client/models.py
diff options
context:
space:
mode:
authorMatheus <matheus.guedes.mg.m@gmail.com>2025-10-31 22:44:37 -0300
committerMatheus <matheus.guedes.mg.m@gmail.com>2025-10-31 22:44:37 -0300
commitd24056dfa246d6ecf67447fa65eb0cdd67942df3 (patch)
tree70e25f610ab41d8028114fd167b0c2ef51e34a1a /mqtt_client/models.py
parent032a77c0b1a2e0e2c247f511c0dc6d2555e691fb (diff)
Adicionado campos no banco de dados
Diffstat (limited to 'mqtt_client/models.py')
-rw-r--r--mqtt_client/models.py2
1 files changed, 2 insertions, 0 deletions
diff --git a/mqtt_client/models.py b/mqtt_client/models.py
index d6bd2ba..98549bc 100644
--- a/mqtt_client/models.py
+++ b/mqtt_client/models.py
@@ -60,6 +60,7 @@ class Measure(Base):
id = Column(Integer, primary_key=True, index=True)
name = Column(String(50), nullable=True, index=True)
+ unit_code = Column(String(10), nullable=True)
# Relationships
readings = relationship("Reading", back_populates="measure")
@@ -75,6 +76,7 @@ class Reading(Base):
sensor_device_id = Column(Integer, ForeignKey("sensor_devices.id"), nullable=True, index=True)
measure_id = Column(Integer, ForeignKey("measures.id"), nullable=True, index=True)
value = Column(Float, nullable=True)
+ time = Column(DateTime, nullable=True)
# Relationships
sensor_device = relationship("SensorDevice", back_populates="readings")