iro/model/schema.py
changeset 308 a891fdd0c1a9
parent 294 0e75bd39767d
child 312 42fd5075a5d1
--- a/iro/model/schema.py	Sat Jul 27 13:34:22 2019 +0200
+++ b/iro/model/schema.py	Sat Jul 27 13:36:18 2019 +0200
@@ -158,6 +158,30 @@
     def __init__(self, **kwargs):
         Base.__init__(self,**kwargs)
 
+class Status(Base):
+    """ Status updates from external"""
+    __tablename__ = "status"
+
+    id = Column(Integer, Sequence('status_id_seq'), primary_key=True)
+    """primary key of the message"""
+
+    date = Column(DateTime)
+    """date of status message"""
+
+    recipient = Column(String(100))
+    """string representation of the recipient"""
+
+    exID = Column(String(100))
+    """external API id """
+
+    status = Column(Integer)
+    """ status of the message"""
+
+    sender = Column(String(100))
+    """ sender of the message """
+
+    data = Column(String(2550))
+    """ rest of the data """
 
 class Job(Base):
     """A complete Job.